public WorkItemEntity AddWorkItem(WorkItemEntity workItem) { WorkItem l_workItem = new WorkItem(); l_workItem.Title = workItem.Title; l_workItem.StatusId = workItem.StatusId; l_workItem.ProjectId = workItem.ProjectId; l_workItem.WorkItemTypeId = workItem.WorkItemTypeId; l_workItem.AssignTo = workItem.AssignTo; l_workItem.Description = workItem.Description; l_workItem.EstimateTime = workItem.EstimateTime; l_workItem.ActualTime = workItem.ActualTime; l_workItem.Priority = workItem.Priority; l_workItem.WorkItemGroupId = workItem.WorkItemGroupId; ChangeHistory history = new ChangeHistory(); history.ActualTime = workItem.ActualTime; history.AssignTo = workItem.AssignTo; history.ChangeTime = DateTime.Now; history.EstimateTime = workItem.EstimateTime; history.Priority = workItem.Priority; history.ProjectId = workItem.ProjectId; history.StatusId = workItem.StatusId; history.Title = workItem.Title; history.WorkItemTypeId = workItem.WorkItemTypeId; l_workItem.ChangeHistories.Add(history); dataContext.WorkItems.Add(l_workItem); dataContext.SaveChanges(); return workItem; }
public IEnumerable<WorkItemEntity> GetAll() { List<WorkItemEntity> workItems = new List<WorkItemEntity>(); foreach (var item in dataContext.WorkItems.OrderBy(c => c.Priority)) { WorkItemEntity workItem = new WorkItemEntity(); workItem.WorkItemId = item.WorkItemId; workItem.WorkItemTypeId = item.WorkItemTypeId; workItem.Title = item.Title; workItem.Description = item.Description; workItem.Priority = item.Priority; workItem.AssignTo = item.AssignTo; workItem.StatusId = item.StatusId; workItem.ProjectId = item.ProjectId; workItem.EstimateTime = item.EstimateTime; workItem.ActualTime = item.ActualTime; workItem.WorkItemGroupId = item.WorkItemGroupId; workItem.User = workItem.AssignTo.HasValue ? new UserRepository().GetUserById(workItem.AssignTo.Value) : null; workItem.WorkItemType = new WorkItemTypeRepository().GetWorkItemTypeById(workItem.WorkItemTypeId); workItem.WorkItemGroup = new WorkItemGroupRepository().GetWorkItemGroupById(workItem.WorkItemGroupId); workItem.Status = new StatusRepository().GetStatusById(workItem.StatusId); workItem.Project = new ProjectRepositiory().GetProjectById(workItem.ProjectId); workItem.ChangeHistories = new ChangesetHistoryRepository().GetChangesetByWorkItemId(item.WorkItemId).ToList(); workItems.Add(workItem); } return workItems; }
public WorkItemEntity GetWorkItemById(int id) { var data = dataContext.WorkItems.FirstOrDefault(w => w.WorkItemId == id); if (data != null) { WorkItemEntity workItem = new WorkItemEntity(); workItem.WorkItemId = data.WorkItemId; workItem.WorkItemTypeId = data.WorkItemTypeId; workItem.Title = data.Title; workItem.Description = data.Description; workItem.Priority = data.Priority; workItem.AssignTo = data.AssignTo; workItem.StatusId = data.StatusId; workItem.ProjectId = data.ProjectId; workItem.EstimateTime = data.EstimateTime; workItem.ActualTime = data.ActualTime; workItem.WorkItemGroupId = data.WorkItemGroupId; workItem.User = workItem.AssignTo.HasValue ? new UserRepository().GetUserById(data.AssignTo.Value) : null; workItem.WorkItemType = new WorkItemTypeRepository().GetWorkItemTypeById(data.WorkItemTypeId); workItem.WorkItemGroup = new WorkItemGroupRepository().GetWorkItemGroupById(data.WorkItemGroupId); workItem.Status = new StatusRepository().GetStatusById(data.StatusId); workItem.Project = new ProjectRepositiory().GetProjectById(data.ProjectId); return workItem; } return null; }
public WorkItemEntity AddWorkItem(WorkItemEntity workItem) { WorkItem l_workItem = new WorkItem(); l_workItem.Title = workItem.Title; l_workItem.StatusId = workItem.StatusId; l_workItem.ProjectId = workItem.ProjectId; l_workItem.WorkItemTypeId = workItem.WorkItemTypeId; l_workItem.AssignTo = workItem.AssignTo; l_workItem.Description = workItem.Description; l_workItem.EstimateTime = workItem.EstimateTime; l_workItem.ActualTime = workItem.ActualTime; l_workItem.Priority = workItem.Priority; l_workItem.WorkItemGroupId = workItem.WorkItemGroupId; dataContext.WorkItems.Add(l_workItem); dataContext.SaveChanges(); return workItem; }
// POST api/WorkItem public HttpResponseMessage PostWorkItem(WorkItemEntity workitem) { if (!ModelState.IsValid) { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } if (workitem == null) { return Request.CreateResponse(HttpStatusCode.BadRequest); } try { dbContext.AddWorkItem(workitem); } catch (DbUpdateConcurrencyException ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } return Request.CreateResponse(HttpStatusCode.OK); }
public bool UpdateWorkItem(WorkItemEntity workItem) { var l_workItem = dataContext.WorkItems.FirstOrDefault(c => c.WorkItemId == workItem.WorkItemId); if(l_workItem != null) { l_workItem.Title = workItem.Title; l_workItem.StatusId = workItem.StatusId; l_workItem.ProjectId = workItem.ProjectId; l_workItem.WorkItemTypeId = workItem.WorkItemTypeId; l_workItem.AssignTo = workItem.AssignTo; l_workItem.Description = workItem.Description; l_workItem.EstimateTime = workItem.EstimateTime; l_workItem.ActualTime = workItem.ActualTime; l_workItem.Priority = workItem.Priority; l_workItem.WorkItemGroupId = workItem.WorkItemGroupId; ChangeHistory history = new ChangeHistory(); history.ActualTime = workItem.ActualTime; history.AssignTo = workItem.AssignTo; history.ChangeTime = DateTime.Now; history.EstimateTime = workItem.EstimateTime; history.Priority = workItem.Priority; history.ProjectId = workItem.ProjectId; history.StatusId = workItem.StatusId; history.Title = workItem.Title; history.WorkItemTypeId = workItem.WorkItemTypeId; l_workItem.ChangeHistories.Add(history); dataContext.Entry(l_workItem).State = EntityState.Modified; dataContext.SaveChanges(); return true; } return false; }
public List<WorkItemEntity> GetWorkItemsByWorkItemGroupId(int workItemGroupId) { List<WorkItemEntity> workItems = new List<WorkItemEntity>(); var items = dataContext.WorkItems.Where(c => c.WorkItemGroupId == workItemGroupId); if (items != null) { foreach (var item in items.OrderBy( c=> c.Priority)) { WorkItemEntity workItem = new WorkItemEntity(); workItem.WorkItemId = item.WorkItemId; workItem.WorkItemTypeId = item.WorkItemTypeId; workItem.Title = item.Title; workItem.Description = item.Description; workItem.Priority = item.Priority; workItem.AssignTo = item.AssignTo; workItem.StatusId = item.StatusId; workItem.ProjectId = item.ProjectId; workItem.EstimateTime = item.EstimateTime; workItem.ActualTime = item.ActualTime; workItem.WorkItemGroupId = item.WorkItemGroupId; workItem.User = workItem.AssignTo.HasValue ? new UserRepository().GetUserById(workItem.AssignTo.Value) : null; workItem.WorkItemType = new WorkItemTypeRepository().GetWorkItemTypeById(workItem.WorkItemTypeId); workItem.WorkItemGroup = new WorkItemGroupRepository().GetWorkItemGroupById(workItem.WorkItemGroupId); workItem.Status = new StatusRepository().GetStatusById(workItem.StatusId); workItem.Project = new ProjectRepositiory().GetProjectById(workItem.ProjectId); workItems.Add(workItem); } } return workItems; }