public JsonResult GetGorevByBoardId(int _sprintId)
{
try
{
var stepList = StepDB.GetInstance().GetGorevBySprintId(_sprintId);
var backLogDetailList = new List <BacklogDetail>();
foreach (var item in stepList)
{
var assigneeUser = PersonDB.GetInstance().GetPersonById(item.AssigneeUser);
var milestone = MilestoneDB.GetInstance().GetMilestoneById(item.MilestoneId);
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
});
}
return(Json(backLogDetailList));
}
catch (System.Exception exc)
{
throw exc;
}
}
public IActionResult Index()
{
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
var dateList = MilestoneDB.GetInstance().GetProjectStartAndEndDate(_projectId);
var dddd = MilestoneDB.GetInstance().GetTotalProjectPercent(_projectId);
return(View(dateList));
}
public JsonResult DeleteMilestone(int _projeId)
{
try
{
var result = MilestoneDB.GetInstance().DeleteMilestone(_projeId);
return(Json(result));
}
catch (System.Exception exc)
{
throw exc;
}
}
public JsonResult GetMilestoneInfo()
{
try
{
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
var list = MilestoneDB.GetInstance().GetMilestoneInfo(_projectId);
return(Json(list));
}
catch (System.Exception exc)
{
throw exc;
}
}
public JsonResult GetMilestoneById(int _milestoneId)
{
try
{
var milestone = MilestoneDB.GetInstance().GetMilestoneById(_milestoneId);
return(Json(milestone));
}
catch (System.Exception exc)
{
throw exc;
}
}
public IActionResult Index()
{
var milestoneDetailList = new MilestoneViewModel();
milestoneDetailList.MilestoneList = MilestoneDB.GetInstance().GetAllMilestone(JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id);
milestoneDetailList.PersonList = PersonDB.GetInstance().GetAllPerson();
//milestoneDetailList.SprintList = SprintDB.GetInstance().GetAllSprint();
var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id;
milestoneDetailList.ProjectList = ProjectDB.GetInstance().GetAllProject(personId);
return(View(milestoneDetailList));
}
public JsonResult GetAllStep()
{
try
{
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
var stepList = StepDB.GetInstance().GetAllStep(_projectId);
var backLogDetailList = new List <BacklogDetail>();
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,
MilestoneId = item.MilestoneId,
StepEndDate = Convert.ToDateTime(item.EndDate),
StepStartDate = Convert.ToDateTime(item.StartDate),
StepStatus = item.Status
});
}
var projectMilestones = MilestoneDB.GetInstance().GetAllMilestoneByProjectId(_projectId);
var projectMilestoneIds = projectMilestones.Select(x => x.Id).ToList();
backLogDetailList = backLogDetailList.Where(x => projectMilestoneIds.Contains(x.MilestoneId)).ToList();
return(Json(backLogDetailList));
}
catch (Exception exc)
{
throw exc;
}
}
public JsonResult GetAllStepForPano()
{
try
{
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
var boardList = BoardDB.GetInstance().GetBoardByProjectId(_projectId);
var boardDetailList = new List <BoardRepo>();
var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id;
foreach (var item in boardList)
{
var stepList = BoardDB.GetInstance().GetStepByBoardId(item.Id, personId);
foreach (var step in stepList)
{
var assigneeUser = PersonDB.GetInstance().GetPersonById(step.AssigneeUser);
var milestone = MilestoneDB.GetInstance().GetMilestoneById(step.MilestoneId);
if (milestone == null)
{
continue;
}
boardDetailList.Add(new BoardRepo()
{
SprintId = step.SprintId,
AssigneeUserName = $"{assigneeUser.Name} {assigneeUser.Surname}",
Descripton = step.Description,
DetailName = step.Name,
MilestoneName = milestone.Name,
AssignedPersonNames = StepDB.GetInstance().GetStepPersonsByStepId(step.Id),
StepId = step.Id,
BoardId = item.Id
});
}
}
return(Json(boardDetailList));
}
catch (System.Exception exc)
{
throw exc;
}
}
public JsonResult SaveMilestone(string _titleMilestone, string _endDate, string _startDate, string _description, int _milestoneId)
{
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
try
{
if (_milestoneId == 0)
{
var milestone = new Milestone()
{
Name = _titleMilestone,
Description = _description,
StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
ProjectId = _projectId,
Status = 1
};
var result = MilestoneDB.GetInstance().SaveMilestone(milestone);
return(Json(result != null));
}
else
{
var milestone = new Milestone()
{
Name = _titleMilestone,
Description = _description,
StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
ProjectId = _projectId,
Id = _milestoneId,
Status = 1
};
var result = MilestoneDB.GetInstance().UpdateMilestone(milestone);
return(Json(result != null));
}
}
catch (Exception exc)
{
throw exc;
}
}
public JsonResult GetMilestonesAndSprintsByProjectId(int _projectId)
{
try
{
var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id;
var milestones = MilestoneDB.GetInstance().GetAllMilestoneByProjectId(_projectId);
var sprints = SprintDB.GetInstance().GetAllSprintByProjectId(_projectId);
var persons = PersonDB.GetInstance().GetHeadOfDepartmentsUsers(personId);
return(Json(new
{
Milestones = milestones.Where(x => x.Status < 3).ToList().OrderBy(x => x.Id).ToList(),
Sprints = sprints.Where(x => x.Status < 3).ToList().OrderBy(x => x.Id).ToList(),
Persons = persons.OrderBy(x => x.Name).ThenBy(x => x.Surname).ToList()
}));
}
catch (Exception exc)
{
throw exc;
}
}
public JsonResult SaveMilestone(string _titleMilestone, string _endDate, string _startDate, string _description, int _projectID, int _milestoneId)
{
try
{
if (_milestoneId == 0)
{
var milestone = new Milestone()
{
Name = _titleMilestone,
Description = _description,
StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
ProjectId = _projectID
};
var result = MilestoneDB.GetInstance().SaveMilestone(milestone);
return(Json(result != null));
}
else
{
var milestone = new Milestone()
{
Name = _titleMilestone,
Description = _description,
StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture),
ProjectId = _projectID,
Id = _milestoneId
};
var result = MilestoneDB.GetInstance().UpdateMilestone(milestone);
return(Json(result != null));
}
}
catch (Exception exc)
{
throw exc;
}
}
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));
}
