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