/// <summary> /// Get a dictionary where key is location id and value is district name. Is used for dropdowns. /// </summary> public static Dictionary <string, string> GetDistrictsOfTown(string town) { Dictionary <string, string> result = new Dictionary <string, string>(); foreach (var row in LocationCache.Query(new SqlFieldsQuery($"select _key, District from Locations where Town='{town}';"))) { result[row[0].ToString()] = row[1] as string; } return(result); }
/// <summary> /// Get list of towns of metioned region. Is used for dropdowns. /// </summary> public static ICollection <string> GetTownsOfRegion(string region) { List <string> result = new List <string>(); foreach (var row in LocationCache.Query(new SqlFieldsQuery($"select distinct Town from Locations where Region='{region}';"))) { result.Add(row[0] as string); } return(result); }