/// <summary>
/// Return participant based on id
/// </summary>
/// <param name="artistID"></param>
/// <remarks>
/// Takes an int id and checks to see if an participant with that id already exists in the entity.
/// If it does then return it. Otherwise create a new instance of participant and return it.
/// </remarks>
/// <returns></returns>
internal static Participant GetParticipantByID(int participantID)
{
Participant participant = BsoArchiveEntities.Current.Participants.FirstOrDefault(a => a.ParticipantID == participantID) ??
Participant.NewParticipant();
return(participant);
}
/// <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();
}