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 CreateTrailer([Bind(Include = "TrailerNumber,DOTDate,TrailerStatus,Leased,InsuranceCard,Insured,Title,PlateNumber,VinNumber,Manufacturer,ManufactureYear,TrailerLocation,TrailerLength,Issues,DateModified")] TrailerList createTrailer)
{
//add new trailer to database
using (TrailerEntities db = new TrailerEntities())
{
if (ModelState.IsValid)
{
//create trailer
TrailerList trailer = new TrailerList()
{
TrailerNumber = createTrailer.TrailerNumber,
DOTDate = createTrailer.DOTDate,
TrailerStatus = createTrailer.TrailerStatus,
Leased = createTrailer.Leased,
InsuranceCard = createTrailer.InsuranceCard,
Insured = createTrailer.Insured,
Title = createTrailer.Title,
PlateNumber = createTrailer.PlateNumber,
VinNumber = createTrailer.VinNumber,
Manufacturer = createTrailer.Manufacturer,
ManufactureYear = createTrailer.ManufactureYear,
TrailerLocation = createTrailer.TrailerLocation,
TrailerLength = createTrailer.TrailerLength,
Issues = createTrailer.Issues,
DateModified = createTrailer.DateModified
};
//check to make sure trailer number does not exist already
if (db.TrailerLists.Any(t => t.TrailerNumber == trailer.TrailerNumber))
{
//duplicate trailer number
ModelState.AddModelError("TrailerNumber", "Trailer number already exists");
return(View());
}
if (createTrailer.TrailerNumber.Contains(" "))
{
ModelState.AddModelError("TrailerNumber", "Trailer number must not contain any spaces");
return(View());
}
db.TrailerLists.Add(trailer);
db.SaveChanges();
return(RedirectToAction(actionName: "TrailerList", controllerName: "Trailer"));
}
return(View());
}
}
public ActionResult CreateInactiveTrailer(string trailerNumber)
{
if (Session["username"] == null)
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
else
{
using (TrailerEntities db = new TrailerEntities())
{
if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_EDIT)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
TrailerList trailer = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber);
InactiveTrailerList trailerEdit = new InactiveTrailerList()
{
TrailerNumber = trailer.TrailerNumber,
DOTDate = trailer.DOTDate,
TrailerStatus = trailer.TrailerStatus,
Leased = trailer.Leased,
InsuranceCard = trailer.InsuranceCard,
Insured = trailer.Insured,
Title = trailer.Title,
PlateNumber = trailer.PlateNumber,
VinNumber = trailer.VinNumber,
Manufacturer = trailer.Manufacturer,
ManufactureYear = trailer.ManufactureYear,
TrailerLength = trailer.TrailerLength,
Issues = trailer.Issues,
DateModified = trailer.DateModified
};
db.InactiveTrailerLists.Add(trailerEdit);
db.SaveChanges();
return(RedirectToAction(actionName: "RemoveFromMasterList", controllerName: "Trailer", routeValues: new { trailerNumber }));
}
}
}
}
public ActionResult EditTrailer(string trailerNumber)
{
if (Session["username"] == null)
{
return(RedirectToAction(actionName: "SignIn", controllerName: "Users"));
}
else
{
if (Convert.ToInt32(Session["permission"]) < constant.PERMISSION_EDIT)
{
return(RedirectToAction(actionName: "InsufficientPermissions", controllerName: "Error"));
}
else
{
using (TrailerEntities db = new TrailerEntities())
{
TrailerList trailer = db.TrailerLists.FirstOrDefault(t => t.TrailerNumber == trailerNumber);
return(View(trailer));
}
}
}
}