//public static double GetMetersByName(string race) //{ // var fred = race.ToLower().Trim(); // var str = Regex.Replace(fred, @"\s", ""); // switch (str) // { // case "1m": return 1609.34; // case "5m": return 8046.72; // case "10m": return 16093.4; // case "13m": return 21082.41; // case "20m": return 32186.9; // case "26m": return 42164.81; // case "5km": return 5000; // case "10km": return 10000; // default: return -1; // } //} public static double GetMetersByCode(string code) { RaceDistance.rrcmlistEntities db = new RaceDistance.rrcmlistEntities(); var fred = code.ToLower().Trim(); var str = Regex.Replace(fred, @"\s", ""); var allDistances = db.distances; var distance = allDistances.SingleOrDefault(d => d.Code == str).Value; return(distance); }
public static string GetByRaceNameByMeters(double distance) { var distanctStr = ""; try { RaceDistance.rrcmlistEntities db = new RaceDistance.rrcmlistEntities(); var allDistances = db.distances; distanctStr = allDistances.SingleOrDefault(d => d.Value == distance).Name; } catch { distanctStr = "not known"; } return(distanctStr); }