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;
}
}
}
