public ActionResult Edit(Models.VehicleBooking booking)
        {
            try
            {
                var db = new CodeFirst.CodeFirst();

                var adjBooking = db.Vehicle_Booking_Line.Where(v => v.VehicleBookingID == booking.VehicleBookingID).FirstOrDefault();
                adjBooking.EndTime   = booking.EndTime;
                adjBooking.Reason    = booking.Reason;
                adjBooking.UserID    = booking.UserID;
                adjBooking.ProjectID = booking.ProjectID;

                db.SaveChanges();

                return(Json(new
                {
                    ResultValue = "Success"
                }));
            }
            catch
            {
                return(Json(new
                {
                    ResultValue = "Error"
                }));
            }
        }
        public ActionResult Add(Models.VehicleBooking booking)
        {
            try
            {
                var db = new CodeFirst.CodeFirst();

                db.Vehicle_Booking.Add(new CodeFirst.Vehicle_Booking
                {
                    VehicleBookingID = booking.VehicleBookingID
                });

                db.Vehicle_Booking_Line.Add(new CodeFirst.Vehicle_Booking_Line
                {
                    VehicleBookingID = booking.VehicleBookingID,
                    Reason           = booking.Reason,
                    ProjectID        = booking.ProjectID,
                    OdoEnd           = booking.OdoEnd,
                    DateBooked       = DateTime.ParseExact(booking.DateBooked, "MM/dd/yyyy", CultureInfo.InvariantCulture),
                    StartTime        = booking.StartTime,
                    EndTime          = booking.EndTime,
                    VehicleID        = globalVehicleID,
                    IntervalID       = booking.IntervalID,
                    UserID           = booking.UserID
                });
                db.SaveChanges();

                return(Json(new
                {
                    ResultValue = "Success"
                }));
            }
            catch
            {
                return(Json(new
                {
                    ResultValue = "Error"
                }));
            }
        }
        public ActionResult Adjusted(Models.VehicleBooking booking)
        {
            try
            {
                var db = new CodeFirst.CodeFirst();

                var adjBooking = db.Vehicle_Booking_Line.Where(v => v.VehicleBookingID == booking.VehicleBookingID).FirstOrDefault();
                adjBooking.OdoEnd = booking.OdoEnd;

                db.SaveChanges();

                return(Json(new
                {
                    ResultValue = "Success"
                }));
            }
            catch
            {
                return(Json(new
                {
                    ResultValue = "Error"
                }));
            }
        }