// Clear Button action
protected void ButtonClear_Click(object sender, EventArgs e)
{
DropDownListCardType.ClearSelection();
TextBoxCardNumber.Text = "";
DropDownListExpMonth.ClearSelection();
DropDownListExpYear.ClearSelection();
TextBoxResult.Text = "";
// Clear Update Credit Card ID Selection
DropDownListSelectCreditCardID.ClearSelection();
}
// Commit Button action
protected void ButtonCommit_Click(object sender, EventArgs e)
{
// Create new object of Credit Card Class
CreditCardClass tempCreditCard = new CreditCardClass(DropDownListCardType.Text, HttpUtility.HtmlEncode(TextBoxCardNumber.Text), DropDownListExpMonth.Text, DropDownListExpYear.Text);
// Store selected credit card id value into variable
string tempID = DropDownListSelectCreditCardID.SelectedValue;
sc.Open();
//TextBoxResult.Text = creditCardSelected.ToString();
if (creditCardSelected == true)
{
// Edit credit card information
String query3 = "UPDATE [Sales].[CreditCard] SET [CardType] = @cardtype, [CardNumber] = @cardnumber, [ExpMonth] = @expmonth, [ExpYear] = @expyear, [ModifiedDate] = @modifieddate WHERE [CreditCardID] = @tempid;";
System.Data.SqlClient.SqlCommand sqlCom3 = new System.Data.SqlClient.SqlCommand(query3, sc);
sqlCom3.Parameters.AddWithValue("@cardtype", tempCreditCard.getCardType());
sqlCom3.Parameters.AddWithValue("@cardnumber", tempCreditCard.getCardNumber());
sqlCom3.Parameters.AddWithValue("@expmonth", tempCreditCard.getExpMonth());
sqlCom3.Parameters.AddWithValue("@expyear", tempCreditCard.getExpYear());
sqlCom3.Parameters.AddWithValue("@modifieddate", tempCreditCard.getModifiedDate());
sqlCom3.Parameters.AddWithValue("@tempid", tempID);
sqlCom3.ExecuteNonQuery();
TextBoxResult.Text = "Credit card information updated.";
}
else if (creditCardSelected == false)
{
//Insert new credit card information
String query1 = "INSERT INTO [Sales].[CreditCard] VALUES (@cardtype, @cardnumber, @expmonth, @expyear, @modifieddate);";
System.Data.SqlClient.SqlCommand sqlCom1 = new System.Data.SqlClient.SqlCommand(query1, sc);
sqlCom1.Parameters.AddWithValue("@cardtype", tempCreditCard.getCardType());
sqlCom1.Parameters.AddWithValue("@cardnumber", tempCreditCard.getCardNumber());
sqlCom1.Parameters.AddWithValue("@expmonth", tempCreditCard.getExpMonth());
sqlCom1.Parameters.AddWithValue("@expyear", tempCreditCard.getExpYear());
sqlCom1.Parameters.AddWithValue("@modifieddate", tempCreditCard.getModifiedDate());
sqlCom1.ExecuteNonQuery();
TextBoxResult.Text = "Credit card information committed.";
DropDownListSelectCreditCardID.DataBind();
}
// Reset creditCardSelected boolean back to false
creditCardSelected = false;
//Clear textbox fields
DropDownListCardType.ClearSelection();
TextBoxCardNumber.Text = "";
DropDownListExpMonth.ClearSelection();
DropDownListExpYear.ClearSelection();
//Clear Update Credit Card ID Selection
DropDownListSelectCreditCardID.ClearSelection();
}
