public JsonResult UpdateRoomBookingOfUserByStayID(RoomBooking_Details stayData)
{
var data = context.tbl_RoomBooking_Details.SingleOrDefault(s => s.ID == stayData.ID);
if (data != null)
{
data.NoOfPerson = stayData.NoOfPerson;
data.RoomID = stayData.RoomID;
data.ComplementaryStays = stayData.ComplementaryStays;
data.TAmtPerRoom = stayData.TAmtPerRoom;
data.ExtraBed = stayData.ExtraBed;
context.Entry(data).State = EntityState.Modified;
context.SaveChanges();
var roomBooking = context.tbl_RoomBooking.SingleOrDefault(s => s.Booking_ID == data.Booking_ID);
if (roomBooking != null)
{
roomBooking.Check_In = stayData.Check_In;
roomBooking.Check_Out = stayData.Check_Out;
roomBooking.NoOfNightStays = stayData.NoOfNightStays;
roomBooking.Amount = calculateAmount(roomBooking.Booking_ID);
context.Entry(roomBooking).State = EntityState.Modified;
context.SaveChanges();
}
}
return(Json("UpdatedRoomBooking"));
}
public ActionResult EditRoomBookingOfUser(int userStayID)
{
var data = context.tbl_RoomBooking_Details.SingleOrDefault(s => s.ID == userStayID);
RoomBooking_Details stayData = new RoomBooking_Details();
if (data != null)
{
var d = context.tbl_RoomBooking.SingleOrDefault(s => s.Booking_ID == data.Booking_ID);
stayData.ID = data.ID;
stayData.Check_In = d != null ? d.Check_In : "";
stayData.Check_Out = d != null ? d.Check_Out : "";
stayData.RoomID = data.RoomID;
stayData.RoomNo = context.tbl_Rooms.SingleOrDefault(r => r.ID == data.RoomID).RoomNo;
stayData.ComplementaryStays = data.ComplementaryStays;
stayData.UserID = d != null ? d.UserID : 0;
stayData.NoOfPerson = data.NoOfPerson;
stayData.TAmtPerRoom = data.TAmtPerRoom;
stayData.ExtraBed = data.ExtraBed;
stayData.Customer = context.tbl_Profile.SingleOrDefault(p => p.ID == d.UserID).F_Name + " " + context.tbl_Profile.SingleOrDefault(p => p.ID == d.UserID).L_Name;
}
return(View(stayData));
}
