public bool ChangeOutcome(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "Outcome"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("SubjectID", colValues[0]); colValuePairs.Add("name", colValues[1]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }
public bool ChangeAccount(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "Account"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("username", colValues[0]); colValuePairs.Add("AccPassword", colValues[1]); colValuePairs.Add("AccPriority", colValues[2]); colValuePairs.Add("isAdmin", colValues[3]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }
public bool ChangeQuestion(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "Question"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("OutcomeDetailsID", colValues[0]); colValuePairs.Add("QuestionTypeID", colValues[1]); colValuePairs.Add("Questions", colValues[2]); colValuePairs.Add("QuestionWeight", colValues[3]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }
public bool ChangeCourse(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "Course"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("code", colValues[0]); colValuePairs.Add("name", colValues[1]); colValuePairs.Add("NQFLevel", colValues[2]); colValuePairs.Add("CourseDescription", colValues[3]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }
public bool ChangeSubjects(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "Subjects"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("name", colValues[0]); colValuePairs.Add("code", colValues[1]); colValuePairs.Add("duration", colValues[2]); colValuePairs.Add("SubjectWeight", colValues[3]); colValuePairs.Add("SubjectDescription", colValues[4]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }
public bool ChangeLecturerCourseSubject(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "LecturerCourseSubject"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("LecturerID", colValues[0]); colValuePairs.Add("CourseSubjectID", colValues[1]); colValuePairs.Add("startDate", colValues[2]); colValuePairs.Add("endDate", colValues[3]); colValuePairs.Add("isFlagged", colValues[4]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }
public bool ChangeLecturer(List <string> where) { bool isUpdated = false; List <string> colValues = ConvertToColumnValues(this); Dictionary <string, string> colValuePairs = new Dictionary <string, string>(); string tableName = "Lecturer"; DataAccess.DataHandler dh = new DataAccess.DataHandler(); colValuePairs.Add("AccountID", colValues[0]); colValuePairs.Add("name", colValues[1]); colValuePairs.Add("surname", colValues[2]); colValuePairs.Add("cell", colValues[3]); colValuePairs.Add("email", colValues[4]); colValuePairs.Add("LecturerLevel", colValues[5]); isUpdated = dh.Update(tableName, colValuePairs, where); return(isUpdated); }