Example #1
0
        internal static bool UpdateWorkItem(IncomingWorkItem currentItem, RokonocontrolContext Context)
        {
            var dbVersion = Context.WorkItem.FirstOrDefault(x => x.Id == currentItem.WorkItemId);

            Context.Attach(dbVersion);
            var relationshipId = default(int);

            if (currentItem.SelectedChildren != null)
            {
                currentItem.SelectedChildren.ForEach(x => {
                    if (x.RelationShipId != null)
                    {
                        var relId   = int.Parse(x.RelationShipId);
                        var getItem = Context.WorkItemRelations.FirstOrDefault(y => y.Id == relId);
                        if (getItem.RelationName == "Parent")
                        {
                            relationshipId = getItem.Id;
                        }
                    }
                });
            }
            if (currentItem.FoundInBuild == null)
            {
                currentItem.FoundInBuild = "0";
            }
            if (currentItem.ResolvedInBuild == null)
            {
                currentItem.ResolvedInBuild = "0";
            }

            dbVersion.Title = currentItem.Title;
            if (currentItem.AssignedUser != 0)
            {
                dbVersion.AssignedAccount = currentItem.AssignedUser;
            }
            if (currentItem.WorktItemType != 0)
            {
                dbVersion.WorkItemTypeId = currentItem.WorktItemType;
            }
            if (!string.IsNullOrEmpty(currentItem.State))
            {
                dbVersion.StateId = int.Parse(currentItem.State);
            }
            if (!string.IsNullOrEmpty(currentItem.ItemReason))
            {
                dbVersion.Reason = int.Parse(currentItem.ItemReason);
            }
            if (!string.IsNullOrEmpty(currentItem.ItemIteration))
            {
                dbVersion.Iteration = int.Parse(currentItem.ItemIteration);
            }
            if (!string.IsNullOrEmpty(currentItem.ItemArea))
            {
                dbVersion.AreaId = int.Parse(currentItem.ItemArea);
            }

            if (!string.IsNullOrEmpty(currentItem.SystemDesignInfo))
            {
                dbVersion.SystemDesignInfo = currentItem.SystemDesignInfo;
            }


            if (currentItem.WorktItemType == 1)
            {
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    dbVersion.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.ItemActivity))
                {
                    dbVersion.Activity = int.Parse(currentItem.ItemActivity);
                }
                dbVersion.RepoSteps  = currentItem.RepoSteps;
                dbVersion.SystemInfo = currentItem.SystemInfo;
                if (!string.IsNullOrEmpty(currentItem.FoundInBuild))
                {
                    dbVersion.FoundInBuild = int.Parse(currentItem.FoundInBuild);
                }
                if (!string.IsNullOrEmpty(currentItem.ResolvedInBuild))
                {
                    dbVersion.IntegratedInBuild = int.Parse(currentItem.ResolvedInBuild);
                }
                dbVersion.Compleated     = currentItem.ItemCompleated;
                dbVersion.Remaining      = currentItem.ItemRemaining;
                dbVersion.OriginEstitame = currentItem.OriginalEstimate;
                if (!string.IsNullOrEmpty(currentItem.ItemSeverity))
                {
                    dbVersion.Severity = int.Parse(currentItem.ItemSeverity);
                }
                dbVersion.ParentId = relationshipId;
            }
            else if (currentItem.WorktItemType == 2)
            {
                dbVersion.AcceptanceCriteria = currentItem.AcceptanceCriteria;
                dbVersion.Description        = currentItem.Description;
                dbVersion.StartDate          = currentItem.StartDate == null ? DateTime.Now : currentItem.StartDate;
                dbVersion.EndDate            = currentItem.EndDate == null ? DateTime.Now : currentItem.EndDate;
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    dbVersion.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                dbVersion.Effort        = currentItem.Effort;
                dbVersion.BusinessValue = currentItem.BusinessValue;
                dbVersion.TimeCapacity  = currentItem.TimeCriticality;
                dbVersion.ValueAreaId   = int.Parse(currentItem.ValueAreId);
            }
            else if (currentItem.WorktItemType == 5)
            {
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    dbVersion.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.RiskId))
                {
                    dbVersion.RiskId = int.Parse(currentItem.RiskId);
                }
                dbVersion.Effort        = currentItem.Effort;
                dbVersion.BusinessValue = currentItem.BusinessValue;
                dbVersion.TimeCapacity  = currentItem.TimeCriticality;
                if (!string.IsNullOrEmpty(currentItem.ValueAreId))
                {
                    dbVersion.ValueAreaId = int.Parse(currentItem.ValueAreId);
                }
                dbVersion.StartDate = currentItem.StartDate == null ? DateTime.Now : currentItem.StartDate;
                dbVersion.EndDate   = currentItem.EndDate == null ? DateTime.Now : currentItem.EndDate;
                if (!string.IsNullOrEmpty(currentItem.Description))
                {
                    dbVersion.Description = currentItem.Description;
                }
            }
            else if (currentItem.WorktItemType == 6)
            {
                dbVersion.StackRank = currentItem.Rank;
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    dbVersion.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                dbVersion.DueDate = currentItem.DueDate == null ? DateTime.Now : currentItem.DueDate;
            }
            else if (currentItem.WorktItemType == 3)
            {
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    dbVersion.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.ItemActivity))
                {
                    dbVersion.Activity = int.Parse(currentItem.ItemActivity);
                }
                dbVersion.OriginEstitame = currentItem.OriginalEstimate;
                dbVersion.Remaining      = currentItem.ItemRemaining;
                dbVersion.Compleated     = currentItem.ItemCompleated;
                if (!string.IsNullOrEmpty(currentItem.ResolvedInBuild))
                {
                    dbVersion.IntegratedInBuild = int.Parse(currentItem.ResolvedInBuild);
                }
                dbVersion.Description = currentItem.Description;
            }
            else if (currentItem.WorktItemType == 7)
            {
                dbVersion.StoryPoints = currentItem.StoryPoints;
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    dbVersion.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.RiskId))
                {
                    dbVersion.RiskId = int.Parse(currentItem.RiskId);
                }
                if (!string.IsNullOrEmpty(currentItem.ValueAreId))
                {
                    dbVersion.ValueAreaId = int.Parse(currentItem.ValueAreId);
                }
                dbVersion.Description        = currentItem.Description;
                dbVersion.AcceptanceCriteria = currentItem.AcceptanceCriteria;
            }
            dbVersion.StartDate            = currentItem.StartDate.Ticks == 0 ? DateTime.Now : currentItem.StartDate;
            dbVersion.EndDate              = currentItem.EndDate.Ticks == 0 ? DateTime.Now : currentItem.EndDate;
            dbVersion.DueDate              = currentItem.DueDate.Ticks == 0 ? DateTime.Now : currentItem.DueDate;
            Context.Entry(dbVersion).State = EntityState.Modified;
            Context.SaveChanges();

            currentItem.SelectedChildren.ForEach(x => {
                if (x.RelationShipId != null)
                {
                    var relId = int.Parse(x.RelationShipId);

                    var getItem = Context.WorkItemRelations.FirstOrDefault(y => y.Id == relId);
                    if (getItem.RelationName != "Parent")
                    {
                        Context.AssociatedWrorkItemChildren.Add(new AssociatedWrorkItemChildren {
                            WorkItemChildId = x.WorkItemId,
                            WorkItemId      = currentItem.WorkItemId,
                            RelationType    = relId
                        });
                        Context.SaveChanges();
                    }
                    else
                    {
                        var dbItem      = Context.WorkItem.FirstOrDefault(y => y.Id == x.WorkItemId);
                        dbItem.ParentId = currentItem.WorkItemId;
                        Context.Attach(dbItem);
                        Context.Update(dbItem);
                        Context.SaveChanges();
                    }
                }
            });
            var notification = Context.Notifications.Add(new Notifications {
                DateOfMessage      = DateTime.Now,
                Content            = $"Work Item  Title:{dbVersion.Title} ID:{dbVersion.Id}- Has been updated",
                NotificationType   = 4,
                WorkItemRelationid = currentItem.WorkItemId
            });

            Context.SaveChanges();
            var projectUsers = Context.AssociatedProjectMembers.Where(x => x.ProjectId == currentItem.ProjectId).ToList();

            //Todo: Thows duplicate error, database mapping should be reworked to allow cross project notification based on user view
            projectUsers.ForEach(x => {
                Context.AssociatedProjectNotifications.Add(new AssociatedProjectNotifications {
                    NotificationId  = notification.Entity.Id,
                    ProjectId       = currentItem.ProjectId,
                    NewNotification = 1,
                    IsRead          = 0,
                    UserAccountId   = x.UserAccountId
                });
                Context.SaveChanges();
            });
            var prevList = Context.AssociatedWorkItemFiles.Where(x => x.WorkItemId == dbVersion.Id).ToList();

            Context.RemoveRange(prevList);
            Context.SaveChanges();
            if (currentItem.SelectedFiles != null)
            {
                currentItem.SelectedFiles.ForEach(x => {
                    var fileId = default(int);
                    if (Context.SystemFiles.FirstOrDefault(y => y.FileLocation == x) == null)
                    {
                        var fileType = FileProcessor.GetImageType(x);

                        var files = Context.SystemFiles.Add(new SystemFiles {
                            DateOfMessage = DateTime.Now,
                            FileLocation  = x,
                            FileType      = fileType == "" ? 2 : 1,
                            SenderName    = "System"
                        });
                        Context.SaveChanges();
                        fileId = files.Entity.Id;
                    }
                    else
                    {
                        var file = Context.SystemFiles.FirstOrDefault(y => y.FileLocation == x);
                        fileId   = file.Id;
                    }

                    Context.AssociatedWorkItemFiles.Add(new AssociatedWorkItemFiles {
                        FileId     = fileId,
                        WorkItemId = dbVersion.Id
                    });
                    Context.SaveChanges();
                });
            }
            return(true);
        }
