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); }