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