//edit product in database public void EditProduct(OrderManagement.DAL.ProductsTable product) { using (OrderManagementDBEntities ct = new OrderManagementDBEntities()) { ct.Entry(product).State = System.Data.EntityState.Modified; ct.SaveChanges(); } }
//adds product to the database public void AddProduct(OrderManagement.DAL.ProductsTable product) { using (OrderManagementDBEntities ct = new OrderManagementDBEntities()) { ct.ProductsTable.Add(product); ct.SaveChanges(); } }
//Get products from database by subcategory public List <OrderManagement.DAL.ProductsTable> GetProductsBySubCategory(String subCategory) { using (OrderManagementDBEntities ct = new OrderManagementDBEntities()) { List <OrderManagement.DAL.ProductsTable> products = new List <OrderManagement.DAL.ProductsTable>(); foreach (var c in ct.ProductsTable.Where(c => c.SubCategory == subCategory)) { OrderManagement.DAL.ProductsTable product = new OrderManagement.DAL.ProductsTable() { Id = c.Id, Name = c.Name, Category = c.Category, SubCategory = c.SubCategory, Brand = c.Brand, Description = c.Description, Price = c.Price }; products.Add(product); } return(products); } }