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