public void delete(dtonhacc k)
{
openC();
SqlCommand cmd = new SqlCommand("sp_delete_NHACC", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MANCC", k.MANCC));
cmd.ExecuteNonQuery();
closeC();
}
private void button13_Click(object sender, EventArgs e)
{
dtonhacc MT = new dtonhacc(textBox17.Text, null, null, null);
try
{
busnhacc bus_mt = new busnhacc();
bus_mt.delete(MT);
LoadData2();
MessageBox.Show("xóa thành công");
}
catch
{
MessageBox.Show("xóa không thành công");
}
}
private void button12_Click(object sender, EventArgs e)
{
dtonhacc MT = new dtonhacc(textBox12.Text, textBox11.Text, textBox10.Text, textBox9.Text);
try
{
busnhacc bus_mt = new busnhacc();
bus_mt.update(MT);
LoadData2();
MessageBox.Show("sửa thành công");
}
catch
{
MessageBox.Show("sửa không thành công");
}
}
public void update(dtonhacc k)
{
openC();
SqlCommand cmd = new SqlCommand("sp_update_NHACC", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MANCC", k.MANCC));
cmd.Parameters.Add(new SqlParameter("@TENNHACC", k.TENNHACC));
cmd.Parameters.Add(new SqlParameter("@DIACHI", k.DIACHI));
cmd.Parameters.Add(new SqlParameter("@SDT", k.SDT));
cmd.ExecuteNonQuery();
closeC();
}
public void delete(dtonhacc k)
{
kh.delete(k);
}
public void update(dtonhacc k)
{
kh.update(k);
}
public void insert(dtonhacc k)
{
kh.insert(k);
}
