public string RunImport(bool update)
{
try
{
Log.Info(string.Format("Starting Import - update = {0}", update.ToString()));
if (update)
{
var updateData = new OPASUpdate();
updateData.UpdateOPASData();
}
else
{
var importData = new ImportOPASData();
importData.Initialize();
importData.Import();
}
}
catch (Exception ex)
{
Log.Error("Import Error", ex);
return(ex.Message);
}
Log.Info("Import Complete.");
return("Success");
}
public void AddEventWorkTest()
{
//var xmlTestPath = "C:\\working\\BSO\\BSO.Archive\\OPASData\\WorkItemTest.xml";
var workId = Helper.CreateXElement(Constants.Work.workIDElement, "-1");
var workGroupID = new System.Xml.Linq.XElement(Constants.Work.workGroupIDElement, "-1");
var workItem = new System.Xml.Linq.XElement(Constants.Work.workElement, workId, workGroupID);
var node = new System.Xml.Linq.XElement(Constants.Event.eventElement, workItem);
ImportOPASData testOPAS = new ImportOPASData();
Event evt = Event.GetEventByID(-1);
if (evt.IsNew)
{
evt.EventID = -1;
evt.EventDate = DateTime.Today;
}
//System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Load(xmlTestPath);
//System.Xml.Linq.XElement node = doc.Root.Element("eventItem");
testOPAS.AddEventWorkItems(evt, node);
var eventWork = evt.EventWorks.First();
var work = eventWork.Work;
Assert.IsTrue(evt.EventWorks.Count == 1);
BsoArchiveEntities.Current.DeleteObject(eventWork);
BsoArchiveEntities.Current.DeleteObject(work);
BsoArchiveEntities.Current.DeleteObject(evt);
}
static void Main(string[] args)
{
Console.WriteLine(DateTime.Now);
var opasData = new ImportOPASData();
opasData.Import();
Console.WriteLine(DateTime.Now);
Console.Read();
}
public void AddEventSeasonTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventNote = "BSO AddEventConductorTest";
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement("eventItem", new System.Xml.Linq.XElement("eventSeason",
new System.Xml.Linq.XElement("eventSeasonId", "-1"),
new System.Xml.Linq.XElement("eventSeasonName", "TestSeasonName"),
new System.Xml.Linq.XElement("eventSeasonCode", "TestSeasonCode")));
var season = importOPAS.AddEventSeason(evt, node);
Assert.IsTrue(evt.Season == season);
}
public void AddEventTypeGroupTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventNote = "BSO AddEventConductorTest";
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement("eventItem", new System.Xml.Linq.XElement("eventTypeGroup",
new System.Xml.Linq.XElement("eventTypeGroupID", "-1"),
new System.Xml.Linq.XElement("eventTypeGroupName", "TestTypeGroupName"),
new System.Xml.Linq.XElement("eventTypeGroupName2", "TestTypeGroupName2")));
var eventTypeGroup = importOPAS.AddEventTypeGroup(evt, node);
Assert.IsTrue(evt.EventTypeGroup == eventTypeGroup);
}
public void AddEventSeriesTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventDate = DateTime.Today;
evt.EventNote = "BSO AddEventSeriesTest";
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement("eventItem", new System.Xml.Linq.XElement("eventSeries",
new System.Xml.Linq.XElement("eventSeriesName", "Testing Series Name")
));
var series = importOPAS.AddEventSeries(evt, node);
Assert.IsTrue(String.Compare(evt.EventSeries, "Testing Series Name") == 0);
}
public void AddEventProjectTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventNote = "BSO AddEventConductorTest";
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement("eventItem", new System.Xml.Linq.XElement("eventProject",
new System.Xml.Linq.XElement("eventProjectID", "-1"),
new System.Xml.Linq.XElement("eventProjectName", ""),
new System.Xml.Linq.XElement("eventProjectName2", "TestProjectName"),
new System.Xml.Linq.XElement("eventProjectTypeName", "TestProjectTypeName")));
var project = importOPAS.AddEventProject(evt, node);
Assert.IsTrue(evt.Project == project);
}
public void AddEventVenueTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventNote = "BSO AddEventVenueTest";
var venueID = Helper.CreateXElement(Constants.Venue.venueIDElement, "-1");
var venueName = Helper.CreateXElement(Constants.Venue.venueNameElement, "TestName");
var venueCode = Helper.CreateXElement(Constants.Venue.venueCodeElement, "Test Venue Code");
var venueElement = new System.Xml.Linq.XElement(Constants.Venue.venueElement, venueID, venueName, venueCode);
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement(Constants.Event.eventElement, venueElement);
Venue venue = importOPAS.AddEventVenue(evt, node);
Assert.IsTrue(evt.Venue == venue);
}
public void AddEventOrchestra()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventNote = "BSO AddEventArtistTest";
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement("eventItem", new System.Xml.Linq.XElement("eventOrchestra",
new System.Xml.Linq.XElement("eventOrchestraID", "-1"),
new System.Xml.Linq.XElement("eventOrchestraName", "TestOrchestraName"),
new System.Xml.Linq.XElement("eventOrchestraURL", "TestOrchestraURL"),
new System.Xml.Linq.XElement("eventOrchestraNotes", "TestOrchestraNotes")
));
var orchestra = importOPAS.AddEventOrchestra(evt, node);
Assert.IsTrue(evt.Orchestra == orchestra);
}
public void AddEventArtistTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = Event.GetEventByID(-1);
if (evt.IsNew)
{
evt.EventID = -1;
}
evt.EventNote = "BSO AddEventArtistTest";
evt.EventDate = DateTime.Today;
var artistId = Helper.CreateXElement(Constants.Artist.artistIDElement, "-1");
var artistFirstName = Helper.CreateXElement(Constants.Artist.artistFirstNameElement, "TestFName");
var artistLastName = Helper.CreateXElement(Constants.Artist.artistLastNameElement, "TestLCode");
var artistNotes = Helper.CreateXElement(Constants.Artist.artistNoteElement, "TestNotes");
var artistInstrument = Helper.CreateXElement(Constants.Artist.artistInstrumentElement, "TestInstr");
var artistInstrument2 = Helper.CreateXElement(Constants.Artist.artistInstrument2Element, "TestInstr2");
var artistInstrumentID = Helper.CreateXElement(Constants.Artist.artistInstrumentIDElement, "-1");
var artistItem = new System.Xml.Linq.XElement(Constants.Artist.artistElement, artistId, artistFirstName, artistLastName, artistNotes, artistInstrument, artistInstrument2, artistInstrumentID);
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement(Constants.Event.eventElement, artistItem);
importOPAS.AddEventArtist(evt, node);
Assert.IsTrue(evt.EventArtists.Count == 1);
//BsoArchiveEntities.Current.DeleteObject(evt);
var eventArtist = evt.EventArtists.First();
var artist = eventArtist.Artist;
var instrument = eventArtist.Instrument;
BsoArchiveEntities.Current.DeleteObject(instrument);
BsoArchiveEntities.Current.DeleteObject(artist);
BsoArchiveEntities.Current.DeleteObject(eventArtist);
BsoArchiveEntities.Current.DeleteObject(evt);
BsoArchiveEntities.Current.Save();
}
public void AddEventConductorTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = new Event();
evt.EventDate = DateTime.Today;
evt.EventNote = "BSO AddEventConductorTest";
System.Xml.Linq.XElement node = new System.Xml.Linq.XElement("eventItem", new System.Xml.Linq.XElement("eventConductor",
new System.Xml.Linq.XElement("eventConductorID", "-1"),
new System.Xml.Linq.XElement("eventConductorFirstname", "TestFName"),
new System.Xml.Linq.XElement("eventConductorLastName", "TestLCode"),
new System.Xml.Linq.XElement("eventConductorNotes", "TestNotes")
));
var conductor = importOPAS.AddEventConductor(evt, node);
Assert.IsTrue(evt.Conductor == conductor);
}
public void AddEventParticipantTest()
{
ImportOPASData importOPAS = new ImportOPASData();
Event evt = Event.GetEventByID(-1);
if (evt.IsNew)
{
evt.EventNote = "BSO AddEventParticipantTest";
evt.EventDate = DateTime.Today;
evt.EventID = -1;
}
Assert.IsTrue(evt.EventParticipants.Count == 0);
var participantID = Helper.CreateXElement(Constants.Participant.participantIDElement, "-1");
var participantFirstName = Helper.CreateXElement(Constants.Participant.participantFirstNameElement, "TestFName");
var participantLastName = Helper.CreateXElement(Constants.Participant.participantLastNameElement, "TestLName");
var participantGroup = Helper.CreateXElement(Constants.Participant.participantGroupNameElement, "TestGroup");
var participantStatusID = Helper.CreateXElement(Constants.Participant.participantStatusIDElement, "-1");
var participantStatus = Helper.CreateXElement(Constants.Participant.participantStatusElement, "1");
var participantItem = new System.Xml.Linq.XElement(Constants.Participant.participantElement, participantID, participantFirstName, participantLastName,
participantGroup, participantStatus, participantStatusID);
var node = new System.Xml.Linq.XElement(Constants.Event.eventElement, participantItem);
importOPAS.AddEventParticipant(evt, node);
Assert.IsTrue(evt.EventParticipants.Count == 1);
Assert.IsTrue(evt.EventParticipantTypes.Count == 1);
var participant = evt.EventParticipants.First();
var participantType = evt.EventParticipantTypes.First();
BsoArchiveEntities.Current.DeleteObject(participant);
BsoArchiveEntities.Current.DeleteObject(participantType);
BsoArchiveEntities.Current.DeleteObject(evt);
BsoArchiveEntities.Current.Save();
}
