public static void productSelect()
{
var productSelect = new ProductsSC().GetProducts().Select(s => new
{
ProductId = s.ProductId,
ProducName = s.ProductName,
ProductUnits = s.UnitsInStock
}).ToList();
}
//SELECT ProductID, ProductName, UnitPrice FROM Products
//Where CategoryID = ID
public static void Product(int ID)
{
var ProductQry = new ProductsSC().GetProduct().Select(s => new
{
s.ProductId,
s.ProductName,
s.UnitPrice,
s.CategoryId
}).Where(w => w.CategoryId == ID);
var output = ProductQry.ToList();
}
public List <Product> Get()
{
var product = new ProductsSC().GetAllProducts().ToList();
return(product);
}
public List <Product> Get()
{
var Products = new ProductsSC().GetProduct().ToList();
return(Products);
}
