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"); } }