// GET: AssignMk2/Details/5
public ActionResult Details(int?id)
{
var assign = db.AssignMk2.Find(id);
var booking = db.NewBookings.Find(assign.BookingIds);
DeliveryNote dnote = new DeliveryNote();
dnote.clientname = booking.clientname;
dnote.ConType = booking.ConType;
dnote.specInstruct = booking.specInstruct;
dnote.Size = booking.Size;
dnote.Dropoff = booking.Dropoff;
dnote.dateCreated = System.DateTime.Now;
db.DeliveryNotes.Add(dnote);
db.SaveChanges();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AssignMk2 assignMk2 = db.AssignMk2.Find(id);
if (assignMk2 == null)
{
return(HttpNotFound());
}
return(View(assignMk2));
}
public ActionResult DeleteConfirmed(int id)
{
AssignMk2 assignMk2 = db.AssignMk2.Find(id);
db.AssignMk2.Remove(assignMk2);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: AssignMk2/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AssignMk2 assignMk2 = db.AssignMk2.Find(id);
if (assignMk2 == null)
{
return(HttpNotFound());
}
return(View(assignMk2));
}
public ActionResult Edit([Bind(Include = "id,TruckId,DriverId,TrailerId,BookingIds")] AssignMk2 assignMk2)
{
if (ModelState.IsValid)
{
db.Entry(assignMk2).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BookingIds = new SelectList(db.NewBookings, "BookingIds", "clientname", assignMk2.BookingIds);
ViewBag.DriverId = new SelectList(db.NewDrivers, "DriverId", "Id", assignMk2.DriverId);
ViewBag.TrailerId = new SelectList(db.NewTrailers, "TrailerId", "reg", assignMk2.TrailerId);
ViewBag.TruckId = new SelectList(db.NewTrucks, "TruckId", "make", assignMk2.TruckId);
return(View(assignMk2));
}
// GET: AssignMk2/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AssignMk2 assignMk2 = db.AssignMk2.Find(id);
if (assignMk2 == null)
{
return(HttpNotFound());
}
ViewBag.BookingIds = new SelectList(db.NewBookings, "BookingIds", "clientname", assignMk2.BookingIds);
ViewBag.DriverId = new SelectList(db.NewDrivers, "DriverId", "Id", assignMk2.DriverId);
ViewBag.TrailerId = new SelectList(db.NewTrailers, "TrailerId", "reg", assignMk2.TrailerId);
ViewBag.TruckId = new SelectList(db.NewTrucks, "TruckId", "make", assignMk2.TruckId);
return(View(assignMk2));
}
public ActionResult Create([Bind(Include = "id,TruckId,DriverId,TrailerId,BookingIds")] AssignMk2 assignMk2, int?id)
{
if (ModelState.IsValid)
{
//var Bid = assignMk2.NewBookings;
//var Bid = db.NewBookings.Find(assignMk2.NewBookings.BookingIds);
var Size = db.NewBookings.Find(assignMk2.BookingIds).Size;
double conSize = Convert.ToDouble(Size.Replace("m", "").Trim());
var TruckCap = db.NewTrucks.Find(assignMk2.TruckId);
if (TruckCap.Capacity <= 18)
{
if (conSize == 6)
{
TruckCap.Capacity = TruckCap.Capacity + 6;
}
else if (conSize == 12)
{
TruckCap.Capacity = TruckCap.Capacity + 12;
}
}
if (TruckCap.Capacity == 18)
{
TruckCap.Status = "In Use";//Better Status For this
}
//needs to take out booked record...
var Booked = db.NewBookings.Find(assignMk2.BookingIds).Booked == true;
//Creates...
db.AssignMk2.Add(assignMk2);
db.SaveChanges();
return(RedirectToAction("RenderView"));
}
ViewBag.BookingIds = new SelectList(db.NewBookings, "BookingIds", "clientname", assignMk2.BookingIds);
ViewBag.DriverId = new SelectList(db.NewDrivers, "DriverId", "Id", assignMk2.DriverId);
ViewBag.TrailerId = new SelectList(db.NewTrailers, "TrailerId", "reg", assignMk2.TrailerId);
ViewBag.TruckId = new SelectList(db.NewTrucks, "TruckId", "make", assignMk2.TruckId);
return(View(assignMk2));
}
public ActionResult AssignIndex()
{
var assignMk2 = db.AssignMk2.Include(a => a.NewBookings).Include(a => a.NewDrivers).Include(a => a.NewTrailers).Include(a => a.NewTruck);
foreach (var Assign in assignMk2.ToList())
{
if (Assign.NewBookings.pickupdate <= DateTime.Now)
{
//Finds the truck makes the capacity and makes it free
var FindTruck = db.NewTrucks.Find(Assign.TruckId);
FindTruck.Capacity = 0;
FindTruck.Status = "Free";
if (Assign.NewBookings.pickupdate.AddDays(1) <= DateTime.Now)
{
//deletes the assign
AssignMk2 RemoveAssignFromTable = db.AssignMk2.Find(Assign.id);
db.AssignMk2.Remove(RemoveAssignFromTable);
db.SaveChanges();
}
}
}
return(PartialView("_Assign", db.AssignMk2.ToList()));
}
