public bool UpdData(LoaiObj lObj)
{
cmd.CommandText = "UPDATE LOAI SET TENL=N'" + lObj.TenL + "'WHERE MAL='" + lObj.MaL + "'";
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(LoaiObj lObj)
{
cmd.CommandText = "INSERT INTO LOAI VALUES ('" + lObj.MaL + "', N'" + lObj.TenL + "')";
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 updData(LoaiObj lObj)
{
return(lMod.UpdData(lObj));
}
public bool addData(LoaiObj lObj)
{
return(lMod.AddData(lObj));
}
private void addData(LoaiObj l)
{
l.MaL = txtmal.Text.Trim();
l.TenL = txttenl.Text.Trim();
}
