public void AddPetShop(string source, keydowno_backyard_farmerEntities db) { int firstPosition = 0; firstPosition = source.IndexOf("StoreId"); int jsonStart = firstPosition - 2; int jsonEnd = source.IndexOf("]", firstPosition); string jsonString = source.Substring(jsonStart, jsonEnd - jsonStart); string[] stringSeparators = new string[] { "},{" }; string[] stores = jsonString.Split(stringSeparators, StringSplitOptions.None); foreach (var store in stores) { NASAGetData.PetShop petShop = new NASAGetData.PetShop(); NASAGetData.PetShopsWorkingHour WorkingHours = new NASAGetData.PetShopsWorkingHour(); petShop.Zip = ParseJSON("PostalCode", store); petShop.Name = ParseJSON("Name", store); petShop.Address = ParseJSON("Address", store); petShop.Phone = ParseJSON("PhoneNumber", store); petShop.City = ParseJSON("City", store); petShop.Latitude = double.Parse(ParseJSON("Latitude", store)); petShop.Longitude = double.Parse(ParseJSON("Longitude", store).TrimEnd('}')); WorkingHours.MondayStartTime = ParseJSON("OpenTimeMonday",store); WorkingHours.MondayEndTime = ParseJSON("CloseTimeMonday", store); WorkingHours.TuesdayStartTime = ParseJSON("CloseTimeTuesday", store); WorkingHours.TuesdayEndTime = ParseJSON("CloseTimeTuesday", store); WorkingHours.WednesdayStartTime = ParseJSON("CloseTimeWednesday", store); WorkingHours.WednesdayEndTime = ParseJSON("CloseTimeWednesday", store); WorkingHours.ThursdayStartTime = ParseJSON("CloseTimeThursday", store); WorkingHours.ThursdayEndTime = ParseJSON("CloseTimeThursday", store); WorkingHours.FridayStartTime = ParseJSON("CloseTimeFriday", store); WorkingHours.FridayEndTime = ParseJSON("CloseTimeFriday", store); WorkingHours.SaturdayStartTime = ParseJSON("CloseTimeSaturday", store); WorkingHours.SaturdayEndTime = ParseJSON("CloseTimeSaturday", store); WorkingHours.SundayStartTime = ParseJSON("CloseTimeSunday", store); WorkingHours.SundayEndTime = ParseJSON("CloseTimeSunday", store); db.PetShops.Add(petShop); //db.SaveChanges(); WorkingHours.Id = petShop.Id; db.PetShopsWorkingHours.Add(WorkingHours); db.SaveChanges(); } }
protected void GetVets_Click(object sender, EventArgs e) { keydowno_backyard_farmerEntities db = new keydowno_backyard_farmerEntities(); List<string> codes = db.ZipCodes.Select(x => x.Zip).ToList(); foreach (var code in codes) { try { Response.Write(code + " "); string zip = code.ToString(); string source = PerformRequest(zip); AddPetShop(source, db); var a = db.ZipCodes.Where(x => x.Zip == code).First(); a.Parsed = true; db.SaveChanges(); } catch (Exception) { continue; } } }