public void LayDanhSachHocVienCacBuoiHoc()
{
try
{
int Tuan = Convert.ToInt32(Request.Params["Tuan"]);
int Thang = Convert.ToInt32(Request.Params["Thang"]);
int Nam = Convert.ToInt32(Request.Params["Nam"]);
int ClassID = Convert.ToInt32(Request.Params["ClassID"]);
// MessageBox.Show(Tuan.ToString() + " " + Thang.ToString() + " " + ClassID.ToString());
ListStudentInClass_Model rs = new ListStudentInClass_Model();
ArrangeSchedule_Controler asController = new ArrangeSchedule_Controler();
rs = asController.LayDanhSachHocVienCacBuoiHoc(ClassID, Tuan, Thang, Nam);
WriteJsonData(Response, rs);
}
catch (Exception ex)
{
//Gửi email báo lỗi
sendEmail.SendMailForTechnical("*****@*****.**", "Lỗi", ex.ToString(), true);
}
}
public ListStudentInClass_Model LayDanhSachHocVienCacBuoiHoc(int ClassID, int Tuan, int Thang, int Nam)
{
ThuVien tv = new ThuVien();
ListStudentInClass_Model rs = new ListStudentInClass_Model();
rs.lstStudentInClass = new List<StudentInClass_Model>();
rs.lstSessions = new List<Sessions_Model>();
DataTable tbStudentInClass = tv.SP_SelectDataTable("USP_ListStudentInClass_GetBySomeConditional",
// new string[] { "@ClassID", "@sWeek", "@sMonth" }, new object[] { 7, 2, 7 });
new string[] { "@flag", "@ClassID", "@sWeek", "@sMonth", "@sYear" }, new object[] { 1, ClassID, Tuan, Thang, Nam });
for (int i = 0; i < tbStudentInClass.Rows.Count; i++)
{
StudentInClass_Model smodel = new StudentInClass_Model();
smodel.ScheduleID = tbStudentInClass.Rows[i]["ScheduleID"].ToString();
smodel.ClassID = tbStudentInClass.Rows[i]["ClassID"].ToString();
smodel.DayInWeek = tbStudentInClass.Rows[i]["DayInWeek"].ToString();
smodel.StudentID = tbStudentInClass.Rows[i]["StudentID"].ToString();
smodel.StudyRecord = tbStudentInClass.Rows[i]["StudyRecord"].ToString();
smodel.StudentName= tbStudentInClass.Rows[i]["StudentName"].ToString();
smodel.StudentName_Short = Common.getLastName(tbStudentInClass.Rows[i]["StudentName"].ToString()) + " " + Common.getFirstName(tbStudentInClass.Rows[i]["StudentName"].ToString());
smodel.CellPhone = tbStudentInClass.Rows[i]["CellPhone"].ToString();
smodel.Color = tbStudentInClass.Rows[i]["Color"].ToString();
smodel.Present = tbStudentInClass.Rows[i]["Present"].ToString();
smodel.StudentStatusID = tbStudentInClass.Rows[i]["StudentStatusID"].ToString();
smodel.MaGiDo = tbStudentInClass.Rows[i]["MaGiDo"].ToString();
rs.lstStudentInClass.Add(smodel);
}
tv = new ThuVien();
DataTable tbSessions = tv.SP_SelectDataTable("USP_Study_GetBySomeConditional",
//new string[] { "@flag", "@ClassID", "@Week", "@Month" }, new object[] { 2, 7, 2, 7 });
new string[] { "@flag", "@ClassID", "@Week", "@Month", "@Year" }, new object[] { 2, ClassID, Tuan, Thang, Nam });
for (int j = 0; j < tbSessions.Rows.Count; j++)
{
Sessions_Model sesmodel = new Sessions_Model();
sesmodel.DayInWeek = tbSessions.Rows[j]["DayInWeek"].ToString();
sesmodel.ScheduleID = tbSessions.Rows[j]["ScheduleID"].ToString();
sesmodel.Date = tbSessions.Rows[j]["Date"].ToString();
sesmodel.Day = tbSessions.Rows[j]["Day"].ToString();
sesmodel.ClassID = tbSessions.Rows[j]["ClassID"].ToString();
rs.lstSessions.Add(sesmodel);
}
return rs;
}
