Saturday, November 23, 2013

Login Code Not Working


createActivitiesTable = "CREATE TABLE IF NOT EXISTS Activities ( activity_num INTEGER PRIMARY KEY NOT NULL, activityname VARCHAR(40) NOT NULL);";
createSubjectsTable = "CREATE TABLE IF NOT EXISTS Subjects ( subject_num INTEGER PRIMARY KEY NOT NULL, subjectname VARCHAR(60) NOT NULL)";
//createQuotasTable = "CREATE TABLE IF NOT EXISTS Quotas ( quota_num INTEGER PRIMARY KEY NOT NULL, hrsMinsSecs INTEGER(6) NOT NULL )";
createStudentsTable = "CREATE TABLE IF NOT EXISTS Students ( student_num INTEGER PRIMARY KEY, studentname VARCHAR(60) NOT NULL, account_num INTEGER NOT NULL )";
createAccountsTable = "CREATE TABLE IF NOT EXISTS Accounts ( account_num INTEGER PRIMARY KEY, username VARCHAR(40) NOT NULL, passcode VARCHAR(40) NOT NULL, type VARCHAR(7) NOT NULL, FOREIGN KEY (account_num) REFERENCES Students (account_num) ON UPDATE CASCADE ON DELETE CASCADE )";
//createLogsTable = "CREATE TABLE IF NOT EXISTS Logs ( student_num INTEGER NOT NULL, subject_num INTEGER NOT NULL, activity_num INTEGER NOT NULL, hrsMinsSecs INTEGER(6) NOT NULL, PRIMARY KEY (student_num, subject_num, activity_num, hrsMinsSecs) )";
//createStudentsAndSubjectsTable = "CREATE TABLE IF NOT EXISTS StudentsAndSubjects ( student_num INTEGER NOT NULL, subject_num INTEGER NOT NULL )";
//createStudentsSubjectsAndActivitiesTable = "CREATE TABLE IF NOT EXISTS StudentsAndSubjects ( student_num INTEGER NOT NULL, subject_num INTEGER NOT NULL, activity_num INTEGER NOT NULL, PRIMARY KEY (student_num, subject_num, activity_num, hrsMinsSecs) )";

using (dbConnect)
{
dbConnect.BeginTransaction();

//Create tables
dbConnect.Execute(createStudentsTable);
dbConnect.Execute(createAccountsTable);
//dbConnect.Execute(createLogsTable);
//dbConnect.Execute(createQuotasTable);
//dbConnect.Execute(createStudentsAndSubjectsTable);
//dbConnect.Execute(createStudentsSubjectsAndActivitiesTable);
dbConnect.Execute(createSubjectsTable);
dbConnect.Execute(createActivitiesTable);


No comments:

Post a Comment