public async Task <TResponse <PageResult <ProductModel> > > GetPaging(int userId,
GetProductPageModel request,
int permissionId)
{
try
{
var checkValid = await _userService.CheckPermission(userId,
permissionId);
if (checkValid.IsSuccess)
{
var result = await ReadOnlyRepository.QueryMultipleLFAsync <ProductModel, int>(string.Format(SqlQuery.PRODUCT_GET_BY_PAGING,
request.ColumnOrder,
request.SortDir.ToUpper()),
new
{
Name = $"%{request.Name}%",
Description = $"%{request.Description}%",
request.ProductGroupId,
request.ProductStatusId,
request.ProductUnitId,
request.ManufacturerId,
request.CountryId,
Skip = (request.Page - 1) * request.PageSize,
Take = request.PageSize
});
if (result.IsSuccess)
{
return(await Ok(new PageResult <ProductModel>(request.Page,
request.PageSize,
result.Data.Item2,
result.Data.Item1)));
}
return(await Fail <PageResult <ProductModel> >(result.Message));
}
return(await Fail <PageResult <ProductModel> >(checkValid.Message));
}
catch (Exception exception)
{
return(await Fail <PageResult <ProductModel> >(exception));
}
}
public async Task <TResponse <PageResult <UserPageModel> > > GetPaging(int userId,
GetUserPageModel request,
int permissionId)
{
try
{
var checkValid = await CheckPermission(userId,
permissionId);
if (checkValid.IsSuccess)
{
var result = await ReadOnlyRepository.QueryMultipleLFAsync <UserPageModel, int>(string.Format(SqlQuery.USER_GET_BY_PAGING,
request.ColumnOrder,
request.SortDir.ToUpper()),
new
{
Username = $"%{request.Username}%",
DisplayName = $"%{request.DisplayName}%",
FullName = $"%{request.FullName}%",
PhoneNumber = $"%{request.PhoneNumber}%",
request.BranchId,
request.RoleId,
Skip = (request.Page - 1) * request.PageSize,
Take = request.PageSize
});
if (result.IsSuccess)
{
return(await Ok(new PageResult <UserPageModel>(request.Page,
request.PageSize,
result.Data.Item2,
result.Data.Item1)));
}
return(await Fail <PageResult <UserPageModel> >(result.Message));
}
return(await Fail <PageResult <UserPageModel> >(checkValid.Message));
}
catch (Exception exception)
{
return(await Fail <PageResult <UserPageModel> >(exception));
}
}
/// <summary>
/// Get User By Paging
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public async Task <TResponse <PageResult <UserModel> > > GetPaging(GetUserByPagingModel req)
{
try
{
if (req.Page <= 1)
{
req.Page = 1;
}
if (req.PageSize <= 5)
{
req.PageSize = 5;
}
var result = await ReadOnlyRepository.QueryMultipleLFAsync <UserModel, int>(
string.Format(SqlQuery.USER_GET_PAGING, req.ColumnOrder, req.SortDir), new
{
Username = $"%{req.Username}%",
Skip = (req.Page - 1) * req.PageSize,
Take = req.PageSize
});
if (result != null)
{
if (result.IsSuccess)
{
return(await Ok(new PageResult <UserModel>(req.Page, req.PageSize, result.Data.Item2,
result.Data.Item1)));
}
return(await Fail <PageResult <UserModel> >(result.Message));
}
return(await Ok(new PageResult <UserModel>(1, req.PageSize, 0, null)));
}
catch (Exception exception)
{
return(await Fail <PageResult <UserModel> >(exception));
}
}
public async Task <TResponse <PageResult <RoleModel> > > GetPaging(int userId,
GetRolePageModel request,
int permissionId)
{
try
{
var checkValid = await _userService.CheckPermission(userId,
permissionId);
if (checkValid.IsSuccess)
{
var result = await ReadOnlyRepository.QueryMultipleLFAsync <RoleModel, int>(SqlQuery.ROLE_GET_BY_PAGING,
new
{
Name = $"%{request.Name}%",
Skip = (request.Page - 1) * request.PageSize,
Take = request.PageSize
});
if (result.IsSuccess)
{
return(await Ok(new PageResult <RoleModel>(request.Page,
request.PageSize,
result.Data.Item2,
result.Data.Item1)));
}
return(await Fail <PageResult <RoleModel> >(result.Message));
}
return(await Fail <PageResult <RoleModel> >(checkValid.Message));
}
catch (Exception exception)
{
return(await Fail <PageResult <RoleModel> >(exception));
}
}
public async Task <TResponse <PageResult <InvoiceModel> > > GetPaging(int userId, GetInvoicePageModel request,
int permissionId)
{
try
{
var checkValid = await _userService.CheckPermission(userId, permissionId);
if (checkValid.IsSuccess)
{
var page = request.Page;
if (page <= 1)
{
page = 1;
}
var pageSize = request.PageSize;
if (pageSize <= 0)
{
pageSize = 20;
}
var result = await ReadOnlyRepository.QueryMultipleLFAsync <InvoiceModel, int>(
SqlQuery.INVOICE_GET_BY_PAGING, new
{
CustomerName = $"%{request.Customer}%",
CustomerPhone = $"%{request.CustomerPhone}%",
CustomerCode = $"%{request.CustomerCode}%",
Code = $"%{request.Code}%",
request.BranchId,
request.InvoiceStatusId,
request.UserSellId,
request.UserCreatedId,
request.FromDate,
request.ToDate,
Skip = (page - 1) * pageSize,
Take = pageSize
});
if (result.IsSuccess)
{
if (result.Data.Item1 != null && result.Data.Item1.Any())
{
var count = result.Data.Item2;
var invoices = result.Data.Item1.ToList();
foreach (var invoice in invoices)
{
var products = await ReadOnlyRepository.QueryAsync <string>(
SqlQuery.INVOICE_GET_PRODUCT_BY_INVOICE_ID, new
{
InvoiceId = invoice.Id
});
if (products.IsSuccess && products.Data != null)
{
invoice.Products.AddRange(products.Data);
}
var users = await ReadOnlyRepository.QueryAsync <string>(
SqlQuery.INVOICE_GET_USER_DELIVERY_BY_INVOICE_ID, new
{
InvoiceId = invoice.Id
});
if (users.IsSuccess && users.Data != null)
{
invoice.UserDelivery.AddRange(users.Data);
}
}
return(await Ok(new PageResult <InvoiceModel>(page, pageSize, result.Data.Item2,
result.Data.Item1)));
}
return(await Ok(new PageResult <InvoiceModel>(page, pageSize, result.Data.Item2,
new List <InvoiceModel>())));
}
return(await Fail <PageResult <InvoiceModel> >(result.Message));
}
return(await Fail <PageResult <InvoiceModel> >(checkValid.Message));
}
catch (Exception exception)
{
return(await Fail <PageResult <InvoiceModel> >(exception));
}
}