public async Task <IActionResult> GetOpenTaskBoards(int start, int pageSize)
{
GoNorthProject project = await _projectDbAccess.GetDefaultProject();
Task <List <TaskBoard> > queryTask;
Task <int> countTask;
queryTask = _taskBoardDbAccess.GetOpenTaskBoards(project.Id, start, pageSize);
countTask = _taskBoardDbAccess.GetOpenTaskBoardCount(project.Id);
Task.WaitAll(queryTask, countTask);
TaskBoardQueryResult queryResult = new TaskBoardQueryResult();
queryResult.Boards = queryTask.Result;
queryResult.HasMore = start + queryResult.Boards.Count < countTask.Result;
return(Ok(queryResult));
}
/// <summary>
/// Checks if a project is empty
/// </summary>
/// <param name="project">Project to check</param>
/// <returns>True if the project is empty, else false</returns>
private async Task <bool> IsProjectEmpty(GoNorthProject project)
{
int rootKortistoFolderCount = await _kortistoFolderDbAccess.GetRootFolderCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (rootKortistoFolderCount > 0)
{
return(false);
}
int rootNpcCount = await _npcDbAccess.GetFlexFieldObjectsInRootFolderCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (rootNpcCount > 0)
{
return(false);
}
int rootStyrFolderCount = await _styrFolderDbAccess.GetRootFolderCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (rootStyrFolderCount > 0)
{
return(false);
}
int rootItemCount = await _itemDbAccess.GetFlexFieldObjectsInRootFolderCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (rootItemCount > 0)
{
return(false);
}
int rootEvneFolderCount = await _evneFolderDbAccess.GetRootFolderCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (rootEvneFolderCount > 0)
{
return(false);
}
int rootSkillCount = await _evneSkillDbAccess.GetFlexFieldObjectsInRootFolderCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (rootSkillCount > 0)
{
return(false);
}
int kirjaPageCount = await _kirjaPageDbAccess.SearchPagesCount(project.Id, string.Empty, string.Empty, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (kirjaPageCount > 1)
{
return(false);
}
else if (kirjaPageCount == 1)
{
KirjaPage defaultPage = await _kirjaPageDbAccess.GetDefaultPageForProject(project.Id);
if (defaultPage == null)
{
return(false);
}
}
int chapterDetailCount = await _chapterDetailDbAccess.GetChapterDetailsByProjectIdCount(project.Id);
if (chapterDetailCount > 0)
{
return(false);
}
int questCount = await _questDbAccess.GetQuestsByProjectIdCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (questCount > 0)
{
return(false);
}
List <KartaMap> maps = await _mapDbAccess.GetAllProjectMaps(project.Id);
if (maps != null && maps.Count > 0)
{
return(false);
}
int taskBoardCount = await _taskBoardDbAccess.GetOpenTaskBoardCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
taskBoardCount += await _taskBoardDbAccess.GetClosedTaskBoardCount(project.Id, CultureInfo.CurrentUICulture.TwoLetterISOLanguageName);
if (taskBoardCount > 0)
{
return(false);
}
return(true);
}
/// <summary>
/// Checks if a project is empty
/// </summary>
/// <param name="project">Project to check</param>
/// <returns>True if the project is empty, else false</returns>
private async Task <bool> IsProjectEmpty(GoNorthProject project)
{
int rootKortistoFolderCount = await _kortistoFolderDbAccess.GetRootFolderCount(project.Id);
if (rootKortistoFolderCount > 0)
{
return(false);
}
int rootNpcCount = await _npcDbAccess.GetFlexFieldObjectsInRootFolderCount(project.Id);
if (rootNpcCount > 0)
{
return(false);
}
int rootStyrFolderCount = await _styrFolderDbAccess.GetRootFolderCount(project.Id);
if (rootStyrFolderCount > 0)
{
return(false);
}
int rootItemCount = await _itemDbAccess.GetFlexFieldObjectsInRootFolderCount(project.Id);
if (rootItemCount > 0)
{
return(false);
}
int kirjaPageCount = await _kirjaPageDbAccess.SearchPagesCount(project.Id, string.Empty, string.Empty);
if (kirjaPageCount > 0)
{
return(false);
}
int chapterDetailCount = await _chapterDetailDbAccess.GetChapterDetailsByProjectIdCount(project.Id);
if (chapterDetailCount > 0)
{
return(false);
}
int questCount = await _questDbAccess.GetQuestsByProjectIdCount(project.Id);
if (questCount > 0)
{
return(false);
}
List <KartaMap> maps = await _mapDbAccess.GetAllProjectMaps(project.Id);
if (maps != null && maps.Count > 0)
{
return(false);
}
int taskBoardCount = await _taskBoardDbAccess.GetOpenTaskBoardCount(project.Id);
taskBoardCount += await _taskBoardDbAccess.GetClosedTaskBoardCount(project.Id);
if (taskBoardCount > 0)
{
return(false);
}
return(true);
}