public void DeleteProductsOrder(int id) { var db = new DataEntities(); var deleteOrder = db.orders.Find(id); db.orders.Remove(deleteOrder); db.SaveChanges(); }
public void DeleteProduct(int id) { var db = new DataEntities(); var deleteProduct = db.Products.Find(id); db.Products.Remove(deleteProduct); db.SaveChanges(); }
public void DeleteHistory(int id) { var db = new DataEntities(); var deleteHistory = db.histories.Find(id); db.histories.Remove(deleteHistory); db.SaveChanges(); }
public void EditProduct(int id, string name, string size, int price) { var db = new DataEntities(); var editProduct = db.Products.Find(id); editProduct.Name = name; editProduct.Size = size; editProduct.Price = price; db.Entry(editProduct).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public int AddHistory() { var addHistory = new history(); DateTime now = DateTime.Now; addHistory.dateofsales = now; var db = new DataEntities(); db.histories.Add(addHistory); db.SaveChanges(); return(addHistory.id); }
public void AddProduct(string name, string size, int price) { var addProduct = new Product(); addProduct.Name = name; addProduct.Size = size; addProduct.Price = price; var db = new DataEntities(); db.Products.Add(addProduct); db.SaveChanges(); }
public void AddOrder(string name, string size, int price, int quantity) { var addOrder = new order(); addOrder.name = name; addOrder.size = size; addOrder.price = price; addOrder.quantity = quantity; var db = new DataEntities(); db.orders.Add(addOrder); db.SaveChanges(); }
public void AddBills(string name, string size, int price, int quantity) { var addBills = new bill(); var db = new DataEntities(); addBills.bill_id = db.histories.Count(); addBills.name = name; addBills.size = size; addBills.price = price; addBills.quantity = quantity; db.bills.Add(addBills); db.SaveChanges(); }