//-> GetList public async Task <GetListDTO <CustomerViewDTO> > GetList(CustomerFindDTO findDTO) { IQueryable <tblCustomer> query = db.tblCustomers.Where(x => x.deleted == null); if (!string.IsNullOrEmpty(findDTO.customerCode)) { query = query.Where(x => x.customerCode.StartsWith(findDTO.customerCode)); } if (!string.IsNullOrEmpty(findDTO.customerName)) { query = query.Where(x => x.customerName.StartsWith(findDTO.customerName)); } if (!string.IsNullOrEmpty(findDTO.phoneNumber)) { query = query.Where(x => x.phoneNumber.StartsWith(findDTO.phoneNumber)); } query = query.AsQueryable().OrderBy($"{findDTO.orderBy} {findDTO.orderDirection}"); return(await ListingHandler(findDTO.currentPage, query)); }
//-> GetList public async Task <GetListDTO <CustomerViewDTO> > GetList(CustomerFindDTO findDTO) { var session = HttpContext.Current.Session; UserViewDTO user = (UserViewDTO)session["user"]; int _user = 0; if (user != null) { _user = user.id; if (user.user_Profile == 1) { _user = -1; } } IQueryable <tblCustomer> query = db.tblCustomers.Where(x => x.deleted == null); if (!string.IsNullOrEmpty(findDTO.code)) { query = query.Where(x => x.code.StartsWith(findDTO.code)); } if (!string.IsNullOrEmpty(findDTO.firstName)) { query = query.Where(x => x.firstName.StartsWith(findDTO.firstName)); } if (!string.IsNullOrEmpty(findDTO.lastName)) { query = query.Where(x => x.lastName.StartsWith(findDTO.lastName)); } if (_user != -1) { query = query.Where(x => x.cust_UserID == _user); } query = query.AsQueryable().OrderBy($"{findDTO.orderBy} {findDTO.orderDirection}"); return(await ListingHandler(findDTO.currentPage, query)); }
public async Task <ActionResult> Paging(CustomerFindDTO findDTO) { return(PartialView(await handler.GetList(findDTO))); }