public List <KPI_REPORT_DATA> GetTransaction(KpiMonitoringGetByParamInput filter) { Expression <Func <KPI_REPORT_DATA, bool> > queryFilter = PredicateHelper.True <KPI_REPORT_DATA>(); if (filter != null) { if (filter.FromDate.HasValue) { queryFilter = queryFilter.And(c => c.EFFECTIVE_DATE >= filter.FromDate); } if (filter.ToDate.HasValue) { queryFilter = queryFilter.And(c => c.EFFECTIVE_DATE <= filter.ToDate); } if (!string.IsNullOrEmpty(filter.FormType)) { queryFilter = queryFilter.And(c => (c.FORM_TYPE == null ? "" : c.FORM_TYPE.ToUpper()) == filter.FormType.ToUpper()); } if (!string.IsNullOrEmpty(filter.VehicleUsage)) { queryFilter = queryFilter.And(c => (c.VEHICLE_USAGE == null ? "" : c.VEHICLE_USAGE.ToUpper()) == filter.VehicleUsage.ToUpper()); } if (!string.IsNullOrEmpty(filter.Location)) { queryFilter = queryFilter.And(c => (c.ADDRESS == null ? "" : c.ADDRESS.ToUpper()) == filter.Location.ToUpper()); } } return(_kpiMonitoringRepository.Get(queryFilter, null, "").ToList()); }
public List <KpiMonitoringDto> GetTransaction(KpiMonitoringGetByParamInput filter) { var data = _kpiMonitoringService.GetTransaction(filter); var redata = Mapper.Map <List <KpiMonitoringDto> >(data); return(redata); }
public ActionResult Index() { var model = new RptKpiMonitoringModel(); var filter = new KpiMonitoringGetByParamInput(); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; var FormTypeList = new Dictionary <string, string> { { "CSF", "CSF" }, { "CTF", "CTF" }, { "CRF", "CRF" } }; var VehicleUsageList = _settingBLL.GetSetting().Where(x => x.SettingGroup == "VEHICLE_USAGE_BENEFIT").ToList(); var BasetownList = _employeeBLL.GetEmployee().Where(x => x.IS_ACTIVE).Select(x => new { BASETOWN = x.BASETOWN }).Distinct().OrderBy(x => x.BASETOWN).ToList(); model.SearchView.FormDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); model.SearchView.ToDate = DateTime.Today; model.SearchView.FormTypeList = new SelectList(FormTypeList, "Key", "Value"); model.SearchView.VehicleUsageList = new SelectList(VehicleUsageList, "SettingName", "SettingName"); model.SearchView.LocationList = new SelectList(BasetownList, "BASETOWN", "BASETOWN"); filter.FromDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); filter.ToDate = DateTime.Today; try { var ListTransactionDto = _kpiMonitoringBLL.GetTransaction(filter); var ListTransaction = Mapper.Map <List <KpiMonitoringItem> >(ListTransactionDto); var UserLogin = GetUserLogin(); foreach (var item in ListTransaction) { var data = GetDateworkflow(item, UserLogin); model.ListTransaction.Add(data); } } catch (Exception exp) { model.ErrorMessage = exp.Message; } return(View(model)); }