} // end btnUpdate /// add a new customer button // btnAdd_Click method protected void btnAddUser_Click(object sender, EventArgs e) { // customer error set to false bool userAddError = false; // path to database string tempPath = Server.MapPath("~/App_Data/dsProgramaholics.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // try block to insert customer information try { // insert info myDataLayer.InsertUser(txtFirstName.Text, txtLastName.Text, txtStreet.Text, txtCity.Text, txtState.Text, txtUsername.Text, txtPassword.Text, txtFavLanguage.Text, txtLeastFavLang.Text, txtDateCompleted.Text); } catch (Exception error) { // catch the error & display error message userAddError = true; string message = "Error adding user, please check form data. "; Master.UserFeedBack.Text = message + error.Message; } // end catch // if there is no error display success message if (!userAddError) { ClearInput(Page.Controls); Master.UserFeedBack.Text = "User Added Successfully."; } // end if }
/// insertUser method // add a new user info to database protected void btnCreate_Click(object sender, EventArgs e) { // set error to false bool userAddError = false; // connection path string tempPath = Server.MapPath("~/App_Data/Programaholics.mdb"); clsDataLayer myData = new clsDataLayer(tempPath); // try to add new user try { // insert user details myData.InsertUser(txtFirstName.Text, txtLastName.Text, txtEmail.Text, txtPassword.Text, txtStreet.Text, txtCity.Text, txtState.Text); myData.InsertUserProgram(txtFav.Text, txtLeast.Text); myData.InsertUserCompleted(txtProgramName.Text, txtProgramLanguage.Text, txtDate.Text); } // end try catch (Exception error) { userAddError = true; string message = "Error adding user, please check your information! "; Master.UserFeedBack.Text = message + error.Message; } // end catch // if no error if (!userAddError) { ClearInputs(Page.Controls); Master.UserFeedBack.Text = "User added successfully! "; BindUserGrid(); } }
/// insertUser method // create new user public string InsertUser(string firstName, string lastName, string username, string password, string street, string city, string state) { string resultMessage = "User added successfully! "; // try to insert try { myDataLayer.InsertUser(firstName, lastName, username, password, street, city, state); } catch (Exception error) { resultMessage = "Error adding new user, please check your information! "; resultMessage = resultMessage + error.Message; } return(resultMessage); }
public string InsertUser(string Username, string Password) { string resultMessage = "User Added Successfully."; try { //Call method InsertUser from DataLayer myDataLayer.InsertUser(Username, Password); } catch (Exception error) { //Exception message when update fails resultMessage = "Error adding User. "; resultMessage = resultMessage = error.Message; } return(resultMessage); }