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