public async Task GetAllNicknames()
        {
            var results = await Nickname.GetAllAsync(_azureSql);

            Assert.NotNull(results);
            Assert.True(results.Any());
        }
        public async Task <IActionResult> MapAsync(string journeyName, string teamName, string name)
        {
            var response = new Map();

            if (!string.IsNullOrWhiteSpace(journeyName) &&
                (journeyName.Length < 100))
            {
                journeyName = journeyName.Trim();

                var journeys = await Journey.GetByJourneyNameAsync(journeyName, _azureSQL);

                response.Journey = journeys.FirstOrDefault();

                var entries = await Step.GetByJourneyAsync(response.Journey?.JourneyName, _azureSQL);

                foreach (var entry in entries)
                {
                    response.StepsTaken += entry.Steps;
                }
            }

            if (!(string.IsNullOrWhiteSpace(teamName)) &&
                (teamName.Length < 100))
            {
                teamName = teamName.Trim();

                var teams = await Team.GetByTeamNameAsync(teamName, _azureSQL);

                response.Team = teams.FirstOrDefault();
            }
            else
            {
                var teams = await Team.GetAllAsync(_azureSQL);

                response.Teams = teams.OrderBy(x => x.TeamName);
            }

            if (!(string.IsNullOrWhiteSpace(name)) &&
                (name.Length < 100))
            {
                name = name.Trim();

                var nicknames = await Nickname.GetByNicknameAsync(name, _azureSQL);

                response.Nickname = nicknames.FirstOrDefault();
            }
            else
            {
                var nicknames = await Nickname.GetAllAsync(_azureSQL);

                response.Nicknames = nicknames.OrderBy(x => x.Name);
            }

            if (response?.Journey is null || string.IsNullOrWhiteSpace(response?.Journey?.JourneyName))
            {
                return(Redirect("/"));
            }

            return(View("Map", response));
        }
        public async Task <IActionResult> IndexAsync(string name)
        {
            if (string.IsNullOrWhiteSpace(name))
            {
                var results = await Nickname.GetAllAsync(_azureSQL);

                return(View("Nicknames", new NicknameSearchResult
                {
                    Query = name,
                    Nicknames = results
                }));
            }
            else
            {
                var results = await Nickname.GetByNicknameAsync(name, _azureSQL);

                if (!results.Any())
                {
                    results = await Nickname.SearchByNicknameAsync(name, _azureSQL);
                }

                if (results.Count() > 1)
                {
                    return(View("Nicknames", new NicknameSearchResult
                    {
                        Query = name,
                        Nicknames = results
                    }));
                }
                else
                {
                    return(View("Nicknames", new NicknameSearchResult
                    {
                        Query = name,
                        Nicknames = results
                    }));
                }
            }
        }