public List <Course> GetCourses() { var list = new List <Course>(); using (var con = new MySqlConnection(GetConnectionString())) { con.Open(); var qry = "select cou_id, cou_name, cou_difficulty, cou_description, cou_creation_date from courses"; using (var cmd = new MySqlCommand(qry, con)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var tmp = new Course(); Func <MySqlDataReader, Course, Course> readData = delegate(MySqlDataReader readerRef, Course courseRef) { courseRef.CourseID = reader.GetInt32(0); courseRef.CourseName = reader.GetString(1); courseRef.CourseDescription = reader.GetString(3); courseRef.CourseDifficulty = reader.GetInt32(2); courseRef.CourseCreationDate = reader.GetDateTime(4); return(courseRef); }; list.Add(readData(reader, tmp)); } } } con.Close(); } CheckList.ReplaceList(list); return(list); // return _courseDal.SelectCourses(); }
public List <Question> Get() { var questionList = new List <Question>(); using (var con = new MySqlConnection(GetConnectionString())) { con.Open(); var qry = "select qns.qns_id, qns.qns_likes, qns.qns_views, qns.qns_comments, qns.qns_text, qns.qns_name, qns.qns_creation_date from questions qns"; using (var cmd = new MySqlCommand(qry, con)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var tmp = new Question(); tmp.QuestionID = reader.GetInt32(0); tmp.QuestionLikes = reader.GetInt32(1); tmp.QuestionViews = reader.GetInt32(2); tmp.QuestionAnswers = reader.GetInt32(3); tmp.QuestionText = reader.GetString(4); tmp.QuestionName = reader.GetString(5); tmp.QuestionCreationDate = reader.GetDateTime(6); questionList.Add(tmp); } } } con.Close(); } CheckList.ReplaceList(questionList); return(questionList); }