private void buttonAddSize_Click(object sender, EventArgs e) { FormChangePaperSize paperSize = new FormChangePaperSize("", "", ""); if (paperSize.ShowDialog(this) == DialogResult.OK) { if ((paperSize.textBoxX.Text.Trim().Length > 0) && (paperSize.textBoxY.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("@size", MySqlDbType.VarChar); p1.Direction = ParameterDirection.Input; p1.Value = paperSize.textBoxX.Text + ";" + paperSize.textBoxY.Text; mySqlConnection.Open(); cmd.ExecuteNonQuery(); } } panelUsers.Controls.Clear(); list.Clear(); loadList(query); } } }
private void ButtonChSize_Click(object sender, EventArgs e) { Label lab = (Label)((Button)sender).Parent.Controls.Find("label-" + ((Button)sender).Name.ToString().Split('-')[1], true)[0]; FormChangePaperSize editText = new FormChangePaperSize(lab.Tag.ToString().Split(';')[1], lab.Tag.ToString().Split(';')[2], lab.Tag.ToString().Split(';')[3]); if (editText.ShowDialog(this) == DialogResult.OK) { if (editText.textBoxPrice.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("@price", MySqlDbType.VarChar); p1.Value = lab.Tag.ToString().Split(';')[0]; p2.Value = editText.textBoxPrice.Text; mySqlConnection.Open(); cmd.ExecuteNonQuery(); } } lab.Text = editText.textBoxX.Text + "x" + editText.textBoxY.Text + " : " + editText.textBoxPrice.Text; } } }