/// <summary>
/// Updates the existing database Event 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)
{
Event updateEvent = Event.GetEventFromNodeItem(element);
if (updateEvent == null)
{
continue;
}
object newValue = element.GetXElement(tagName);
BsoArchiveEntities.UpdateObject(updateEvent, newValue, columnName);
}
}
private void PopulateDatabase(string xmlPath)
{
Log.Debug(string.Format("Started import of file: {0}", xmlPath));
var doc = XDocument.Load(xmlPath);
var events = doc.Root.Descendants(Constants.Event.eventElement);
foreach (XElement node in events)
{
Event eventItem = Event.GetEventFromNodeItem(node);
try
{
AddEventVenue(eventItem, node);
AddEventConductor(eventItem, node);
AddEventArtist(eventItem, node);
AddEventOrchestra(eventItem, node);
AddEventTypeGroup(eventItem, node);
AddEventType(eventItem, node);
AddEventSeason(eventItem, node);
AddEventProject(eventItem, node);
AddEventWorkItems(eventItem, node);
AddEventParticipant(eventItem, node);
AddEventSeries(eventItem, node);
}
catch (System.Exception e)
{
Log.Error("Suppressed exception", e);
}
try
{
BsoArchiveEntities.Current.Save();
}
catch (System.Exception ex)
{
Log.Error("Suppressed exception", ex);
}
}
Log.Debug(string.Format("Finished import of file: {0}", xmlPath));
}