private SheetItem _ParseSQL(SqlDataReader dr)
{
TeacherItem t = new TeacherItem(
(int)dr["TeacherId"],
dr["TeacherFirstName"].ToString(),
dr["TeacherMiddleName"].ToString(),
dr["TeacherLastName"].ToString(),
(int)dr["ChairId"],
dr["ChairName"].ToString()
);
SubjectItem sub = new SubjectItem(
(int)dr["SubjectInCurriculumId"], dr["SubjectName"].ToString(),
(int)dr["CountOfHours"], (int)dr["Course"], (int)dr["Semester"],
new FormOfControlItem((int)dr["FormOfControlId"], dr["FormOfControlName"].ToString()));
SheetItem s = new SheetItem((int)dr["SheetId"],
sub,
t,
(DateTime)dr["DateSet"],
(DateTime)dr["DateGet"],
new FormOfControlItem((int)dr["FormOfControlId"],
dr["FormOfControlName"].ToString())
);
return(s);
}
//public List<StudentItem> Students { set; get; }
public SheetItem(int id, SubjectItem subject, TeacherItem teacher, DateTime date_set, DateTime date_get, FormOfControlItem control, int group_id = 0, string group_name = "")
{
this.Id = id;
this.Subject = subject;
this.Teacher = teacher;
this.DateSet = date_set;
this.DateGet = date_get;
this.Control = control;
this.GroupId = group_id;
this.GroupName = group_name;
}
//public List<StudentItem> Students { set; get; }
public SheetItem(int id, SubjectItem subject, TeacherItem teacher, DateTime date_set, DateTime date_get, FormOfControlItem control, int group_id = 0, string group_name = "")
{
this.Id = id;
this.Subject = subject;
this.Teacher = teacher;
this.DateSet = date_set;
this.DateGet = date_get;
this.Control = control;
this.GroupId = group_id;
this.GroupName = group_name;
}
