Example #1
0
        public JsonResult GetScheduleID(int selectedDay, int selectedMonth, int selectedYear, int ServingTimeID)
        {
            try
            {
                DateTime selectedDate = DateTime.Parse(selectedYear + "-" + selectedMonth + "-" + selectedDay);

                ScheduleTableAdapter scheduleTA = new ScheduleTableAdapter();
                int? ScheduleID = scheduleTA.GetIDFromDateAndServingTime(selectedDate, ServingTimeID);

                if (ScheduleID == null)
                {
                    DateTime now = DateTime.Now;
                    string username = AccountInfo.GetUserName(Request);

                    string newScheduleID = scheduleTA.InsertScalar(selectedDate, ServingTimeID, true, now, username, now).ToString();

                    ScheduleID = int.Parse(newScheduleID);
                    XmlSync.SaveScheduleXml(ScheduleID.Value, selectedDate, ServingTimeID, true, now, username, now, null);
                }

                return Json(new { ScheduleID = ScheduleID.Value }, JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                Log.ErrorLog(ex.Message);
                return Json("error", JsonRequestBehavior.AllowGet);
            }
        }