public void DeleteHistory(int id)
{
var db = new DataDeAnCEntities();
var bill = db.Bills.Find(id);
db.Bills.Remove(bill);
db.SaveChanges();
}
public void DeleteGood(int id)
{
var db = new DataDeAnCEntities();
var Good = db.Goods.Find(id);
db.Goods.Remove(Good);
db.SaveChanges();
}
public void UpdateGood1(int id, int number)
{
var db = new DataDeAnCEntities();
var old = db.Goods.Find(id);
old.Number = number;
db.Entry(old).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public void UpdateGood(int id, string code, string nameitems, int number, DateTime date, int price, string status)
{
var db = new DataDeAnCEntities();
var Oldgood = db.Goods.Find(id);
Oldgood.Code = code;
Oldgood.NameItems = nameitems;
Oldgood.Number = number;
Oldgood.Date_Add = date;
Oldgood.UnitPrice = price;
Oldgood.Status = status;
db.Entry(Oldgood).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public void CreateBill(string item, int number, int unitprice, int totalprice, int good_id)
{
var bill = new Bill();
bill.NameItems = item;
bill.Number = number;
bill.UnitPrice = unitprice;
bill.TotalPrice = totalprice;
bill.Bill_id = good_id;
var db = new DataDeAnCEntities();
db.Bills.Add(bill);
db.SaveChanges();
}
public void CreateGood(string code, string nameitems, int number, DateTime date, int price, string status)
{
var NewGood = new Good();
NewGood.Code = code;
NewGood.NameItems = nameitems;
NewGood.Number = number;
NewGood.Date_Add = date;
NewGood.UnitPrice = price;
NewGood.Status = status;
var db = new DataDeAnCEntities();
db.Goods.Add(NewGood);
db.SaveChanges();
}
public int CreateBuyGood(string customer, int phone, string email, string address, string note)
{
var Newbuygood = new BuyGood();
Newbuygood.Customer_name = customer;
Newbuygood.Phone_Number = phone;
Newbuygood.Email = email;
Newbuygood.Address = address;
Newbuygood.Note = note;
var db = new DataDeAnCEntities();
db.BuyGoods.Add(Newbuygood);
db.SaveChanges();
return(Newbuygood.id);
}
