public static BacklogViewModel GetBacklogViewModel(int productBacklogId)
{
using (var db = new ScrumApplicationDbContext())
{
var backlogModel = new BacklogViewModel();
backlogModel.Backlog = db.ProductBacklogs.FirstOrDefault
(x => x.ProductBacklogId == productBacklogId);
var existProject = new Project();
existProject = db.Projects.FirstOrDefault(x => x.ProjectId == backlogModel.Backlog.ProjectId);
backlogModel.ProjectEpics = EpicRepository.GetEpics(backlogModel.Backlog.ProjectId);
backlogModel.Epic.ProjectId = backlogModel.Backlog.ProjectId;
var query = from btm in db.BacklogToMembers
where btm.ProductBacklogId == backlogModel.Backlog.ProductBacklogId
select btm;
var teamMembers = new List <Member>();
var tquery = from member in db.Members
where member.TeamId == existProject.TeamId
select member;
teamMembers = tquery.ToList();
var unAssignedTeamMembers = new List <Member>();
unAssignedTeamMembers = teamMembers.ToList();
unAssignedTeamMembers = unAssignedTeamMembers.OrderBy(x => x.MemberId).ToList();
foreach (var btm in query.ToList())
{
var member = new MemberViewModel();
member.MemberId = btm.MemberId;
member.Name = btm.MemberName;
backlogModel.AssignedMembers.Add(member);
foreach (var tmember in teamMembers)
{
if (tmember.MemberId == member.MemberId)
{
unAssignedTeamMembers.Remove(tmember);
}
}
}
foreach (var umember in unAssignedTeamMembers)
{
var memberModel = new MemberViewModel();
memberModel.MemberId = umember.MemberId;
memberModel.Name = umember.Name;
backlogModel.UnAssignedMembers.Add(memberModel);
}
var cquery = from comment in db.Comments
where comment.ProductBacklogId == backlogModel.Backlog.ProductBacklogId
orderby comment.CommentId descending
select comment;
backlogModel.BacklogComments = cquery.ToList();
if (IsUserAssigned(backlogModel.Backlog.ProductBacklogId, null) == 1)
{
backlogModel.IsUserAssigned = true;
}
else
{
backlogModel.IsUserAssigned = false;
}
return(backlogModel);
}
}
public async Task <IActionResult> Post(BacklogViewModel data)
{
var content = JsonConvert.SerializeObject(data);
await http.PostAsync("http://localhost:62021/api/backlog", new StringContent(content, Encoding.UTF8, "application/json"));
return(Redirect("/backlog"));
}
public ActionResult EditBacklog(BacklogViewModel backlogModel)
{
var _existBacklog = new ProductBacklog();
_existBacklog = db.ProductBacklogs.FirstOrDefault(x => x.ProductBacklogId
== backlogModel.Backlog.ProductBacklogId);
_existBacklog.Name = backlogModel.Backlog.Name;
_existBacklog.Priority = backlogModel.Backlog.Priority;
_existBacklog.StoryPoint = backlogModel.Backlog.StoryPoint;
_existBacklog.AcceptanceCriteria = backlogModel.Backlog.AcceptanceCriteria;
_existBacklog.EpicId = backlogModel.Backlog.EpicId;
_existBacklog.SprintNo = backlogModel.Backlog.SprintNo;
_existBacklog.BacklogStatus = backlogModel.Backlog.BacklogStatus;
if (backlogModel.AssignMember != null)
{
var existMember = db.Members.FirstOrDefault
(x => x.MemberId == backlogModel.AssignMember.MemberId);
var backlogToMember = new BacklogToMember();
if (existMember != null && backlogToMember != null)
{
backlogToMember.MemberId = existMember.MemberId;
backlogToMember.MemberName = existMember.Name;
backlogToMember.ProductBacklogId = backlogModel.Backlog.ProductBacklogId;
db.BacklogToMembers.Add(backlogToMember);
}
}
db.SaveChanges();
ActivityRepository.ActivityCreator
("edited " + _existBacklog.Name + " backlog.", _existBacklog.ProjectId, _existBacklog.ProductBacklogId);
return(RedirectToAction("EditBacklog", new { id = _existBacklog.ProductBacklogId,
sprintNo = backlogModel.ViewSprintNo, sortBy = backlogModel.ViewSortBy }));
}
public ActionResult CreateBacklog(int projectId, int sprintNo = 0, int sortBy = 0)
{
var backlogModel = new BacklogViewModel();
backlogModel.Backlog.ProjectId = projectId;
backlogModel.ProjectEpics = EpicRepository.GetEpics(projectId);
backlogModel.Epic.ProjectId = backlogModel.Backlog.ProjectId;
backlogModel.ViewSortBy = sortBy;
backlogModel.ViewSprintNo = sprintNo;
return(View(backlogModel));
}
public ActionResult Index()
{
var viewModel = new BacklogViewModel();
using (var database = new DatabaseEntities())
{
viewModel.Backlog = new List <Item>(
from i in database.Items
where !i.Approved
select i);
}
return(View(viewModel));
}
public ActionResult CreateBacklog(BacklogViewModel backlogModel)
{
var backlogEpic = db.Epics.FirstOrDefault(x => x.EpicId == backlogModel.Backlog.EpicId);
if (backlogEpic != null)
{
backlogModel.Backlog.EpicName = backlogEpic.Name;
db.ProductBacklogs.Add(backlogModel.Backlog);
db.SaveChanges();
ActivityRepository.ActivityCreator
("created " + backlogModel.Backlog.Name + " backlog.",
backlogModel.Backlog.ProjectId, backlogModel.Backlog.ProductBacklogId);
return(RedirectToAction("EditBacklog", new { id = backlogModel.Backlog.ProductBacklogId, sprintNo = backlogModel.ViewSprintNo, sortBy = backlogModel.ViewSortBy }));
}
return(Content("Please assign a epic task first."));
}
public IActionResult Index()
{
var backLogDetailList = new List <BacklogDetail>();
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
var stepList = StepDB.GetInstance().GetAllStep(_projectId);
foreach (var item in stepList)
{
var assigneeUser = PersonDB.GetInstance().GetPersonById(item.AssigneeUser);
var milestone = MilestoneDB.GetInstance().GetMilestoneById(item.MilestoneId);
if (milestone == null)
{
continue;
}
backLogDetailList.Add(new BacklogDetail()
{
SprintId = item.SprintId,
AssigneeUserName = $"{assigneeUser.Name} {assigneeUser.Surname}",
Descripton = item.Description,
DetailName = item.Name,
MilestoneName = milestone.Name,
AssignedPersonNames = StepDB.GetInstance().GetStepPersonsByStepId(item.Id),
StepId = item.Id,
StepStatus = item.Status
});
}
var viewModel = new BacklogViewModel()
{
SprintList = SprintDB.GetInstance().GetAllSprintByProjectId(_projectId),
Details = backLogDetailList
};
return(View(viewModel));
}
