public static async Task <Domain.RealEstate> GetAsync(int id)
{
using (var context = new RealEstateOfficeContext())
{
var realEstate = await context.RealEstates.SingleAsync(x => x.Id == id);
return(realEstate);
}
}
public static List <Domain.User> ListOfUser()
{
List <Domain.User> UserList = new List <Domain.User>();
using (var context = new RealEstateOfficeContext())
{
UserList = context.Users.ToList();
}
return(UserList);
}
public static List <Domain.RealEstate> RealEstateChoice(Filter filter, SearchSettings searchSettings) //List<RealEstate>
{
using (var context = new RealEstateOfficeContext())
{
IQueryable <Domain.RealEstate> query = context.RealEstates;
if (!filter.Street.IsNullOrEmpty())
{
query = query
.Where(x => x.Street == filter.Street);
}
if (!filter.City.IsNullOrEmpty())
{
query = query
.Where(x => x.City == filter.City);
}
if (!filter.OwnerName.IsNullOrEmpty())
{
query = query
.Where(x => x.Ownername == filter.OwnerName);
}
if (!filter.OwnerSurname.IsNullOrEmpty())
{
query = query
.Where(x => x.Ownersurname == filter.OwnerSurname);
}
if (filter.PriceHighest != null)
{
query = query
.Where(x => x.Price <= filter.PriceHighest);
}
if (filter.PriceLowest != null)
{
query = query
.Where(x => x.Price >= filter.PriceLowest);
}
if (filter.AreaBiggest != null)
{
query = query
.Where(x => x.Area <= filter.AreaBiggest);
}
if (filter.AreaSmallest != null)
{
query = query
.Where(x => x.Area >= filter.AreaSmallest);
}
if (filter.RoomAmountBiggest != null)
{
query = query
.Where(x => x.Roomamount <= filter.RoomAmountBiggest);
}
if (filter.RoomAmountSmallest != null)
{
query = query
.Where(x => x.Roomamount >= filter.RoomAmountSmallest);
}
if (filter.CreationDateEarliest != null)
{
query = query
.Where(x => DateTime.Compare(x.Creationdate, (DateTime)filter.CreationDateEarliest) >= 0);
}
if (filter.CreationDateLatest != null)
{
query = query
.Where(x => DateTime.Compare(x.Creationdate, (DateTime)filter.CreationDateLatest) <= 0);
}
if (filter.TypesOfRealEstate.Any(x => x == true))
{
List <int> chosenRealEstateTypes = new List <int>();
for (int i = 0; i < 5; i++)
{
if (filter.TypesOfRealEstate[i])
{
chosenRealEstateTypes.Add(i);
}
}
query = query
.Where(x => chosenRealEstateTypes.Contains(x.Typeofrealestate));
}
searchSettings.TableSize = query.Count();
searchSettings.PageSize = 20;
searchSettings.PageCount = searchSettings.TableSize / searchSettings.PageSize;
return(query
.Skip(Math.Max(searchSettings.PageNumber - 1, 0) * searchSettings.PageSize)
.Take(searchSettings.PageSize)
.ToList());
}
}