public void AddProduct(Product p)
{
try
{
using (prodigiousEntities _Model = new prodigiousEntities())
{
_Model.Product.Add(p);
_Model.SaveChanges();
}
}
catch (Exception ex)
{
Trace.WriteLine(ex.Message);
throw ex;
}
}
public List<Product> GetProducts()
{
try
{
using (prodigiousEntities _Model = new prodigiousEntities())
{
var products = from Product in _Model.Product
select Product;
return products.ToList();
}
}
catch (Exception ex)
{
Trace.WriteLine(ex.Message);
throw ex;
}
}
public Product GetSingleProduct(int id)
{
try
{
using (prodigiousEntities _Model = new prodigiousEntities())
{
var product = _Model.Product
.Where(p => p.ProductID == id)
.FirstOrDefault();
return product;
}
}
catch (Exception ex)
{
Trace.WriteLine(ex.Message);
throw ex;
}
}
