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)); }