public List <CostObDto> GetByFilter(CostObParamInput filter)
{
var data = _CostObService.GetCostObByFilter(filter);
var redata = Mapper.Map <List <CostObDto> >(data);
return(redata);
}
public List <MST_COST_OB> GetCostObByFilter(CostObParamInput filter)
{
Expression <Func <MST_COST_OB, bool> > queryFilter = PredicateHelper.True <MST_COST_OB>();
if (filter != null)
{
if (!string.IsNullOrEmpty(filter.Function))
{
queryFilter = queryFilter.And(c => (c.FUNCTION_NAME == null ? "" : c.FUNCTION_NAME.ToUpper()) == (filter.Function == null ? "" : filter.Function.ToUpper()));
}
if (!string.IsNullOrEmpty(filter.Regional))
{
queryFilter = queryFilter.And(c => (c.REGIONAL == null ? "" : c.REGIONAL.ToUpper()) == (filter.Regional == null ? "" : filter.Regional.ToUpper()));
}
if (!string.IsNullOrEmpty(filter.VehicleType))
{
queryFilter = queryFilter.And(c => (c.VEHICLE_TYPE == null ? "" : c.VEHICLE_TYPE.ToUpper()) == (filter.VehicleType == null ? "" : filter.VehicleType.ToUpper()));
}
if (filter.Status.HasValue)
{
queryFilter = queryFilter.And(c => c.IS_ACTIVE == filter.Status.Value);
}
if (filter.Year.HasValue)
{
queryFilter = queryFilter.And(c => c.YEAR == filter.Year.Value);
}
}
return(_costObRepository.Get(queryFilter, null, "").ToList());
}
public ActionResult Index()
{
var model = new CostObModel();
model.SearchView.Year = DateTime.Now.Year;
var VehicleTypeList = _settingBLL.GetSetting().Where(x => x.IsActive && x.SettingGroup == EnumHelper.GetDescription(Enums.SettingGroup.VehicleType)).Select(x => new { x.SettingName }).Distinct().ToList();
var FunctionList = _functionGroupBll.GetGroupCenter().Where(x => x.IsActive).Select(x => new { x.FunctionName }).Distinct().ToList();
var LocationMappingList = _locationMappingBLL.GetLocationMapping().Where(x => x.IsActive).Select(x => new { x.Region }).Distinct().ToList();
model.SearchView.VehicleTypeList = new SelectList(VehicleTypeList, "SettingName", "SettingName");
model.SearchView.FunctionList = new SelectList(FunctionList, "FunctionName", "FunctionName");
model.SearchView.RegionalList = new SelectList(LocationMappingList, "Region", "Region");
var filter = new CostObParamInput();
filter.Year = DateTime.Now.Year;
var data = _costObBLL.GetByFilter(filter);
model.Details = Mapper.Map <List <CostObItem> >(data);
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
model.CurrentPageAccess = CurrentPageAccess;
foreach (CostObItem item in model.Details)
{
item.MonthS = this.SetMonthToString(item.Month == null ? 0:item.Month.Value);
}
return(View(model));
}
