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