private void DeleteWorksWritersAndChildren(Snapshot_WorksRecording recording)
{
var writersForRecording = _snapshotWorksWriterRepository.GetAllWritersForCloneTrackId(recording.CloneTrackId);
foreach (var writer in writersForRecording)
{
//Delete all affiliation list and child if not null
//delete affil;iatio base list
DeleteAllAffiliationsAndChildren(writer);
//Delete knownAs list if not null
var knownAsAll = _snapshotKnownAsRepository.GetAllKnownAsForWriterCaeCode(writer.CloneCaeNumber);
if (knownAsAll != null)
{
foreach (var knownAs in knownAsAll)
{
_snapshotKnownAsRepository.DeleteKnownAsBySnapshotId(knownAs.SnapshotKnownAsId);
}
}
//Delete Original Publiliser list and child if not null
DeleteOriginalPublisherSnapshotAndChildern(writer);
//delete writer
_snapshotWorksWriterRepository.DeleteWorksWriterSnapshotBySnapshotId(writer.SnapshotWorksWriterId);
}
}
public Snapshot_WorksRecording SaveSnapshotWorksRecording(Snapshot_WorksRecording snapshotWorksRecording)
{
using (var context = new DataContext())
{
Logger.Info("Saving Snapshot recording Id: " + snapshotWorksRecording.SnapshotWorksRecodingId);
context.Snapshot_WorksRecordings.Add(snapshotWorksRecording);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Logger.Debug(e.ToString());
throw new Exception(e.ToString());
}
return(snapshotWorksRecording);
}
}
public Snapshot_WorksRecording SaveSnapshotWorksRecording(Snapshot_WorksRecording snapshotWorksRecording)
{
using (var context = new DataContext())
{
Logger.Info("CLONE TRACK ID: " + snapshotWorksRecording.CloneTrackId);
Logger.Info("TRACK ID: " + snapshotWorksRecording.TrackId);
context.Snapshot_WorksRecordings.Add(snapshotWorksRecording);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Logger.Debug(e.ToString());
throw new Exception(e.ToString());
}
return(snapshotWorksRecording);
}
}
private List <Snapshot_WorksRecording> CastToSnapshotRecordings(List <WorksRecording> worksRecording,
int productId, int licenseProductId)
{
var snapshotList = new List <Snapshot_WorksRecording>();
foreach (var rec in worksRecording)
{
var snapshot = new Snapshot_WorksRecording();
snapshot.ProductId = productId;
snapshot.CloneTrackId = rec.TrackId;
snapshot.TrackId = rec.TrackId;
snapshot.LicenseProductId = licenseProductId;
snapshot.CdIndex = rec.CdIndex;
snapshot.UmpgPercentageRollup = (int)rec.UmpgPercentageRollup;
snapshot.CdNumber = rec.CdNumber;
snapshot.LicensedRollup = (int)rec.LicensedRollup;
if (rec.LicenseRecording != null)
{
snapshot.LicenseProductRecordingId = rec.LicenseRecording.LicenseRecordingId;
}
// snapshot.WorkTrackId = rec.TrackId
snapshot.Message = rec.Message;
if (rec.Writers != null)
{
snapshot.Writers = CastToSnapshotWorksWriter(rec.Writers, rec.TrackId);
}
if (rec.Track != null)
{
snapshot.Track = CastToSnapshotWorksTrack(rec.Track, rec.TrackId);
}
snapshotList.Add(snapshot);
}
return(snapshotList);
}
