public IQueryable<Property> SearchPropertiesByUser(SearchQuery search)
{
//Finding user that matches SearchQuery's username
string username = search.UserName;
var user = db.Users.FirstOrDefault(u => u.UserName == username);
//Returns all properties that have associated username's userId
IQueryable<Property> properties = db.Properties.Where(p => p.UserId == user.Id);
return properties;
}
public IQueryable<Property> SearchProperties(SearchQuery search)
{
//Building SQL query based on null values in SearchQuery object
IQueryable<Property> properties = db.Properties;
if (!String.IsNullOrEmpty(search.City))
{
properties = properties.Where(p => p.City == search.City);
}
if (search.MinRent > 0 && search.MinRent != null)
{
properties = properties.Where(p => p.Rent >= search.MinRent);
}
if (search.MaxRent > 0 && search.MaxRent != null)
{
properties = properties.Where(p => p.Rent <= search.MaxRent);
}
if (search.Bedrooms > 0 && search.Bedrooms != null)
{
properties = properties.Where(p => p.Bedrooms >= search.Bedrooms);
}
if (search.Bathrooms > 0 && search.Bathrooms != null)
{
properties = properties.Where(p => p.Bathrooms >= search.Bathrooms);
}
//Returns results of search query
return properties;
}