/// click method of update button // btnUpdate_Click protected void btnUpdateUser_Click(object sender, EventArgs e) { // bool for update error bool userUpdateError = false; // path for database string tempPath = Server.MapPath("~/App_Data/dsProgramaholics.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // try block to update customer try { myDataLayer.UpdateUser(txtFirstName.Text, txtLastName.Text, txtStreet.Text, txtCity.Text, txtState.Text, txtUsername.Text, txtPassword.Text, txtFavLanguage.Text, txtLeastFavLang.Text, txtDateCompleted.Text, Convert.ToInt32(userID.Text)); } catch (Exception error) { userUpdateError = true; string message = "Error updating customer information. Please check your form data."; Master.UserFeedBack.Text = message + error.Message; } // end catch // if no error update feedback text to display success message if (!userUpdateError) { ClearInput(Page.Controls); Master.UserFeedBack.Text = "Customer Updated Succesfully."; } // end if } // end btnUpdate
// Method to update users protected void btnUpdate_Click(object sender, EventArgs e) { // Set to false to ensure completion bool userUpdateError = false; // Path is literally to App_Data string tempPath = Server.MapPath("~/App_Data/Users.accdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // Try-catch statement to update users with usual variables try { myDataLayer.UpdateUser(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(); }
public string UpdateUser(string username, string city, string state, string favoriteLanguage, string leastFavoriteLanguage, string dateLastProgramCompleted, int userID) { string resultMessage = "Customer Updated Successfully."; try { myDataLayer.UpdateUser(username, city, state, favoriteLanguage, leastFavoriteLanguage, dateLastProgramCompleted, userID); } catch (Exception error) { resultMessage = "Error updating user, check form data."; resultMessage = resultMessage + error.Message; } return(resultMessage); }
public string UpdateUser(string username, string City, string State, string FavLang, string LeastFavLang, DateTime LastProgDate) { bool userUpdateError = false; string message = ""; //try catch block update customer try { myDataLayer.UpdateUser(username, City, State, FavLang, LeastFavLang, LastProgDate); } catch (Exception error) { userUpdateError = true; message = "Error update user, please check form data. "; return(message + error); } if (!userUpdateError) { HttpContext.Current.Response.Redirect("Account Details.aspx"); } return(message); }