public ActionResult BookVehicle(LogisticBooking lb) { try { var GetVehicle = db.Vehicles.Where(c => c.Status.Equals("RoadWorthy") && !db.LogisticBookings.Select(b => b.VehicleId).Contains(c.VehicleId)); ViewBag.ChooseVehicle = new SelectList(GetVehicle, "VehicleId", "VehicleName"); var vehicle = db.LogisticBookings.Find(lb.VehicleId); lb.Status = "Pending"; lb.BookingDate = DateTime.Now; lb.EmpId = Convert.ToInt32(Session["EmpId"]); lb.ProjectId = Convert.ToInt32(Session["ProjectId"]); db.LogisticBookings.Add(lb); db.SaveChanges(); TempData["Success"] = "Booked Successfully"; } catch (Exception ex) { return(View(ex)); } return(View()); }
public ActionResult UpdateBooking(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LogisticBooking booking = db.LogisticBookings.Find(id); if (booking == null) { return(HttpNotFound()); } return(View(booking)); }
public ActionResult UpdateBooking(LogisticBooking l) { if (ModelState.IsValid) { if (!(l.Status.Equals("Approved") || l.Status.Equals("Declined"))) { ViewBag.Error = "Select Status"; } else { l.DateAttended = DateTime.Now; db.Entry(l).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "successful"; } } return(View(l)); }