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