public static void SaveAdditionalJumpers(AdditionalJumpers cl) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("insert into AdditionalJumpers values (@ID, @order, @name, @surname, @weight, @height)", cl); } }
private void enterAddJumperButton_Click(object sender, EventArgs e) { AdditionalJumpers ad2 = new AdditionalJumpers(); bool fields; if (addJumperHelper2 < peopleNUpDown.Value) { ad2.ID = addJumperHelper; ad2.order = orders.Count; ad2.name = addNameTextBox.Text; ad2.surname = addSurnameTextBox.Text; ad2.weight = Convert.ToDouble(addWeightTextBox.Text); ad2.height = Convert.ToDouble(addHeightTextBox.Text); additionalJumpers2.Add(ad2); //additionalJumpers2 = new List<AdditionalJumpers> //{ // new AdditionalJumpers {ID = addJumperHelper, order = orders.Count, name = addNameTextBox.Text, surname = addSurnameTextBox.Text, weight = Convert.ToDouble(addWeightTextBox.Text), height = Convert.ToDouble(addHeightTextBox.Text) } //}; addJumpersList.Add(addNameTextBox.Text + " " + addSurnameTextBox.Text + " " + Convert.ToDouble(addWeightTextBox.Text) + " " + Convert.ToDouble(addHeightTextBox.Text)); addJumperHelper++; addJumperHelper2++; RefreshAddJumpersList(); addNameTextBox.Text = ""; addSurnameTextBox.Text = ""; addWeightTextBox.Text = ""; addHeightTextBox.Text = ""; } else { fields = false; closeAddjumpersFields(fields); MessageBox.Show("You have reached max number of People"); } }