private List <FuelOdometerItem> SearchDataFuelOdometer(DTParameters <FuelOdometerModel> searchView = null)
{
var param = new FuelOdometerParamInput();
param.Status = searchView.StatusSource;
param.VehicleType = searchView.VehicleType;
param.DateOfCost = searchView.DateOfCost;
param.PostedTime = searchView.PostedTime;
param.EmployeeId = searchView.EmployeeId;
param.EmployeeName = searchView.EmployeeName;
param.PoliceNumber = searchView.PoliceNumber;
param.SeqNumber = searchView.SeqNumber;
param.LastKM = searchView.LastKM;
param.ClaimComment = searchView.ClaimComment;
param.ClaimType = searchView.ClaimType;
param.CostCenter = searchView.CostCenter;
param.EcsRmbTransId = searchView.EcsRmbTransId;
var data = _fuelodometerBLL.GetFuelOdometerByParam(param);
return(Mapper.Map <List <FuelOdometerItem> >(data));
}
public List <MST_FUEL_ODOMETER> GetFuelOdometerByParam(FuelOdometerParamInput input)
{
Expression <Func <MST_FUEL_ODOMETER, bool> > queryFilterFuelOdometer = null;
queryFilterFuelOdometer = c => c.IS_ACTIVE == true;
if (input != null)
{
if (!string.IsNullOrEmpty(input.Status))
{
if (input.Status == "True")
{
queryFilterFuelOdometer = c => c.IS_ACTIVE == true;
}
else if (input.Status == "False")
{
queryFilterFuelOdometer = c => c.IS_ACTIVE == false;
}
}
if (!string.IsNullOrEmpty(input.EmployeeId))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.EMPLOYEE_ID == input.EmployeeId);
}
if (!string.IsNullOrEmpty(input.EmployeeName))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.EMPLOYEE_NAME == input.EmployeeName);
}
if (!string.IsNullOrEmpty(input.PoliceNumber))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.POLICE_NUMBER == input.PoliceNumber);
}
if (!string.IsNullOrEmpty(input.ClaimComment))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.CLAIM_COMMENT == input.ClaimComment);
}
if (!string.IsNullOrEmpty(input.ClaimType))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.CLAIM_TYPE == input.ClaimType);
}
if (!string.IsNullOrEmpty(input.CostCenter))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.COST_CENTER == input.CostCenter);
}
if (!string.IsNullOrEmpty(input.EcsRmbTransId))
{
var ecsRmbTransId = Convert.ToInt32(input.EcsRmbTransId);
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.ECS_RMB_TRANSID == ecsRmbTransId);
}
if (!string.IsNullOrEmpty(input.VehicleType))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.VEHICLE_TYPE == input.VehicleType);
}
if (!string.IsNullOrEmpty(input.LastKM))
{
var lastKM = Convert.ToInt64(input.LastKM);
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.LAST_KM == lastKM);
}
if (!string.IsNullOrEmpty(input.SeqNumber))
{
var seqNumber = Convert.ToInt32(input.SeqNumber);
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.SEQ_NUMBER == seqNumber);
}
if (!string.IsNullOrEmpty(input.DateOfCost))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.DATE_OF_COST == Convert.ToDateTime(input.DateOfCost));
}
if (!string.IsNullOrEmpty(input.PostedTime))
{
queryFilterFuelOdometer = queryFilterFuelOdometer.And(c => c.POSTED_TIME == Convert.ToDateTime(input.PostedTime));
}
}
return(_FuelOdometerRepository.Get(queryFilterFuelOdometer, null, "").ToList());
}
public List <FuelOdometerDto> GetFuelOdometerByParam(FuelOdometerParamInput param)
{
var data = _fuelodometerService.GetFuelOdometerByParam(param);
return(Mapper.Map <List <FuelOdometerDto> >(data));
}
