public ActionResult TimeInExceptionBreak(string inputBreak) { foreach (string s in HomeController.workers) { if (!HomeController.workersToDeny.Contains(s)) { DateTime11 date = new DateTime11(); date.Email = s; date.Date = DateTime.Today; date.Id = new Random().Next(); date.TimeIn = DateTime.Now.TimeOfDay; if (db.DateTime11.Where(e => e.Email.Equals(s) && e.Date.Equals(DateTime.Today)).Any()) { List <DateTime11> listd = db.DateTime11.Where(e => e.Email.Equals(s) && e.Date.Equals(DateTime.Today)).ToList(); if (!listd.OrderBy(e => e.TimeIn).Last().TimeOut.HasValue) { if (inputBreak != null) { db.DateTime11.Where(e => e.Email.Equals(s) && e.Date.Equals(DateTime.Today)).OrderBy(e => e.TimeIn).Last().TimeOut = TimeSpan.Parse(inputBreak); } else { db.DateTime11.Where(e => e.Email.Equals(s) && e.Date.Equals(DateTime.Today)).OrderBy(e => e.TimeIn).Last().TimeOut = date.TimeIn; } db.DateTime11.Update(db.DateTime11.Where(e => e.Email.Equals(s) && e.Date.Equals(DateTime.Today)).OrderBy(e => e.TimeIn).Last()); db.SaveChanges(); } } db.DateTime11.Add(date); db.SaveChanges(); } db.SaveChanges(); } db.SaveChanges(); return(Json(new { status = true })); }