} //end page_load protected void ShowGroupSelect(int userId) { groupMessage.Text = ""; GroupDa gda = new GroupDa(); //get users existing groups DataSet uds = gda.GetUserGroupsByUserId(userId); rptUserGroups.DataSource = uds.Tables[0].DefaultView; rptUserGroups.DataBind(); if (uds.Tables[0].Rows.Count == 0) { groupMessage.Text = "No Groups Assigned"; } //get groups DataSet gds = gda.GetGroups(); UserGroup.DataSource = gds.Tables[0].DefaultView; UserGroup.DataValueField = "GroupId"; UserGroup.DataTextField = "GroupName"; UserGroup.DataBind(); UserGroup.Items.Insert(0, new ListItem("")); SelectGroupTable.Visible = true; }
} //end page_load protected void ShowGroupSelect(int datasetId) { datasetMessage.Text = ""; GroupDatasetDa da = new GroupDatasetDa(); //get users existing groups DataSet ds = da.GetGroupsByDatasetId(datasetId); rptDatasetGroups.DataSource = ds.Tables[0].DefaultView; rptDatasetGroups.DataBind(); if (ds.Tables[0].Rows.Count == 0) { datasetMessage.Text = "No Groups Assigned"; } //get groups GroupDa gda = new GroupDa(); DataSet gds = gda.GetGroups(); Group.DataSource = gds.Tables[0].DefaultView; Group.DataValueField = "GroupId"; Group.DataTextField = "GroupName"; Group.DataBind(); Group.Items.Insert(0, new ListItem("")); SelectDatasetTable.Visible = true; }
/// <summary> /// Save tab names assigned to user group /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void UpdateCodesBtn_Click(object sender, CommandEventArgs e) { StringBuilder sb = new StringBuilder(); if (!SbGroup.SelectedValue.Equals("")) { for (int i = 0; i < TabCheckBoxList.Items.Count; i++) { if (TabCheckBoxList.Items[i].Selected) { if (sb.Length > 0) { sb.Append(","); } sb.Append(TabCheckBoxList.Items[i].Text); } } //update db GroupDa da = new GroupDa(); da.UpdateGroupAccessCode(int.Parse(SbGroup.SelectedValue), sb.ToString()); //refresh item in cache CacheManager.RefreshTabListCache(); } }
/// <summary> /// /// </summary> private void BuildUserGroups() { GroupDa gda = new GroupDa(); DataView groups = gda.GetGroups().Tables[0].DefaultView; GroupsRptr.DataSource = groups; GroupsRptr.DataBind(); GroupsCount.Text = groups.Count.ToString(); }
/// <summary> /// Creates list of tabs names that should be available to user based on the user group(s) /// </summary> /// <param name="datasetIdVal">datasetId</param> public string SetGroupViewCode(int datasetId, string userName) { UserDa uda = new UserDa(); DataSet uds = uda.GetByUserName(userName); //TODO: replace this with call to GetUserId and set output variable UserId int userId = int.Parse(uds.Tables[0].Rows[0][User.UserId].ToString()); GroupDa da = new GroupDa(); DataSet ds = da.GetGroupAccessCode(userId, datasetId); List <string> tabs = new List <string>(); foreach (DataRow row in ds.Tables[0].Rows) { foreach (string s in row[Group.GroupAccessCode].ToString().Split(',')) { if (!tabs.Contains(s)) { tabs.Add(s); } } } // TODO: merge tabs //StringBuilder sb = new StringBuilder(); // TODO: this ALWAYS RETURNS ONE COMMA Deliminated ROW. Don't need all of the below // user may be part of many groups and access to tabs must be cumulative /* * foreach (DataRow dr in ds.Tables[0].Rows) * { * sb.Append(dr[Group.GroupAccessCode].ToString()); * } * * string[] tabNameList = sb.ToString().Split(new Char[] { ',' }); * * string showTabs = ""; * * // now remove duplicates from list * * foreach (string s in tabNameList) * { * if (showTabs.IndexOf(s) == -1) * { * showTabs += s; * } * } */ // in v 4.1 this method moved to UserController for access by other pages. Session references removed. //Session[SessionKey.GroupViewCode] = showTabs; //string tabs = ds.Tables[0].Rows[0][Group.GroupAccessCode].ToString(); return(string.Join(",", tabs.ToArray())); }
protected void ShowGroupList() { RepeaterDiv.Visible = true; AddGroupTable.Visible = false; GroupDa gda = new GroupDa(); DataSet uds = gda.GetGroups(); rptGroups.DataSource = uds.Tables[0].DefaultView; rptGroups.DataBind(); }
public int GetTabCount(int datasetId, string userName) { // TODO: should just use SetGroupViewCode; parse the string array on the .aspx page so you can use the tab count; dont need this method UserDa uda = new UserDa(); DataSet uds = uda.GetByUserName(userName); //TODO: replace this with call to GetUserId and set output variable UserId int userId = int.Parse(uds.Tables[0].Rows[0][User.UserId].ToString()); GroupDa da = new GroupDa(); DataSet ds = da.GetGroupAccessCode(userId, datasetId); string tabs = ds.Tables[0].Rows[0][Group.GroupAccessCode].ToString(); string[] tabNameList = tabs.ToString().Split(new Char[] { ',' }); return(tabNameList.Length); }
override protected void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { //get groups GroupDa gda = new GroupDa(); DataSet gds = gda.GetGroups(); SbGroup.DataSource = gds.Tables[0].DefaultView; SbGroup.DataValueField = "GroupId"; SbGroup.DataTextField = "GroupName"; SbGroup.DataBind(); SbGroup.Items.Insert(0, new ListItem("")); } }
private void BuildUserGroups(int?userId) { GroupsList.Items.Clear(); if (userId.HasValue) { GroupDa da = new GroupDa(); DataView groupsList = da.GetGroupsByUser(userId.Value).DefaultView; groupsList.Sort = BOL.Group.GroupName + " ASC"; // build list of avialble groups // groupsList.RowFilter = BOL.UserGroup.UserGroupId + " IS NULL"; GroupsList.DataSource = groupsList; GroupsList.DataBind(); SetGroupCheckBox(GroupsList, groupsList.Table); // build list of current groups groupsList.RowFilter = BOL.UserGroup.UserGroupId + " IS NOT NULL"; UserGroupsPanel.Visible = true; CurrentUserGroupsRptr.DataSource = groupsList; CurrentUserGroupsRptr.DataBind(); BuildUserAttributes(userId.Value); AddUserGroupText.Visible = true; } else { DataView groupsList = BOL.BusinessObject.GetAllAsDataView <BOL.Group>(); groupsList.Sort = BOL.Group.GroupName + " ASC"; // build list of avialble groups GroupsList.DataSource = groupsList; GroupsList.DataBind(); // build list of current groups (empty) UserGroupsPanel.Visible = false; CurrentUserGroupsRptr.DataSource = null; CurrentUserGroupsRptr.DataBind(); AddUserGroupText.Visible = false; } }
protected void DeleteButtonClick(object sender, CommandEventArgs e) { RepeaterDiv.Visible = false; GroupDa groupDa = new GroupDa(); int groupId = int.Parse(e.CommandName); DataSet ds = groupDa.GetUsersInGroup(groupId); string numberOfUsers = ""; if (ds.Tables[0].Rows.Count > 0) { numberOfUsers = ds.Tables[0].Rows[0]["UserCount"].ToString(); valMsg.Text = "There are " + numberOfUsers + " users associated with this group. Are you sure you want to delete it?"; } else { valMsg.Text = "There are currently no users associated with this group. Confirm delete?"; } valMsg.Text += "<br><br><a href=\"AdminGroups.aspx?delete=yes&groupId=" + groupId + "\">Yes</a> <a href=\"AdminGroups.aspx\">No</a>"; }
protected override void Page_Load(object sender, EventArgs e) { // validate GROUP access string userName = new Security.SecurityController().GetUserName(); GroupDa da = new GroupDa(); var userGroupNames = da.GetUserGroups(userName).Tables[0].AsEnumerable().Select(r => r[BOL.Group.GroupName].ToString()); // if user is not in special group, end response if (RESTRICTED_GROUPS.Intersect(userGroupNames).Count() == 0) { Page.Visible = false; Response.End(); } base.Page_Load(sender, e); base.EnableViewState = true; if (!Page.IsPostBack) { // default dates FromDate.Text = DateTime.Today.AddMonths(-1).ToShortDateString(); ToDate.Text = DateTime.Today.ToShortDateString(); } }
protected void EditButtonClick(object sender, CommandEventArgs e) { RepeaterDiv.Visible = false; AddGroupTable.Visible = true; UpdateBtn.Visible = true; AddBtn.Visible = false; this.PopulateRolesSelect(); GroupDa groupDa = new GroupDa(); int groupId = int.Parse(e.CommandName); DataSet ds = groupDa.GetGroupsRecord(groupId); if (ds.Tables[0].Rows.Count > 0) { GroupId.Value = groupId.ToString(); GroupName.Value = ds.Tables[0].Rows[0][Group.GroupName].ToString(); GroupDesc.Value = ds.Tables[0].Rows[0][Group.GroupDescription].ToString(); GroupRole.Value = ds.Tables[0].Rows[0][Group.RoleId].ToString(); } //this.Page_Load(sender, (System.EventArgs)e); }