private void btn_Submit_Click(object sender, EventArgs e) { if (tb_SecurityQAnswer.Text != "" && cb_AccountType.Text != "" && cb_SecurityQuestion.Text != "") { using (connection = new SqlConnection(GlobalVariablesClass.connectionString)) using (SqlDataAdapter adapter = new SqlDataAdapter("INSERT INTO tbl_Account([Account Type],[Account Balance],[Security Question],[Security Question Answer],[customerID]) VALUES (@accountType,'0',@SecQues,@SecQuesAns,@customerID); SELECT SCOPE_IDENTITY()", connection)) { adapter.SelectCommand.Parameters.AddWithValue("@accountType", cb_AccountType.SelectedItem); adapter.SelectCommand.Parameters.AddWithValue("@SecQues", cb_SecurityQuestion.SelectedItem); adapter.SelectCommand.Parameters.AddWithValue("@SecQuesAns", tb_SecurityQAnswer.Text.ToLower()); adapter.SelectCommand.Parameters.AddWithValue("@customerID", Convert.ToInt16(GlobalVariablesClass.customerID)); DataTable accountNumber = new DataTable(); adapter.Fill(accountNumber); GlobalVariablesClass.accountNumber = accountNumber.Rows[0][0].ToString(); } AccountViewingScreen frm = new AccountViewingScreen(); this.Hide(); frm.ShowDialog(); this.Close(); } else { MessageBox.Show("You must not leave inputs blank"); } }
private void btn_Submit_Click(object sender, EventArgs e) { GlobalVariablesClass.accountNumber = lb_YourAccounts.SelectedValue.ToString(); AccountViewingScreen frm = new AccountViewingScreen(); this.Hide(); frm.ShowDialog(); this.Close(); }
private void btn_SubmitSQAnswer_Click(object sender, EventArgs e) { if (tb_AnswerBox.Text.ToLower() == answer.ToLower()) { using (connection = new SqlConnection(GlobalVariablesClass.connectionString)) using (SqlCommand cmd = new SqlCommand("UPDATE tbl_Account SET customerID = '" + Convert.ToInt16(GlobalVariablesClass.customerID) + "' WHERE [Account Number] = '" + Convert.ToInt16(GlobalVariablesClass.accountNumber) + "' ", connection)) { connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); AccountViewingScreen frm = new AccountViewingScreen(); this.Hide(); frm.ShowDialog(); this.Close(); } } else { MessageBox.Show("Incorrect answer please try again"); } }