public List <FUEL_COST_BY_FUNC_REPORT_DATA> GetAllFuelCostByFunction(FuelCostFuncGetByParamInput filter) { Expression <Func <FUEL_COST_BY_FUNC_REPORT_DATA, bool> > queryFilter = PredicateHelper.True <FUEL_COST_BY_FUNC_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.Region)) { queryFilter = queryFilter.And(c => c.REGION.ToUpper() == filter.Region.ToUpper()); } if (!string.IsNullOrEmpty(filter.Function)) { var listFunction = filter.Function.ToUpper().Split(',').ToList(); if (listFunction.Contains("OTHERS")) { queryFilter = queryFilter.And(c => listFunction.Contains(c.FUNCTION.ToUpper()) || (c.FUNCTION.ToUpper() != "SALES" && c.FUNCTION.ToUpper() != "MARKETING" && c.FUNCTION.ToUpper() != "OPERATIONS")); } else { queryFilter = queryFilter.And(c => listFunction.Contains(c.FUNCTION.ToUpper())); } } if (!string.IsNullOrEmpty(filter.VehicleType)) { queryFilter = queryFilter.And(c => c.VEHICLE_TYPE.ToUpper() == filter.VehicleType.ToUpper()); } } return(_fuelCostByFuncRepository.Get(queryFilter, null, "").ToList()); }
public List <FuelCostByFunctionDto> GetFuelCostByFunctionData(FuelCostFuncGetByParamInput filter) { var data = _ExecSummService.GetAllFuelCostByFunction(filter); var listData = Mapper.Map <List <FuelCostByFunctionDto> >(data); var groupData = listData.GroupBy(x => new { x.REGION, x.FUNCTION, x.VEHICLE_TYPE, x.REPORT_MONTH, x.REPORT_YEAR }) .Select(p => new FuelCostByFunctionDto() { REGION = p.FirstOrDefault().REGION, FUNCTION = p.FirstOrDefault().FUNCTION, VEHICLE_TYPE = p.FirstOrDefault().VEHICLE_TYPE, REPORT_MONTH = p.FirstOrDefault().REPORT_MONTH, REPORT_YEAR = p.FirstOrDefault().REPORT_YEAR, TOTAL_FUEL_COST = p.Sum(c => c.TOTAL_FUEL_COST) }).ToList(); return(groupData); }