public static List <ALittleAlliteration> GetCluesForTheme(string theme, int season = 0) { List <ALittleAlliteration> matchingPuzzles = new List <ALittleAlliteration>(); GoogleSheet sheet = new GoogleSheet() { GoogleSheetKey = ALittleAlliterationGoogleSheet }; string query = $"SELECT * WHERE H LIKE '%{theme}%'"; if (season == 1) { sheet.GoogleSheetKey = ALittleAlliterationSeasonOneGoogleSheet; query = $"SELECT * WHERE I LIKE '%{theme}%'"; } foreach (var result in sheet.ExecuteQuery(query)) { ALittleAlliteration aLittleAlliteration = new ALittleAlliteration(result, season); if (!string.IsNullOrWhiteSpace(aLittleAlliteration.Clue)) { matchingPuzzles.Add(aLittleAlliteration); } } return(matchingPuzzles); }
public List <ALittleAlliteration> FindPuzzle(string firstThreeLetters) { GoogleSheet sheet = new GoogleSheet() { GoogleSheetKey = ALittleAlliterationGoogleSheet }; string firstThreeLetters1 = firstThreeLetters.ToLower(); List <ALittleAlliteration> results = new List <ALittleAlliteration>(); foreach (var dictionary in sheet.ExecuteQuery($"SELECT * WHERE E = '{firstThreeLetters1}'")) { var aLittleAlliteration = new ALittleAlliteration(dictionary); if (string.IsNullOrWhiteSpace(aLittleAlliteration.TwitterUrl) && string.IsNullOrWhiteSpace(aLittleAlliteration.DatePosted) && !string.IsNullOrWhiteSpace(aLittleAlliteration.Clue)) { results.Add(aLittleAlliteration); } } return(results); }
public List <VowelMovement> FindPuzzle(string startConsonant, string endConsonant) { // ReSharper disable StringLiteralTypo GoogleSheet sheet = new GoogleSheet() { GoogleSheetKey = "1iYI-nE-5hYN7J3ckXmJjmzbxLmqs5UAGpGJh5yNUKgM" }; // ReSharper restore StringLiteralTypo string startConsonant1; if (string.IsNullOrWhiteSpace(startConsonant)) { startConsonant1 = null; } else { startConsonant1 = startConsonant.ToLower(); switch (startConsonant1) { case "c": case "k": startConsonant1 = "c, k"; break; case "g": startConsonant1 = "g (hard)"; break; case "n": case "kn": startConsonant1 = "n, kn"; break; case "q": startConsonant1 = "qu"; break; case "j": startConsonant1 = "j/soft g"; break; } } if (!string.IsNullOrWhiteSpace(endConsonant)) { endConsonant = endConsonant.ToLower(); switch (endConsonant) { case "c": case "k": endConsonant = "c, k"; break; case "h": case "w": case "y": endConsonant = "(h) (w) (y)"; break; } } List <Dictionary <int, string> > queryResults = sheet.ExecuteQuery(string.Format($@"SELECT * WHERE I = '{startConsonant1}' AND J = '{endConsonant}'")); List <VowelMovement> vowelMovements = new List <VowelMovement>(); foreach (var dictionary in queryResults) { var vowelMovement = new VowelMovement(dictionary); if (string.IsNullOrWhiteSpace(vowelMovement.TwitterUrl) && string.IsNullOrWhiteSpace(vowelMovement.DatePosted)) { vowelMovements.Add(vowelMovement); } } return(vowelMovements); }