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