Example #2
0
        public static WorkItem AddNewWorkItem(IncomingWorkItem currentItem, RokonocontrolContext Context, IConfiguration configuration, int userId)
        {
            var currentUser = "******";

            var relationshipId = default(int);

            currentItem.SelectedChildren.ForEach(x => {
                var relId   = int.Parse(x.RelationShipId);
                var getItem = Context.WorkItemRelations.FirstOrDefault(y => y.Id == relId);
                if (getItem.RelationName == "Parent")
                {
                    relationshipId = getItem.Id;
                }
            });
            if (currentItem.FoundInBuild == null)
            {
                currentItem.FoundInBuild = "0";
            }
            if (currentItem.ResolvedInBuild == null)
            {
                currentItem.ResolvedInBuild = "0";
            }

            var databaseItem = new WorkItem();

            databaseItem.Title = currentItem.Title;
            if (currentItem.AssignedUser != 0)
            {
                var userData = Context.UserAccounts.FirstOrDefault(x => x.Id == currentItem.AssignedUser);
                databaseItem.AssignedAccount = currentItem.AssignedUser;
                currentUser = $"{userData.FirstName} {userData.LastName}";
            }

            if (!string.IsNullOrEmpty(currentItem.SystemDesignInfo))
            {
                databaseItem.SystemDesignInfo = currentItem.SystemDesignInfo;
            }


            if (currentItem.WorktItemType != 0)
            {
                databaseItem.WorkItemTypeId = currentItem.WorktItemType;
            }
            if (!string.IsNullOrEmpty(currentItem.State))
            {
                databaseItem.StateId = int.Parse(currentItem.State);
            }
            if (!string.IsNullOrEmpty(currentItem.ItemReason))
            {
                databaseItem.Reason = int.Parse(currentItem.ItemReason);
            }
            if (!string.IsNullOrEmpty(currentItem.ItemIteration))
            {
                databaseItem.Iteration = int.Parse(currentItem.ItemIteration);
            }
            if (!string.IsNullOrEmpty(currentItem.ItemArea))
            {
                databaseItem.AreaId = int.Parse(currentItem.ItemArea);
            }



            if (currentItem.WorktItemType == 1)
            {
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    databaseItem.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.ItemActivity))
                {
                    databaseItem.Activity = int.Parse(currentItem.ItemActivity);
                }
                databaseItem.RepoSteps  = currentItem.RepoSteps;
                databaseItem.SystemInfo = currentItem.SystemInfo;
                if (!string.IsNullOrEmpty(currentItem.FoundInBuild))
                {
                    databaseItem.FoundInBuild = int.Parse(currentItem.FoundInBuild);
                }
                if (!string.IsNullOrEmpty(currentItem.ResolvedInBuild))
                {
                    databaseItem.IntegratedInBuild = int.Parse(currentItem.ResolvedInBuild);
                }
                databaseItem.Compleated     = currentItem.ItemCompleated;
                databaseItem.Remaining      = currentItem.ItemRemaining;
                databaseItem.OriginEstitame = currentItem.OriginalEstimate;
                if (!string.IsNullOrEmpty(currentItem.ItemSeverity))
                {
                    databaseItem.Severity = int.Parse(currentItem.ItemSeverity);
                }
                databaseItem.ParentId = relationshipId;
            }
            else if (currentItem.WorktItemType == 2)
            {
                databaseItem.AcceptanceCriteria = currentItem.AcceptanceCriteria;
                databaseItem.Description        = currentItem.Description;
                databaseItem.StartDate          = currentItem.StartDate == null ? DateTime.Now : currentItem.StartDate;
                databaseItem.EndDate            = currentItem.EndDate == null ? DateTime.Now : currentItem.EndDate;
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    databaseItem.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                databaseItem.Effort        = currentItem.Effort;
                databaseItem.BusinessValue = currentItem.BusinessValue;
                databaseItem.TimeCapacity  = currentItem.TimeCriticality;
                databaseItem.ValueAreaId   = int.Parse(currentItem.ValueAreId);
            }
            else if (currentItem.WorktItemType == 5)
            {
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    databaseItem.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.RiskId))
                {
                    databaseItem.RiskId = int.Parse(currentItem.RiskId);
                }
                databaseItem.Effort        = currentItem.Effort;
                databaseItem.BusinessValue = currentItem.BusinessValue;
                databaseItem.TimeCapacity  = currentItem.TimeCriticality;
                if (!string.IsNullOrEmpty(currentItem.ValueAreId))
                {
                    databaseItem.ValueAreaId = int.Parse(currentItem.ValueAreId);
                }
                databaseItem.StartDate = currentItem.StartDate == null ? DateTime.Now : currentItem.StartDate;
                databaseItem.EndDate   = currentItem.EndDate == null ? DateTime.Now : currentItem.EndDate;
                if (!string.IsNullOrEmpty(currentItem.Description))
                {
                    databaseItem.Description = currentItem.Description;
                }
            }
            else if (currentItem.WorktItemType == 6)
            {
                databaseItem.StackRank = currentItem.Rank;
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    databaseItem.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                databaseItem.DueDate = currentItem.DueDate == null ? DateTime.Now : currentItem.DueDate;;
            }
            else if (currentItem.WorktItemType == 3)
            {
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    databaseItem.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.ItemActivity))
                {
                    databaseItem.Activity = int.Parse(currentItem.ItemActivity);
                }
                databaseItem.OriginEstitame = currentItem.OriginalEstimate;
                databaseItem.Remaining      = currentItem.ItemRemaining;
                databaseItem.Compleated     = currentItem.ItemCompleated;
                if (!string.IsNullOrEmpty(currentItem.ResolvedInBuild))
                {
                    databaseItem.IntegratedInBuild = int.Parse(currentItem.ResolvedInBuild);
                }
                databaseItem.Description = currentItem.Description;
            }
            else if (currentItem.WorktItemType == 7)
            {
                databaseItem.StoryPoints = currentItem.StoryPoints;
                if (!string.IsNullOrEmpty(currentItem.ItemPriority))
                {
                    databaseItem.PriorityId = int.Parse(currentItem.ItemPriority);
                }
                if (!string.IsNullOrEmpty(currentItem.RiskId))
                {
                    databaseItem.RiskId = int.Parse(currentItem.RiskId);
                }
                if (!string.IsNullOrEmpty(currentItem.ValueAreId))
                {
                    databaseItem.ValueAreaId = int.Parse(currentItem.ValueAreId);
                }
                databaseItem.Description        = currentItem.Description;
                databaseItem.AcceptanceCriteria = currentItem.AcceptanceCriteria;
            }

            if (float.TryParse(databaseItem.Compleated, out var complete))
            {
                databaseItem.Remaining = "0";
                databaseItem.Remaining = "0";
            }
            databaseItem.StartDate = currentItem.StartDate.Ticks == 0 ? DateTime.Now : currentItem.StartDate;
            databaseItem.EndDate   = currentItem.EndDate.Ticks == 0 ? DateTime.Now : currentItem.EndDate;
            databaseItem.DueDate   = currentItem.DueDate.Ticks == 0 ? DateTime.Now : currentItem.DueDate;
            var item = Context.WorkItem.Add(databaseItem);

            Context.SaveChanges();
            //Associated with parent id in case its being added as a child of another item
            if (currentItem.ParentId != 0)
            {
                Context.AssociatedWrorkItemChildren.Add(new AssociatedWrorkItemChildren {
                    RelationType    = databaseItem.RelationId,
                    WorkItemId      = currentItem.ParentId,
                    WorkItemChildId = databaseItem.Id
                });
                Context.SaveChanges();
            }
            var pBoard = Context.AssociatedProjectBoards.Include(x => x.Board).FirstOrDefault(x => x.ProjectId == currentItem.ProjectId && x.Board.BoardName == "Open");

            if (pBoard != null)
            {
                Context.AssociatedBoardWorkItems.Add(new AssociatedBoardWorkItems {
                    BoardId    = pBoard.BoardId.Value,
                    WorkItemId = item.Entity.Id,
                    ProjectId  = currentItem.ProjectId
                });
                Context.SaveChanges();
            }
            if (relationshipId == default(int))
            {
                databaseItem.ParentId = item.Entity.Id;
                Context.Attach(item.Entity);
                Context.Entry(item.Entity).Property("ParentId").IsModified = true;
                Context.SaveChanges();
            }
            currentItem.SelectedChildren.ForEach(x => {
                var relId = int.Parse(x.RelationShipId);

                var getItem = Context.WorkItemRelations.FirstOrDefault(y => y.Id == relId);
                if (getItem.RelationName != "Parent")
                {
                    Context.AssociatedWrorkItemChildren.Add(new AssociatedWrorkItemChildren {
                        WorkItemChildId = x.WorkItemId,
                        WorkItemId      = item.Entity.Id,
                        RelationType    = relId
                    });
                    Context.SaveChanges();
                }
                else
                {
                    var dbItem           = Context.WorkItem.FirstOrDefault(y => y.Id == x.WorkItemId);
                    item.Entity.ParentId = dbItem.Id;
                    Context.Attach(item.Entity);
                    Context.Update(item.Entity);
                    Context.SaveChanges();
                }
            });

            var notification = Context.Notifications.Add(new Notifications {
                DateOfMessage      = DateTime.Now,
                Content            = $"Work Item  Title:{item.Entity.Title} ID:{item.Entity.Id}- Has been created and assigned to {currentUser}",
                NotificationType   = 3,
                WorkItemRelationid = currentItem.WorkItemId,
            });

            Context.SaveChanges();
            var projectUsers = Context.AssociatedProjectMembers.Where(x => x.ProjectId == currentItem.ProjectId).ToList();

            //Todo: Thows duplicate error, database mapping should be reworked to allow cross project notification based on user view
            projectUsers.ForEach(x => {
                Context.AssociatedProjectNotifications.Add(new AssociatedProjectNotifications {
                    NotificationId  = notification.Entity.Id,
                    ProjectId       = currentItem.ProjectId,
                    NewNotification = 1,
                    IsRead          = 0,
                    UserAccountId   = x.UserAccountId
                });
                Context.SaveChanges();
            });
            if (currentItem.SelectedFiles != null)
            {
                currentItem.SelectedFiles.ForEach(x => {
                    var fileType = FileProcessor.GetImageType(x);

                    var files = Context.SystemFiles.Add(new SystemFiles {
                        DateOfMessage = DateTime.Now,
                        FileLocation  = x,
                        FileType      = fileType == "" ? 2 : 1,
                        SenderName    = "System"
                    });

                    Context.SaveChanges();
                    Context.AssociatedWorkItemFiles.Add(new AssociatedWorkItemFiles {
                        FileId     = files.Entity.Id,
                        WorkItemId = item.Entity.Id
                    });
                    Context.SaveChanges();
                });
            }

            return(databaseItem);
        }
