示例#1
0
 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");
            }
        }