public IQueryable<Project> GetProjects()
{
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
var result = from prj in kt.Projects
select prj;
return result;
}
public IQueryable<ProjectStatus> GetProjectStatuses( int projectID)
{
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
var result = from prj in kt.ProjectStatus1
where prj.ProjectID == projectID
select prj;
return result;
}
public bool Delete(Task task)
{
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
Task t = new Task() { TaskID = task.TaskID };
kt.Tasks.Attach(t);
kt.Tasks.Remove(t);
kt.SaveChanges();
return true;
}
public IQueryable<User> GetProjectUsers(int projectID)
{
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
var result = from prj in kt.Projects
from usr in prj.Users
where prj.ProjectID == projectID
select usr;
return result;
}
public ICollection<Project> GetProjectsForUser(int userID)
{
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
var result = from usr in kt.Users
where usr.UserID == userID
select usr;
foreach (var usr in result)
{
return usr.Projects;
}
return null;
}
public ICollection<BoardItem> GetProjectBoard(int projectID)
{
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
List<BoardItem> lst = new List<BoardItem>();
var result = kt.GetProjectBoard(projectID);
foreach (var res in result)
{
lst.Add(new BoardItem(res));
}
return lst;
}
public Task UpdateTask(Task task)
{
Task ret = null;
KanbanBoard.Data.KanbanTFSEntities kt = new KanbanTFSEntities();
bool taskFound = false;
var result = from tsk in kt.Tasks
where tsk.TaskID == task.TaskID
select tsk;
foreach (var tsk in result)
{
taskFound = true;
tsk.ProjectID = task.ProjectID;
tsk.TFSTaskID = task.TFSTaskID;
tsk.Title = task.Title;
tsk.Descriptions = task.Descriptions;
tsk.UserID = task.UserID;
tsk.StatusID = task.StatusID;
ret = tsk;
}
if (taskFound == false)
{
ret = task;
kt.Tasks.Add(task);
}
kt.SaveChanges();
return ret;
}