public List <NO_OF_VEHICLE_MAKE_TYPE_REPORT_DATA> GetAllNoVehicleMake(VehicleMakeGetByParamInput filter)
{
Expression <Func <NO_OF_VEHICLE_MAKE_TYPE_REPORT_DATA, bool> > queryFilter = PredicateHelper.True <NO_OF_VEHICLE_MAKE_TYPE_REPORT_DATA>();
if (filter != null)
{
if (filter.MonthFrom > 0)
{
queryFilter = queryFilter.And(c => c.REPORT_MONTH >= filter.MonthFrom);
}
if (filter.MonthTo > 0)
{
queryFilter = queryFilter.And(c => c.REPORT_MONTH <= filter.MonthTo);
}
if (filter.YearFrom > 0)
{
queryFilter = queryFilter.And(c => c.REPORT_YEAR >= filter.YearFrom);
}
if (filter.YearTo > 0)
{
queryFilter = queryFilter.And(c => c.REPORT_YEAR <= filter.YearTo);
}
if (!string.IsNullOrEmpty(filter.Manufacturer))
{
queryFilter = queryFilter.And(c => c.MANUFACTURER.Contains(filter.Manufacturer));
}
if (!string.IsNullOrEmpty(filter.BodyType))
{
queryFilter = queryFilter.And(c => c.BODY_TYPE.Contains(filter.BodyType));
}
}
return(_noVehMakeRepository.Get(queryFilter, null, "").ToList());
}
public List <NoVehicleMakeDto> GetNoOfVehicleMakeData(VehicleMakeGetByParamInput filter)
{
var data = _ExecSummService.GetAllNoVehicleMake(filter);
var listData = Mapper.Map <List <NoVehicleMakeDto> >(data);
var groupData = listData.GroupBy(x => new { x.MANUFACTURER, x.BODY_TYPE, x.REPORT_MONTH, x.REPORT_YEAR })
.Select(p => new NoVehicleMakeDto()
{
MANUFACTURER = p.FirstOrDefault().MANUFACTURER,
BODY_TYPE = p.FirstOrDefault().BODY_TYPE,
REPORT_MONTH = p.FirstOrDefault().REPORT_MONTH,
REPORT_YEAR = p.FirstOrDefault().REPORT_YEAR,
NO_OF_VEHICLE = p.Sum(c => c.NO_OF_VEHICLE)
}).ToList();
return(groupData);
}
