public void Xoa(QLKTX.BusinessObject.KyLuatInfo tg)
{
SqlCommand s = new SqlCommand("Delete KyLuat where MAKyLuat=@ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = tg.MaKyLuat;
ser.Load(s);
}
public void Sua(QLKTX.BusinessObject.KyLuatInfo tg)
{
SqlCommand s = new SqlCommand("Update KyLuat set TENKyLuat = @ten where MAKyLuat= @ma");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = tg.TenKyLuat;
s.Parameters.Add("@ma", SqlDbType.Int).Value = tg.MaKyLuat;
ser.Load(s);
}
public void Them(QLKTX.BusinessObject.KyLuatInfo tg)
{
SqlCommand s = new SqlCommand("INSERT INTO KyLuat(MAKyLuat,TENKyLuat) VALUES(@ma,@ten)");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = tg.TenKyLuat;
s.Parameters.Add("@ma", SqlDbType.Int).Value = tg.MaKyLuat;
ser.Load(s);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtTen.Text != "")
{
QLKTX.BusinessObject.KyLuatInfo tg = new QLKTX.BusinessObject.KyLuatInfo();
tg.MaKyLuat = Convert.ToInt32(txtMa.Text);
tg.TenKyLuat = txtTen.Text.ToString();
ctl.Them(tg);
DialogResult = DialogResult.Yes;
}
else
{
MessageBox.Show("Chưa nhập Tên!", "Kỹ Luật", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Sua(QLKTX.BusinessObject.KyLuatInfo info)
{
KyLuatData data = new KyLuatData();
data.Sua(info);
}
public void Them(QLKTX.BusinessObject.KyLuatInfo info)
{
KyLuatData data = new KyLuatData();
data.Them(info);
}