public void BookRoom(BookingModel model)
{
using (HMSEntities dbContext = new HMSEntities())
{
tbl_RoomBooking entity = new tbl_RoomBooking();
entity.FromDate = model.fromDate.Value;
entity.ToDate = model.To.Value;
entity.RoomId = model.RoomId;
entity.UserId = model.UserId;
dbContext.tbl_RoomBooking.Add(entity);
dbContext.SaveChanges();
//updateing room status
var room = dbContext.tbl_Room.Where(x => x.Id == model.RoomId).FirstOrDefault();
room.IsAvailable = false;
dbContext.Entry(room).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public JsonResult addStayOfCustomer(string checkin, string checkout, string UserID, string membershipID, string memberName, string phno, int noOfNights, List <RoomBooking_Details> roomInfo, double?advancedPayment, int gstPercent)
{
double?amt = 0;
if (UserID == "0")
{
tbl_Profile prf = new tbl_Profile();
prf.F_Name = memberName;
prf.PhoneNo = phno;
prf.Walk_In_Member = true;
prf.Status = true;
prf.UserType = 3;
prf.AddedBy = Request.Cookies["AddedBy"].Value;
prf.NewUsrBySuperApprv = true;
prf.DelUsrBySuperApprv = false;
prf.Reference_Of_Walk_In = "0";
prf.EmailNotifications = true;
context.tbl_Profile.Add(prf);
context.SaveChanges();
UserID = prf.ID.ToString();
}
foreach (var i in roomInfo)
{
amt += i.TAmtPerRoom;
}
tbl_RoomBooking usrStay = new tbl_RoomBooking();
if (UserID != "0")
{
usrStay.UserID = Convert.ToInt32(UserID);
}
else
{
usrStay.UserID = null;
}
if (membershipID != "0" && membershipID != null)
{
usrStay.MemberID = Convert.ToInt32(membershipID);
}
else
{
usrStay.MemberID = null;
}
usrStay.Check_In = checkin;
usrStay.Check_Out = checkout;
usrStay.NoOfNightStays = noOfNights;
usrStay.Roombillno = GetBillNO();
usrStay.Amount = Math.Round((double)amt, 2);
if (advancedPayment != null)
{
usrStay.AdvancedPayment = advancedPayment;
}
else
{
usrStay.AdvancedPayment = 0;
}
usrStay.GstPercent = gstPercent;
context.tbl_RoomBooking.Add(usrStay);
context.SaveChanges();
foreach (var i in roomInfo)
{
tbl_RoomBooking_Details roomDetails = new tbl_RoomBooking_Details();
roomDetails.Booking_ID = usrStay.Booking_ID;
roomDetails.RoomID = i.RoomID;
roomDetails.NoOfPerson = i.NoOfPerson;
roomDetails.ExtraBed = i.ExtraBed;
roomDetails.ComplementaryStays = i.ComplementaryStays;
roomDetails.TAmtPerRoom = i.TAmtPerRoom;
context.tbl_RoomBooking_Details.Add(roomDetails);
context.SaveChanges();
}
return(Json("RoomBooked"));
}
