public List <EstateApi> GetEstatesByNetArea(int minArea, int maxArea)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.NetArea > minArea && ea.NetArea < maxArea).ToList());
}
}
public List <EstateApi> GetEstatesByPrice(int minPrice, int maxPrice)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.Price < maxPrice && ea.Price > minPrice).ToList());
}
}
public List <EstateApi> GetEstatesByFurnitureStatus(bool status)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.FurnitureStatus == status).ToList());
}
}
public List <EstateApi> GetEstatesByHeathingType(int type)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.Heating == type).ToList());
}
}
public List <EstateApi> GetEstatesByCity(string city)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.City == city).ToList());
}
}
public List <EstateApi> GetEstatesByDistrict(string district)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.District == district).ToList());
}
}
public List <EstateApi> GetEstatesByBuildingAge(int maxAge)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.BuildingAge < maxAge).ToList());
}
}
public List <EstateApi> GetEstatesByBathroomNumber(int bathroomNumber)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.BathroomNumber == bathroomNumber).ToList());
}
}
public EstateApi GetEstateByAdvertId(int id)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.AdvertId == id).FirstOrDefault());
}
}
public List <EstateApi> GetEstatesByType(bool type)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.EstateType == type).ToList());
}
}
public List <EstateApi> GetEstatesByRoomNumber(int roomNumber, int livingroomNumber)
{
using (var ec = new EstateDBContext())
{
return(ec.EstateApi.Where(ea => ea.RoomNumber == roomNumber && ea.LivingRoomNumber == livingroomNumber).ToList());
}
}
