/// <summary> /// Checks existing Project based upon the given ID. If the Project /// already exists then return it. Otherwise create a new Project /// and return it. /// </summary> /// <param name="projectID"></param> /// <returns></returns> internal static Project GetProjectByID(int projectID) { Project project = BsoArchiveEntities.Current.Projects.FirstOrDefault(p => p.ProjectID == projectID) ?? Project.NewProject(); return(project); }
/// <summary> /// Update OPAS Data /// </summary> public void UpdateOPASData(XDocument loadDocument) { var recordsToUpdate = BsoArchiveEntities.Current.OPASUpdates.Where(d => !d.HasBeenUpdated); var entitesToUpdate = recordsToUpdate.GroupBy(d => d.TableName); foreach (var entity in entitesToUpdate) { Log.Debug(string.Format("Started update processing of entity: {0}", entity.Key)); string columnName = entity.FirstOrDefault().ColumnName; string tagName = entity.FirstOrDefault().TagName; switch ((Table)Enum.Parse(typeof(Table), entity.Key.ToUpper())) { case Table.EVENT: opasData = Event.NewEvent(); break; case Table.ARTIST: opasData = Artist.NewArtist(); break; case Table.EVENTTYPE: opasData = EventType.NewEventType(); break; case Table.CONDUCTOR: opasData = Conductor.NewConductor(); break; case Table.ORCHESTRA: opasData = Orchestra.NewOrchestra(); break; case Table.PARTICIPANT: opasData = Participant.NewParticipant(); break; case Table.PROJECT: opasData = Project.NewProject(); break; case Table.SEASON: opasData = Season.NewSeason(); break; case Table.EVENTTYPEGROUP: opasData = EventTypeGroup.NewEventTypeGroup(); break; case Table.VENUE: opasData = Venue.NewVenue(); break; case Table.WORK: opasData = Work.NewWork(); break; case Table.WORKARTIST: opasData = WorkArtist.NewWorkArtist(); break; } opasData.UpdateData(loadDocument, columnName, tagName); entity.FirstOrDefault().HasBeenUpdated = true; BsoArchiveEntities.Current.Detach(opasData); Log.Debug(string.Format("Finished update processing of entity: {0}", entity.Key)); } BsoArchiveEntities.Current.Save(); }