public async Task <IActionResult> GetPP_Projects([FromRoute] Guid id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var proj = await _context.Projects.SingleOrDefaultAsync(m => m.ProjectID == id);
if (proj == null)
{
return(NotFound());
}
var categoryList = _context.Categories.ToList();
var scores = _context.CentricScores.ToList();
var mapCodes = _context.MapCodes.ToList();
var departments = _context.Departments.ToList();
ProjectstDTO project = new ProjectstDTO
{
Status = proj.Status,
ProjectCategoryID = proj.ProjectCategoryID,
Category = categoryList.Find(x => x.CategoryID == proj.ProjectCategoryID).Category,
CustomerCentricScoreID = proj.CustomerCentricScoreID,
Score = scores.Find(x => x.CentricScoreID == proj.CustomerCentricScoreID).Score,
DepartmentID = proj.DepartmentID,
Department = departments.Find(x => x.DepartmentID == proj.DepartmentID).Department,
EndDate = proj.EndDate.ToShortDateString(),
EndDateChanged = proj.EndDateChanged,
GroupName = proj.GroupName,
MapCode = mapCodes.Find(x => x.MapCodeID == proj.CustomerMapCodeID).MapCode,
CustomerMapCodeID = proj.CustomerMapCodeID,
NumberOfTasks = proj.NumberOfTasks,
ProjectManager = proj.ProjectManager,
ProjectOverview = proj.ProjectOverview,
ProjectSponsor = proj.ProjectSponsor,
ProjectNumber = proj.ProjectNumber,
ProjectStakeHolder = proj.ProjectStakeHolder,
ProjectTargetDate = proj.ProjectTargetDate.ToShortDateString(),
StartDate = proj.StartDate.ToShortDateString(),
ProjectID = proj.ProjectID
};
return(Ok(project));
}
public List <ProjectstDTO> GetProjects()
{
List <ProjectstDTO> projects = new List <ProjectstDTO>();
//dependencies
var categoryList = _context.Categories.ToList();
var scores = _context.CentricScores.ToList();
var mapCodes = _context.MapCodes.ToList();
var departments = _context.Departments.ToList();
var projectList = _context.Projects.ToList();
foreach (var proj in projectList)
{
ProjectstDTO project = new ProjectstDTO
{
Status = proj.Status,
ProjectCategoryID = proj.ProjectCategoryID,
Category = categoryList.Find(x => x.CategoryID == proj.ProjectCategoryID).Category,
CustomerCentricScoreID = proj.CustomerCentricScoreID,
Score = scores.Find(x => x.CentricScoreID == proj.CustomerCentricScoreID).Score,
DepartmentID = proj.DepartmentID,
Department = departments.Find(x => x.DepartmentID == proj.DepartmentID).Department,
EndDate = proj.EndDate.ToShortDateString(),
EndDateChanged = proj.EndDateChanged,
GroupName = proj.GroupName,
MapCode = mapCodes.Find(x => x.MapCodeID == proj.CustomerMapCodeID).MapCode,
CustomerMapCodeID = proj.CustomerMapCodeID,
NumberOfTasks = proj.NumberOfTasks,
ProjectManager = proj.ProjectManager,
ProjectOverview = proj.ProjectOverview,
ProjectSponsor = proj.ProjectSponsor,
ProjectNumber = proj.ProjectNumber,
ProjectStakeHolder = proj.ProjectStakeHolder,
ProjectTargetDate = proj.ProjectTargetDate.ToShortDateString(),
StartDate = proj.StartDate.ToShortDateString(),
ProjectID = proj.ProjectID
};
if (project != null)
{
projects.Add(project);
}
}
return(projects);
}
