public static List <Sprint> GetAllSprintsByRange(DateTime startDate, DateTime endDate)
{
using (var context = new TaskTrackerContext())
{
return(context.Sprints.Where(a => a.StartDate >= startDate && a.EndDate <= endDate).ToList());
}
}
public static List <Sprint> GetAllSprints()
{
using (var context = new TaskTrackerContext())
{
return(context.Sprints.ToList());
}
}
public static List <Board> GetBoards()
{
using (var context = new TaskTrackerContext())
{
return(context.Boards.ToList());
}
}
public static Sprint GetSprintByID(long id)
{
using (var context = new TaskTrackerContext())
{
var sprint = context.Sprints.Find(id);
return(sprint);
}
}
public static Board GetBoardByID(long id)
{
using (var context = new TaskTrackerContext())
{
var board = context.Boards.Find(id);
return(board);
}
}
public UnitOfWork(string connectionString)
{
db = new TaskTrackerContext(connectionString);
userManager = new ApplicationUserManager(new UserStore <ApplicationUser>(db));
roleManager = new ApplicationRoleManager(new RoleStore <ApplicationRole>(db));
projectRepository = new ProjectRepository(db);
projectTaskRepository = new ProjectTaskRepository(db);
userProfileRepository = new UserProfileRepository(db);
}
protected void Dispose(bool disposing)
{
if (disposing)
{
if (db != null)
{
db.Dispose();
db = null;
}
}
}
public ProjectRepository(TaskTrackerContext context)
{
this.context = context;
}
public UserProfileRepository(TaskTrackerContext context)
{
this.context = context;
}
public BoardController(IProjectManagementClient projectManagementClient, TaskTrackerContext taskTrackerContext)
{
_projectManagementClient = projectManagementClient;
_taskTrackerContext = taskTrackerContext;
}
public PublicLayer(TaskTrackerContext context)
{
this.context = context;
}
public Jira(TaskTrackerContext taskTrackerContext)
{
_taskTrackerContext = taskTrackerContext;
}
