public Product GetProductById(int productId) { using (HAOEntities db = new HAOEntities()) { return((from p in db.Products where p.Id == productId select p).FirstOrDefault()); } }
public List <Product> GetAllProduct() { using (HAOEntities db = new HAOEntities()) { return((from p in db.Products select p).ToList()); } }
public int AddProduct(Product product) { using (HAOEntities db = new HAOEntities()) { db.Products.Add(product); return(db.SaveChanges()); } }
public int ModidyProduct(Product product) { using (HAOEntities db = new HAOEntities()) { db.Products.Attach(product); db.Entry <Product>(product).State = EntityState.Modified; return(db.SaveChanges()); } }
public int DeleteProduct(int productId) { using (HAOEntities db = new HAOEntities()) { Product p = new Product() { Id = productId }; db.Products.Attach(p); db.Products.Remove(p); return(db.SaveChanges()); } }