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();
}
}
