public void suaCV(EC_tb_CongViec cv)
{
string sql = (@"UPDATE tb_Congviec
SET tencv =N'" + cv.TENCV + "' where macv =N'" + cv.MACV + "'");
cn.ExcuteNonQuery(sql);
}
public void themoicv(EC_tb_CongViec cv)
{
if (!cvsql.kiemtraCV(cv.MACV))
{
cvsql.themmoiCV(cv);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoaCV(EC_tb_CongViec cv)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Congviec] WHERE [macv] = N'" + cv.MACV + "'");
}
public void themmoiCV(EC_tb_CongViec cv)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Congviec
(macv, tencv) VALUES (N'" + cv.MACV + "',N'" + cv.TENCV + "')");
}
public void xoacv(EC_tb_CongViec cv)
{
cvsql.xoaCV(cv);
}
public void suacv(EC_tb_CongViec cv)
{
cvsql.suaCV(cv);
}
