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