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