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