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