public static List <AnswerModel> Select(List <string> answers) { DataAccess.DataHandler datahandler = new DataAccess.DataHandler(); List <AnswerModel> answersList = new List <AnswerModel>(); DataTable datatable = new DataTable(); string query = "select * from Answer where "; for (int i = 0; i < answers.Count; i++) { query = query + "questionId = " + answers[i]; if (i < answers.Count - 1) { query = query + " or "; } else { } } using (datatable = datahandler.Select(query)) { foreach (DataRow item in datatable.Rows) { answersList.Add(new AnswerModel(int.Parse(item["id"].ToString()), int.Parse(item["questionId"].ToString()), item["Answer"].ToString())); } } return(answersList); }
public List <QuestionModel> Select(List <string> outcomes) { DataAccess.DataHandler datahandler = new DataAccess.DataHandler(); List <QuestionModel> questionsList = new List <QuestionModel>(); DataTable datatable = new DataTable(); string query = "select * from Question inner join OutcomeDetails on OutcomeDetails.id = Question.OutcomeDetailsID where "; for (int i = 0; i < outcomes.Count; i++) { query = query + "OutcomeDetails.Material = '" + outcomes[i] + "'"; if (i <= outcomes.Count - 1) { } else { query = query + " or "; } } using (datatable = datahandler.Select(query)) { foreach (DataRow item in datatable.Rows) { questionsList.Add(new QuestionModel(int.Parse(item["id"].ToString()), int.Parse(item["OutcomeDetailsID"].ToString()), int.Parse(item["QuestionTypeID"].ToString()), item["Questions"].ToString(), int.Parse(item["QuestionWeight"].ToString()))); } } return(questionsList); }
public List <LecturerModel> GetLecturer(List <string> columns = null, List <string> where = null) { string tableName = "Lecturer"; List <LecturerModel> lecturers = new List <LecturerModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { fieldValues.Clear(); int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("AccountID", attribute); break; case 3: fieldValues.Add("name", attribute); break; case 4: fieldValues.Add("surname", attribute); break; case 5: fieldValues.Add("cell", attribute); break; case 6: fieldValues.Add("email", attribute); break; case 7: fieldValues.Add("LecturerLevel", attribute); break; } counter++; } lecturers.Add(ConvertToLecturer(fieldValues)); } return(lecturers); }
public static List <SubjectModel> GetSubject(List <string> columns = null, List <string> where = null) { string tableName = "Subjects"; List <SubjectModel> subjects = new List <SubjectModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { fieldValues.Clear(); int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("name", attribute); break; case 3: fieldValues.Add("code", attribute); break; case 4: fieldValues.Add("duration", attribute); break; case 5: fieldValues.Add("SubjectWeight", attribute); break; case 6: fieldValues.Add("SubjectDescription", attribute); break; } counter++; } subjects.Add(ConvertToSubject(fieldValues)); } return(subjects); }
public List <LecturerCourseSubjectModel> GetLecturerCourseSubject(List <string> columns = null, List <string> where = null) { string tableName = "LecturerCourseSubject"; List <LecturerCourseSubjectModel> lecturerCourseSubjects = new List <LecturerCourseSubjectModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("LecturerID", attribute); break; case 3: fieldValues.Add("CourseSubjectID", attribute); break; case 4: fieldValues.Add("startDate", attribute); break; case 5: fieldValues.Add("endDate", attribute); break; case 6: fieldValues.Add("isFlagged", attribute); break; } counter++; } lecturerCourseSubjects.Add(ConvertToLecturerCourseSubject(fieldValues)); } return(lecturerCourseSubjects); }
public List <AccountModel> GetAccount(List <string> columns = null, List <string> where = null) { string tableName = "Account"; List <AccountModel> accounts = new List <AccountModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { fieldValues.Clear(); int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("username", attribute); break; case 3: fieldValues.Add("AccPassword", attribute); break; case 4: fieldValues.Add("AccPriority", attribute); break; case 5: fieldValues.Add("isAdmin", attribute); break; } counter++; } accounts.Add(ConvertToAccount(fieldValues)); } return(accounts); }
public List <QuestionModel> GetQuestion(List <string> columns = null, List <string> where = null) { string tableName = "Question"; List <QuestionModel> questions = new List <QuestionModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { fieldValues.Clear(); int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("OutcomeDetailsID", attribute); break; case 3: fieldValues.Add("QuestionTypeID", attribute); break; case 4: fieldValues.Add("Questions", attribute); break; case 5: fieldValues.Add("QuestionWeight", attribute); break; } counter++; } questions.Add(ConvertToQuestion(fieldValues)); } return(questions); }
public static List <CourseModel> GetCourse(List <string> columns = null, List <string> where = null) { string tableName = "Course"; List <CourseModel> courses = new List <CourseModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("code", attribute); break; case 3: fieldValues.Add("name", attribute); break; case 4: fieldValues.Add("NQFLevel", attribute); break; case 5: fieldValues.Add("CourseDescription", attribute); break; } counter++; } courses.Add(ConvertToCourse(fieldValues)); } return(courses); }
public static List <PracticalWeightModel> Select(string question) { DataAccess.DataHandler datahandler = new DataAccess.DataHandler(); List <PracticalWeightModel> practicalWeightsList = new List <PracticalWeightModel>(); DataTable datatable = new DataTable(); string query = "select * from PracticalWeight where QuestionId = " + question; using (datatable = datahandler.Select(query)) { foreach (DataRow item in datatable.Rows) { practicalWeightsList.Add(new PracticalWeightModel(int.Parse(item["id"].ToString()), int.Parse(item["QuestionId"].ToString()), int.Parse(item["practicalQuestionWeight"].ToString()), item["QuestionBreakDown"].ToString())); } } return(practicalWeightsList); }
public static List <OutcomeModel> GetOutcome(List <string> columns = null, List <string> where = null) { string tableName = "Outcome"; List <OutcomeModel> outcomes = new List <OutcomeModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { fieldValues.Clear(); int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("SubjectID", attribute); break; case 3: fieldValues.Add("name", attribute); break; } counter++; } outcomes.Add(ConvertToOutcome(fieldValues)); } return(outcomes); }
public static List <AnswerModel> GetAnswer(List <string> columns = null, List <string> where = null) { string tableName = "Answer"; List <AnswerModel> answers = new List <AnswerModel>(); List <string> records = new List <string>(); DataAccess.DataHandler dh = new DataAccess.DataHandler(); records = dh.Select(tableName, columns, where); Dictionary <string, string> fieldValues = new Dictionary <string, string>(); foreach (string item in records) { fieldValues.Clear(); int counter = 1; string[] fields = item.Split(','); foreach (string attribute in fields) { switch (counter) { case 1: fieldValues.Add("id", attribute); break; case 2: fieldValues.Add("questionId", attribute); break; case 3: fieldValues.Add("Answer", attribute); break; } counter++; } answers.Add(ConvertToAnswer(fieldValues)); } return(answers); }