public IActionResult ValueStockLocation(StockReportsModel filter)
{
LoadViewData();
filter.TypeView = "_ValueStockLocation";
filter.WithStock = true;
return(View(filter));
}
public async Task <IActionResult> Product(StockReportsModel filter, string trash)
{
LoadViewData();
IQueryable <Product> data = await GetProducts(filter);
filter.Product = data;
return(View(filter));
}
public async Task <IQueryable <Product> > GetProducts(StockReportsModel filter)
{
var data = await _productServices.QueryAsync();
data = data.Include(a => a.VProduct);
if (filter.ProductId.HasValue)
{
data = data.Where(a => a.ProductId == filter.ProductId.Value);
}
if (!string.IsNullOrEmpty(filter.Name))
{
data = data.Where(a => a.Name.Contains(filter.Name));
}
if (!string.IsNullOrEmpty(filter.ProductNumber))
{
data = data.Where(a => a.Name.Contains(filter.ProductNumber));
}
if (!string.IsNullOrEmpty(filter.Manufacturer))
{
data = data.Where(a => a.Name.Contains(filter.Manufacturer));
}
if (!string.IsNullOrEmpty(filter.Ean))
{
data = data.Where(a => a.Name.Contains(filter.Ean));
}
if (!string.IsNullOrEmpty(filter.HsCode))
{
data = data.Where(a => a.Name.Contains(filter.HsCode));
}
if (!string.IsNullOrEmpty(filter.Location))
{
data = data.Where(a => a.Name.Contains(filter.Location));
}
if (!string.IsNullOrEmpty(filter.SizeUnitMeasureCode))
{
data = data.Where(a => a.Name.Contains(filter.SizeUnitMeasureCode));
}
if (!string.IsNullOrEmpty(filter.ProductAttribute))
{
data = data.Where(a => a.Name.Contains(filter.ProductAttribute));
}
if (filter.ProductSourceId.HasValue)
{
data = data.Where(a => a.ProductSourceId == filter.ProductSourceId);
}
if (filter.LocationId.HasValue)
{
data = data.Where(a => a.ProductInventory.Any(i => i.LocationId == filter.LocationId));
}
if (filter.ClassId.HasValue)
{
data = data.Where(a => a.ClassId == filter.ClassId);
}
if (filter.CategoryId.HasValue)
{
data = data.Where(a => a.ClassId == filter.CategoryId);
}
if (filter.CategoryId.HasValue)
{
data = data.Where(a => a.ClassId == filter.CategoryId);
}
if (filter.SellStartDate.HasValue)
{
data = data.Where(a => a.SellStartDate >= filter.SellStartDate);
}
if (filter.SellEndDate.HasValue)
{
data = data.Where(a => a.SellEndDate <= filter.SellEndDate);
}
if (filter.SellEndDate.HasValue)
{
data = data.Where(a => a.SellEndDate <= filter.SellEndDate);
}
data = data.Where(a => a.MakeFlag == filter.MakeFlag);
data = data.Where(a => a.VariableFlag == filter.VariableFlag);
data = data.Where(a => a.FinishedGoodsFlag == filter.FinishedGoodsFlag);
data = data.Where(a => a.Active == filter.Active);
if (filter.WithStock)
{
data = data.Where(a => a.VProduct.Stock.Value > 0);
}
if (filter.TypeView.Equals("_ProductWithutSaldo", StringComparison.CurrentCultureIgnoreCase))
{
data = data.Where(a => a.VProduct.Stock.Value == 0);
}
if (filter.TypeView.Equals("_ProductMinimumStocklevel", StringComparison.CurrentCultureIgnoreCase))
{
data = data.Where(a =>
a.SafetyStockLevel.Value > 0 &&
((a.SafetyStockLevel.Value / a.VProduct.Stock.Value) * 100 >= 80));
}
return(data);
}
public IActionResult ProductMinimumStocklevel(StockReportsModel filter)
{
LoadViewData();
filter.TypeView = "_ProductMinimumStocklevel";
return(View(filter));
}
public IActionResult ProductWithutSaldo(StockReportsModel filter)
{
LoadViewData();
filter.TypeView = "_ProductWithutSaldo";
return(View(filter));
}
public IActionResult Product(StockReportsModel filter)
{
LoadViewData();
return(View(filter));
}
