public bool HotelIsReal(Hotel hotel)
{
using (HotelDb hotelDb = new HotelDb())
{
return(1 <= hotelDb.Hotels.Where(a => a.Name == hotel.Name).Count());
}
}
public Country[] GetCountries()
{
using (HotelDb hotel = new HotelDb())
{
hotel.Configuration.ProxyCreationEnabled = false;
return(hotel.Countries.ToArray());
}
}
public TypeApartment[] GetTypeApartments()
{
using (HotelDb hotel = new HotelDb())
{
hotel.Configuration.ProxyCreationEnabled = false;
return(hotel.TypeApartments.ToArray());
}
}
public void AddHotel(Hotel hotel)
{
using (HotelDb hotelDb = new HotelDb())
{
hotel.Address.Country = hotelDb.Countries.Where(a => a.Name == hotel.Address.Country.Name).First();
hotelDb.Hotels.Add(hotel);
hotelDb.SaveChanges();
}
}
public void AddRoom(string nameHotel, Apartament apartament)
{
using (HotelDb hotelDb = new HotelDb())
{
apartament.Hotel = hotelDb.Hotels.Where(a => a.Name == nameHotel).First();
apartament.TypeApartment = hotelDb.TypeApartments.Where(a => a.Type == apartament.TypeApartment.Type).First();
hotelDb.Apartaments.Add(apartament);
hotelDb.SaveChanges();
}
}
public string[] GetHotelName()
{
List <string> HotelName = new List <string>();
using (HotelDb hotelDb = new HotelDb())
{
foreach (var item in hotelDb.Hotels.ToList())
{
HotelName.Add(item.Name);
}
}
return(HotelName.ToArray());
}
public Apartamet_DTO[] GetApartaments(DateTime first, DateTime Second, string name)
{
Hotel hot;
using (HotelDb hotelDb = new HotelDb())
{
hot = hotelDb.Hotels.Where(a => a.Name == name).First();
var client = hotelDb.Clients.Where(d => (d.FirstDate > first && d.FirstDate < Second) || (d.LastDate > first && d.LastDate < first) || (d.FirstDate <first && d.LastDate> Second));
var apartament = hotelDb.Apartaments.Where(a => a.Clients.Where(c => client.Where(c1 => c1.Id == c.Id).Count() == 0).Count() == 0).ToArray();
//for (int i = 0; i < client; i++)
//{
// for (int i = 0; i < length; i++)
// {
//
// }
//}
// var apart = hotelDb.Clients.Where( c => c.)
hotelDb.Configuration.ProxyCreationEnabled = false;
return(apartament.Select(a => new Apartamet_DTO()
{
Id = a.Id,
RoomQuantity = a.RoomQuantity,
ClientIds = a.Clients.Select(c => c.Id).ToArray(),
Floor = a.Floor,
Hotel = a.Hotel.Name,
Numb = a.Numb,
PlaceQuantity = a.PlaceQuantity,
Price = a.Price,
TypeApartament = a.TypeApartment.Type
}
).ToArray());
//return apart.ToArray();
//return new
}
}
public CustomerRepository(HotelDb dbContext) : base(dbContext)
{
_dbContext = dbContext;
}
public RoomRepository(HotelDb dbContext) : base(dbContext)
{
_dbContext = dbContext;
}
public BaseRepository(HotelDb dbContext)
{
_dbContext = dbContext;
}
public ReservationRepository(HotelDb dbContext) : base(dbContext)
{
_dbContext = dbContext;
}
