public Section GetSectionByClassCourse(string classID, string courseID)
{
var cmd = dbconn.SqlCommand("SELECT * FROM section WHERE class_id=? AND course_id=?", classID, courseID);
var rd = cmd.ExecuteReader();
Section sec = null;
while (rd.Read())
{
sec = SectionReader.Read(ref rd);
}
return(sec);
}
public Section GetSection(int sectionID)
{
var cmd = dbconn.SqlCommand("SELECT * FROM section WHERE id=?", sectionID);
var rd = cmd.ExecuteReader();
Section sec = null;
while (rd.Read())
{
sec = SectionReader.Read(ref rd);
}
return(sec);
}
public List <Section> GetListSections()
{
List <Section> listSections = new List <Section>();
var cmd = dbconn.SqlCommand("SELECT * FROM section");
var rd = cmd.ExecuteReader();
while (rd.Read())
{
listSections.Add(SectionReader.Read(ref rd));
}
return(listSections);
}
