public bool UpdateWorkItem([FromBody] IncomingWorkItem currentItem)
{
var result = default(bool);
using (var context = new WorkItemsContext(Context, Configuration))
{
result = context.UpdateWorkItem(currentItem);
}
return(result);
}
public List <AssociatedWorkItemMessages> GetWorkItemDiscussions([FromBody] IncomingWorkItem request)
{
var result = new List <AssociatedWorkItemMessages>();
using (var context = new WorkItemsContext(Context, Configuration))
{
result = context.GetWorkItemDiscussions(request.ProjectId, request.WorkItemId);
}
return(result);
}
public OutgoingJsonData StageWorkItem([FromBody] IncomingWorkItem currentItem)
{
var result = new OutgoingJsonData {
Data = ""
};
using (var context = new WorkItemsContext(Context, Configuration))
{
result = context.AddNewWorkItem(currentItem, UserId);
}
return(result);
}
public bool StageWorkItem([FromBody] IncomingWorkItem currentItem)
{
var result = default(bool);
var currentUser = this.User;
var id = int.Parse(currentUser.Claims.ElementAt(1).Value);
using (var context = new DatabaseController(Context, Configuration))
{
result = context.AddNewWorkItem(currentItem, id);
}
return(result);
}
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);
}
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);
}
public static bool AddNewWorkItem(IncomingWorkItem currentItem, RokonoControlContext Context, IConfiguration configuration, int userId)
{
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)
{
databaseItem.AssignedAccount = currentItem.AssignedUser;
}
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;
}
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();
}
});
if (currentItem.AssignedUser != 0)
{
var projectName = Context.Projects.FirstOrDefault(X => X.Id == currentItem.ProjectId).ProjectName;
var getCurrentCreator = Context.UserAccounts.FirstOrDefault(x => x.Id == currentItem.AssignedUser);
using (var notificationHandler = new NotificationHandler(configuration))
{
notificationHandler.GenerateNewWorkItemNotification(item.Entity, getCurrentCreator, projectName);
}
}
return(true);
}
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);
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";
}
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 (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 => {
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();
}
});
return(true);
}
