/* Get Group Users of selected */ public Entities.UserGroup GetUserSecurity(string userName) { if (!userName.ToLower().StartsWith("coned")) { userName = "******" + userName; } Entities.UserGroup userGroup = new Entities.UserGroup(); try { var dbUserGroup = JSSESecurityManager.GetUserSecurity(userName); if (dbUserGroup != null) { userGroup.User = new Entities.UserInfo(); userGroup.User.SecurityUserID = dbUserGroup.SecurityUser_ID; userGroup.User.User_ID = dbUserGroup.User_ID; int empId = 0; Int32.TryParse(dbUserGroup.EmptNo, out empId); userGroup.User.Emp_Id = empId; userGroup.User.FirstName = dbUserGroup.FirstName; userGroup.User.LastName = dbUserGroup.LastName; userGroup.User.FullName = dbUserGroup.LastName + " , " + dbUserGroup.FirstName; userGroup.User.Email = dbUserGroup.Email; userGroup.User.User_ID = dbUserGroup.User_ID; userGroup.User.Org_Id = dbUserGroup.Org_ID; userGroup.User.MajorGroup_Id = dbUserGroup.MajorGroup_ID; userGroup.User.Dept_Id = dbUserGroup.Dept_Id; userGroup.User.Section_Id = dbUserGroup.SectionId; List <Entities.Group> groups = new List <Entities.Group>(); foreach (var ugp in dbUserGroup.T_JSSE_Security_UserGroup) { Entities.Group group = new Entities.Group(); group.Group_ID = ugp.T_JSSE_Security_Group.SecurityGroup_ID; group.GroupName = ugp.T_JSSE_Security_Group.GroupName; group.GroupType = new Entities.GroupType() { Level_Id = ugp.T_JSSE_Security_Group.GroupLevel }; group.MajorGroup_Id = ugp.T_JSSE_Security_Group.MajorGroup_Id; group.Org_Id = ugp.T_JSSE_Security_Group.Org_Id; List <Entities.Permission> perms = new List <Entities.Permission>(); foreach (var dbPerm in ugp.T_JSSE_Security_Group.T_JSSE_Security_GroupPermission) { Entities.Permission perm = new Entities.Permission(); perm.Permission_ID = dbPerm.T_JSSE_Security_Permission.SecurityPermission_ID; perm.PermissionName = dbPerm.T_JSSE_Security_Permission.PermissionName; perms.Add(perm); } group.Permissions = perms.ToArray(); groups.Add(group); } userGroup.Groups = groups.ToArray(); } } catch { throw; } return(userGroup); }
public int AddUserToGroupByRequest(Entities.UserRequest request) { Entities.UserGroup group = new Entities.UserGroup(); group.User = request.User; group.Group = request.Group; //Add User to Group from Request try { JSSESecurityManager.AddUser(group); } catch (Exception ex) { //Check Data base Error to see if User Already member of Group, Then Remove Request if (ex.Message.IndexOf(JSSEConstants.USER_ALREADY_IN_GROUP) > 0) { RemoveUserRequest(request); } throw ex; }; RemoveUserRequest(request); var ccUsers = string.Empty; //Get Groups By Level Id (1 for admin 2 for Owner and 3 for user of JSSE) var ownerGroups = GetGroupsByLevel(2, request.Group.Org_Id, 0); //If Owner Group Exists, then Get Users Owner List in to Variable for Email if (ownerGroups.Count > 0) { int groupId = ownerGroups.FirstOrDefault().Group_ID; var ccUserList = GetGroupUsers(groupId).Select(x => x.User.Email); ccUsers = string.Join(",", ccUserList.ToArray()); } else { string userName = request.User.User_ID; ccUsers = GetUserInfo(userName).Email; } //Send Email notification to User and CC Owner string subject = string.Format(JSSEConstants.ACCESS_GRANT_TEXT, request.Group.GroupName);// "Access has been GRANTED to " + request.Group.GroupName + " Group."; StringBuilder sbBody = new StringBuilder(); sbBody.AppendLine(subject); sbBody.Append("<br/>"); sbBody.AppendLine(@"<b>Request Sent by: </b>"); sbBody.Append(request.User.FullName); sbBody.Append("<br/>"); sbBody.AppendLine(@"<b>Granted Access to: </b>"); sbBody.Append(request.Group.GroupName + " Group"); SendEmailNotification(sbBody.ToString(), request.User.Email, ccUsers, subject); return(1); }
public List <Entities.UserGroup> GetGroupUsers(int groupId) { List <Entities.UserGroup> uGrps = new List <Entities.UserGroup>(); try { var dbGroups = JSSESecurityManager.GetGroupUsers(groupId); foreach (var dbGrp in dbGroups) { Entities.UserGroup uGrp = new Entities.UserGroup(); uGrp.Group = new Entities.Group(); uGrp.User = new Entities.UserInfo(); uGrp.User.SecurityUserID = dbGrp.SecurityUser_ID; uGrp.User.User_ID = dbGrp.User_ID; int empId = 0; Int32.TryParse(dbGrp.EmptNo, out empId); uGrp.User.Emp_Id = empId; uGrp.User.CompanyId = dbGrp.CompanyCd; uGrp.User.FirstName = dbGrp.FirstName; uGrp.User.LastName = dbGrp.LastName; uGrp.User.FullName = dbGrp.LastName + " " + dbGrp.FirstName; uGrp.User.Email = dbGrp.Email; uGrp.ModifiedDate = dbGrp.ModifiedDate; uGrp.Group.Group_ID = dbGrp.SecurityGroup_ID; uGrp.Group.GroupName = dbGrp.GroupName; uGrp.Group.GroupType = new Entities.GroupType() { Level_Id = dbGrp.Level_ID, Level_Name = dbGrp.LevelName }; uGrp.Group.MajorGroup_Id = dbGrp.MajorGroup_Id; uGrp.Group.Org_Id = dbGrp.Org_Id; uGrps.Add(uGrp); } } catch { throw; } return(uGrps); }