/// <summary>
/// Get all orders
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public virtual DTResult <GetOrdersViewModel> GetAllOrdersWithPaginationWay(DTParameters param)
{
if (param == null)
{
return(new DTResult <GetOrdersViewModel>());
}
var filtered = _dataFilter.FilterAbstractEntity <Order, ICommerceContext>(_commerceContext, param.Search.Value, param.SortOrder, param.Start,
param.Length,
out var totalCount).ToList();
var list = filtered.Select(async x =>
{
var map = x.Adapt <GetOrdersViewModel>();
map.ProductOrders =
await _orderDbContext.ProductOrders.Where(t => t.OrderId.Equals(map.Id)).ToListAsync();
map.User = _userManager.UserManager.Users.FirstOrDefault(y => y.Id.Equals(x.UserId));
return(map);
}).Select(x => x.Result);
return(new DTResult <GetOrdersViewModel>
{
Draw = param.Draw,
Data = list.ToList(),
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count
});
}
/// <summary>
/// Get all document from table model
/// </summary>
/// <returns></returns>
public virtual DTResult <DocumentViewModel> GetAllDocument(DTParameters param)
{
var filtered = DataFilter.FilterAbstractEntity <Document, IDocumentContext>(_documentContext, param.Search.Value,
param.SortOrder,
param.Start,
param.Length,
out var totalCount).Select(x =>
{
x.DocumentVersions = _documentContext.DocumentVersions.Where(i => i.DocumentId == x.Id).ToList();
x.DocumentType = _documentContext.DocumentTypes.FirstOrDefault(i => x.DocumentTypeId == i.Id) ?? new DocumentType();
x.DocumentCategory = _documentContext.DocumentCategories.FirstOrDefault(i => i.Id == x.DocumentCategoryId);
var listModel = x.Adapt <DocumentViewModel>();
return(listModel);
}).Where(x => !x.IsDeleted && x.DocumentCategory?.Code == 1).ToList();
var result = new DTResult <DocumentViewModel>
{
Draw = param.Draw,
Data = filtered,
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count
};
return(result);
}
/// <summary>
/// Get all document category
/// </summary>
/// <returns></returns>
public virtual DTResult <DocumentCategoryViewModel> GetAllDocumentCategory(DTParameters param)
{
var filtered = DataFilter.FilterAbstractEntity <DocumentCategory, IDocumentContext>(_context, param.Search.Value,
param.SortOrder, param.Start,
param.Length,
out var totalCount).Select(x =>
{
var listModel = x.Adapt <DocumentCategoryViewModel>();
return(listModel);
}).ToList();
var result = new DTResult <DocumentCategoryViewModel>
{
Draw = param.Draw,
Data = filtered,
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count
};
//var result = new ResultModel<IEnumerable<DocumentType>>();
//var listDocumentTypes = await _context.DocumentTypes.ToListAsync();
//if(listDocumentTypes is null || !listDocumentTypes.Any())
// new NotFoundResultModel<IEnumerable<DocumentType>>();
//result.IsSuccess = true;
//result.Result = listDocumentTypes;
return(result);
}
public virtual JsonResult OrderedList(DTParameters param)
{
var filtered = DataFilter.FilterAbstractEntity <TEntity, ICommerceContext>(Context, param.Search.Value,
param.SortOrder, param.Start,
param.Length,
out var totalCount).ToList();
var result = new DTResult <TEntity>
{
Draw = param.Draw,
Data = filtered,
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count
};
return(Json(result));
}
/// <summary>
/// Get all document type
/// </summary>
/// <returns></returns>
public virtual DTResult <DocumentTypeViewModel> GetAllDocumentType(DTParameters param)
{
var filtered = DataFilter.FilterAbstractEntity <DocumentType, IDocumentContext>(_context, param.Search.Value,
param.SortOrder, param.Start,
param.Length,
out var totalCount).Select(x =>
{
var listModel = x.Adapt <DocumentTypeViewModel>();
return(listModel);
}).ToList();
var result = new DTResult <DocumentTypeViewModel>
{
Draw = param.Draw,
Data = filtered,
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count
};
return(result);
}
