public ActionResult Index() { try { List <LocationDockQuery> ldq = _repo.GetLocationDockings(); List <TimerModel> list = new List <TimerModel>(); foreach (var d in ldq) { string cn = ""; if (d.CartNumber < 10) { cn = "0" + d.CartNumber.ToString(); } else { cn = d.CartNumber.ToString(); } list.Add(new TimerModel { TimeDisplayName = "Display_" + d.LocationCode, //ReleaseDateTime = Convert.ToString(new DateTime(2020, 6, 8, 17, 42, 00)) //ReleaseDateTime = Convert.ToString(DateTime.Now.AddSeconds(45)) ReleaseDateTime = d.EndTime.ToString(), CartLineNumber = d.LineNumber + " Cart #" + cn, CartDisplayName = "Display_Cart_" + d.LocationCode }); } FreezeDownViewModel fdvm = new FreezeDownViewModel(); fdvm.CartLines = new SelectList(_repo.GetCartLines(), "LineNumber", "LineNumber"); fdvm.CartNumbers = new SelectList(_repo.GetCartNumbers(), "CartNumber", "CartNumber"); fdvm.UserNames = new SelectList(_repo.GetUsersForDD(), "UserName", "UserName"); ViewBag.TimerList = list; ViewBag.Controller = this; //Response.AddHeader("Refresh", "600"); //return View("Index",fdvm); return(View("TestGrid", fdvm)); } catch (Exception ex) { TempData["FreezeDownError"] = ex; return(RedirectToAction("ShowError", "Error")); } }
public ActionResult EndFreeze(FreezeDownViewModel fdvm) { try { User user = new User() { UserName = fdvm.UserName, Password = fdvm.Password }; int UserID = _repo.IsValidUser(user); if (UserID == 0) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Invalid UserName or Password", MediaTypeNames.Text.Plain)); } string CartLine = fdvm.LineNumberEnd; int CartNumber = fdvm.CartNumberEnd.GetValueOrDefault(); string LocationCode = fdvm.LocationCode; int CartID = _repo.GetCartID(CartLine, CartNumber); int LocationID = _repo.GetLocationID(LocationCode); Location loc = _repo.GetLocation(LocationID); Docking dock = _repo.GetDocking(CartID, LocationID); bool rslt = false; if (dock.IsActive == true && loc.IsOcuppied == true) { loc.IsOcuppied = false; loc.LastUpdate = DateTime.Now.ConvertToEST(); dock.IsActive = false; dock.LastUpdate = DateTime.Now.ConvertToEST(); dock.LastUpdateBy = UserID; rslt = _repo.UpdateLocationDock(loc, dock); } return(Json(Url.Action("Index", "Timer"))); } catch (Exception ex) { TempData["FreezeDownError"] = ex; return(RedirectToAction("ShowError", "Error")); } }
public ActionResult StartFreeze(FreezeDownViewModel fdvm) { try { User user = new User() { UserName = fdvm.UserName, Password = fdvm.Password }; int UserID = _repo.IsValidUser(user); if (UserID == 0) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Invalid UserName or Password", MediaTypeNames.Text.Plain)); } bool IsCartValid = _repo.IsCartValid(fdvm.LineNumberStart, fdvm.CartNumberStart.GetValueOrDefault()); if (IsCartValid == false) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Please Select a Valid Cart", MediaTypeNames.Text.Plain)); } bool IsCartInUse = _repo.IsCartInUse(fdvm.LineNumberStart, fdvm.CartNumberStart.GetValueOrDefault()); if (IsCartInUse == true) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Cart Is In Use - Please Select Another", MediaTypeNames.Text.Plain)); } string LocationCode = fdvm.LocationCode; int LocationID = _repo.GetLocationID(LocationCode); string LineNumber = fdvm.LineNumberStart; int CartNumber = fdvm.CartNumberStart.GetValueOrDefault(); int CartID = _repo.GetCartID(LineNumber, CartNumber); var docking = new Docking(); docking.LocationID = LocationID; docking.CartID = CartID; docking.StartTime = DateTime.Now; //docking.EndTime = docking.StartTime.GetValueOrDefault().AddHours(5); //docking.EndTime = docking.StartTime.GetValueOrDefault().AddMinutes(1); docking.EndTime = docking.StartTime.GetValueOrDefault().AddSeconds(90); docking.IsActive = true; docking.InsertDate = DateTime.Now.ConvertToEST(); docking.InsertBy = UserID; //docking.LastUpdate = DateTime.Now.ConvertToEST(); //docking.LastUpdateBy = UserID; bool rslt = false; if (ModelState.IsValid) { rslt = _repo.CreateDocking(docking); } if (rslt == true) { return(Json(Url.Action("Index", "Timer"))); } else { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Docking Record Creation In Database Failed", MediaTypeNames.Text.Plain)); } } catch (Exception ex) { TempData["FreezeDownError"] = ex; return(RedirectToAction("ShowError", "Error")); } }