public ActionResult Update(int parkingID, int bookingID, string bookingDateTime, int hours) { ParkingBooking ParkingBooking = db.ParkingBookings.Find(bookingID); ParkingBooking.ParkingID = parkingID; ParkingBooking.BookingTime = Convert.ToDateTime(bookingDateTime); ParkingBooking.Hours = hours; db.SaveChanges(); return(RedirectToAction("Bookings")); }
public ActionResult Delete(int?id) { string userID = User.Identity.GetUserId(); if (string.IsNullOrEmpty(userID)) { return(RedirectToAction("Login", "Account")); } else { SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@user_id", userID); sqlparams[1] = new SqlParameter("@booking_id", id); string query = "select * from ParkingBookings where BookingID = @booking_id AND UserId = @user_id"; ParkingBooking booking = db.ParkingBookings.SqlQuery(query, sqlparams).FirstOrDefault(); return(View(booking)); } }
public ActionResult UpdateBooking(int?id) { string userID = User.Identity.GetUserId(); if (string.IsNullOrEmpty(userID)) { return(RedirectToAction("Login", "Account")); } else { List <Parking> parkings = db.Parkings.ToList(); ParkingUpdate parkingUpdate = new ParkingUpdate(); SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@userID", userID); sqlparams[1] = new SqlParameter("@id", id); ParkingBooking booking = db.ParkingBookings.SqlQuery("select * from ParkingBookings where BookingID = @id AND UserId = @userID", sqlparams).FirstOrDefault(); parkingUpdate.Parkings = parkings; parkingUpdate.ParkingBooking = booking; Debug.WriteLine(parkingUpdate.ParkingBooking.BookingTime); return(View(parkingUpdate)); } }
public ActionResult AddBooking(int parkingID, string bookingDateTime, int hours) { Debug.WriteLine(bookingDateTime); string userID = User.Identity.GetUserId(); if (string.IsNullOrEmpty(userID)) { return(RedirectToAction("Login", "Account")); } else { ParkingBooking booking = new ParkingBooking(); booking.ParkingID = parkingID; booking.Hours = hours; booking.UserId = User.Identity.GetUserId(); booking.BookingTime = Convert.ToDateTime(bookingDateTime); // Equivalent to SQL insert statement: db.ParkingBookings.Add(booking); db.SaveChanges(); return(RedirectToAction("Bookings")); } }