private void buttonAdd_Click(object sender, EventArgs e)
{
FormEditText userName = new FormEditText("", formText);
if (userName.ShowDialog(this) == DialogResult.OK)
{
if (userName.textBox1.Text.Trim().Length > 0)
{
using (var mySqlConnection = new DBUtils().getDBConnection())
{
using (var cmd = new MySqlCommand())
{
cmd.Connection = mySqlConnection;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = querys[0];
cmd.Parameters.Clear();
MySqlParameter p1 = cmd.Parameters.Add("@name", MySqlDbType.VarChar);
p1.Direction = ParameterDirection.Input;
p1.Value = userName.textBox1.Text;
mySqlConnection.Open();
cmd.ExecuteNonQuery();
}
}
panelUsers.Controls.Clear();
list.Clear();
loadList(query);
}
}
}
private void ButtonCh_Click(object sender, EventArgs e)
{
Label lab = (Label)((Button)sender).Parent.Controls.Find("label-" + ((Button)sender).Name.ToString().Split('-')[1], true)[0];
FormEditText editText = new FormEditText(lab.Text, formText);
if (editText.ShowDialog(this) == DialogResult.OK)
{
if (editText.textBox1.Text.Trim().Length > 0)
{
using (var mySqlConnection = new DBUtils().getDBConnection())
{
using (var cmd = new MySqlCommand())
{
cmd.Connection = mySqlConnection;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = querys[2];
cmd.Parameters.Clear();
MySqlParameter p1 = cmd.Parameters.Add("@id", MySqlDbType.Int32);
p1.Direction = ParameterDirection.Input;
MySqlParameter p2 = cmd.Parameters.Add("@oldname", MySqlDbType.VarChar);
p2.Direction = ParameterDirection.Input;
MySqlParameter p3 = cmd.Parameters.Add("@newname", MySqlDbType.VarChar);
p3.Direction = ParameterDirection.Input;
p1.Value = lab.Tag;
p2.Value = lab.Text;
p3.Value = editText.textBox1.Text;
mySqlConnection.Open();
cmd.ExecuteNonQuery();
}
}
lab.Text = editText.textBox1.Text;
}
}
}
