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