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);
}
