public void DemographicsScript() { List <int> allZipCodes = zipCsv.Replace(" ", String.Empty).Split(',').ToList().ConvertAll <int>(x => Convert.ToInt32(x)); List <int> selectedZipCodes = allZipCodes.GetRange(592, 1); List <DemographicsModel> results = DemographicsQuery.GetDemographics(selectedZipCodes, false, 0); DemographicsData.UpdateDatabase(results); }
public static void GetDemographics() { // Try to read zips from app.config string zipCsv = ConfigurationManager.AppSettings["zipCodes"]; List <int> allZipCodes = zipCsv.Replace(" ", String.Empty).Split(',').ToList().ConvertAll <int>(x => Convert.ToInt32(x)); List <int> missingZipCodes = new List <int>(); //allZipCodes.GetRange(592, 1); using (SportsDataContext db = new SportsDataContext()) { missingZipCodes = allZipCodes.Except(db.Demographic_DbSet.Select(z => z.Zip).ToList()).ToList(); } if (missingZipCodes.Count == 0) { Console.WriteLine("All zip codes have been retrieved and stored in the database. To update existing zip code data, delete it from the database and re-run"); Console.WriteLine("Zip codes in the list of zip codes to retrieve:"); Console.WriteLine(allZipCodes); } List <DemographicsModel> results = DemographicsQuery.GetDemographics(missingZipCodes, false, 0); DemographicsData.UpdateDatabase(results); }
public void DemographicsTest() { List <int> zipCodes = new List <int> { 98103, 98052, 98007 }; List <DemographicsModel> results = DemographicsQuery.GetDemographics(zipCodes); Assert.AreEqual(3, results.Count); DemographicsModel fremont = results.Single(x => x.Zip == 98103); Assert.AreEqual(49044, fremont.MedianIncome); Assert.AreEqual(73, fremont.MedianIncomeRank); Assert.AreEqual(43.9, fremont.OwnerOccupiedHomesPercent); Assert.AreEqual(5, fremont.OwnerOccupiedHomesRank); Assert.AreEqual(36.5, fremont.MarriedPercent); Assert.AreEqual(2, fremont.MarriedRank); Assert.AreEqual("Seattle", fremont.City); Assert.AreEqual("WA", fremont.State); }