private static void ExtractLoadPersonPublications()
{
var results = GetDataFileResults("PERSON");
using (var db = new AppContext())
{
foreach (var record in results.ToList())
{
var id = Convert.ToInt32(record.Id);
var beholderRecord = db.BeholderPeople.Include("CommonPerson").FirstOrDefault(p => p.Id == id);
if (beholderRecord == null)
{
continue;
}
Console.WriteLine("Creating item for Person: {0}: BeholderId: {1}", beholderRecord.CommonPerson.FullName, beholderRecord.Id);
using (var client = new WebClient())
{
byte[] buffer = client.DownloadData(record.Url);
var rel = new PersonMediaPublishedRel()
{
PersonId = beholderRecord.Id,
RelationshipTypeId = 99,
MediaPublished = new MediaPublished()
{
MediaTypeId = 4,
ConfidentialityTypeId = 4,
DateCreated = DateTime.Now,
DateModified = DateTime.Now,
CreatedUserId = CreatedUserId,
Name = "MavroImport-Person-" + beholderRecord.CommonPerson.LName
}
};
db.PersonMediaPublishedRels.AddOrUpdate(rel);
db.SaveChanges();
var context = new MediaPublishedContext()
{
ContextText = buffer,
MimeTypeId = 7,
DocumentExtension = ".pdf",
FileStreamID = Guid.NewGuid(),
FileName = "MavroImport-Person-" + beholderRecord.CommonPerson.FullName + ".pdf",
MediaPublishedId = rel.MediaPublishedId
};
db.MediaPublishedContexts.Add(context);
db.SaveChanges();
}
}
}
}
public void InsertOrUpdatePublished(PersonMediaPublishedRel personmediapublishedrel)
{
if (personmediapublishedrel.Id == default(int))
{
// New entity
_ctx.PersonMediaPublishedRels.Add(personmediapublishedrel);
}
else
{
// Existing entity
_ctx.Entry(personmediapublishedrel).State = EntityState.Modified;
}
}
