public JsonResult GetScheduleDateDetail(int selectedDay, int selectedMonth, int selectedYear)
{
try
{
DateTime selectedDate = DateTime.Parse(selectedYear + "-" + selectedMonth + "-" + selectedDay);
MealSetInScheduleTableAdapter adapter = new MealSetInScheduleTableAdapter();
DataTable dt = adapter.GetData(selectedDate);
if (dt.Rows.Count == 0)
{
return null;
}
List<ScheduleJsonModel> schedule = new List<ScheduleJsonModel>();
foreach (DataRow row in dt.Rows)
{
ScheduleJsonModel model = new ScheduleJsonModel();
model.MealSetID = row.Field<int?>("MealSetID");
model.ScheduleMealSetDetailID = row.Field<int?>("ScheduleMealSetDetailID");
model.Name = row.Field<string>("Name");
model.Image = row.Field<string>("Image");
model.Description = row.Field<string>("Description");
model.ServingTimeID = row.Field<int>("ServingTimeID");
model.ServingTimeName = row.Field<string>("ServingTimeName");
model.IsDayOn = row.Field<bool>("IsDayOn");
schedule.Add(model);
}
return Json(new { result = schedule }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
return Json("error", JsonRequestBehavior.AllowGet);
}
}
public ActionResult EditSchedule()
{
try
{
string ScheduleIDStr = Request.QueryString["ScheduleID"];
if (ScheduleIDStr == null)
{
return RedirectToAction("ListSchedule", "Schedule");
}
int ScheduleID = int.Parse(ScheduleIDStr);
MealSetInScheduleTableAdapter mealSetInScheduleTA = new MealSetInScheduleTableAdapter();
DataTable mealSetInSchedule = mealSetInScheduleTA.GetDataByScheduleID(ScheduleID);
if (mealSetInSchedule.Rows.Count == 0)
{
Log.ErrorLog("MealSetInScheduleTableAdapter: can't find row with [ScheduleID] = " + ScheduleIDStr);
return View("Có lỗi khi lấy dữ liệu.");
}
@ViewBag.isDayOn = mealSetInSchedule.Rows[0].Field<bool>("IsDayOn");
@ViewBag.scheduleID = ScheduleID;
return View(mealSetInSchedule);
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
return View("Error");
}
}