Example #3
0
        internal void UpdateUserAccount(IncomingUserAccountUpdate userData)
        {
            var userAccount = Context.UserAccounts.FirstOrDefault(x => x.Id == userData.Id);

            Context.Attach(userAccount);
            userAccount.Email = userData.Email;
            if (!string.IsNullOrEmpty(userData.Password))
            {
                // generate a 128-bit salt using a secure PRNG
                byte[] salt = new byte[128 / 8];
                using (var rng = RandomNumberGenerator.Create())
                {
                    rng.GetBytes(salt);
                }
                Console.WriteLine($"Salt: {Convert.ToBase64String(salt)}");

                // derive a 256-bit subkey (use HMACSHA1 with 10,000 iterations)
                string hashed = Convert.ToBase64String(KeyDerivation.Pbkdf2(
                                                           password: userData.Password,
                                                           salt: salt,
                                                           prf: KeyDerivationPrf.HMACSHA1,
                                                           iterationCount: 10000,
                                                           numBytesRequested: 256 / 8));
                userAccount.Salt     = Convert.ToBase64String(salt);
                userAccount.Password = hashed;
                Context.Entry(userAccount).Property("Password").IsModified = true;
                Context.Entry(userAccount).Property("Salt").IsModified     = true;
            }
            userAccount.FirstName = userData.FirstName;
            userAccount.LastName  = userData.LastName;
            Context.Update(userAccount);
            Context.SaveChanges();
            var rights         = default(UserRights);
            var getCommonRight = Context.UserRights.FirstOrDefault(x => x.ManageIterations == userData.Rights.IterationOptions &&
                                                                   x.ManageUserdays == userData.Rights.ScheduleManagement &&
                                                                   x.UpdateUserRights == userData.Rights.EditUserRights &&
                                                                   x.ViewOtherPeoplesWork == userData.Rights.ViewWorkItems &&
                                                                   x.WorkItemRule == userData.Rights.WorkItemOption &&
                                                                   x.ChatChannelsRule == userData.Rights.ChatChannels);

            if (getCommonRight != null)
            {
                rights = getCommonRight;
            }
            else
            {
                var newRights = Context.UserRights.Add(new UserRights {
                    ManageIterations     = Convert.ToInt16(userData.Rights.IterationOptions),
                    ManageUserdays       = Convert.ToInt16(userData.Rights.ScheduleManagement),
                    ChatChannelsRule     = Convert.ToInt16(userData.Rights.ChatChannels),
                    UpdateUserRights     = Convert.ToInt16(userData.Rights.EditUserRights),
                    ViewOtherPeoplesWork = Convert.ToInt16(userData.Rights.ViewWorkItems),
                    WorkItemRule         = Convert.ToInt16(userData.Rights.WorkItemOption)
                });
                rights = newRights.Entity;
                Context.SaveChanges();
            }

            Context.AssociatedProjectMemberRights.Add(new AssociatedProjectMemberRights {
                ProjectId     = userData.ProjectId,
                RightsId      = rights.Id,
                UserAccountId = userAccount.Id
            });
            Context.SaveChanges();
        }