public void Xoa(QLKTX.BusinessObject.DanTocInfo dt)
{
SqlCommand s = new SqlCommand("Delete DANTOC where MADANTOC=@ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = dt.MaDanToc;
ser.Load(s);
}
public void Sua(QLKTX.BusinessObject.DanTocInfo dt)
{
SqlCommand s = new SqlCommand("Update DANTOC set TENDANTOC = @ten where MADANTOC= @ma");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = dt.TenDanToc;
s.Parameters.Add("@ma", SqlDbType.Int).Value = dt.MaDanToc;
ser.Load(s);
}
public void Them(QLKTX.BusinessObject.DanTocInfo dt)
{
SqlCommand s = new SqlCommand("INSERT INTO DANTOC(MADANTOC,TENDANTOC) VALUES(@ma,@ten)");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = dt.TenDanToc;
s.Parameters.Add("@ma", SqlDbType.Int).Value = dt.MaDanToc;
ser.Load(s);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtTen.Text != "")
{
QLKTX.BusinessObject.DanTocInfo dt = new QLKTX.BusinessObject.DanTocInfo();
dt.MaDanToc = Convert.ToInt32(txtMa.Text);
dt.TenDanToc = txtTen.Text.ToString();
ctl.Them(dt);
DialogResult = DialogResult.Yes;
}
else
{
MessageBox.Show("Chưa nhập Tên!", "Dân Tộc", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Sua(QLKTX.BusinessObject.DanTocInfo info)
{
data.Sua(info);
}
public void Them(QLKTX.BusinessObject.DanTocInfo info)
{
data.Them(info);
}
