public IList <RoomOption> GetRoomOptions(RoomOptionDaoCriteria criteria)
{
using (var db = new HotelBookingDb())
{
List <RoomOption> roomOptions = db.RoomOption.ToList();
if (criteria.AirConditioning)
{
roomOptions = roomOptions.Where(x => x.AirConditioning == true).ToList();
}
if (criteria.Balcony && roomOptions.Count > 1)
{
roomOptions = roomOptions.Where(x => x.Balcony == true).ToList();
}
if (criteria.ChildBed && roomOptions.Count > 1)
{
roomOptions = roomOptions.Where(x => x.ChildBed == true).ToList();
}
if (criteria.WiFi && roomOptions.Count > 1)
{
roomOptions = roomOptions.Where(x => x.WiFi == true).ToList();
}
return(roomOptions);
}
}
public Reservation GetReservationById(int reservationId)
{
using (var db = new HotelBookingDb())
{
Reservation reservation = db.Reservation.Single(x => x.Id == reservationId);
return(reservation);
}
}
public List <Reservation> GetAllReservations()
{
using (var db = new HotelBookingDb())
{
List <Reservation> reservations = db.Reservation.ToList();
return(reservations);
}
}
public IList <Room> GetAllRooms()
{
using (var db = new HotelBookingDb())
{
List <Room> rooms = db.Room.ToList();
return(rooms);
}
}
public List <Room> GetRoomByRoomsIds(List <int> roomIds)
{
using (var db = new HotelBookingDb())
{
List <Room> rooms = db.Room.Where(x => roomIds.Contains(x.Id)).ToList();
return(rooms);
}
}
public List <Reservation> GetReservationsByUserId(int userId)
{
using (var db = new HotelBookingDb())
{
List <Reservation> reservations = db.Reservation.Where(x => x.UserId == userId).ToList();
return(reservations);
}
}
public void Insert(Reservation reservation)
{
using (var db = new HotelBookingDb())
{
db.Reservation.Add(reservation);
db.SaveChanges();
}
}
public User GetUserByUsername(string username)
{
using (var db = new HotelBookingDb())
{
User user = db.User.Where(x => x.Username == username).FirstOrDefault();
return(user);
}
}
public void Insert(User user)
{
using (var db = new HotelBookingDb())
{
db.User.Add(user);
db.SaveChanges();
}
}
public Room GetRoomByRoomId(int roomId)
{
using (var db = new HotelBookingDb())
{
Room room = db.Room.Single(x => x.Id == roomId);
return(room);
}
}
public RoomOption GetRoomOptionByRoomId(int roomId)
{
using (var db = new HotelBookingDb())
{
RoomOption roomOption = db.RoomOption.Single(x => x.RoomId == roomId);
return(roomOption);
}
}
public IList <RoomOption> GetAllRoomOptions()
{
using (var db = new HotelBookingDb())
{
List <RoomOption> roomOptions = db.RoomOption.ToList();
return(roomOptions);
}
}
public IList <RoomOption> GetRoomOptionsByRoomIds(List <int> roomIds)
{
using (var db = new HotelBookingDb())
{
List <RoomOption> roomOptions = db.RoomOption.Where(x => roomIds.Contains(x.RoomId)).ToList();
return(roomOptions);
}
}
public Room GetRoomByRoomName(string roomName)
{
using (var db = new HotelBookingDb())
{
Room room = db.Room.Single(x => x.Name == roomName);
return(room);
}
}
public List <Reservation> GetReservationsByDateRange(DateTime reservationStartDate, DateTime reservationEndDate)
{
using (var db = new HotelBookingDb())
{
List <Reservation> reservations = db.Reservation.Where(x => x.StartDate >= reservationStartDate && x.StartDate <= reservationEndDate ||
reservationStartDate >= x.StartDate && reservationStartDate <= x.EndDate).ToList();
return(reservations);
}
}
public IList <Room> GetRooms(SearchRoomCriteria criteria)
{
int personNumber = criteria.Adults + criteria.Children;
using (var db = new HotelBookingDb())
{
List <Room> rooms = db.Room.Where(x => x.MaxPerson >= personNumber).ToList();
return(rooms);
}
}
public void Delete(int reservationId)
{
using (var db = new HotelBookingDb())
{
Reservation reservation = db.Reservation.Single(x => x.Id == reservationId);
db.Reservation.Remove(reservation);
db.SaveChanges();
}
}
public void UpdateReservationStatus(int reservationId, int status)
{
using (var db = new HotelBookingDb())
{
Reservation reservation = db.Reservation.Single(x => x.Id == reservationId);
reservation.Status = status;
db.SaveChanges();
}
}
public void UpdateReservation(Reservation reservationEntity)
{
using (var db = new HotelBookingDb())
{
Reservation reservation = db.Reservation.Single(x => x.Id == reservationEntity.Id);
reservation.RoomId = reservationEntity.Status;
reservation.UserId = reservationEntity.UserId;
reservation.StartDate = reservationEntity.StartDate;
reservation.EndDate = reservationEntity.EndDate;
reservation.Status = reservationEntity.Status;
db.SaveChanges();
}
}
