public TonDauKySanPham(tonDauKy tonKy) { InitializeComponent(); tbTenTon.Text = tonKy.TenKy; TonKy = tonKy; NapDanhSachSanPhamTheoKy(); }
public SuaKy(tonDauKy tonKy) { InitializeComponent(); tbMa.Text = tonKy.MaKy; tbTen.Text = tonKy.TenKy; datePicker1.Text = tonKy.NgayBatDau.ToString(); datePicker2.Text = tonKy.NgayKetThuc.ToString(); }
// Xóa một tồn kỳ khỏi database public static void XoaKy(tonDauKy tonKy) { using (MyDatabaseDataContext db = new MyDatabaseDataContext()) { TONKY tonKyDB = (from n in db.TONKies where n.MAKY == tonKy.MaKy select n).FirstOrDefault(); db.TONKies.DeleteOnSubmit(tonKyDB); db.SubmitChanges(); } }
// Sửa thông tin kỳ public static void CapNhatKy(tonDauKy tonKy) { using (MyDatabaseDataContext db = new MyDatabaseDataContext()) { TONKY tonKyDB = (from n in db.TONKies where n.MAKY == tonKy.MaKy select n).FirstOrDefault(); tonKyDB.TENKY = tonKy.TenKy; tonKyDB.NGAYBATDAU = tonKy.NgayBatDau; tonKyDB.NGAYKETTHUC = tonKy.NgayKetThuc; db.SubmitChanges(); } }
private void Button_Sua_Click(object sender, RoutedEventArgs e) { if (tbTen.Text != "" && datePicker1.Text != "" && datePicker2.Text != "") { tonDauKy tonKy = new tonDauKy(); tonKy.MaKy = tbMa.Text; tonKy.TenKy = tbTen.Text; tonKy.NgayBatDau = datePicker1.SelectedDate.Value; tonKy.NgayKetThuc = datePicker2.SelectedDate.Value; Database.UPDATE.CapNhatKy(tonKy); MessageBox.Show("Cập nhật thành công", "Thông báo"); this.Close(); } else { MessageBox.Show("Không được để thông tin trống", "Thông báo"); } }