public void SearchSchedule()
{
try
{
string variableSearch = Request.Params["variableSearch"];
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
dynamic variable = json_serializer.DeserializeObject(variableSearch);
Schedule_Model rs = new Schedule_Model();
VariableConditionsSchedule_Model vsc = new VariableConditionsSchedule_Model();
vsc.BranchID = variable["BranchID"];
vsc.TeacherID = variable["TeacherID"];
if (variable["StartDate"] != "")
{
vsc.StartDate = Convert.ToDateTime(variable["StartDate"]);
}
else
{
vsc.StartDate = new DateTime(2012, 1 , 1, 0, 0, 0);
}
if (variable["EndDate"] != "")
{
vsc.EndDate = Convert.ToDateTime(variable["EndDate"]);
}
else
{
vsc.EndDate = DateTime.MaxValue;
}
vsc.Thu2 = Convert.ToInt32(variable["Thu2"]);
vsc.Thu3 = Convert.ToInt32(variable["Thu3"]);
vsc.Thu4 = Convert.ToInt32(variable["Thu4"]);
vsc.Thu5 = Convert.ToInt32(variable["Thu5"]);
vsc.Thu6 = Convert.ToInt32(variable["Thu6"]);
vsc.Thu7 = Convert.ToInt32(variable["Thu7"]);
vsc.ChuNhat = Convert.ToInt32(variable["ChuNhat"]);
ArrangeSchedule_Controler asController = new ArrangeSchedule_Controler();
rs = asController.GetSchedule(vsc);
WriteJsonData(Response, rs);
}
catch (Exception ex)
{
//Gửi email báo lỗi
sendEmail.SendMailForTechnical("*****@*****.**", "Lỗi", ex.ToString(), true);
}
}
public Schedule_Model GetSchedule(VariableConditionsSchedule_Model vsc)
{
ThuVien tv = new ThuVien();
Schedule_Model rs = new Schedule_Model();
rs.listClass = new List<listClass_Model>();
rs.listBranch = new List<Branch_Model>();
//rs.listStudent = new List<Student_Model>();
DataTable tbSchedule = tv.SP_SelectDataTable("USP_Schedule_GetBySomeConditional",//DataTable tbSchedule = tv.SP_SelectDataTable("USP_Schedule_GetBySomeConditional",
new string[] { "@flag", "@BranchID", "@TeacherID", "@StartDate", "@EndDate", "@Mon", "@Tue", "@Wed", "@Thu", "@Fri", "@Sat", "@Sun" },
new object[] { 1, vsc.BranchID, vsc.TeacherID, vsc.StartDate, vsc.EndDate, vsc.Thu2, vsc.Thu3, vsc.Thu4, vsc.Thu5, vsc.Thu6, vsc.Thu7, vsc.ChuNhat });
if (tbSchedule.Rows.Count > 0)
{
for (int i = 0; i < tbSchedule.Rows.Count; i++)
{
listClass_Model armodel = new listClass_Model();
//armodel.ScheduleID = tbSchedule.Rows[i]["ScheduleID"].ToString();
armodel.BranchID = tbSchedule.Rows[i]["BranchID"].ToString();
armodel.BranchName = tbSchedule.Rows[i]["BranchName"].ToString();
armodel.Coordinates = tbSchedule.Rows[i]["Coordinates"].ToString();
armodel.ClassID = tbSchedule.Rows[i]["ClassID"].ToString();
armodel.ClassName = tbSchedule.Rows[i]["ClassName"].ToString();
armodel.TeacherID = tbSchedule.Rows[i]["TeacherID"].ToString();
armodel.TeacherName = tbSchedule.Rows[i]["TeacherName"].ToString();
armodel.BeginDate = Convert.ToString(tbSchedule.Rows[i]["BeginDate"]);
armodel.Hour = tbSchedule.Rows[i]["Hour"].ToString();
armodel.Minute = tbSchedule.Rows[i]["Minute"].ToString();
armodel.Monday = tbSchedule.Rows[i]["Monday"].ToString();
armodel.Tuesday = tbSchedule.Rows[i]["Tuesday"].ToString();
armodel.Wednesday = tbSchedule.Rows[i]["Wednesday"].ToString();
armodel.Thursday = tbSchedule.Rows[i]["Thursday"].ToString();
armodel.Friday = tbSchedule.Rows[i]["Friday"].ToString();
armodel.Saturday = tbSchedule.Rows[i]["Saturday"].ToString();
armodel.Sunday = tbSchedule.Rows[i]["Sunday"].ToString();
armodel.TotalStudent = tbSchedule.Rows[i]["TotalStudent"].ToString();
armodel.TotalDangHoc = tbSchedule.Rows[i]["TotalDangHoc"].ToString();
armodel.TotalDangHocThu = tbSchedule.Rows[i]["TotalDangHocThu"].ToString();
armodel.TotalDaHocThuChuaGhiDanh = tbSchedule.Rows[i]["TotalDaHocThuChuaGhiDanh"].ToString();
armodel.MaxStudent = tbSchedule.Rows[i]["MaxStudent"].ToString();
rs.listClass.Add(armodel);
Branch_Model brmodel = new Branch_Model();
if (rs.listBranch.Count == 0)
{
brmodel.BranchID = tbSchedule.Rows[i]["BranchID"].ToString();
brmodel.BranchName = tbSchedule.Rows[i]["BranchName"].ToString();
brmodel.Coordinates = tbSchedule.Rows[i]["Coordinates"].ToString();
rs.listBranch.Add(brmodel);
}
else
{
if (rs.listBranch.FindIndex(f => f.BranchID == tbSchedule.Rows[i]["BranchID"].ToString()) < 0)
{
brmodel.BranchID = tbSchedule.Rows[i]["BranchID"].ToString();
brmodel.BranchName = tbSchedule.Rows[i]["BranchName"].ToString();
brmodel.Coordinates = tbSchedule.Rows[i]["Coordinates"].ToString();
rs.listBranch.Add(brmodel);
}
}
//ThuVien tv1 = new ThuVien();
//string sID = tbSchedule.Rows[i]["ScheduleID"].ToString();
//DataTable tbStudent = tv1.SP_SelectDataTable("USP_Student_GetScheduleID", new string[] { "@ScheduleID" }, new object[] { sID });
//if (tbStudent.Rows.Count > 0)
//{
// for (int j = 0; j < tbStudent.Rows.Count; j++)
// {
// Student_Model sdmodel = new Student_Model();
// sdmodel.StudentID = tbStudent.Rows[i]["StudentID"].ToString();
// sdmodel.StudentName = tbStudent.Rows[i]["StudentName"].ToString();
// sdmodel.ScheduleID = tbStudent.Rows[i]["ScheduleID"].ToString();
// sdmodel.StudentStatusID = tbStudent.Rows[i]["StudentStatusID"].ToString();
// sdmodel.StudentStatusName = tbStudent.Rows[i]["StudentStatusName"].ToString();
// sdmodel.Present = tbStudent.Rows[i]["Present"].ToString();
// sdmodel.Color = tbStudent.Rows[i]["Color"].ToString();
// rs.listStudent.Add(sdmodel);
// }
//}
}
}
return rs;
}
