//TODO ~ Add products to new Customer update stored procedure to use scope_identity private void btnNewCustomer_Click(object sender, EventArgs e) { List <MaterialSingleLineTextField> allFields = NewCustomerDetails(); List <MaterialSingleLineTextField> numericFields = new List <MaterialSingleLineTextField>(); numericFields.Add(txtNewPhone); if (!IsNullOrWhiteSpace(allFields) && IsNumeric(numericFields)) { management.Insert(txtNewName.Text, txtNewSurname.Text, txtNewEmail.Text, txtNewAddress.Text, int.Parse(txtNewPhone.Text), txtNewBankAccount.Text, 0); MessageBox.Show("Insertion successful!"); RefreshAll(); ClearFields(allFields); techSupport.RefreshAll(); } else { MessageBox.Show("Vaules in incorrect format"); } }