public void AddRow(HelpProj.InsertDialogData data)
{
mySqlCommand = new MySqlCommand(@"`insertData`", usingDB.Connection);
List <string> parameters = new List <string> {
@"FirstName", @"SecondName", @"eMail", @"skype", @"phone", @"adress"
};
mySqlCommand.Parameters.AddWithValue(parameters[0], data.FirstName);
mySqlCommand.Parameters.AddWithValue(parameters[1], data.SecondName);
mySqlCommand.Parameters.AddWithValue(parameters[2], data.Email);
mySqlCommand.Parameters.AddWithValue(parameters[3], data.Skype);
mySqlCommand.Parameters.AddWithValue(parameters[4], data.Phone);
mySqlCommand.Parameters.AddWithValue(parameters[5], data.Adress);
for (int i = 0; i < parameters.Count; i++)
{
mySqlCommand.Parameters[i].MySqlDbType = MySqlDbType.String;
}
mySqlCommand.Parameters[4].MySqlDbType = MySqlDbType.Decimal;
mySqlCommand.CommandType = CommandType.StoredProcedure;
mySqlCommand.ExecuteNonQuery();
}
public void button1_Click(object sender, EventArgs e)
{
var data = new HelpProj.InsertDialogData(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, Convert.ToInt32(textBox5.Text), textBox6.Text);
Close();
}
public void InputRow(HelpProj.InsertDialogData data)
{
wrapper.AddRow(data);
}
