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