public bool UpdData(ChatLieuObj clObj)
{
cmd.CommandText = "UPDATE CHATLIEU SET TENCL=N'" + clObj.TenCl + "'WHERE MACL='" + clObj.MaCl + "'";
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(ChatLieuObj clObj)
{
cmd.CommandText = "INSERT INTO CHATLIEU VALUES ('" + clObj.MaCl + "',N'" + clObj.TenCl + "')";
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(ChatLieuObj cl)
{
cl.MaCl = txtmacl.Text.Trim();
cl.TenCl = txttencl.Text.Trim();
}
public bool updData(ChatLieuObj clObj)
{
return(clMod.UpdData(clObj));
}
public bool addData(ChatLieuObj clObj)
{
return(clMod.AddData(clObj));
}
