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));
}
}
}
}
