//-> GetList public async Task <GetListDTO <CheckLoanRequestViewDTO> > GetList(CheckLoanRequestFindDTO findDTO) { //--seem like search sql not dynamic -> should write one helper function or interface to do dynamic search IQueryable <tblAccount> accounts = from a in db.tblAccounts where a.acct_Deleted == null && (string.IsNullOrEmpty(findDTO.name) ? 1 == 1 : a.acct_Name.Contains(findDTO.name)) && (string.IsNullOrEmpty(findDTO.email) ? 1 == 1 : a.acct_Email.Contains(findDTO.email)) && (string.IsNullOrEmpty(findDTO.status) ? 1 == 1 : a.acct_Status == findDTO.status) orderby a.acct_AccountID ascending select a; return(await Listing(findDTO.currentPage, accounts)); }
//->Paging public async Task <ActionResult> Paging(CheckLoanRequestFindDTO findDTO) { return(PartialView(await handler.GetList(findDTO))); }