public JsonResult updatePreset(VisitorLimit preset) { db.Entry(preset).State = EntityState.Modified; db.SaveChanges(); var result = new { Success = "true" }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult searchDay(string date) { DateTime choice = Convert.ToDateTime(date); VisitorLimit special = db.VisitorLimit.FirstOrDefault(s => s.VisitorLimit_date == choice.Date); if (special == null) { int id = (int)choice.DayOfWeek; special = db.VisitorLimit.Find(id); } return(Json(special)); }
public JsonResult readAdmin() { VisitorLimit limitation = db.VisitorLimit.FirstOrDefault(l => l.VisitorLimit_date == DateTime.Today); if (limitation == null) { int id = (int)DateTime.Now.DayOfWeek; limitation = db.VisitorLimit.Find(id); } int regs = db.VisitorReg.Where(r => r.VisitorReg_date == DateTime.Today).Count(); visitorAdmin visitorAdmin = new visitorAdmin(); visitorAdmin.visitorLimit = limitation; visitorAdmin.visitorRegs = regs; return(Json(visitorAdmin)); }
public JsonResult updateToday(VisitorLimit today) { DateTime timer = today.VisitorLimit_date.Value.Date; if (db.VisitorLimit.Any(v => v.VisitorLimit_date == timer)) { VisitorLimit old = db.VisitorLimit.First(v => v.VisitorLimit_date == timer); old.VisitorLimit_max = today.VisitorLimit_max; old.VisitorLimit_start = today.VisitorLimit_start; old.VisitorLimit_end = today.VisitorLimit_end; db.VisitorLimit.Attach(old); db.Entry(old).State = EntityState.Modified; } else { db.VisitorLimit.Add(today); } db.SaveChanges(); var result = new { Success = "true" }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult readPreset(int date) { VisitorLimit preset = db.VisitorLimit.Find(date); return(Json(preset)); }