public bool AddAnswer()
{
bool isInserted = false;
string tableName = "Answer";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("questionId");
columns.Add("Answer");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddOutcome()
{
bool isInserted = false;
string tableName = "Outcome";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("SubjectID");
columns.Add("name");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddAccount()
{
bool isInserted = false;
string tableName = "Account";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("username");
columns.Add("AccPassword");
columns.Add("AccPriority");
columns.Add("isAdmin");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddQuestion(QuestionModel obj)
{
bool isInserted = false;
string tableName = "Question";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(obj);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("OutcomeDetailsID");
columns.Add("QuestionTypeID");
columns.Add("Questions");
columns.Add("QuestionWeight");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddCourse()
{
bool isInserted = false;
string tableName = "Course";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("code");
columns.Add("name");
columns.Add("NQFLevel");
columns.Add("CourseDescription");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddSubject()
{
bool isInserted = false;
string tableName = "Subjects";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("name");
columns.Add("code");
columns.Add("duration");
columns.Add("SubjectWeight");
columns.Add("SubjectDescription");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddLecturerCourseSubject()
{
bool isInserted = false;
string tableName = "LecturerCourseSubject";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("LecturerID");
columns.Add("CourseSubjectID");
columns.Add("startDate");
columns.Add("endDate");
columns.Add("isFlagged");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}
public bool AddLecturer()
{
bool isInserted = false;
string tableName = "Lecturer";
List <string> columns = new List <string>(), colValues = ConvertToColumnValues(this);
DataAccess.DataHandler dh = new DataAccess.DataHandler();
columns.Add("AccountID");
columns.Add("name");
columns.Add("surname");
columns.Add("cell");
columns.Add("email");
columns.Add("LecturerLevel");
isInserted = dh.Insert(tableName, columns, colValues);
columns.Clear();
colValues.Clear();
return(isInserted);
}