public RoleResult Save(UserRole userRole, BORoleRightXCollection roleRights)
        {
            try
            {
                if (userRole == null)
                {
                    return RoleResult.Failed;
                }
                else
                {
                    if (userRole.RoleId == SQLPersistent.NULL_INT64)
                    {
                        // Create Role
                        if (UserRole.GetByName(userRole.RoleName) != null)
                            return RoleResult.NameAlreadyExists;

                        BORole role = new BORole();
                        role.Name = userRole.RoleName;
                        role.RoleType = new BORoleType(userRole.RoleTypeId);
                        role.Description = userRole.Description;
                        role.Save();

                        UserRole newUserRole = UserRole.GetByName(userRole.RoleName);
                        if (newUserRole == null)
                        {
                            return RoleResult.Failed;
                        }
                        userRole = newUserRole;
                    }
                    UserRole.UserRoleResult userRoleResult = userRole.Save(roleRights);
                    switch (userRoleResult)
                    {
                        case UserRole.UserRoleResult.Success:
                            return RoleResult.Success;
                        case UserRole.UserRoleResult.NameAlreadyExists:
                            return RoleResult.NameAlreadyExists;
                        case UserRole.UserRoleResult.FailedToUpdateRights:
                            return RoleResult.FailedToUpdateRights;
                        default:
                            return RoleResult.Failed;
                    }
                }
            }
            catch (Exception ex)
            {
                logger.ErrorException("Failed to update Role.", ex);
                return RoleResult.Failed;
            }
        }
Ejemplo n.º 2
0
        public void MergeRoleRights(BORoleRightXCollection roleRights)
        {
            //Save Existing.
            foreach (BORoleRightX newRoleRight in roleRights)
            {
                bool saved = false;
                foreach (BORoleRightX roleRight in RoleRights)
                {
                    if (roleRight.Right.ID == newRoleRight.Right.ID && !saved)
                    {
                        roleRight.CanCreate = newRoleRight.CanCreate;
                        roleRight.CanDelete = newRoleRight.CanDelete;
                        roleRight.CanExecute = newRoleRight.CanExecute;
                        roleRight.CanRead = newRoleRight.CanRead;
                        roleRight.CanUpdate = newRoleRight.CanUpdate;
                        roleRight.Save();
                        saved = true;
                        break;
                    }
                }
                if (!saved)
                {
                    BORoleRightX roleRight = new BORoleRightX();
                    roleRight.Role = newRoleRight.Role;
                    roleRight.Right = newRoleRight.Right;
                    roleRight.CanCreate = newRoleRight.CanCreate;
                    roleRight.CanDelete = newRoleRight.CanDelete;
                    roleRight.CanExecute = newRoleRight.CanExecute;
                    roleRight.CanRead = newRoleRight.CanRead;
                    roleRight.CanUpdate = newRoleRight.CanUpdate;
                    roleRight.Save();
                }

            }
            //Remove not existing
            foreach (BORoleRightX roleRight in RoleRights)
            {
                bool exists = false;
                foreach (BORoleRightX newRoleRight in roleRights)
                {
                    if (roleRight.Right.ID == newRoleRight.Right.ID)
                    {
                        exists = true;
                        break;
                    }
                }
                if (!exists)
                    roleRight.Delete();
            }
        }
Ejemplo n.º 3
0
        public UserRoleResult Save(BORoleRightXCollection roleRights)
        {
            //Does this role already Exist
            UserRole roleByName = GetByName(this.RoleName);
            //Does the role match the one that is being modified
            if (roleByName != null && roleByName.RoleId != SQLPersistent.NULL_INT64 && roleByName.RoleId != this.RoleId)
            {
                //Role exists, do not modify.  It is a different role.
                return UserRoleResult.NameAlreadyExists;
            }
            else if (roleByName == null || roleByName != null && roleByName.RoleId != SQLPersistent.NULL_INT64 && roleByName.RoleId == this.RoleId)
            {
                //Same Role, update it
                if (!BORoleRightX.UpdateRole(this.RoleId, this.RoleName, this.Description))
                    return UserRoleResult.Fail;
                //Update Rights for the role
                try
                {
                    if (roleRights != null)
                        this.MergeRoleRights(roleRights);
                    return UserRoleResult.Success;
                }
                catch (Exception ex)
                {
                    logger.ErrorException("Failed to update Role Rights", ex);
                    return UserRoleResult.FailedToUpdateRights;
                }

            }
            else
                return UserRoleResult.Fail;
        }
        public static BORoleRightXCollection GetByRole(string roleId)
        {
            BORoleRightXCollection collection = new BORoleRightXCollection();
            SqlConnection con = new SqlConnection(BOBase.GetConnectionString());

            con.Open();

            try
            {
                SqlCommand cmd = new SqlCommand("P_RoleRightX_GetByRole", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SQLPersistent.SetVarCharParameter(cmd.Parameters, "@RORI_ROLGUID", 50, roleId, false);
                SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult);

                try
                {
                    while (rdr.Read())
                    {
                        collection.Add(new BORoleRightX(rdr));
                    }
                }
                catch (Exception ex)
                {
                    logger.ErrorException("Failed to fetch record", ex);
                    return null;
                }
                finally
                {
                    rdr.Close();
                }
            }
            finally
            {
                con.Close();
            }
            return collection;
        }