public void UpdateData(XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement eventElement in eventElements) { var workElements = eventElement.Descendants(Constants.Work.workElement); foreach (var workElement in workElements) { Work workItem = Work.GetWorkFromNode(workElement); IEnumerable <System.Xml.Linq.XElement> workDocumentElements = workElement.Descendants(Constants.WorkDocument.workDocumentElement); foreach (var workDocumentElement in workDocumentElements) { int documentID = 0; int.TryParse((string)workDocumentElement.GetXElement(Constants.WorkArtist.workArtistIDElement), out documentID); WorkDocument updateWorkDocument = WorkDocument.GetDocumentByID(documentID, workItem.WorkID); updateWorkDocument = WorkDocument.BuildWorkDocument(workDocumentElement, documentID, updateWorkDocument); if (updateWorkDocument == null) { continue; } object newValue = (string)workDocumentElement.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateWorkDocument, newValue, columnName); BsoArchiveEntities.Current.Save(); } } } }
public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Conductor updateConductor = Conductor.GetConductorFromNode(element); System.Xml.Linq.XElement conductorNode = element.Element(Constants.Conductor.conductorElement); if (conductorNode == null) { continue; } object newValue = conductorNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateConductor, newValue, columnName); } }
/// <summary> /// Updates the existing database Instrument on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Artist.artistElement); foreach (System.Xml.Linq.XElement element in eventElements) { Instrument updateInstrument = Instrument.GetInstrumentFromNode(element); if (updateInstrument == null) { continue; } object newValue = element.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateInstrument, newValue, columnName); } }
/// <summary> /// Updates the existing database TypeGroup on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { EventTypeGroup updateTypeGroup = EventTypeGroup.GetEventTypeGroupFromNode(element); if (updateTypeGroup == null) { continue; } System.Xml.Linq.XElement typeGroupNode = element.Element(Constants.EventTypeGroup.typeGroupElement); object newValue = typeGroupNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateTypeGroup, newValue, columnName); } }
/// <summary> /// Updates the existing database Season on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Season updateSeason = Season.GetSeasonFromNode(element); if (updateSeason == null) { continue; } System.Xml.Linq.XElement seasonNode = element.Element(Constants.Season.seasonElement); object newValue = seasonNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateSeason, newValue, columnName); } }
/// <summary> /// Updates the existing database Project on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Project updateProject = Project.GetProjectFromNode(element); if (updateProject == null) { continue; } System.Xml.Linq.XElement projectNode = element.Element(Constants.Project.projectElement); object newValue = projectNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateProject, newValue, columnName); } }
/// <summary> /// Updates the existing database Orchestra on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Orchestra updateOrchestra = Orchestra.GetOrchestraFromNode(element); if (updateOrchestra == null) { continue; } System.Xml.Linq.XElement orchestraNode = element.Element(Constants.Orchestra.orchestraElement); object newValue = orchestraNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateOrchestra, newValue, columnName); } }
/// <summary> /// Updates the existing database Venue on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Venue updateVenue = Venue.GetVenueFromNode(element); if (updateVenue == null) { continue; } System.Xml.Linq.XElement venueNode = element.Element(Constants.Venue.venueElement); object newValue = (string)venueNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateVenue, newValue, columnName); } }
/// <summary> /// Update given column from xml given the tag name /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> /// <remarks> /// Read Composer information from OPAS XML and update the Composer Column based upon appropriate tagName /// </remarks> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { IEnumerable <System.Xml.Linq.XElement> composerElements = element.Descendants(Constants.Work.workComposerElement); foreach (System.Xml.Linq.XElement composer in composerElements) { Composer updateComposer = Composer.GetComposerFromNode(composer); if (updateComposer == null) { continue; } object newValue = composer.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateComposer, newValue, columnName); } } }
/// <summary> /// Updates the existing database Work on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { //System.Xml.Linq.XElement workNode = element.Element(Constants.Work.workElement); var workNodes = element.Descendants(Constants.Work.workElement); foreach (var workNode in workNodes) { Work updateWork = Work.GetWorkFromNode(workNode); if (updateWork == null) { continue; } object newValue = (string)workNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateWork, newValue, columnName); } } }