/// <summary>
/// Gets the tags.
/// </summary>
/// <returns></returns>
private IQueryable <Location> GetLocations()
{
int filterCount = 0;
var queryable = new Rock.Model.LocationService(new RockContext()).Queryable()
.Where(l => l.Street1 != null && l.Street1 != string.Empty);
if (!string.IsNullOrWhiteSpace(rFilter.GetUserPreference("Street Address")))
{
string streetAddress1 = rFilter.GetUserPreference("Street Address");
queryable = queryable.Where(l => l.Street1.StartsWith(streetAddress1));
filterCount++;
}
if (!string.IsNullOrWhiteSpace(rFilter.GetUserPreference("City")))
{
string city = rFilter.GetUserPreference("City");
queryable = queryable.Where(l => l.City.StartsWith(city));
filterCount++;
}
if (!string.IsNullOrWhiteSpace(rFilter.GetUserPreference("Not Geocoded")))
{
bool notGeocoded = Convert.ToBoolean(rFilter.GetUserPreference("Not Geocoded"));
if (notGeocoded)
{
queryable = queryable.Where(l => l.GeoPoint == null);
filterCount++;
}
}
if (filterCount == 0)
{
return(null);
}
else
{
return(queryable);
}
}
/// <summary>
/// Gets the tags.
/// </summary>
/// <returns></returns>
private IQueryable<Location> GetLocations()
{
int filterCount = 0;
var queryable = new Rock.Model.LocationService( new RockContext() ).Queryable()
.Where( l => l.Street1 != null && l.Street1 != string.Empty );
if ( !string.IsNullOrWhiteSpace(rFilter.GetUserPreference( "Street Address" )) )
{
string streetAddress1 = rFilter.GetUserPreference( "Street Address" );
queryable = queryable.Where( l => l.Street1.StartsWith( streetAddress1 ) );
filterCount++;
}
if ( !string.IsNullOrWhiteSpace( rFilter.GetUserPreference( "City" ) ) )
{
string city = rFilter.GetUserPreference( "City" );
queryable = queryable.Where( l => l.City.StartsWith( city ) );
filterCount++;
}
if ( !string.IsNullOrWhiteSpace( rFilter.GetUserPreference( "Not Geocoded" ) ) )
{
bool notGeocoded = Convert.ToBoolean(rFilter.GetUserPreference( "Not Geocoded" ));
if ( notGeocoded )
{
queryable = queryable.Where( l => l.GeoPoint == null );
filterCount++;
}
}
if ( filterCount == 0 )
{
return null;
}
else
{
return queryable;
}
}
