public List <Feature> RetrieveToDoFeatures(CRUDProjectManager currentProj)
{
using (PlannerContext pc = new PlannerContext())
{
List <Feature> features = new List <Feature>();
var _featureIDs =
from f in pc.Features
where f.ProjectId == currentProj.SelectedProject.ProjectId && f.Status != 3
orderby f.Priority
select f;
foreach (var item in _featureIDs)
{
features.Add(item);
}
return(features);
}
}
public List <Issue> RetrieveProjectIssues(CRUDProjectManager currentProj)
{
using (PlannerContext pc = new PlannerContext())
{
List <Issue> issues = new List <Issue>();
var _issueIDs =
from i in pc.Issues
where i.ProjectId == currentProj.SelectedProject.ProjectId
orderby i.Priority
select i;
foreach (var item in _issueIDs)
{
issues.Add(item);
}
return(issues);
}
}
public List <Feature> RetrieveCompleteFeatures(CRUDProjectManager currentProj)
{
using (PlannerContext pc = new PlannerContext())
{
List <Feature> features = new List <Feature>();
var _featureIDs =
from f in pc.Features
where f.ProjectId == currentProj.SelectedProject.ProjectId && f.Status == 3
select f;
if (_featureIDs.Count() > 0)
{
foreach (var item in _featureIDs)
{
features.Add(item);
}
}
return(features);
}
}
public void CreateNewIssue(string title, string description, int status, int priority, string notes, CRUDProjectManager currentProj)
{
using (PlannerContext pc = new PlannerContext())
{
Issue _newIssue = new Issue()
{
Title = title,
Description = description,
Status = status,
Priority = priority,
Notes = notes,
ProjectId = currentProj.SelectedProject.ProjectId
};
pc.Issues.Add(_newIssue);
pc.SaveChanges();
}
}
