public void Xoa(QLKTX.BusinessObject.TonGiaoInfo tg)
{
SqlCommand s = new SqlCommand("Delete TONGIAO where MATONGIAO=@ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = tg.MaTonGiao;
ser.Load(s);
}
public void Sua(QLKTX.BusinessObject.TonGiaoInfo tg)
{
SqlCommand s = new SqlCommand("Update TONGIAO set TENTONGIAO = @ten where MATONGIAO= @ma");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = tg.TenTonGiao;
s.Parameters.Add("@ma", SqlDbType.Int).Value = tg.MaTonGiao;
ser.Load(s);
}
public void Them(QLKTX.BusinessObject.TonGiaoInfo tg)
{
SqlCommand s = new SqlCommand("INSERT INTO TONGIAO(MATONGIAO,TENTONGIAO) VALUES(@ma,@ten)");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = tg.TenTonGiao;
s.Parameters.Add("@ma", SqlDbType.Int).Value = tg.MaTonGiao;
ser.Load(s);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtTen.Text != "")
{
QLKTX.BusinessObject.TonGiaoInfo tg = new QLKTX.BusinessObject.TonGiaoInfo();
tg.MaTonGiao = Convert.ToInt32(txtMa.Text);
tg.TenTonGiao = txtTen.Text.ToString();
ctl.Them(tg);
DialogResult = DialogResult.Yes;
}
else
{
MessageBox.Show("Chưa nhập Tên!", "Tôn Giáo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Sua(QLKTX.BusinessObject.TonGiaoInfo info)
{
TonGiaoData data = new TonGiaoData();
data.Sua(info);
}
