public bool UpdData(CongViecObj cvObj)
{
cmd.CommandText = "UPDATE CONGVIEC SET TENCV=N'" + cvObj.TenCv + "', MUCLUONG='" + cvObj.MucLuong + "' WHERE MACV='" + cvObj.MaCv + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
con.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool AddData(CongViecObj cvObj)
{
cmd.CommandText = "INSERT INTO CONGVIEC VALUES ('" + cvObj.MaCv + "',N'" + cvObj.TenCv + "','" + cvObj.MucLuong + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
con.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
private void addData(CongViecObj cv)
{
cv.MaCv = txtmacv.Text.Trim();
cv.TenCv = txttencv.Text.Trim();
cv.MucLuong = int.Parse(txtmucluong.Text);
}
public bool updData(CongViecObj cvObj)
{
return(cvMod.UpdData(cvObj));
}
public bool addData(CongViecObj cvObj)
{
return(cvMod.AddData(cvObj));
}
