private void btnSua_Click(object sender, EventArgs e)
{
SuKien_DTO skDTO = new SuKien_DTO();
skDTO.MaSuKien = txtTen.Text;
skDTO.SuKien = txtMota.Text;
skDTO.Nhom = txtNhom.Text;
sk.sua(skDTO);
dataSuKien.DataSource = sk.loadsukien();
}
private void btnThem_Click(object sender, EventArgs e)
{
SuKien_DTO skDTO = new SuKien_DTO();
skDTO.MaSuKien = txtTen.Text;
skDTO.SuKien = txtMota.Text;
skDTO.Nhom = txtNhom.Text;
sk.them(skDTO);
dataSuKien.DataSource = sk.loadsukien();
this.txtTen.Text = "";
this.txtMota.Text = "";
this.txtNhom.Text = "";
MessageBox.Show("Thêm sự kiện thành công!");
}
public void sua(SuKien_DTO sk)
{
String sql = "update tb_sukien set MOTA=N'" + sk.SuKien + "',NHOM=N'" + sk.Nhom + "' where MASUKIEN='" + sk.MaSuKien + "' ";
kn.ThucHien(sql);
}
public void them(SuKien_DTO sk)
{
String sql = "insert into tb_sukien values('" + sk.MaSuKien + "',N'" + sk.SuKien + "','" + sk.Nhom + "')";
kn.ThucHien(sql);
}
