public bool BookingDetails(BookingVM bookingVM)
{
//check hotel name and room name
HotelDL hotelDL = new HotelDL();
RoomDL roomDL = new RoomDL();
bool isExistHotelName = hotelDL.CheckHotelName(bookingVM.HotelName);
bool isExistRoomName = roomDL.CheckRoomName(bookingVM.RoomName);
if (isExistHotelName == true && isExistRoomName == true)
{
int hotelId = hotelDL.GetHotelAscending()
.Where(x => x.HotelName == bookingVM.HotelName)
.Select(x => x.HotelId)
.FirstOrDefault();;
int roomId = roomDL.GetRooms()
.Where(x => x.RoomName == bookingVM.RoomName && x.HotelId == hotelId)
.Select(x => x.RoomId)
.FirstOrDefault();;
bookingVM.HotelId = hotelId;
bookingVM.RoomId = roomId;
List <BookingVM> bookingVMs = new List <BookingVM>();
bookingVMs.Add(bookingVM);
bool saveStatus = bookingDL.SaveBookings(bookingVM);
return(saveStatus);
}
return(false);
}
public List <RoomVM> FilterRooms(int?price, int?pincode, string city, string category)
{
var rooms = roomDL.GetRooms(); //returns list of rooms orderby price
var querableRooms = rooms.AsQueryable();
if (price != null && category != null && pincode != null && city != null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.RoomCategory == category && x.Pincode == pincode && x.City == city);
}
else if (price == null && category != null && pincode != null && city != null)
{
querableRooms = querableRooms.Where(x => x.RoomCategory == category && x.Pincode == pincode && x.City == city);
}
else if (price != null && category == null && pincode != null && city != null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.Pincode == pincode && x.City == city);
}
else if (price != null && category != null && pincode == null && city != null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.RoomCategory == category && x.City == city);
}
else if (price != null && category != null && pincode != null && city == null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.RoomCategory == category && x.Pincode == pincode);
}
else if (price == null && category == null && pincode != null && city != null)
{
querableRooms = querableRooms.Where(x => x.Pincode == pincode && x.City == city);
}
else if (price != null && category == null && pincode == null && city != null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.City == city);
}
else if (price != null && category != null && pincode == null && city == null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.RoomCategory == category);
}
else if (price == null && category != null && pincode == null && city != null)
{
querableRooms = querableRooms.Where(x => x.RoomCategory == category && x.City == city);
}
else if (price != null && category == null && pincode != null && city == null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price && x.Pincode == pincode);
}
else if (price == null && category != null && pincode != null && city == null)
{
querableRooms = querableRooms.Where(x => x.RoomCategory == category && x.Pincode == pincode);
}
else if (price == null && category == null && pincode == null && city != null)
{
querableRooms = querableRooms.Where(x => x.City == city);
}
else if (price != null && category == null && pincode == null && city == null)
{
querableRooms = querableRooms.Where(x => x.RoomPrice >= price);
}
else if (price == null && category != null && pincode == null && city == null)
{
querableRooms = querableRooms.Where(x => x.RoomCategory == category);
}
else if (price == null && category == null && pincode != null && city == null)
{
querableRooms = querableRooms.Where(x => x.Pincode == pincode);
}
rooms = querableRooms.ToList();
return(rooms);
}
