public void xoa(string a)
{
RestaurantManagerDataContext dbs = new RestaurantManagerDataContext();
HOADONNH hd = dbs.HOADONNHs.Single(p => p.ID.ToString() == a);
hd.TrangThai = false;
dbs.SubmitChanges();
}
public void sua(string a)
{
RestaurantManagerDataContext dbs = new RestaurantManagerDataContext();
HOADONNH HD = dbs.HOADONNHs.Single(p => p.ID.ToString() == a);
txttong.Text = (DG * txtSoLuong.Value).ToString();
HD.NV = Convert.ToInt32(cbxMANV.SelectedValue.ToString());
HD.NSX = Convert.ToInt32(cbxNSX.SelectedValue.ToString());
HD.SP = Convert.ToInt32(cbxSP.SelectedValue.ToString());
HD.SoLuong = Convert.ToInt32(txtSoLuong.Text);
HD.DonGia = Convert.ToInt32(txtgia.Text);
HD.ThanhTien = Convert.ToInt32(txttong.Text);
dbs.SubmitChanges();
}
public void them(string nv, string nsx, string sp, string sl, string gia, string tong, string ngay, bool trangthai)
{
RestaurantManagerDataContext dbs = new RestaurantManagerDataContext();
HOADONNH HD = new HOADONNH();
txttong.Text = (DG * txtSoLuong.Value).ToString();
HD.NV = Convert.ToInt32(cbxMANV.SelectedValue.ToString());
HD.NSX = Convert.ToInt32(cbxNSX.SelectedValue.ToString());
HD.SP = Convert.ToInt32(cbxSP.SelectedValue.ToString());
HD.SoLuong = Convert.ToInt32(txtSoLuong.Text);
HD.DonGia = Convert.ToInt32(txtgia.Text);
HD.ThanhTien = Convert.ToInt32(txttong.Text);
HD.Ngay = DateTime.Now;
HD.TrangThai = true;
dbs.HOADONNHs.InsertOnSubmit(HD);
dbs.SubmitChanges();
}
