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