/// 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
/// 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(); } }
// 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(); } }
} // 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 }
protected void submitNewCategoryTime(object sender, EventArgs e) { int catID; DateTime startDateTimeObject; DateTime endDateTimeObject; if (dropdownCategoryTypes.SelectedIndex == 0) { catMessageText.InnerHtml = "Please select a category"; } else if (catStartTime.Text == "") { catMessageText.InnerHtml = "Please enter a start time"; } else if (catEndTime.Text == "") { catMessageText.InnerHtml = "Please enter an end time"; } if ((catID = dropdownCategoryTypes.SelectedIndex) != -1) { catID = dropdownCategoryTypes.SelectedIndex; string startDate = catStartDate.Text + ' ' + catStartTime.Text; startDateTimeObject = Convert.ToDateTime(startDate); string endDate = catEndDate.Text + ' ' + catEndTime.Text; endDateTimeObject = Convert.ToDateTime(endDate); clsDataLayer dataLayer = new clsDataLayer(); dataLayer.InsertCategoryInstance(username, catID, startDateTimeObject, endDateTimeObject); } Response.Redirect("frmDashBoard.aspx"); }
// 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(); }
protected void Page_Load(object sender, EventArgs e) { startDate = DateTime.Today.ToString("yyyy/MM/dd"); connectionString = @"Server=" + SERVER + @";Database=" + DATABASE + @";Uid=" + UID + @";Pwd=" + PWD; DataLayer = new clsDataLayer(); username = Session["sessionUserID"].ToString(); usernameLabel.InnerText = username; // TODO: move code in to this method //GetCategoryTypes(); //loads categories clsDataLayer cls; if (!IsPostBack) { cls = new clsDataLayer(); dropdownCategoryTypes.DataSource = cls.GetCategoryTypes((string)Session["sessionUserID"]); dropdownCategoryTypes.DataTextField = "CatName"; dropdownCategoryTypes.DataValueField = "CatID"; dropdownCategoryTypes.DataBind(); dropdownCategoryTypes.Items.Insert(0, new ListItem("--Select Category--", "0")); getChartData(username); } else { } }
protected void cmdFind_Click(object sender, EventArgs e) { //creates a new data access layer object. clsDataLayer myDAL = new clsDataLayer(); dsAddress myAddressSet; //call the FindAddress method in the data access layer and store the results in myAddressSet. myAddressSet = (myDAL.FindAddress(Server.MapPath("~/App_Data/AddressBook.mdb"), Convert.ToInt32(txtAddressId.Text))); lblStatus.Text = string.Empty; //if the above operation returns a myAddressSet that is not null and contains a row then display the information in the forms textboxes. if (!(myAddressSet == null) && (myAddressSet.tblAddressBook.Rows.Count != 0)) { this.txtFirstName.Text = myAddressSet.tblAddressBook[0].FirstName.ToString(); this.txtLastName.Text = myAddressSet.tblAddressBook[0].LastName.ToString(); this.txtEmail.Text = myAddressSet.tblAddressBook[0].Email.ToString(); this.txtPhoneNumber.Text = myAddressSet.tblAddressBook[0].PhoneNumber.ToString(); Session.Add("ValidRecord", true); } else { //dislay a message in the status label that no record was found. lblStatus.Text = "No record was found"; Session.Add("ValidRecord", false); } BindGridView(); }
//Adds click event that calls Data Layer method InsertCustomer. protected void btnAddCustomer_Click(object sender, EventArgs e) { //Creates a boolean to false if the add customer creates an error bool customerAddError = false; //accesses Accounts.mdb database for the clsDataLayer string tempPath = Server.MapPath("Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); //Inserts Customer Information for all fields try { myDataLayer.InsertCustomer(txtUserName.Text, txtCity.Text, txtState.Text, txtLeastLanguage.Text, txtFavoriteLanguage.Text, txtDateCompleted.Text); } catch (Exception error) { customerAddError = true; string message = "Error adding customer, please check form data. "; Master.UserProgrammer.Text = message + error.Message; } if (!customerAddError) { ClearInputs(Page.Controls); Master.UserProgrammer.Text = "Customer Added Successfully"; } //Binds CustomerGridView() BindCustomerGridView(); }
protected void LnkBtnAdd_Click(object sender, EventArgs e) { clsDataLayer cls = new clsDataLayer(); cls.AddCategory(Session["sessionUserID"].ToString(), txbxCatName.Text, txbxCatDesc.Text); Response.Redirect("frmEditCategories.aspx"); }
protected void LnkBtnUpdate_Click(object sender, EventArgs e) { clsDataLayer cls = new clsDataLayer(); cls.UpdateCategory(Int32.Parse(Session["UpdateCatID"].ToString()), txbxCatName.Text, txbxCatDesc.Text, "T"); Response.Redirect("frmEditCategories.aspx"); }
protected void btnDeleteUser_Click(object sender, EventArgs e) { //Creates a boolean to false if the update creates an error bool customerDeleteError = false; //accesses Accounts.mdb database for the clsDataLayer string tempPath = Server.MapPath("Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); //Deletes User Name try { myDataLayer.DeleteInfo(txtUserName.Text, txtCity.Text, txtState.Text, txtLeastLanguage.Text, txtFavoriteLanguage.Text); } catch (Exception error) { customerDeleteError = true; string message = "Error deleting customer, please check form data. "; Master.UserProgrammer.Text = message + error.Message; } if (!customerDeleteError) { ClearInputs(Page.Controls); Master.UserProgrammer.Text = "Customer Deleted Successfully"; } }
} /* end Page_Load() */ protected void btnLogOut_Click(object sender, EventArgs e) { clsDataLayer c = new clsDataLayer(); c.signOut(); Response.Redirect("/Default.aspx"); }
protected void Page_Load(object sender, EventArgs e) { // instantiate objects for method access // clsDataLayer c = new clsDataLayer(); clsCustomers p = new clsCustomers(); if (Session["CustomerID"] == null) { Response.Redirect("~/Customers/CustomerLogin.aspx"); } /* end if() */ bool creditCardAdded; creditCardAdded = p.checkCCInfoAdded(Convert.ToInt32(Session["CustomerID"])); if (!creditCardAdded) { lblAddCCInfo.Text = "Please click on Account Details below and enter a credit card"; } if (Page.IsPostBack) { lblAddCCInfo.Visible = false; } } /* end Page_Load() */
protected void btmSubmit_Click(object sender, EventArgs e) { // instantiate clsDataLayer object for access to methods // clsDataLayer c = new clsDataLayer(); // check if form is posting back to Register page // if (IsPostBack) { lblRegistrationSuccess.Visible = true; } else { lblRegistrationSuccess.Visible = false; } /* end if (IsPostBack) */ if (c.customerLogin(txtEmail.Text, txtPassword.Text)) { int sessionID = c.getSessionID(txtEmail.Text); Session["CustomerID"] = sessionID; Response.Redirect("~/Customers/CustomerPortal.aspx"); } { // // lblLoginError.Text = "Incorrect username/password"; } } /* end btmSubmit_Click() */
public clsBusinessLayer(string serverMappedPath) { // NMeggos // Contructor init var\values // New instance of dl passing relation path to ms access asset. dataPath = serverMappedPath; myDataLayer = new clsDataLayer(path: String.Format("{0}Accounts.mdb", dataPath)); }
protected void lnkBtnDelete_Click(object sender, EventArgs e) { if (lstCategoryNames.SelectedIndex >= 0) { clsDataLayer cls = new clsDataLayer(); cls.DeleteCategory(Int32.Parse(lstCategoryNames.SelectedValue)); Response.Redirect("frmEditCategories.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { clsDataLayer cls = new clsDataLayer(); Tuple <int, String, String> catInfo = cls.GetCategoryDetails(Int32.Parse(Session["UpdateCatID"].ToString())); DataTable dt = cls.GetCategoryTypes(Session["sessionUserID"].ToString()); txbxCatName.Text = catInfo.Item2; txbxCatDesc.Text = catInfo.Item3; } }
protected void Page_Load(object sender, EventArgs e) { clsDataLayer cdl; if (!IsPostBack) { cdl = new clsDataLayer(); lstCategoryNames.DataSource = cdl.GetCategoryTypes((string)Session["sessionUserID"]); lstCategoryNames.DataTextField = "CatName"; lstCategoryNames.DataValueField = "CatID"; lstCategoryNames.DataBind(); } }
protected void btnAdd_Click(object sender, EventArgs e) { //instantiate new clsDataLayer object. clsDataLayer myDataLayer = new clsDataLayer(); //string to hold location of database. string TempPath = Server.MapPath("App_Data/AddressBook.mdb"); //call the method in clsDataLayer Object and pass in arguments from the text boxes on the form. myDataLayer.InsertAddress(TempPath, txtFirstName.Text, txtLastName.Text, txtPhoneNumber.Text, txtEmail.Text); //bind the grid view with the newly added information. BindGridView(); }
protected void cmdUpdate_Click(object sender, EventArgs e) { //create new data access layer object. clsDataLayer myDAL = new clsDataLayer(); //check the session state value for ValidRecord. If true call the UpdateAddress record which will update the record in the database. if (Convert.ToBoolean(Session["ValidRecord"])) { //call the Update Address method in myDAL clsDataLayer object. myDAL.UpdatAddress(Server.MapPath("~/App_Data/AddressBook.mdb"), Convert.ToInt32(txtAddressId.Text), txtFirstName.Text, txtLastName.Text, txtPhoneNumber.Text, txtEmail.Text); } BindGridView(); }
// btn click method to destroy user sessions // protected void btnLogOut_Click(object sender, EventArgs e) { // instantiate clsDataLayer object // clsDataLayer c = new clsDataLayer(); // run the signOut method to clear sessions // c.signOut(); //remove the logout button from navbar btnLogOut.Visible = false; lnkProfile.Visible = false; // redirect back to login page // Response.Redirect("~/Default.aspx"); }
}//end clearinputs //bind customer grid view private dsAccounts BindCustomerGridView() { string tempPath = Server.MapPath("~/App_Data/Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); dsAccounts customerListing = myBusinessLayer.SelectAllCustomers(); gvCustomerList.DataSource = customerListing.tblCustomers; //binding customer list griedview gvCustomerList.DataBind(); Cache.Insert("CustomerDataSet", customerListing); return customerListing; }
private dsAccounts BindCustomerGridView() { //accesses Accounts.mdb database for the clsDataLayer string tempPath = Server.MapPath("Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); //retrieve customer listings from data layer in GetAllCustomers() method dsAccounts customerListing = myDataLayer.GetAllCustomers(); //adds information from customerListing in tblCustomers to the grid view gvCustomerList.DataSource = customerListing.tblCustomers; //data binds gvCustomerList and inserts into the cache gvCustomerList.DataBind(); Cache.Insert("CustomerDataSet", customerListing); return(customerListing); }
private dsAccounts BindOrdersGridView() { // Pulls data from the database for use string tempPath = Server.MapPath("~/App_Data/Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // Adds data from the first to the second dsAccounts orderListing = myDataLayer.FillOrders(Username.Text); // Adds data from the first to the second gvCart.DataSource = orderListing.tblOrders; // Caches data collected gvCart.DataBind(); Cache.Insert("CustomerDataSet", orderListing); return orderListing; }
/// BindUserGrid method // binds gridview to data private dsProgramaholics BindUserGrid() { // path string tempPath = Server.MapPath("~/App_Data/Programaholics.mdb"); clsDataLayer myData = new clsDataLayer(tempPath); // get users dsProgramaholics userList = myData.GetAllUsers(); // fill gridview gvUsers.DataSource = userList.tblUserDetails; // bind gridview gvUsers.DataBind(); Cache.Insert("UserDataSet", userList); return(userList); }
private dsAccounts BindCartGridView() { // Pulls data from the database for use string tempPath = Server.MapPath("~/App_Data/Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // Adds data from the first to the second dsAccounts cartListing = myDataLayer.FillCart(lblCurrentCustomer.Text); // Adds data from the first to the second gvCart.DataSource = cartListing.tblCart; // Caches data collected gvCart.DataBind(); Cache.Insert("CustomerDataSet", cartListing); return(cartListing); }
private dsAccounts BindCustomerGridView() { // Pulls data from the database for use string tempPath = Server.MapPath("~/App_Data/Accounts.mdb"); clsDataLayer myDataLayer = new clsDataLayer(tempPath); // Adds data from the first to the second dsAccounts customerListing = myDataLayer.GetAllCustomers(); // Adds data from the first to the second gvCustomerList.DataSource = customerListing.tblCustomers; // Caches data collected gvCustomerList.DataBind(); Cache.Insert("CustomerDataSet", customerListing); return(customerListing); }
// Button with actions to find user's name (not legal name) protected void btnFind_Click(object sender, EventArgs e) { // Instance of object, dsAccounts dsAccounts dsFind; // My path is via App_Data. string tempPath = Server.MapPath("~/App_Data/Users.accdb"); clsDataLayer dataLayerObj = new clsDataLayer(tempPath); // Try-catch statement to check for user's info try { // Reference to the usernames dsFind = dataLayerObj.FindUser(Username.Text); // Another check to make sure data is present if (dsFind.tblUsers.Rows.Count > 0) { // The following variables should be there from the sample data txtUsername.Text = dsFind.tblUsers[0].Username; txtCity.Text = dsFind.tblUsers[0].City; txtState.Text = dsFind.tblUsers[0].State; txtFavLang.Text = dsFind.tblUsers[0].FavLang; txtWorstLang.Text = dsFind.tblUsers[0].WorstLang; txtLastProgram.Text = dsFind.tblUsers[0].LastProgram; // Default error text Master.UserFeedBack.Text = "Record Found"; } else { // Error text as a complement to above Master.UserFeedBack.Text = "No records were found!"; } } catch (Exception error) { // Hopefuly the stack can trace what went wrong. string message = "Something went wrong - "; Master.UserFeedBack.Text = message + error.Message; } }
protected void GetCategoryTypes() { if (!IsPostBack) { clsDataLayer cls = new clsDataLayer(); //DatacatInfo = cls.GetCategoryDetails( username); DataTable dt = cls.GetCategoryTypes(username); //dropdownCategoryTypes.Text = //ddlTeamLead.DataSource = cmd.ExecuteReader(); dropdownCategoryTypes.DataSource = dt; dropdownCategoryTypes.DataTextField = "TeamLead"; dropdownCategoryTypes.DataValueField = "TeamLead"; //dropdownCategoryTypes.DataBind(); //ddlTeamLead.DataBind(); } }
// find user by last name protected void btnFindUser_Click(object sender, EventArgs e) { dsProgramaholics dsFindLastName; // database path string tempPath = Server.MapPath("~/App_Data/dsProgramaholics.mdb"); clsDataLayer dataLayerObj = new clsDataLayer(tempPath); // try comparing try { dsFindLastName = dataLayerObj.FindUser(txtLastName.Text); // if matching record if (dsFindLastName.tblProgramaholics.Rows.Count > 0) { // fill with info txtFirstName.Text = dsFindLastName.tblProgramaholics[0].FName; txtLastName.Text = dsFindLastName.tblProgramaholics[0].LName; txtStreet.Text = dsFindLastName.tblProgramaholics[0].Street; txtCity.Text = dsFindLastName.tblProgramaholics[0].City; txtState.Text = dsFindLastName.tblProgramaholics[0].State; txtUsername.Text = dsFindLastName.tblProgramaholics[0].Email; txtPassword.Text = dsFindLastName.tblProgramaholics[0].Password; txtFavLanguage.Text = dsFindLastName.tblProgramaholics[0].FavLang; txtLeastFavLang.Text = dsFindLastName.tblProgramaholics[0].LeastFavLang; txtDateCompleted.Text = dsFindLastName.tblProgramaholics[0].DateComplete.ToString(); userID.Text = dsFindLastName.tblProgramaholics[0].ID.ToString(); Master.UserFeedBack.Text = "Record Found!"; }//end if else { Master.UserFeedBack.Text = "No Records Found!"; } //end else } // end try catch (Exception error) { // error message string message = "Something went wrong..."; Master.UserFeedBack.Text = message + " " + error.Message; }// end catch }