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(); }
void grdView1_DoubleClick(object sender, EventArgs e) { var Good = (Good)this.grdView1.SelectedRows[0].DataBoundItem; var updateForm = new UpdateGood(Good.id); updateForm.ShowDialog(); this.ShowAllGood(); var db = new DataDeAnCEntities(); grdView1.DataSource = db.Goods.Where(x => x.Code.Contains(txtSearch.Text)).ToList(); }
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(); }
void btnDelete1_Click(object sender, EventArgs e) { if (this.grdView1.SelectedRows.Count == 1) { if (MessageBox.Show("Do you want to delete this ?", "Confire", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { var delete1 = (Good)this.grdView1.SelectedRows[0].DataBoundItem; this.Business.DeleteGood(delete1.id); MessageBox.Show("Delete Good Successfully."); this.ShowAllGood(); var db = new DataDeAnCEntities(); grdView1.DataSource = db.Goods.Where(x => x.Code.Contains(txtSearch.Text)).ToList(); } } }
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); }
public Good GetGood(int id) { var db = new DataDeAnCEntities(); return(db.Goods.Find(id)); }
public Good[] GetGoods() { var db = new DataDeAnCEntities(); return(db.Goods.ToArray()); }
void btnSearch_Click(object sender, EventArgs e) { var db = new DataDeAnCEntities(); grdView1.DataSource = db.Goods.Where(x => x.Code.Contains(txtSearch.Text)).ToList(); }
public Bill[] GetBill() { var db = new DataDeAnCEntities(); return(db.Bills.ToArray()); }