public ActionResult LogBundyWeb(String time_period, String EIC, String schemeCode) { var logNow = DateTime.Now; var logDate = logNow.Date; var logTime = logNow.TimeOfDay; // check for existing record entry var rec = db.tAttDailyLogs.Where(r => r.EIC == EIC).SingleOrDefault(r => r.LogDate == logDate); if (rec == null) { // create an entry if no existing record var n = new tAttDailyLog { EIC = EIC, LogDate = logDate, SchemeCode = schemeCode, nonRegDay = 0 }; db.tAttDailyLogs.Add(n); db.SaveChanges(); } // update the record var l = db.tAttDailyLogs.Where(r => r.EIC == EIC).Single(r => r.LogDate == logDate); if (time_period.Equals("IN1")) { l.In1 = logNow; l.LastLog = time_period; } else if (time_period.Equals("OUT1")) { l.Out1 = logNow; l.LastLog = time_period; } else if (time_period.Equals("IN2")) { l.In2 = logNow; l.LastLog = time_period; } else if (time_period.Equals("OUT2")) { l.Out2 = logNow; l.LastLog = time_period; } // save all changes db.SaveChanges(); //BundyTransaction(EIC, time_period); var log = db.tAttDailyLogs.Where(r => r.EIC == EIC).SingleOrDefault(r => r.LogDate == logDate); ViewBag.log = log; ViewBag.EIC = EIC; return(Content("1")); }
public JsonResult LogBundy(String time_period, String EIC, String schemeCode) { var logNow = DateTime.Now; var logDate = logNow.Date; var logTime = logNow.TimeOfDay; // check for existing record entry var rec = db.tAttDailyLogs.Where(r => r.EIC == EIC).SingleOrDefault(r => r.LogDate == logDate); if (rec == null) { // create an entry if no existing record var n = new tAttDailyLog { EIC = EIC, LogDate = logDate, SchemeCode = schemeCode }; db.tAttDailyLogs.Add(n); db.SaveChanges(); } // update the record var l = db.tAttDailyLogs.Where(r => r.EIC == EIC).Single(r => r.LogDate == logDate); if (time_period.Equals("IN1")) { l.In1 = logNow; l.LastLog = time_period; } else if (time_period.Equals("OUT1")) { l.Out1 = logNow; l.LastLog = time_period; } else if (time_period.Equals("IN2")) { l.In2 = logNow; l.LastLog = time_period; } else if (time_period.Equals("OUT2")) { l.Out2 = logNow; l.LastLog = time_period; } // save all changes db.SaveChanges(); // log bundy transaction BundyTransaction(EIC, time_period); var log = db.tAttDailyLogs.Where(r => r.EIC == EIC).Where(r => r.LogDate == logDate); return(Json(new { log }, JsonRequestBehavior.AllowGet)); }