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