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;
}
}
}
