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(); } }