public ActionResult EditTrailer([Bind(Include = "TrailerNumber,DOTDate,TrailerStatus,Leased,InsuranceCard,Insured,Title,PlateNumber,VinNumber,Manufacturer,ManufactureYear,TrailerLocation,TrailerLength,Issues,DateModified")] TrailerList UpdatedTrailer) { using (TrailerEntities db = new TrailerEntities()) { TrailerList trailer = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber); try { ActiveTrailerList editActiveTrailer = db.ActiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber); editActiveTrailer.TrailerLocation = UpdatedTrailer.TrailerLocation; } catch {} trailer.DOTDate = UpdatedTrailer.DOTDate; trailer.TrailerStatus = UpdatedTrailer.TrailerStatus; trailer.Leased = UpdatedTrailer.Leased; trailer.InsuranceCard = UpdatedTrailer.InsuranceCard; trailer.Insured = UpdatedTrailer.Insured; trailer.Title = UpdatedTrailer.Title; trailer.PlateNumber = UpdatedTrailer.PlateNumber; trailer.VinNumber = UpdatedTrailer.VinNumber; trailer.Manufacturer = UpdatedTrailer.Manufacturer; trailer.ManufactureYear = UpdatedTrailer.ManufactureYear; trailer.TrailerLength = UpdatedTrailer.TrailerLength; trailer.TrailerLocation = UpdatedTrailer.TrailerLocation; trailer.Issues = UpdatedTrailer.Issues; trailer.DateModified = UpdatedTrailer.DateModified; db.SaveChanges(); return(RedirectToAction(actionName: "TrailerList", controllerName: "Trailer")); } }
public ActionResult EditActiveTrailer([Bind(Include = "TrailerGUID,TrailerNumber,TrailerStatus,LoadStatus,Customer,OrderDate,OrderNumber,LocationStatus,TrailerLocation,Notes,Tags,DateModified,LastModifiedBy")] ActiveTrailerList UpdatedTrailer) { using (TrailerEntities db = new TrailerEntities()) { ActiveTrailerList trailer = db.ActiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber); if (!constant.checkIfEqual(trailer, UpdatedTrailer)) { trailer.DateModified = DateTime.Now.ToString("yyyy-MM-dd"); } TrailerList trailerEdit = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == UpdatedTrailer.TrailerNumber); if (trailer.TrailerStatus != constant.TRAILER_STATUS_NEED_EMPTY && UpdatedTrailer.TrailerStatus == constant.TRAILER_STATUS_NEED_EMPTY) { SortList newSort = new SortList() { TrailerNumber = UpdatedTrailer.TrailerNumber, Customer = UpdatedTrailer.Customer, OrderNumber = UpdatedTrailer.OrderNumber, SortType = UpdatedTrailer.Notes, LoadStatus = UpdatedTrailer.LoadStatus, DateArrived = DateTime.Now.ToString("yyyy-MM-dd"), Status = "NEW", }; db.SortLists.Add(newSort); } if (trailerEdit != null) { trailerEdit.TrailerLocation = UpdatedTrailer.TrailerLocation; } trailer.TrailerStatus = UpdatedTrailer.TrailerStatus; trailer.LoadStatus = UpdatedTrailer.LoadStatus; trailer.Customer = UpdatedTrailer.Customer; trailer.OrderDate = UpdatedTrailer.OrderDate; trailer.OrderNumber = UpdatedTrailer.OrderNumber; trailer.LocationStatus = UpdatedTrailer.LocationStatus; if (UpdatedTrailer.TrailerStatus == constant.TRAILER_STATUS_DELIVERED) { trailer.TrailerLocation = UpdatedTrailer.Customer; } else { trailer.TrailerLocation = UpdatedTrailer.TrailerLocation; } trailer.Notes = UpdatedTrailer.Notes; trailer.Tags = UpdatedTrailer.Tags; trailer.LastModifiedBy = Session["name"].ToString(); db.SaveChanges(); return(RedirectToAction(actionName: "ActiveTrailerList", controllerName: "Trailer")); } }
public ActionResult CreateActiveTrailer(string trailerNumber) { using (TrailerEntities db = new TrailerEntities()) { if (Session["username"] == null) { return(RedirectToAction(actionName: "SignIn", controllerName: "Users")); } else { if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_MANAGER) { return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error")); } else { TrailerList trailer; try { trailer = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber); if (db.ActiveTrailerLists.Any(t => t.TrailerNumber == trailer.TrailerNumber)) { //duplicate trailer number return(RedirectToAction(actionName: "AddToActiveTrailerAlreadyExists", controllerName: "Error")); } else { //create active trailer with only 3 fields to copy information, the rest is inputted by user ActiveTrailerList trailerEdit = new ActiveTrailerList() { TrailerNumber = trailer.TrailerNumber, TrailerLocation = trailer.TrailerLocation, DateModified = trailer.DateModified, }; db.ActiveTrailerLists.Add(trailerEdit); db.SaveChanges(); return(RedirectToAction(actionName: "ActiveTrailerList", controllerName: "Trailer")); } } catch { //return trailer does not exist page if trailer is not found in try return(RedirectToAction(actionName: "AddToActiveTrailerDoesNotExist", controllerName: "Error")); } } } } }
public ActionResult AddStorageTrailer(string trailerNumber) { using (TrailerEntities db = new TrailerEntities()) { var trailer = db.InactiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber); var date = DateTime.Now; ActiveTrailerList newTrailer = new ActiveTrailerList() { TrailerNumber = trailer.TrailerNumber, TrailerStatus = "8", LoadStatus = "FIXED", LocationStatus = "ON SITE", DateModified = date.ToString("yyyy-MM-dd"), Notes = trailer.TrailerStatus, }; db.ActiveTrailerLists.Add(newTrailer); db.SaveChanges(); return(RedirectToAction(actionName: "InactiveTrailerList", controllerName: "Trailer")); } }
public ActionResult EditActiveTrailer(string trailerNumber) { if (Session["username"] == null) { return(RedirectToAction(actionName: "SignIn", controllerName: "Users")); } else { if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_DRIVER && (Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_TRANSPORTATION || Convert.ToInt32(Session["department"]) != constant.DEPARTMENT_SUPER_ADMIN)) { return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error")); } else { using (TrailerEntities db = new TrailerEntities()) { ActiveTrailerList trailer = db.ActiveTrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber); return(View(trailer)); } } } }