private void SaveChangesbtn_Click(object sender, EventArgs e) { //check if all fields have data if (textBoxCardNumber.Text == "" || textBoxCVV.Text == "" || textBoxExpiryMM.Text == "" || textBoxExpiryYY.Text == "" || comboBoxCardtype.SelectedIndex == -1 || (radioButtonOnline.Checked == false && radioButtonAtBooth.Checked == false)) { MessageBox.Show("All Fields Required."); } else { string val = ""; if (radioButtonAtBooth.Checked == true) { val = "Booth"; } if (radioButtonOnline.Checked == true) { val = "Online"; } //add card details to object CardDetails cd = new CardDetails(val, textBoxCardNumber.Text, comboBoxCardtype.SelectedItem.ToString(), textBoxExpiryMM.Text, textBoxExpiryYY.Text, textBoxCVV.Text); //send to db instance class DBSingleton.GetDBSingletonInstance.InsertCardDetails(cd); MessageBox.Show("Details Saved!"); } }
public void InsertCardDetails(CardDetails cd) { //insert query to add card details in database OleDbConnection connection = GetOleDbConnection(); string query = "insert into carddetails values ('" + cd.tickepurchase + "','" + cd.cardnumber + "','" + cd.cardtype + "','" + cd.MM + "','" + cd.YY + "','" + cd.CVV + "')"; OleDbCommand Command = new OleDbCommand(query, connection); try { connection.Open(); //adding parameters to query Command.CommandType = CommandType.Text; Command.Parameters.AddWithValue("@purchaselocation", cd.tickepurchase); Command.Parameters.AddWithValue("@CardNumber", cd.cardnumber); Command.Parameters.AddWithValue("@Type", cd.cardtype); Command.Parameters.AddWithValue("@ExpiryDateMM", cd.MM); Command.Parameters.AddWithValue("@ExpiryDateDD", cd.YY); Command.Parameters.AddWithValue("@CVV", cd.CVV); Command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); //System.Diagnostics.Debug.WriteLine("Exception: " + ex); } finally { connection.Close(); } }