// UpdateUser_click method
protected void btnUpdate_Click(object sender, EventArgs e)
{
// start off error as false
bool userUpdateError = false;
// path for database
string tempPath = Server.MapPath("~App_Data/Programaholics.mdb");
clsDataLayer myData = new clsDataLayer(tempPath);
// try to update, catch error
try
{
myData.UpdateTblUser(txtFirstName.Text, txtLastName.Text,
txtEmail.Text, txtPassword.Text, txtStreet.Text, txtCity.Text, txtState.Text);
myData.UpdateTblProgram(txtFav.Text, txtLeast.Text);
myData.UpdateTblCompleted(txtProgramLanguage.Text, txtProgramName.Text, txtDate.Text);
} // end try
catch (Exception error)
{
userUpdateError = true;
string message = "Error updating user information! Please check your info. ";
Master.UserFeedBack.Text = message + error.Message;
} // end catch
// if there is no error updating
if (!userUpdateError)
{
ClearInputs(Page.Controls);
Master.UserFeedBack.Text = "User information updated Successfully! ";
BindUserGrid();
}
}
/// UpdateUser information
// updating users
public string UpdateUser(string firstName, string lastName, string username, string password,
string street, string city, string state, string favLang, string least, string programName, string programLanguage, string date)
{
// message of success
string resultMessage = "User Updated Successfully! ";
// try to update, catch errors
try
{
myDataLayer.UpdateTblUser(firstName, lastName, username, password, street, city, state);
myDataLayer.UpdateTblProgram(favLang, least);
myDataLayer.UpdateTblCompleted(programLanguage, programName, date);
}
catch (Exception error)
{
resultMessage = "Error updating customer, please check your information! ";
resultMessage = resultMessage + error.Message;
}
return(resultMessage);
}