public void Xoa(QLKTX.BusinessObject.CanBoInfo cb)
{
SqlCommand s = new SqlCommand("Delete CANBO where MACBQL=@ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = cb.MaSo;
ser.Load(s);
}
public void Sua(QLKTX.BusinessObject.CanBoInfo cb)
{
SqlCommand s = new SqlCommand("Update CANBO set TENCBQL = @ten, DIACHI=@diachi where MACBQL= @ma");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = cb.Ten;
s.Parameters.Add("@ma", SqlDbType.Int).Value = cb.MaSo;
s.Parameters.Add("@diachi", SqlDbType.NVarChar, 100).Value = cb.DiaChi;
ser.Load(s);
}
public void Them(QLKTX.BusinessObject.CanBoInfo cb)
{
SqlCommand s = new SqlCommand("INSERT INTO CANBO(MACBQL,TENCBQL,DIACHI) VALUES(@ma,@ten,@diachi)");
s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = cb.Ten;
s.Parameters.Add("@ma", SqlDbType.Int).Value = cb.MaSo;
s.Parameters.Add("@diachi", SqlDbType.NVarChar, 100).Value = cb.DiaChi;
ser.Load(s);
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (dataDSCanBoQuanLy.SelectedRows.Count > 0)
{
txtMa.Text = dataDSCanBoQuanLy.SelectedRows[0].Cells[0].Value.ToString();
txtTen.Text = dataDSCanBoQuanLy.SelectedRows[0].Cells[1].Value.ToString();
txtDiaChi.Text = dataDSCanBoQuanLy.SelectedRows[0].Cells[2].Value.ToString();
if (MessageBox.Show("Bạn có muốn xóa cán bộ: \"" + txtTen.Text + "\" Không?", "Cán bộ", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
QLKTX.BusinessObject.CanBoInfo info = new QLKTX.BusinessObject.CanBoInfo();
info.MaSo = Convert.ToInt32(txtMa.Text);
info.Ten = txtTen.Text;
info.DiaChi = txtDiaChi.Text;
ctrl.Xoa(info);
ctrl.LayDSCanBoQuanLy(dataDSCanBoQuanLy);
}
}
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
if (ctrl.KiemTra(txtMa, txtTen, txtDiaChi))
{
QLKTX.BusinessObject.CanBoInfo cb = new QLKTX.BusinessObject.CanBoInfo();
cb.MaSo = Convert.ToInt32(txtMa.Text);
cb.Ten = txtTen.Text;
cb.DiaChi = txtDiaChi.Text;
if (Adding)
{
ctrl.Them(cb);
}
else
{
if (Updating)
{
ctrl.Sua(cb);
}
}
ctrl.LayDSCanBoQuanLy(dataDSCanBoQuanLy);
Updating = Adding = false;
txtMa.Enabled = false;
txtTen.Enabled = false;
txtDiaChi.Enabled = false;
btnThem.Enabled = true;
btnXoa.Enabled = true;
btnSua.Enabled = true;
btnCapNhat.Enabled = false;
btnBoQua.Visible = false;
dataDSCanBoQuanLy.Enabled = true;
}
}
public void Sua(QLKTX.BusinessObject.CanBoInfo info)
{
CanBoData data = new CanBoData();
data.Sua(info);
}
public void Them(QLKTX.BusinessObject.CanBoInfo info)
{
CanBoData data = new CanBoData();
data.Them(info);
}
