public Product GetProduct(int id)
{
try {
using (CustProductEntities db = new CustProductEntities())
{
Product product = db.Products.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public string AddProduct(Product product)
{
try
{
CustProductEntities db = new CustProductEntities();
db.Products.Add(product);
db.SaveChanges();
return(product.ProductName + " was successfully added ");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public List <Product> GetitemsByCategory(string categoryname)
{
try
{
using (CustProductEntities db = new CustProductEntities())
{
List <Product> Items = (from x in db.Products where x.ProductCategory == categoryname select x).ToList();
return(Items);
}
}
catch (Exception)
{
return(null);
}
}
public List <Product> GetAllProducts()
{
try
{
using (CustProductEntities db = new CustProductEntities())
{
List <Product> products = (from x in db.Products select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
