/// <summary>
/// For Mapping table so that the booked rooms will not be shown
/// </summary>
/// <param name="obj"></param>
public bool RoomIdBookingIdUpdate(BookingTransfer obj)
{
obj.bookingDate = DateTime.Today;
List <int> bookingIds = (from booking in dbContext.booking
where booking.bookingDate == obj.bookingDate && booking.checkInDate == obj.checkInDate &&
booking.checkOutDate == obj.checkOutDate && booking.bookingAmount == obj.bookingAmount &&
booking.discountAmount == obj.discountAmount
select booking.bookingId).ToList();
List <int> allBookingIds = (from map in dbContext.roomBookingDetails
select map.bookingId).ToList();
List <int> idsToBeExcluded = new List <int>();
foreach (int id in bookingIds)
{
foreach (int ids in allBookingIds)
{
if (id == ids)
{
idsToBeExcluded.Add(id);
}
}
}
if (idsToBeExcluded.Count != 0)
{
bookingIds.RemoveAll(x => idsToBeExcluded.Any(y => y == x));
}
try
{
int bookingIdToMap = bookingIds[0];
RoomBookingDetails roomBookingUpdate = new RoomBookingDetails();
roomBookingUpdate.bookingId = bookingIdToMap;
roomBookingUpdate.roomId = obj.roomId;
roomBookingUpdate.userId = obj.userId;
//Adding the roomBookingUpdate object to database
dbContext.roomBookingDetails.Add(roomBookingUpdate);
dbContext.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public void RoomIdBookingIdUpdate(BookingTransfer obj)
{
int bookingIdToMap = (from booking in db.booking
where booking.bookingDate == obj.bookingDate && booking.checkInDate == obj.checkInDate &&
booking.checkOutDate == obj.checkOutDate && booking.bookingAmount == obj.bookingAmount &&
booking.discountAmount == obj.discountAmount
select booking.bookingId).FirstOrDefault();
RoomBookingDetails roomBookingUpdate = new RoomBookingDetails();
try
{
// roomBookingUpdate.bookingId = Convert.ToInt32(bookingIdToMap);
roomBookingUpdate.bookingId = bookingIdToMap;
roomBookingUpdate.roomId = obj.roomId;
db.roomBookingDetails.Add(roomBookingUpdate);
db.SaveChanges();
}
catch
{
Console.WriteLine("Alert");
}
}
