//
// GET: /ShiftHour/
public ActionResult Index()
{
var MenuShifts = db.tabMenuShiftHours;
var days = db.tabWeekDays;
if (MenuShifts.Count() != 28)
{
db.Database.ExecuteSqlCommand(@"truncate table MenuShiftHours");
}
if (MenuShifts.Count() == 0)
{
foreach (var day in days)
{
var breakfast = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 1,
OpenAt = "10:00 AM",
CloseAt = "10:00 AM"
};
db.tabMenuShiftHours.Add(breakfast);
var brunch = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 2,
OpenAt = "10:00 AM",
CloseAt = "10:00 AM"
};
db.tabMenuShiftHours.Add(brunch);
var lunch = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 3,
OpenAt = "10:00 AM",
CloseAt = "10:00 AM"
};
db.tabMenuShiftHours.Add(lunch);
var dinner = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 4,
OpenAt = "10:00 AM",
CloseAt = "10:00 AM"
};
db.tabMenuShiftHours.Add(dinner);
}
db.SaveChanges();
UpdateShiftHoursCache();
}
//var startTime = DateTime.Parse("3:45:00");
//var str = new List<string>();
//var endTime = startTime.AddHours(23).AddMinutes(45);
//while (startTime <= endTime)
//{
// var dt = startTime.AddMinutes(15);
// str.Add(dt.ToString("h:mm tt"));
// startTime = startTime.AddMinutes(15);
//}
var newstartTime = DateTime.Parse("3:45:00");
var newendTime = newstartTime.AddHours(23).AddMinutes(45);
var obj = new List<TimeIntervalVM>();
while (newstartTime <= newendTime)
{
var tI = new TimeIntervalVM();
var dt = newstartTime.AddMinutes(15);
tI.text = dt.ToString("h:mm tt");
tI.timeVal = dt.ToString("dd/MM/yyyy hh:mm tt").Replace("-", "/");
obj.Add(tI);
newstartTime = newstartTime.AddMinutes(15);
}
ViewBag.Time = obj;
return View(MenuShifts);
}
public JsonResult Update(List<WeekDayShift> hours, string timezone)
{
using (var context = new UsersContext())
{
// delete existing records
context.Database.ExecuteSqlCommand(@"truncate table MenuShiftHours");
}
bool isSucess = false;
if (ModelState.IsValid)
{
foreach (var day in hours)
{
var breakfast = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 1,
OpenAt = day.BreakfastOpen == null ? null : Convert.ToDateTime(day.BreakfastOpen, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
CloseAt = day.BreakfastClose == null ? null : Convert.ToDateTime(day.BreakfastClose, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
IsNext = day.BreakfastClose == null ? 0 : Convert.ToDateTime(day.BreakfastClose, CultureInfo.CurrentCulture).Date == DateTime.Now.AddDays(1).Date ? 1 : 0
};
db.tabMenuShiftHours.Add(breakfast);
var brunch = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 2,
OpenAt = day.BrunchOpen == null ? null : Convert.ToDateTime(day.BrunchOpen, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
CloseAt = day.BrunchClose == null ? null : Convert.ToDateTime(day.BrunchClose, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
IsNext = day.BrunchClose == null ? 0 : Convert.ToDateTime(day.BrunchClose, CultureInfo.CurrentCulture).Date == DateTime.Now.AddDays(1).Date ? 1 : 0
};
db.tabMenuShiftHours.Add(brunch);
var lunch = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 3,
OpenAt = day.LunchOpen == null ? null : Convert.ToDateTime(day.LunchOpen, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
CloseAt = day.LunchClose == null ? null : Convert.ToDateTime(day.LunchClose, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
IsNext = day.LunchClose == null ? 0 : Convert.ToDateTime(day.LunchClose, CultureInfo.CurrentCulture).Date == DateTime.Now.AddDays(1).Date ? 1 : 0
};
db.tabMenuShiftHours.Add(lunch);
var dinner = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 4,
OpenAt = day.DinnerOpen == null ? null : Convert.ToDateTime(day.DinnerOpen, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
CloseAt = day.DinnerClose == null ? null : Convert.ToDateTime(day.DinnerClose, CultureInfo.CurrentCulture).ToString("hh:mm tt"),
IsNext = day.DinnerClose == null ? 0 : Convert.ToDateTime(day.DinnerClose, CultureInfo.CurrentCulture).Date == DateTime.Now.AddDays(1).Date ? 1 : 0
};
db.tabMenuShiftHours.Add(dinner);
}
var timezoneSetting = db.tabSettings.Where(s => s.Name.Contains("TimeZone")).Single();
timezoneSetting.Value = timezone;
db.Entry(timezoneSetting).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
UpdateShiftHoursCache();
isSucess = true;
return Json(new
{
IsSucess = isSucess,
});
}
return Json(new
{
IsSucess = isSucess,
});
}
public JsonResult Create(List<WeekDayShift> model)
{
using (var context = new UsersContext())
{
// delete existing records
context.Database.ExecuteSqlCommand(@"truncate table [AIS].[dbo].[MenuShiftHours]");
}
bool isSucess = false;
if (ModelState.IsValid)
{
foreach (var day in model)
{
var breakfast = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 1,
OpenAt = day.BreakfastOpen,
CloseAt = day.BreakfastClose
};
db.tabMenuShiftHours.Add(breakfast);
var brunch = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 2,
OpenAt = day.BrunchOpen,
CloseAt = day.BrunchClose
};
db.tabMenuShiftHours.Add(brunch);
var lunch = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 3,
OpenAt = day.LunchOpen,
CloseAt = day.LunchClose
};
db.tabMenuShiftHours.Add(lunch);
var dinner = new MenuShiftHours
{
DayId = day.DayId,
FoodMenuShiftId = 4,
OpenAt = day.DinnerOpen,
CloseAt = day.DinnerClose
};
db.tabMenuShiftHours.Add(dinner);
}
db.SaveChanges();
isSucess = true;
return Json(new
{
IsSucess = isSucess,
});
}
return Json(new
{
IsSucess = isSucess,
});
}