public void sua(EC_tb_Congdung q)
{
string sql = (@"UPDATE tb_Congdung
SET tencongdung =N'" + q.MACONGDUNG + "' where macongdung =N'" + q.TENCONGDUNG + "'");
cn.ExcuteNonQuery(sql);
}
public void themoinv(EC_tb_Congdung nv)
{
if (!nvsql.kiemtra(nv.MACONGDUNG))
{
nvsql.themmoi(nv);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoanv(EC_tb_Congdung nv)
{
nvsql.xoa(nv);
}
public void suanv(EC_tb_Congdung nv)
{
nvsql.sua(nv);
}
public void xoa(EC_tb_Congdung q)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Congdung] WHERE [macongdung] = N'" + q.MACONGDUNG + "'");
}
public void themmoi(EC_tb_Congdung q)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Congdung
(macongdung, tencongdung) VALUES (N'" + q.MACONGDUNG + "',N'" + q.TENCONGDUNG + "')");
}
