public List <int> GetRoomIds(DateTime date)
{
using (var db = new HotelManagementDbEntities())
{
return(db.tbl_Bookings.Where(x => x.BookingDate == date).Select(x => x.RoomId).ToList());
}
}
public bool CheckRoomName(string roomName)
{
using (var db = new HotelManagementDbEntities())
{
return(db.tbl_Room.Where(x => x.RoomName == roomName).Any());
}
}
public List <HotelRoomVM> CreateHotelsAndRooms(List <HotelRoomVM> hotelRooms)
{
using (var db = new HotelManagementDbEntities())
{
tbl_Hotel hotel = new tbl_Hotel();
tbl_Room room = new tbl_Room();
var mapper = ModelMapping.MappingConfig();
foreach (var hotelRoom in hotelRooms)
{
hotel = mapper.Map <HotelRoomVM, tbl_Hotel>(hotelRoom);
db.tbl_Hotel.Add(hotel);
db.SaveChanges();
foreach (var rooms in hotelRoom.Rooms)
{
rooms.HotelId = hotel.HotelId;
room = mapper.Map <Room, tbl_Room>(rooms);
db.tbl_Room.Add(room);
db.SaveChanges();
}
}
hotelRooms.ForEach(x => x.HotelId = hotel.HotelId);
hotelRooms.ForEach(x => x.Rooms.ForEach(p => p.RoomId = room.RoomId));
return(hotelRooms);
}
}
public bool CheckHotelName(string hotelName)
{
using (var db = new HotelManagementDbEntities())
{
return(db.tbl_Hotel.Where(x => x.HotelName == hotelName).Any());
}
}
public bool DeleteBooking(int id)
{
using (var db = new HotelManagementDbEntities())
{
var booking = db.tbl_Bookings.Where(x => x.BookingId == id).FirstOrDefault();
if (booking != null)
{
booking.Status = "Deleted";
db.SaveChanges();
return(true);
}
return(false);
}
}
public bool UpdateBookingDetails(int id, string updatedBookingSatus)
{
using (var db = new HotelManagementDbEntities())
{
var exisitingBookingStatus = db.tbl_Bookings.Where(x => x.BookingId == id).FirstOrDefault();
if (exisitingBookingStatus != null)
{
exisitingBookingStatus.Status = updatedBookingSatus;
db.SaveChanges();
return(true);
}
return(false);
}
}
//if isActive is true, returns false (room not available because it is active)
//else returns true
public bool?IsRoomAvailable(List <int> ids)
{
using (var db = new HotelManagementDbEntities())
{
bool isAvailable = false;
foreach (var id in ids)
{
isAvailable = db.tbl_Room.Where(x => x.RoomId == id && x.IsActive == false).Any();
if (isAvailable)
{
return(true);
}
}
return(false);
}
}
public bool SaveBookings(BookingVM bookingVMs)
{
tbl_Bookings booking = new tbl_Bookings();
using (var db = new HotelManagementDbEntities())
{
if (bookingVMs.Status == null)
{
bookingVMs.Status = "Optional";
}
var mapper = ModelMapping.MappingConfig();
var booked = mapper.Map <BookingVM, tbl_Bookings>(bookingVMs);
db.tbl_Bookings.Add(booked);
db.SaveChanges();
return(true);
}
}
public List <RoomVM> GetRooms()
{
List <RoomVM> roomVMs = new List <RoomVM>();
var roomVM = new RoomVM();
using (var db = new HotelManagementDbEntities())
{
var rooms = db.tbl_Room.OrderBy(x => x.RoomPrice).ToList();
var mapper = ModelMapping.MappingConfig();
foreach (var room in rooms)
{
roomVM = mapper.Map <tbl_Room, RoomVM>(room);
roomVMs.Add(roomVM);
}
return(roomVMs);
}
}
public List <HotelLocationVM> GetHotelAscending()
{
List <HotelLocationVM> hotelVMs = new List <HotelLocationVM>();
HotelLocationVM hotelVM = new HotelLocationVM();
using (var db = new HotelManagementDbEntities())
{
var hotels = db.tbl_Hotel.OrderBy(x => x.HotelName).ToList();
var mapper = ModelMapping.MappingConfig();
foreach (var hotel in hotels)
{
hotelVM = mapper.Map <tbl_Hotel, HotelLocationVM>(hotel);
hotelVMs.Add(hotelVM);
}
return(hotelVMs);
}
}
