private List <FleetItem> SearchDataFleet(DTParameters <FleetModel> searchView = null)
{
var param = new FleetParamInput();
param.Status = searchView.StatusSource;
param.SupplyMethod = searchView.SupplyMethod;
param.BodyType = searchView.BodyType;
param.VehicleType = searchView.VehicleType;
param.VehicleUsage = searchView.VehicleUsage;
param.Vendor = searchView.Vendor;
param.Function = searchView.Function;
param.StartRent = searchView.StartRent;
param.EndRent = searchView.EndRent;
param.Regional = searchView.Regional;
param.City = searchView.City;
param.EmployeeId = searchView.EmployeeId;
param.FormalName = searchView.FormalName;
param.PoliceNumber = searchView.PoliceNumber;
var data = _fleetBLL.GetFleetByParam(param);
return(Mapper.Map <List <FleetItem> >(data));
}
public List <MST_FLEET> GetFleetByParam(FleetParamInput input)
{
Expression <Func <MST_FLEET, bool> > queryFilterFleet = null;
queryFilterFleet = c => c.IS_ACTIVE == true;
if (input != null)
{
if (!string.IsNullOrEmpty(input.Status))
{
if (input.Status == "True")
{
queryFilterFleet = c => c.IS_ACTIVE == true;
}
else if (input.Status == "False")
{
queryFilterFleet = c => c.IS_ACTIVE == false;
}
}
if (!string.IsNullOrEmpty(input.EmployeeId))
{
queryFilterFleet = queryFilterFleet.And(c => c.EMPLOYEE_ID == input.EmployeeId);
}
if (!string.IsNullOrEmpty(input.FormalName))
{
queryFilterFleet = queryFilterFleet.And(c => c.EMPLOYEE_NAME == input.FormalName);
}
if (!string.IsNullOrEmpty(input.PoliceNumber))
{
queryFilterFleet = queryFilterFleet.And(c => c.POLICE_NUMBER == input.PoliceNumber);
}
if (!string.IsNullOrEmpty(input.EngineNumber))
{
queryFilterFleet = queryFilterFleet.And(c => c.POLICE_NUMBER == input.PoliceNumber);
}
if (!string.IsNullOrEmpty(input.ChasisNumber))
{
queryFilterFleet = queryFilterFleet.And(c => c.CHASIS_NUMBER == input.ChasisNumber);
}
if (!string.IsNullOrEmpty(input.VehicleCity))
{
queryFilterFleet = queryFilterFleet.And(c => c.CITY == input.VehicleCity);
}
if (!string.IsNullOrEmpty(input.PoliceNumber))
{
queryFilterFleet = queryFilterFleet.And(c => c.POLICE_NUMBER == input.PoliceNumber);
}
if (!string.IsNullOrEmpty(input.VehicleType))
{
queryFilterFleet = queryFilterFleet.And(c => c.VEHICLE_TYPE == input.VehicleType);
}
if (!string.IsNullOrEmpty(input.VehicleUsage))
{
queryFilterFleet = queryFilterFleet.And(c => c.VEHICLE_USAGE == input.VehicleUsage);
}
if (!string.IsNullOrEmpty(input.BodyType))
{
queryFilterFleet = queryFilterFleet.And(c => c.BODY_TYPE == input.BodyType);
}
if (!string.IsNullOrEmpty(input.SupplyMethod))
{
queryFilterFleet = queryFilterFleet.And(c => c.SUPPLY_METHOD == input.SupplyMethod);
}
if (!string.IsNullOrEmpty(input.City))
{
queryFilterFleet = queryFilterFleet.And(c => c.CITY == input.City);
}
if (!string.IsNullOrEmpty(input.StartRent))
{
queryFilterFleet = queryFilterFleet.And(c => c.START_CONTRACT == Convert.ToDateTime(input.StartRent));
}
if (!string.IsNullOrEmpty(input.EndRent))
{
queryFilterFleet = queryFilterFleet.And(c => c.END_CONTRACT == Convert.ToDateTime(input.EndRent));
}
if (!string.IsNullOrEmpty(input.EndDate))
{
queryFilterFleet = queryFilterFleet.And(c => c.END_DATE == Convert.ToDateTime(input.EndDate));
}
if (!string.IsNullOrEmpty(input.Regional))
{
queryFilterFleet = queryFilterFleet.And(c => c.REGIONAL == input.Regional);
}
}
return(_fleetRepository.Get(queryFilterFleet, null, "").ToList());
}
public List <FleetDto> GetFleetByParam(FleetParamInput param)
{
var data = _FleetService.GetFleetByParam(param);
return(Mapper.Map <List <FleetDto> >(data));
}
