/* * Insert the data from the JSON parser into the database */ private bool insertDevInfoIntoDB(DeviceInfoHolder devInfo) { //something is wrong and the device was not found. Bail if (devInfo == null) { Debug.WriteLine("something went terribly wrong with a DeviceInfo. Bailing"); NavigationService.GoBack(); return false; } Topic top = null; Debug.WriteLine("putting device info into DB..."); //try to get a topic of this name from the DB //if it fails, make a new one. if it works, update the old using (iFixitDataContext db = new iFixitDataContext(App.DBConnectionString)) { bool gotTopicFromDB = true; top = DBHelpers.GetCompleteTopic(devInfo.topic_info.name, db); if (top == null) { top = new Topic(); gotTopicFromDB = false; } //translate devInfo in a Topic() //name is already the same top.Name = devInfo.topic_info.name; top.parentName = devInfo.title; top.Contents = devInfo.description; top.ImageURL = devInfo.image.text + ".medium"; top.Populated = true; //TODO inject metatdata here like # answers top.Description = ""; top.Description += prepHTML(devInfo.contents, devInfo); //now do the same for all attached guides foreach (DIGuides g in devInfo.guides) { Debug.WriteLine("\tguide " + g.title); //search if the guide already exists, and get or update it Guide gOld = new Guide(); gOld.FillFieldsFromDeviceInfo(navTopicName, g); gOld = db.GuidesTable.FirstOrDefault(other => other.GuideID == gOld.GuideID); if (gOld == null) { gOld = new Guide(); db.GuidesTable.InsertOnSubmit(gOld); } gOld.FillFieldsFromDeviceInfo(navTopicName, g); // hang it below the topic, it its collection of guides top.AddGuide(gOld); //FIXME do we need to specifically add this to the guide table? is that magic? db.SubmitChanges(); } if (!gotTopicFromDB) { db.TopicsTable.InsertOnSubmit(top); } //update the Topic() into the database db.SubmitChanges(); //force the view model to update infoVM.UpdateData(); updateInfoBrowser(); //force the views to update this.InfoStack.DataContext = infoVM; this.GuidesStack.DataContext = infoVM; //disable the loading bars this.LoadingBarInfo.Visibility = System.Windows.Visibility.Collapsed; this.LoadingBarGuides.Visibility = System.Windows.Visibility.Collapsed; } return true; }