private nhaCC getnhacc()
{
nhaCC c = new nhaCC();
c.MaNCC = txt_macc.Text;
c.TenNCC = txt_tencc.Text;
c.Diachi = txt_diachi.Text;
c.Sodt = txt_sdt.Text;
c.Email = txt_email.Text;
return(c);
}
public void delete(nhaCC n)
{
openC();
SqlCommand cmd = new SqlCommand("sp_delete_nhaCC", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maNCC", n.MaNCC));
cmd.ExecuteNonQuery();
closeC();
}
public void update(nhaCC n)
{
openC();
SqlCommand cmd = new SqlCommand("sp_update_nhaCC", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maNCC", n.MaNCC));
cmd.Parameters.Add(new SqlParameter("@tenNCC", n.TenNCC));
cmd.Parameters.Add(new SqlParameter("@diachi", n.Diachi));
cmd.Parameters.Add(new SqlParameter("@sodt", n.Sodt));
cmd.Parameters.Add(new SqlParameter("@email", n.Email));
cmd.ExecuteNonQuery();
closeC();
}
private void btn_xoa_Click(object sender, EventArgs e)
{
nhaCC n = new nhaCC();
n.MaNCC = dg_nhacc.Rows[dg_nhacc.CurrentRow.Index].Cells[0].Value.ToString();
int kq = nhacc.check(n.MaNCC);
if (kq == 0)
{
nhacc.delete(n);
load();
}
else
{
MessageBox.Show("Không thể xóa vì còn dữ liệu");
}
}
public void delete(nhaCC n)
{
ncc.delete(n);
}
public void update(nhaCC n)
{
ncc.update(n);
}
public void insert(nhaCC n)
{
ncc.insert(n);
}