//-> GetList
public async Task <GetListDTO <TransactionViewDTO> > GetList(TransactionFindDTO findDTO)
{
IQueryable <TransactionFindResultDTO> query = from x in db.tblTransactions
join c in db.tblCustomers on x.tran_CustomerID equals c.id
join d in db.tblDrivers on x.tran_DriverID equals d.id
join v in db.tblVehicles on x.tran_VehicleID equals v.id
where x.tran_Deleted == null &&
(findDTO.customerID == 0 ? 1 == 1 : c.id == findDTO.customerID) &&
(findDTO.tran_DriverID == 0 ? 1 == 1 : d.id == findDTO.tran_DriverID) &&
(findDTO.tran_VehicleID == 0 ? 1 == 1 : v.id == findDTO.tran_VehicleID)
select new TransactionFindResultDTO
{
tran_TransactionID = x.tran_TransactionID,
tran_Code = x.tran_Code,
tran_StartAddress = x.tran_StartAddress,
tran_EndAddress = x.tran_EndAddress,
driverCode = d.driverCode,
driverName = d.driverName,
customerCode = c.customerCode,
customerName = c.customerName,
vehicleCode = v.vehicleCode
};
query = query.AsQueryable().OrderBy($"{findDTO.orderBy} {findDTO.orderDirection}");
return(await ListingHandler(findDTO.currentPage, query));
}
public async Task <ActionResult> Paging(TransactionFindDTO findDTO)
{
return(PartialView(await handler.GetList(findDTO)));
}
