public void suancc(EC_tb_NCC ncc)
{
string sql = (@"UPDATE tb_NCC
SET tenncc =N'" + ncc.TENNCC + "', diachi =N'" + ncc.DIACHI + "', dienthoai =N'" + ncc.DIENTHOAI + "' where mancc=N'" + ncc.MANCC + "'");
cn.ExcuteNonQuery(sql);
}
public void themoincc(EC_tb_NCC ncc)
{
if (!nccsql.kiemtrancc(ncc.MANCC))
{
nccsql.themmoincc(ncc);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoancc(EC_tb_NCC ncc)
{
nccsql.xoancc(ncc);
}
public void suancc(EC_tb_NCC ncc)
{
nccsql.suancc(ncc);
}
public void xoancc(EC_tb_NCC ncc)
{
cn.ExcuteNonQuery("DELETE FROM [tb_NCC] WHERE mancc=N'" + ncc.MANCC + "'");
}
public void themmoincc(EC_tb_NCC ncc)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_NCC
(mancc, tenncc, diachi,dienthoai) VALUES (N'" + ncc.MANCC + "',N'" + ncc.TENNCC + "',N'" + ncc.DIACHI + "',N'" + ncc.DIENTHOAI + "')");
}
