protected IQueryable <FleetNow> GetAvailabilityToday()
{
var availability = DataContext.FleetNows.Select(d => d);
availability = FleetNowRestriction.RestrictVehicleQueryable(DataContext, availability);
availability = FleetNowQueryable.GetFleetNow(availability, Parameters);
return(availability);
}
protected IQueryable <FleetNow> GetAvailabilityToday()
{
var availability = DataContext.FleetNows.Select(d => d);
availability = FleetNowRestriction.RestrictVehicleQueryable(DataContext, availability);
if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.FleetTypes))
{
var selectedFleetTypes = Parameters[DictionaryParameter.FleetTypes].Split(',').Select(int.Parse);
availability = availability.Where(d => selectedFleetTypes.Contains(d.FleetTypeId));
}
if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.CarGroup))
{
var carGroupId = int.Parse(Parameters[DictionaryParameter.CarGroup]);
availability = from av in availability
where av.CAR_GROUP.car_group_id == carGroupId
select av;
}
else if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.CarClass))
{
var carClassId = int.Parse(Parameters[DictionaryParameter.CarClass]);
availability = from av in availability
where av.CAR_GROUP.car_class_id == carClassId
select av;
}
else if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.CarSegment))
{
var carSegmentId = int.Parse(Parameters[DictionaryParameter.CarSegment]);
availability = from av in availability
where av.CAR_GROUP.CAR_CLASS.car_segment_id == carSegmentId
select av;
}
else if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.OwningCountry))
{
var owningCountry = Parameters[DictionaryParameter.OwningCountry];
availability = from av in availability
where av.CAR_GROUP.CAR_CLASS.CAR_SEGMENT.country == owningCountry
select av;
}
if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Location))
{
var location = int.Parse(Parameters[DictionaryParameter.Location]);
availability = from av in availability
where av.LOCATION.dim_Location_id == location
select av;
}
else if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.LocationGroup) ||
Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Area))
{
if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.LocationGroup))
{
var locationGroupId = int.Parse(Parameters[DictionaryParameter.LocationGroup]);
availability = from av in availability
where av.LOCATION.cms_location_group_id == locationGroupId
select av;
}
else
{
var areaId = int.Parse(Parameters[DictionaryParameter.Area]);
availability = from av in availability
where av.LOCATION.ops_area_id == areaId
select av;
}
}
else if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Pool) ||
Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Region))
{
if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Pool))
{
var poolId = int.Parse(Parameters[DictionaryParameter.Pool]);
availability = from av in availability
where av.LOCATION.CMS_LOCATION_GROUP.cms_pool_id == poolId
select av;
}
else
{
var regionId = int.Parse(Parameters[DictionaryParameter.Region]);
availability = from av in availability
where av.LOCATION.OPS_AREA.ops_region_id == regionId
select av;
}
}
else if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.LocationCountry))
{
var locationCountry = Parameters[DictionaryParameter.LocationCountry];
availability = from av in availability
where av.LOCATION.country == locationCountry
select av;
}
return(availability);
}
