// GET: Product
public ActionResult Index(string SearchString)
{
decimal s = 0;
if (!String.IsNullOrEmpty(SearchString))
{
s = Convert.ToDecimal(SearchString);
}
PharmaTest_NREntities entities = new PharmaTest_NREntities();
List <Product> products = entities.Products.ToList();
List <ProductToDisplay> productToDisplays = new List <ProductToDisplay>();
foreach (var p in products)
{
ProductToDisplay pr = new ProductToDisplay();
pr.id = p.id;
pr.product_id = p.product_id;
pr.msr_prx = p.msr_prx;
pr.product_name = p.product_name;
pr.purchase_prx = Convert.ToDecimal(p.purchase_prx);
pr.manufacturer = p.manufacturer;
productToDisplays.Add(pr);
}
if (s > 0)
{
productToDisplays = productToDisplays.Where(pr => pr.purchase_prx <= s).ToList();
}
var orderByManufacturer = from k in productToDisplays
orderby k.manufacturer
select k;
return(View(orderByManufacturer));
}
public List <ProductToDisplay> Get_List_Product()
{
List <ProductToDisplay> lstProduct = new List <ProductToDisplay>();
var product = dbproduct.Product.ToList();
foreach (var item in product)
{
ProductToDisplay pro = new ProductToDisplay
{
category = contructorPro.get_Categories(item.id_cat),
description = item.description,
price = item.price,
product_id = item.product_id,
status = item.status,
product_name = item.product_name,
supplier = contructorPro.get_Supplier(item.id_supplier),
};
lstProduct.Add(pro);
}
return(lstProduct);
}