static void Main(string[] args) { Console.WriteLine(DateTime.Now); var opasData = new ImportOPASData(); opasData.Import(); Console.WriteLine(DateTime.Now); Console.Read(); }
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 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 string RunImport(bool update) { try { if (update) { var updateData = new OPASUpdate(); updateData.UpdateOPASData(); } else { var importData = new ImportOPASData(); importData.Initialize(); importData.Import(); //importData.Finalize(); } } catch (Exception ex) { return ex.Message; } 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); }
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 AddEventTypeTest() { 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("eventType", new System.Xml.Linq.XElement("eventTypeID", "-1"), new System.Xml.Linq.XElement("eventTypeName", "TestTypeName"), new System.Xml.Linq.XElement("eventTypeName2", "TestTypeName2"), new System.Xml.Linq.XElement("eventTypePerformance", "-1"))); var eventType = importOPAS.AddEventType(evt, node); Assert.IsTrue(evt.EventType == eventType); }
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 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 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 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(); }
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); }