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)); }