// GET: RailTransportationRequests/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TransportationRequest transportationRequest = db.TransportationRequest.Find(id);
if (transportationRequest == null)
{
return(HttpNotFound());
}
//ViewBag.idDateMonth = new SelectList(db.DateMonth, "idDateMonth", "DateMonth1", transportationRequest.idDateMonth);
//ViewBag.idRailwayDispatch = new SelectList(db.RailwayDispatch, "idRailwayDispatch", "DispatchType", transportationRequest.idRailwayDispatch);
//ViewBag.idSpecialCondition = new SelectList(db.SpecialCondition, "idSpecialCondition", "SpecialCondition1", transportationRequest.idSpecialCondition);
//ViewBag.idRefBookCars = new SelectList(db.RefBookCars, "idRefBookCars", "CarId", transportationRequest.idRefBookCars);
//ViewBag.Shipper = new SelectList(db.RefBookClient, "idRefBookClient", "ShortName", transportationRequest.Shipper);
//ViewBag.Consignee = new SelectList(db.RefBookClient, "idRefBookClient", "ShortName", transportationRequest.Consignee);
//ViewBag.idRefBookETSNG = new SelectList(db.RefBookETSNG, "idRefBookETSNG", "Kod", transportationRequest.idRefBookETSNG);
//ViewBag.idRefBookGNG = new SelectList(db.RefBookGNG, "idRefBookGNG", "Kod", transportationRequest.idRefBookGNG);
//ViewBag.idRefBookLandFrom = new SelectList(db.RefBookLand, "idRefBookLand", "LandId", transportationRequest.idRefBookLandFrom);
//ViewBag.idRefBookLandTo = new SelectList(db.RefBookLand, "idRefBookLand", "LandId", transportationRequest.idRefBookLandTo);
//ViewBag.idRefBookOwner = new SelectList(db.RefBookOwner, "idRefBookOwner", "OwnerId", transportationRequest.idRefBookOwner);
//ViewBag.RefBookStationFrom = new SelectList(db.RefBookStations, "idRefBookStation", "Kod", transportationRequest.RefBookStationFrom);
//ViewBag.RefBookStationTo = new SelectList(db.RefBookStations, "idRefBookStation", "Kod", transportationRequest.RefBookStationTo);
ViewBag.idTranshipmentMethod = new SelectList(db.TranshipmentMethod, "idTranshipmentMethod", "TranshipmentMethod1", transportationRequest.idTranshipmentMethod);
return(View(transportationRequest));
}
public ActionResult DeleteConfirmed(Guid id)
{
TransportationRequest transportationRequest = db.TransportationRequest.Find(id);
db.TransportationRequest.Remove(transportationRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "idTransportationRequest,idDateMonth,idRefBookLandFrom,idRefBookLandTo,idRefBookETSNG,idRefBookGNG,DeliveryType,RefBookStationFrom,RefBookStationTo,idDepartuePoint,idDestinationPoint,idDepartuePort,idDestinationPort,Shipper,Consignee,idRailwayDispatch,idRefBookCars,idRefBookOwner,Weight,CargoUnitAmmount,CargoUnitNumber1,idSpecialCondition,Note,idTranshipmentMethod")] TransportationRequest transportationRequest)
{
if (ModelState.IsValid)
{
db.Entry(transportationRequest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idTranshipmentMethod = new SelectList(db.TranshipmentMethod, "idTranshipmentMethod", "TranshipmentMethod1", transportationRequest.idTranshipmentMethod);
return(View(transportationRequest));
}
public ActionResult Create([Bind(Include = "idTransportationRequest,idDateMonth,idRefBookLandFrom,idRefBookLandTo,idRefBookETSNG,idRefBookGNG,DeliveryType,RefBookStationFrom,RefBookStationTo,idDepartuePoint,idDestinationPoint,idDepartuePort,idDestinationPort,Shipper,Consignee,idRailwayDispatch,idRefBookCars,idRefBookOwner,Weight,CargoUnitAmmount,CargoUnitNumber1,idSpecialCondition,Note,idTranshipmentMethod")] TransportationRequest transportationRequest)
{
if (ModelState.IsValid)
{
transportationRequest.idTransportationRequest = Guid.NewGuid();
db.TransportationRequest.Add(transportationRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(transportationRequest));
}
public ActionResult Create([Bind(Include = "idTransportationRequest,idDateMonth,idRefBookLandFrom,idRefBookLandTo,idRefBookETSNG,idRefBookGNG,DeliveryType,DepartuePoint,DestinationPoint,Shipper,Consignee,Weight,CargoUnitAmmount,idCargoUnitNumber,idSpecialCondition,Note,idTranshipmentMethod")] TransportationRequest transportationRequest)
{
if (ModelState.IsValid)
{
transportationRequest.idTransportationRequest = Guid.NewGuid();
db.TransportationRequest.Add(transportationRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idTranshipmentMethod = new SelectList(db.TranshipmentMethod, "idTranshipmentMethod", "TranshipmentMethod1", transportationRequest.idTranshipmentMethod);
return(View(transportationRequest));
}
// GET: AutoTransportationRequests/Details/5
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TransportationRequest transportationRequest = db.TransportationRequest.Find(id);
if (transportationRequest == null)
{
return(HttpNotFound());
}
return(View(transportationRequest));
}
// GET: SeaTransportationRequests/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TransportationRequest transportationRequest = db.TransportationRequest.Find(id);
if (transportationRequest == null)
{
return(HttpNotFound());
}
ViewBag.idTranshipmentMethod = new SelectList(db.TranshipmentMethod, "idTranshipmentMethod", "TranshipmentMethod1", transportationRequest.idTranshipmentMethod);
return(View(transportationRequest));
}
public ActionResult Edit([Bind(Include = "idTransportationRequest, idDateMonth, idRefBookLandFrom, idRefBookLandTo, idRefBookETSNG, idRefBookGNG, DeliveryType, DepartuePoint, DestinationPoint, Shipper, Consignee, Weight, CargoUnitAmmount, idCargoUnitNumber, idSpecialCondition, Note, idTranshipmentMethod")] TransportationRequest transportationRequest)
{
if (ModelState.IsValid)
{
db.Entry(transportationRequest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.idTranshipmentMethod = new SelectList(db.TranshipmentMethod, "idTranshipmentMethod", "TranshipmentMethod1", transportationRequest.idTranshipmentMethod);
//ViewBag.idDateMonth = new SelectList(db.DateMonth, "idDateMonth", "DateMonth1", transportationRequest.idDateMonth);
//ViewBag.idRefBookLandFrom = new SelectList(db.RefBookLand, "idRefBookLand", "LName", transportationRequest.idRefBookLandFrom);
//ViewBag.idRefBookLandTo = new SelectList(db.RefBookLand, "idRefBookLand", "LName", transportationRequest.idRefBookLandTo);
//ViewBag.idRefBookETSNG = new SelectList(db.RefBookETSNG, "idRefBookETSNG", "Name", transportationRequest.idRefBookETSNG);
//ViewBag.idRefBookGNG = new SelectList(db.RefBookGNG, "idRefBookGNG", "Name", transportationRequest.idRefBookGNG);
//ViewBag.Shipper = new SelectList(db.RefBookClient, "idRefBookClient", "ShortName", transportationRequest.Shipper);
//ViewBag.Consignee = new SelectList(db.RefBookClient, "idRefBookClient", "ShortName", transportationRequest.Consignee);
//ViewBag.idSpecialCondition = new SelectList(db.SpecialCondition, "idSpecialCondition", "SpecialCondition1", transportationRequest.idSpecialCondition);
return(View(transportationRequest));
}
public ActionResult NewRequest(TransportationRequest_View transRequest)//Drivers[] drivers
{
if (ModelState.IsValid)
{
try
{
// Grabs current logged on user ID as they will be the requester
var RequesterId = transportationContext.Users.Where(u => u.BannerId == transRequest.BannerId).Select(i => i.UserId).FirstOrDefault();
if (RequesterId != null)
{
TransportationRequest newRequest = new TransportationRequest();
newRequest.RequesterUserId = RequesterId;
newRequest.LeaveDate = transRequest.LeaveDate.GetValueOrDefault();
newRequest.LeaveTime = transRequest.LeaveTime.GetValueOrDefault();
newRequest.ReturnDate = transRequest.ReturnDate.GetValueOrDefault();
newRequest.ReturnTime = transRequest.ReturnTime.GetValueOrDefault();
newRequest.Destination = transRequest.Destination;
newRequest.TripPurpose = transRequest.TripPurpose;
newRequest.NumOfStudents = transRequest.NumOfStudents.GetValueOrDefault();
/* Testing default values */
newRequest.RequesterUserId = 1;
newRequest.LeaveDate = DateTime.Parse("7/1/2017");
newRequest.LeaveTime = TimeSpan.Parse("5:15");
newRequest.ReturnDate = DateTime.Parse("7/5/2017");
newRequest.ReturnTime = TimeSpan.Parse("18:35");
newRequest.Destination = "LA";
newRequest.TripPurpose = "Pancakes";
newRequest.NumOfStudents = 4;
//Create Empty Int Object
var transReqId = new ObjectParameter("TranReqId", typeof(int));
//Call Precedure and give transReqId a value
transportationContext.p_TransReq_Add(newRequest.RequesterUserId, newRequest.LeaveDate, newRequest.LeaveTime, newRequest.ReturnDate, newRequest.ReturnTime, newRequest.Destination, newRequest.TripPurpose, newRequest.NumOfStudents, transReqId);
//Drivers _Drivers = new Drivers();
//_Drivers.DriverUserId = 1;
//_Drivers.NeedGasCard = false;
//_Drivers.TransReqId = Convert.ToInt16(transReqId.Value);
//_Drivers.VehicleAddonId = 1;
//_Drivers.VehicleTypeId = 1;
//for (int i = 0; i<drivers.Length; i++) {
// drivers[i].DriverUserId = 1;
//}
if (transReqId != null)
{
//foreach (driver in array)
//{
// insert into db
//}
}
return(RedirectToAction("RequestConfirmation"));
}
// Will require a foreach loop to grab all drivers listed on request
//var DriverId = transportationContext.Users.Where(u => u.UserId == transRequest.UserId).Select(i => i.UserId).FirstOrDefault();
// Will require a foreach loop to grab all passangers listed on the request
//var PassangerId = transportationContext.Users.Where(u => u.UserId == transRequest.UserId).Select(i => i.UserId).FirstOrDefault();
// Add all drivers to DriverGroup Table
//foreach ( /* Driver listed on form (may need to make an array) */)
//{
// DriverGroup Driver = new DriverGroup();
// Driver.RequestId = 0/*Transportation Request primary key*/;
// Driver.UserId = transportationContext.Users.Where(u => u.UserId == 0/*Current Driver Id*/).Select(i => i.UserId).FirstOrDefault();
// if (true /*Driver requires a vehicle*/)
// {
// //Driver.VehicleType
// }
// transportationContext.DriverGroups.Add(Driver);
//}
}
catch
{
return(new HttpStatusCodeResult(Response.StatusCode = 400));
}
}
return(View());
}
public ActionResult NewRequest(TransportationRequest_View_DemoForSymposium transRequest)
{
if (ModelState.IsValid)
{
try
{
// Grabs current logged on user ID as they will be the requester
//Note: This Lambda function is using the logged in user as the requester so if html is edited the validation is still correct
var RequesterId = transportationContext.Users.Where(u => u.BannerId == _LoggedInUser.userInfo.EmployeeId.Substring(1)).Select(i => i.UserId).FirstOrDefault();
if (RequesterId != null)
{
TransportationRequest newRequest = new TransportationRequest();
newRequest.RequesterUserId = RequesterId;
newRequest.LeaveDate = transRequest.LeaveDate.GetValueOrDefault();
newRequest.LeaveTime = transRequest.LeaveTime.GetValueOrDefault();
newRequest.ReturnDate = transRequest.ReturnDate.GetValueOrDefault();
newRequest.ReturnTime = transRequest.ReturnTime.GetValueOrDefault();
newRequest.Destination = transRequest.Destination;
newRequest.TripPurpose = transRequest.TripPurpose;
newRequest.NumOfStudents = transRequest.NumOfStudents.GetValueOrDefault();
//Create Empty Int Object
var transReqId = new ObjectParameter("TranReqId", typeof(int));
//Save Request and Get transportation request Id
transportationContext.p_TransReq_Add(newRequest.RequesterUserId, newRequest.LeaveDate, newRequest.LeaveTime, newRequest.ReturnDate, newRequest.ReturnTime, newRequest.Destination, newRequest.TripPurpose, newRequest.NumOfStudents, transReqId);
//Save to Driver Group Table
DriverGroup driverGroup = new DriverGroup();
driverGroup.NeedGasCard = transRequest.NeedGasCard.GetValueOrDefault();
driverGroup.TranRequestId = Convert.ToInt16(transReqId.Value);
driverGroup.UserId = transRequest.UserId;
driverGroup.VehicleAddOnId = transRequest.VehicleAddOnId;
driverGroup.VehicleTypeId = transRequest.VehicleTypeId;
//Add new driver associated with request
transportationContext.DriverGroups.Add(driverGroup);
//save
transportationContext.SaveChanges();
return(RedirectToAction("RequestConfirmation"));
}
// Will require a foreach loop to grab all drivers listed on request
//var DriverId = transportationContext.Users.Where(u => u.UserId == transRequest.UserId).Select(i => i.UserId).FirstOrDefault();
// Will require a foreach loop to grab all passangers listed on the request
//var PassangerId = transportationContext.Users.Where(u => u.UserId == transRequest.UserId).Select(i => i.UserId).FirstOrDefault();
// Add all drivers to DriverGroup Table
//foreach ( /* Driver listed on form (may need to make an array) */)
//{
// DriverGroup Driver = new DriverGroup();
// Driver.RequestId = 0/*Transportation Request primary key*/;
// Driver.UserId = transportationContext.Users.Where(u => u.UserId == 0/*Current Driver Id*/).Select(i => i.UserId).FirstOrDefault();
// if (true /*Driver requires a vehicle*/)
// {
// //Driver.VehicleType
// }
// transportationContext.DriverGroups.Add(Driver);
//}
}
catch
{
return(new HttpStatusCodeResult(Response.StatusCode = 400));
}
}
return(View());
}
