public bool Update()
{
if (!WhiteList(ID.ToString()) || !WhiteList(ID_Root.ToString()) || !WhiteList(Name))
{
return(false);
}
if (!ExistID(ID) || !ExistID(ID_Root))
{
return(false);
}
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
string query = "UPDATE tree SET id_root=@id_root, name=@name WHERE id=@id";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Connection = con;
con.Open();
cmd.Parameters.AddWithValue("@id_root", ID_Root);
cmd.Parameters.AddWithValue("@name", Name);
cmd.Parameters.AddWithValue("@id", ID);
cmd.ExecuteNonQuery();
con.Close();
}
}
return(true);
}
public bool Delete(bool saveChilds)
{
if (!WhiteList(ID.ToString()) || !WhiteList(ID_Root.ToString()) || !WhiteList(Name))
{
return(false);
}
if (!ExistID(ID))
{
return(false);
}
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
string query = "DELETE FROM tree WHERE id=@id";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Connection = con;
con.Open();
cmd.Parameters.AddWithValue("@id", ID);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (saveChilds)
{
SaveChilds(ID, ID_Root);
}
else
{
RemoveChilds(ID);
}
return(true);
}
public bool Insert()
{
if (!WhiteList(ID.ToString()) || !WhiteList(ID_Root.ToString()) || !WhiteList(Name))
{
return(false);
}
if (ID_Root != 0)
{
if (!ExistID(ID_Root))
{
return(false);
}
}
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
string query = "INSERT INTO tree (id_root, name) VALUES (@id_root, @name)";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Connection = con;
con.Open();
cmd.Parameters.AddWithValue("@id_root", ID_Root);
cmd.Parameters.AddWithValue("@name", Name);
cmd.ExecuteNonQuery();
con.Close();
}
}
return(true);
}
