public async Task <PageResult <CustomerViewModel> > GetCustomerPaging(GetCustomerPagingRequest request) { var query = from p in _context.Customers select p; if (!string.IsNullOrEmpty(request.Keyword)) { query = query.Where(x => x.Name.Contains(request.Keyword)); } //int totalRow = await query.CountAsync(); var data = await query .Select(x => new CustomerViewModel() { Id = x.Id, Name = x.Name, Adress = x.Adress, PhoneNumber = x.PhoneNumber, DOB = x.DOB, Sex = x.Sex }).ToListAsync(); var pageResult = new PageResult <CustomerViewModel>() { Items = data }; return(pageResult); }
public async Task <IActionResult> GetAllPaging([FromQuery] GetCustomerPagingRequest request) { var cus = await _customerService.GetAllPaging(request); if (cus == null) { return(BadRequest()); } return(Ok(cus)); }
public async Task <PagedResult <CustomerViewModel> > GetCustomerPagings(GetCustomerPagingRequest request) { var client = _httpClientFactory.CreateClient(); client.BaseAddress = new Uri(_configuration["BaseAddress"]); var respone = await client.GetAsync($"/api/customer/paging?Keyword={request.Keyword}&pageIndex=" + $"{request.PageIndex}&pageSize={request.PageSize}"); var body = await respone.Content.ReadAsStringAsync(); var customer = JsonConvert.DeserializeObject <PagedResult <CustomerViewModel> >(body); return(customer); }
public async Task <PageResult <CustomerViewModel> > GetAll(GetCustomerPagingRequest request) { var client = _httpClientFactory.CreateClient(); client.BaseAddress = new Uri("https://localhost:5001"); var response = await client.GetAsync($"/api/Customer/GetAll?keyword={request.Keyword}"); var body = await response.Content.ReadAsStringAsync(); var data = JsonConvert.DeserializeObject <PageResult <CustomerViewModel> >(body); return(data); }
public async Task <IActionResult> Index(string keyword, int pageIndex = 1, int pageSize = 10) { var request = new GetCustomerPagingRequest() { keyword = keyword, pageIndex = pageIndex, pageSize = pageSize }; var data = await _customerApi.GetCustomerPaging(request); ViewBag.keyword = keyword; if (TempData["result"] != null) { ViewBag.SuccessMsg = TempData["result"]; } return(View(data.ResultObj)); }
public async Task <IActionResult> Index(string keyword, int pageIndex = 1, int pageSize = 10) { var request = new GetCustomerPagingRequest() { Keyword = keyword, PageIndex = pageIndex, PageSize = pageSize, }; var data = await _customerApiClient.GetCustomerPagings(request); ViewBag.Keyword = keyword; if (TempData["result"] != null) { ViewBag.SuccessMsg = TempData["result"]; } if (TempData["error"] != null) { ViewBag.ErrorMsg = TempData["error"]; } return(View(data)); }
public async Task <PagedResult <CustomerViewModel> > GetAllPaging(GetCustomerPagingRequest request) { var query = from cus in _context.Customers where cus.isDelete == false select cus; if (!String.IsNullOrEmpty(request.Keyword)) { query = query.Where(x => x.name.Contains(request.Keyword) || x.phone.Contains(request.Keyword) || x.email.Contains(request.Keyword)); } int totalRow = await query.CountAsync(); var data = query.OrderByDescending(m => m.create_at) .Skip((request.PageIndex - 1) * request.PageSize) .Take(request.PageSize) .Select(a => new CustomerViewModel() { id = a.id, address = a.address, birthday = a.birthday, email = a.email, name = a.name, password = a.password, phone = a.phone, sex = a.sex, isActive = a.isActive, }).ToListAsync(); var pageResult = new PagedResult <CustomerViewModel>() { TotalRecords = totalRow, PageIndex = request.PageIndex, PageSize = request.PageSize, Items = await data, }; return(pageResult); }
public async Task <IActionResult> GetAllPaging([FromQuery] GetCustomerPagingRequest request) { var customer = await _customerService.GetCustomerPaging(request); return(Ok(customer)); }
public async Task <ApiResult <PageViewModel <CustomerViewRequest> > > GetAllPaging(GetCustomerPagingRequest request) { var quey = from c in db.Ib_customers select c; if (!string.IsNullOrEmpty(request.keyword)) { quey = quey.Where(x => x.Ib_customer_name.ToLower().Contains(request.keyword.ToLower()) || x.Ib_customer_type.ToLower().Contains(request.keyword.ToLower())); } int totalRow = await quey.CountAsync(); var data = await quey.Skip((request.pageIndex - 1) *request.pageSize) .Take(request.pageSize).Select(c => new CustomerViewRequest() { id = c.Ib_record_primary_key, name = c.Ib_customer_name, registration = c.Ib_customer_registration, cus_type = c.Ib_customer_type }).ToListAsync(); // var pageViewModel = new PageViewModel <CustomerViewRequest>() { TotalRecords = totalRow, PageIndex = request.pageIndex, PageSize = request.pageSize, Items = data }; return(new ApiSuccessResult <PageViewModel <CustomerViewRequest> >(pageViewModel)); }
public async Task <ApiResult <PageViewModel <CustomerViewRequest> > > GetCustomerPaging(GetCustomerPagingRequest request) { var client = _httpClientFactory.CreateClient(); var session = _httpContextAccessor.HttpContext.Session.GetString("Token"); client.BaseAddress = new Uri(_configuration["BaseAddress"]); client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", session); var response = await client.GetAsync($"/api/customer/paging?pageIndex=" + $"{request.pageIndex}&pageSize={request.pageSize}&keyword={request.keyword}"); var body = await response.Content.ReadAsStringAsync(); var cus = JsonConvert.DeserializeObject <ApiSuccessResult <PageViewModel <CustomerViewRequest> > >(body); return(cus); }
public async Task <IActionResult> Index(GetCustomerPagingRequest request) { var data = await _customerApiClient.GetAll(request); return(View(data)); }