public static List <ProductView> GetProductByPriceInterval(string textBoxMin, string textBoxMax)
{
List <ProductView> productViewsList = new List <ProductView>();
var productsList = ProductViewManager.JoinProductAndProductStockTables();
foreach (var product in productsList)
{
if (product.Price >= Convert.ToDouble(textBoxMin) && product.Price <= Convert.ToDouble(textBoxMax))
{
productViewsList.Add(new ProductView
{
Reference = product.Reference,
Name = product.Name,
ExclTaxPrice = product.ExclTaxPrice,
Price = product.Price,
Quantity = product.Quantity
});
}
}
return(productViewsList);
}
public static List <ProductView> GetProductByGlobalResearch(string input)
{
List <ProductView> productViewsList = new List <ProductView>();
var productsList = ProductViewManager.JoinProductAndProductStockTables();
foreach (var product in productsList)
{
if (product.Reference.ToLowerInvariant().Contains(input.ToLowerInvariant()) ||
product.Name.ToLowerInvariant().Contains(input.ToLowerInvariant()) ||
product.Price.ToString().ToLowerInvariant().Contains(input.ToLowerInvariant()) ||
product.Quantity.ToString().ToLowerInvariant().Contains(input.ToLowerInvariant()))
{
productViewsList.Add(new ProductView
{
Reference = product.Reference,
Name = product.Name,
ExclTaxPrice = product.ExclTaxPrice,
Price = product.Price,
Quantity = product.Quantity
});
}
}
return(productViewsList);
}
