Hello Team,
In my project, I have the Room page and booking page, so at the booking page when I select the bookingFrom to bookingTo date, and the Room number I expected the room amount to multiple by the number of days book, but things are not working that way, kindly check it for me.
Database
Home Controller
public ActionResult RoomBooking()
{
var objBookingViewModel = new BookingViewModel();
var room = objHotelDbEntities.Rooms.ToList();
objBookingViewModel.ListOfRoom = room.Select(obj => new SelectListItem
{
Text = obj.RoomNumber,
Value = obj.RoomId.ToString(),
Selected = false
});
objBookingViewModel.BookingFrom = DateTime.Now;
objBookingViewModel.BookingTo = DateTime.Now.AddDays(1);
return View(objBookingViewModel);
}
public ActionResult SaveRoomBooking(BookingViewModel objBookingViewModel)
{
int numberOfDays = Convert.ToInt32((objBookingViewModel.BookingFrom - objBookingViewModel.BookingTo).TotalDays);
Room objRoom = objHotelDbEntities.Rooms.Single(model => model.RoomId == objBookingViewModel.AssignRoomId);
decimal RoomPrice = objRoom.RoomPrice;
decimal TotalAmount = objRoom.RoomPrice * numberOfDays;
RoomBooking roomBooking = new RoomBooking()
{
BookingFrom = objBookingViewModel.BookingFrom,
BookingTo = objBookingViewModel.BookingTo,
AssignRoomId = objBookingViewModel.AssignRoomId,
Address = objBookingViewModel.Address,
CustomerName = objBookingViewModel.CustomerName,
PhoneNo = objBookingViewModel.PhoneNo,
NoOfMembers = objBookingViewModel.AssignRoomId,
TotalAmount = objBookingViewModel.TotalAmount
};
objHotelDbEntities.RoomBookings.Add(roomBooking);
objHotelDbEntities.SaveChanges();
objRoom.BookingStatusId = 3;
objHotelDbEntities.SaveChanges();
return Json(new{message="Hotel Booking is Successfully Created.",success=true}, JsonRequestBehavior.AllowGet);
}