private void ShowFilterDialog()
{
var param = new DialogParameters();
param.Add("ProductsFilterModel", ProductsFilterModel.Clone());
_dialogService.ShowDialog(nameof(FilterDialogView), param, (res) => { FilterProducts(res); });
}
public async Task Load(ProductsFilterModel filter)
{
_logger.LogDebug("LOAD PRODUCTS!");
var(r, e) = await _repository.GetFilteredProducts(filter);
_page = r;
Error = e;
}
private void InitData()
{
var products = _productService.GetAll(e => true);
Products = new ObservableCollection <ProductModel>(products.Select(e => MapProduct(e)));
var maxPrice = (int)products.Max(e => e.Price);
ProductsFilterModel = new ProductsFilterModel {
CurrentMinValue = 0, CurrentMaxValue = maxPrice, MinValue = 0, MaxValue = maxPrice
};
}
public async Task <IActionResult> GetAll(ProductsFilterModel filter)
{
var products = await _service.Get(new ProductsFilter(new PageFilter(filter.Skip, filter.Take, MAX_TAKE), filter.Title, filter.MinPrice, filter.MaxPrice, filter.Descending, filter.OrderBy));
return(Ok(new PageResultModel <ProductModel>()
{
ProductsFilter = products.PageFilter,
TotalCount = products.TotalCount,
Value = products.Value.Select(p => new ProductModel(p)).ToList()
}));
}
public static List <ProductsModel> GetProductsList(ProductsFilterModel filter, ref int totalRecord, ref ResponseModel response)
{
ACTION = "GetProductsList(ProductsFilterModel)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
filter.ProductsIDs = filter.ProductsIDs != null ? filter.ProductsIDs : new int[] { };
var IQuery = context.USR_TMMA_PRODUCTS
.Where(o =>
(!string.IsNullOrEmpty(filter.Keywords) ?
(o.CreatedBy.Contains(filter.Keywords))
: true) &&
(filter.ProductsID.HasValue ? o.ProductsID == filter.ProductsID.Value : true) &&
(filter.ProductsIDs.Count() > 0 ? filter.ProductsIDs.Contains(o.ProductsID) : true) &&
(!string.IsNullOrEmpty(filter.CreatedBy) ? filter.CreatedBy.Contains(o.CreatedBy) : true) &&
(filter.IsActive.HasValue ? o.IsActive == 1 : true)
);
totalRecord = IQuery.Count();
List <USR_TMMA_PRODUCTS> list = filter.Pagination.IsPaging ? IQuery.OrderBy(o => o.CreatedDate).Skip(filter.Pagination.Skip).Take(filter.Pagination.Take).ToList() : IQuery.ToList();
List <ProductsModel> mList = Mapping(list);
response = new ResponseModel()
{
Source = SOURCE,
Action = ACTION,
Status = true,
Message = "Success"
};
return(mList);
}
}
catch (Exception ex)
{
totalRecord = 0;
response = new ResponseModel()
{
Source = SOURCE,
Action = ACTION,
Status = false,
Message = ex.Message
};
return(null);
}
}
public static ProductsViewModel GetProductsView(ProductsFilterModel filter)
{
ACTION = "GetProductsView(ProductsFilterModel)";
try
{
ResponseModel response = new ResponseModel();
int totalRecord = 0;
var model = ProductsDAL.GetProductsList(filter, ref totalRecord, ref response);
filter.Pagination.TotalRecord = totalRecord;
PaginationModel pagination = new PaginationModel(totalRecord, filter.Pagination.Page, filter.Pagination.Take);
filter.Pagination = pagination;
return(new ProductsViewModel()
{
Action = ACTION,
Source = SOURCE,
Status = response.Status,
Message = response.Message,
List = model,
Filter = filter
});
}
catch (Exception ex)
{
return(new ProductsViewModel()
{
Action = ACTION,
Source = SOURCE,
Status = false,
Message = ex.Message,
List = null,
Filter = filter
});
}
}
public Task <(PageResultModel <ProductModel>, string)> GetFilteredProducts(ProductsFilterModel model)
{
var url = GetFullUrl("/products/filter");
return(_http.PostAsync <PageResultModel <ProductModel> >(url, model, false));
}
/// <summary>
/// Monomer BOM
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public ProductsViewModel GetProductsView(ProductsFilterModel filter)
{
return(ProductsBLL.GetProductsView(filter));
}
