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