private void PageDataRefresh() { string uEmail = txtEmail.Text.ToString(); string uPhone = txtPhoneNumber.Text.ToString(); string uUsername = txtUserName.Text.ToString(); string rRoleID = txtRoleID.Text.ToString(); string rName = txtName.Text.ToString(); UsersAndRolesTableAdapter userRolesAdapter = new UsersAndRolesTableAdapter(); LvUserList.DataSource = userRolesAdapter.GetUsersRolesByParameters(uEmail, uPhone, uUsername, rRoleID, rName); LvUserList.DataBind(); }
protected void FvUserView_ItemUpdating(object sender, FormViewUpdateEventArgs e) { // Code versions of all controls TextBox Email_txt = (TextBox)FvUserView.FindControl("txtEmail"); TextBox PhoneNumber_txt = (TextBox)FvUserView.FindControl("txtPhoneNumber"); TextBox UserName_txt = (TextBox)FvUserView.FindControl("txtUserName"); CheckBoxList Roles_cbl = (CheckBoxList)FvUserView.FindControl("CblRoles"); string email = Email_txt.Text; string phoneNumber = PhoneNumber_txt.Text; string userName = UserName_txt.Text; UsersAndRolesTableAdapter userAdapter = new UsersAndRolesTableAdapter(); try { string originalID = Request.QueryString["id"].ToString(); // Conduct Update userAdapter.UpdateRecord(email, phoneNumber, userName, originalID); // Update CheckBoxList on all items. foreach (ListItem item in Roles_cbl.Items) { if (item.Selected) { userAdapter.InsertUserRoleLink(originalID, item.Value); } else { userAdapter.DeleteUserRoleLink(originalID, item.Value); } } //Response.Write("<script LANGUAGE='JavaScript' >alert('Record Edited')</script>"); ClientScript.RegisterStartupScript(GetType(), "text", "AlertTimeout();", true); // Return to Read Only mode FvUserView.ChangeMode(FormViewMode.ReadOnly); PageDataRefresh(); } catch (System.Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('An ERROR (" + ex.Message + ") occurred connecting to the database.')</script>"); } }
private void PageDataRefresh() { string uID = Request.QueryString["id"]; if (uID == null || uID == "0") { Response.Redirect("~/Admin/RegisterUser.aspx"); } /* *********** Configure DAL *********** */ UsersAndRolesTableAdapter userAdapter = new UsersAndRolesTableAdapter(); FvUserView.DataSource = userAdapter.GetUserByID(uID); FvUserView.DataBind(); CheckBoxList Roles_cbl = (CheckBoxList)FvUserView.FindControl("CblRoles"); RolesTableAdapter roleAdapter = new RolesTableAdapter(); Roles_cbl.DataSource = roleAdapter.GetData(); Roles_cbl.DataValueField = "RoleID"; Roles_cbl.DataTextField = "Name"; Roles_cbl.DataBind(); UserRolesTableAdapter userRolesAdapter = new UserRolesTableAdapter(); int RoleCount = (int)userRolesAdapter.CountRolesByUserID(uID); if (RoleCount > 0) { DataTable Roles = userRolesAdapter.GetUserRolesByID(uID).CopyToDataTable(); foreach (DataRow row in Roles.Rows) { for (int i = 0; i < Roles_cbl.Items.Count; i++) { if (Roles.Rows[Roles.Rows.IndexOf(row)]["Name"].ToString() == Roles_cbl.Items[i].Text.ToString()) { Roles_cbl.Items[i].Selected = true; } } } } }
/* ************************************* * ****** DDL Refresh Subroutines ******* * ************************************* */ private void DdlUserRefresh(string UserValue = "", int UserIndex = 0) { UsersAndRolesTableAdapter userAdapter = new UsersAndRolesTableAdapter(); DropDownList ddlUser = (DropDownList)FvDriverView.FindControl("ddlUser"); ddlUser.DataSource = userAdapter.GetUsersNotDrivers(UserValue); ddlUser.DataValueField = "UserID"; ddlUser.DataTextField = "UserName"; if (UserValue == "" || UserValue == null) { ddlUser.SelectedIndex = UserIndex; } else { ddlUser.SelectedValue = UserValue; } ddlUser.DataBind(); }