public ActionResult Prioritize()
{
ViewBag.CurrentView = "CashCost";
var query = dbController.GetPrioritizeProjectPacInfoFromDb(programName);
var listOfPrioritizeProjects = query.ToList <PrioritizeProjectPAC>();
var queryIssuesRankings = (from t in dbPrioritization.IssuesRankings
select t).ToList();
for (int i = 0; i < listOfPrioritizeProjects.Count(); i++)
{
string projID = listOfPrioritizeProjects[i].projectID;
IssuesRanking result = queryIssuesRankings.Find(x => x.bscmProjectsID == projID);
if (result != null)
{
listOfPrioritizeProjects[i].pacRank = result.pacRank;
listOfPrioritizeProjects[i].overallRank = result.overallRank;
listOfPrioritizeProjects[i].ITHR = result.ITHR;
}
if (listOfPrioritizeProjects[i].benefit != null)
{
listOfPrioritizeProjects[i].benefit = Regex.Replace(listOfPrioritizeProjects[i].benefit, "<.*?>|&.*?;", string.Empty).Trim();
}
}
listOfPrioritizeProjects.Sort();
return(View(listOfPrioritizeProjects));
}
public void UpdateInfoInDb(List <PrioritizeProjectOverall> data)
{
var query = (from t in dbPrioritization.IssuesRankings
select t.bscmProjectsID).ToList();
foreach (var item in data)
{
if (query.Contains(item.projectID))
{
IssuesRanking foundItem = dbPrioritization.IssuesRankings.Find(item.projectID);
foundItem.pacRank = item.pacRank;
foundItem.overallRank = item.overallRank;
foundItem.ITHR = item.ITHR;
}
else
{
IssuesRanking temp = new IssuesRanking();
temp.bscmProjectsID = item.projectID;
temp.pacRank = item.pacRank;
temp.overallRank = item.overallRank;
temp.ITHR = item.ITHR;
dbPrioritization.IssuesRankings.Add(temp);
}
}
dbPrioritization.SaveChanges();
}
public ActionResult Prioritize()
{
ViewBag.CurrentView = "Prioritization";
var query = (from t1 in db.MSP_EpmProject_UserView
where programNames.Contains(t1.Program) && t1.State_of_Project == "Active"
select new PrioritizeProjectOverall
{
projectUID = t1.ProjectUID.ToString(),
projectTitle = t1.ProjectTitle,
projectID = t1.Project_ID,
PAC = t1.Program,
benefit = t1.Benefits_Comment
});
var listOfPrioritizeProjects = query.ToList <PrioritizeProjectOverall>();
var queryIssuesRankings = (from t in dbPrioritization.IssuesRankings
select t).ToList();
for (int i = 0; i < listOfPrioritizeProjects.Count(); i++)
{
string projID = listOfPrioritizeProjects[i].projectID;
IssuesRanking result = queryIssuesRankings.Find(x => x.bscmProjectsID == projID);
if (result != null)
{
listOfPrioritizeProjects[i].pacRank = result.pacRank;
listOfPrioritizeProjects[i].overallRank = result.overallRank;
listOfPrioritizeProjects[i].ITHR = result.ITHR;
}
if (listOfPrioritizeProjects[i].benefit != null)
{
listOfPrioritizeProjects[i].benefit = Regex.Replace(listOfPrioritizeProjects[i].benefit, "<.*?>|&.*?;", string.Empty).Trim();
}
}
listOfPrioritizeProjects.Sort();
return(View(listOfPrioritizeProjects));
}
public ActionResult GanttChart(int numOfSprintsBefore = 5, int numOfSprintsAfter = 26)
{
int numberOfHoursInASprint = 72; //default
int numberOfSprintsBefore = numOfSprintsBefore;
int numberOfSprintsAfter = numOfSprintsAfter;
PopulateViewBagWorkWeekRange(numberOfSprintsBefore, numberOfSprintsAfter);
//Query gantt chart items
var query = (from t1 in db142.MSP_EpmProject_UserView
where programNames.Contains(t1.Program) && t1.State_of_Project == "Active"
select new GanttChartItem
{
itemUID = t1.ProjectUID.ToString(),
itemID = t1.Project_ID,
itemName = t1.ProjectTitle,
PAC = t1.Program
});
var listOfGanttChartItem = query.ToList <GanttChartItem>();
var queryIssuesRankings = (from t in dbPrioritization.IssuesRankings
where t.overallRank != 0 && t.ITHR.StartsWith("a")
select t).ToList();
var queryGanttChartDetails = (from t in dbGanttChart.AuxITGanttChart_Items
select t).ToList();
for (int i = 0; i < listOfGanttChartItem.Count(); i++)
{
string itemID = listOfGanttChartItem[i].itemID;
IssuesRanking result = queryIssuesRankings.Find(x => x.bscmProjectsID == itemID);
AuxITGanttChart_Items resultGanttChart = queryGanttChartDetails.Find(x => x.bscmProjectsID == itemID);
if (result != null)
{
listOfGanttChartItem[i].overallRank = result.overallRank;
listOfGanttChartItem[i].rankingStatus = result.overallRank.ToString();
listOfGanttChartItem[i].ITHR = Int32.Parse(result.ITHR.Split('-')[1]);
if (resultGanttChart != null)
{
numberOfHoursInASprint = resultGanttChart.numberOfHoursInASprint;
listOfGanttChartItem[i].rankingStatus = resultGanttChart.OCLT;
listOfGanttChartItem[i].developer = resultGanttChart.developer;
listOfGanttChartItem[i].plannedStartWorkWeek = resultGanttChart.plannedStartWW;
listOfGanttChartItem[i].plannedEndWorkWeek = resultGanttChart.plannedEndWW;
listOfGanttChartItem[i].actualStartWorkWeek = resultGanttChart.actualStartWW;
listOfGanttChartItem[i].actualEndWorkWeek = resultGanttChart.actualEndWW;
listOfGanttChartItem[i].deadlineWorkWeek = resultGanttChart.needDateWW;
listOfGanttChartItem[i].developerWorkload = resultGanttChart.developerWorkload;
}
}
else
{
listOfGanttChartItem.RemoveAt(i);
i--;
}
}
listOfGanttChartItem.Sort();
ViewBag.numberOfHoursInASprint = numberOfHoursInASprint;
ViewBag.numberOfSprintsBefore = numberOfSprintsBefore;
ViewBag.numberOfSprintsAfter = numberOfSprintsAfter;
return(View(listOfGanttChartItem));
}
