public ActionResult DeleteConfirmed(int id) { NewNEWAssign newNEWAssign = db.NewNEWAssigns.Find(id); db.NewNEWAssigns.Remove(newNEWAssign); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "AssignID,ContID,SelectedDate,ContainerNumber,ContainerSize,Driver,Truck,Trailer,Location,Destination,Status,PickUpTime,PickUpDate,EstDate,EstTime,AssignCode")] NewNEWAssign newNEWAssign) { if (ModelState.IsValid) { db.Entry(newNEWAssign).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ContID = new SelectList(db.NewContainers, "ContainerID", "ContainerNumber", newNEWAssign.ContID); return(View(newNEWAssign)); }
// GET: NewNEWAssigns/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NewNEWAssign newNEWAssign = db.NewNEWAssigns.Find(id); if (newNEWAssign == null) { return(HttpNotFound()); } return(View(newNEWAssign)); }
// GET: NewNEWAssigns/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NewNEWAssign newNEWAssign = db.NewNEWAssigns.Find(id); if (newNEWAssign == null) { return(HttpNotFound()); } ViewBag.ContID = new SelectList(db.NewContainers, "ContainerID", "ContainerNumber", newNEWAssign.ContID); return(View(newNEWAssign)); }
public ActionResult Create([Bind(Include = "AssignID,ContID,SelectedDate,ContainerNumber,ContainerSize,Driver,Truck,Trailer,Location,Destination,Status,PickUpTime,PickUpDate,EstDate,EstTime,AssignCode")] NewNEWAssign newNEWAssign) { if (ModelState.IsValid) { var containers = db.NewContainers.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).ToList(); var Priority1 = containers.Where(x => x.Priority == "High").ToList(); var Priority2 = containers.Where(x => x.Priority == "Medium").ToList(); var Priority3 = containers.Where(x => x.Priority == "Low").ToList(); var FreeDri = db.DatesBookedDrivers.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).ToList(); var FreeTru = db.DatesBookedTrucks.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).ToList(); var FreeTra = db.DatesBookedTrailers.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).ToList(); foreach (var item in Priority1) { if (FreeDri != null && FreeTra != null && FreeTru != null) { try { var Pri1 = Priority1.Where(x => x.Status == "UnAssigned").First(); var Dri = FreeDri.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var DriverYeah = db.NewDrivers.Find(Dri.DriveID); var Tru = FreeTru.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var TruckYeah = db.NewTrucks.Find(Dri.DriveID); var Tra = FreeTra.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var TrailerYeah = db.NewTrailers.Find(Dri.DriveID); NewNEWAssign obj = new NewNEWAssign(); obj.AssignID = Pri1.ContainerID; obj.PickUpDate = Pri1.PickUp; obj.PickUpTime = Pri1.PickUpTime; obj.ContainerNumber = Pri1.ContainerNumber; obj.ContainerSize = Pri1.ContainerSize; obj.Location = Pri1.Location; obj.Destination = Pri1.Destination; //////// //////// obj.Driver = DriverYeah.Email; obj.Trailer = TrailerYeah.reg; obj.Truck = TruckYeah.reg; Pri1.Status = "Pending"; Dri.PickUpDate = newNEWAssign.SelectedDate; Tra.PickUpDate = newNEWAssign.SelectedDate; Tru.PickUpDate = newNEWAssign.SelectedDate; } catch (Exception) { } } else { foreach (var item1 in Priority1) { var Pri1 = Priority1.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).First(); Pri1.PickUp = Pri1.PickUp.AddDays(1); } } } foreach (var item in Priority2) { if (FreeDri != null && FreeTra != null && FreeTru != null) { try { var Pri2 = Priority2.Where(x => x.Status == "UnAssigned").First(); var Dri = FreeDri.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var DriverYeah = db.NewDrivers.Find(Dri.DriveID); var Tru = FreeTru.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var TruckYeah = db.NewTrucks.Find(Dri.DriveID); var Tra = FreeTra.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var TrailerYeah = db.NewTrailers.Find(Dri.DriveID); NewNEWAssign obj = new NewNEWAssign(); obj.AssignID = Pri2.ContainerID; obj.PickUpDate = Pri2.PickUp; obj.PickUpTime = Pri2.PickUpTime; obj.ContainerNumber = Pri2.ContainerNumber; obj.ContainerSize = Pri2.ContainerSize; obj.Location = Pri2.Location; obj.Destination = Pri2.Destination; //////// //////// obj.Driver = DriverYeah.Email; obj.Trailer = TrailerYeah.reg; obj.Truck = TruckYeah.reg; Pri2.Status = "Pending"; Dri.PickUpDate = newNEWAssign.SelectedDate; Tra.PickUpDate = newNEWAssign.SelectedDate; Tru.PickUpDate = newNEWAssign.SelectedDate; } catch (Exception) { } } else { foreach (var item2 in Priority2) { var Pri2 = Priority2.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).First(); Pri2.PickUp = Pri2.PickUp.AddDays(1); } } } foreach (var item in Priority3) { if (FreeDri != null && FreeTra != null && FreeTru != null) { try { var Pri3 = Priority3.Where(x => x.Status == "UnAssigned").First(); var Dri = FreeDri.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var DriverYeah = db.NewDrivers.Find(Dri.DriveID); var Tru = FreeTru.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var TruckYeah = db.NewTrucks.Find(Dri.DriveID); var Tra = FreeTra.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First(); var TrailerYeah = db.NewTrailers.Find(Dri.DriveID); NewNEWAssign obj = new NewNEWAssign(); obj.AssignID = Pri3.ContainerID; obj.PickUpDate = Pri3.PickUp; obj.PickUpTime = Pri3.PickUpTime; obj.ContainerNumber = Pri3.ContainerNumber; obj.ContainerSize = Pri3.ContainerSize; obj.Location = Pri3.Location; obj.Destination = Pri3.Destination; //////// //////// obj.Driver = DriverYeah.Email; obj.Trailer = TrailerYeah.reg; obj.Truck = TruckYeah.reg; Pri3.Status = "Pending"; Dri.PickUpDate = newNEWAssign.SelectedDate; Tra.PickUpDate = newNEWAssign.SelectedDate; Tru.PickUpDate = newNEWAssign.SelectedDate; } catch (Exception) { } } else { foreach (var item3 in Priority3) { var Pri3 = Priority3.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).First(); Pri3.PickUp = Pri3.PickUp.AddDays(1); } } } db.NewNEWAssigns.Add(newNEWAssign); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ContID = new SelectList(db.NewContainers, "ContainerID", "ContainerNumber", newNEWAssign.ContID); return(View(newNEWAssign)); }