// Method to delete customers protected void btnDelete_Click(object sender, EventArgs e) { // Set to false to ensure completion bool userUpdateError = false; // Mine is in App_Data string tempPath = Server.MapPath("~/App_Data/Users.accdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // Try-catch statement to delete users try { myDataLayer.DeleteUser(txtUsername.Text, txtCity.Text, txtState.Text, txtFavLang.Text, txtWorstLang.Text, txtLastProgram.Text); } // Error details for syntax, spelling or run-time issues. catch (Exception error) { userUpdateError = true; string message = "Error updating customer, please check form data. "; Master.UserFeedBack.Text = message + error.Message; } // If no errors, success has been made if (!userUpdateError) { // Wipes the controls so another update can be made ClearInputs(Page.Controls); Master.UserFeedBack.Text = "Customer Updated Successfully."; } // Necessary for displaying the info for the table "Customers in Database" BindCustomerGridView(); }
/// DELETE USER // btnDeleteUser method protected void btnDeleteUser_Click(object sender, EventArgs e) { // bool for delete error bool userDeleteError = false; // path for database string tempPath = Server.MapPath("~/App_Data/dsProgramaholics.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // try block to update customer try { myDataLayer.DeleteUser(Convert.ToInt32(userID.Text)); } catch (Exception error) { userDeleteError = true; string message = "Error deleting user. Please check your form data. "; Master.UserFeedBack.Text = message + error.Message; } // end catch // if no error update feedback text to display success message if (!userDeleteError) { ClearInput(Page.Controls); Master.UserFeedBack.Text = "Customer Updated Succesfully."; } // end if } // end delete