public static void ExtractLoadChapterPublications()
{
// Read file
var engine = new FileHelperEngine<MavroRecord>();
var results = engine.ReadFile(@"C:\temp\beholderArchiveUrl.csv").Where(r => r.RecordType == "CHAPTER");
var records = results as IList<MavroRecord> ?? results.ToList().Take(10);
using (var db = new AppContext())
{
foreach (var record in records)
{
var chapter = db.Chapters.Find(Convert.ToInt32(record.Id));
Console.WriteLine("Creating publication for chapter: {0}: Id: {1}", chapter.ChapterName, chapter.Id);
using (var client = new WebClient())
{
byte[] buffer = client.DownloadData(record.Url);
const int userId = 1;
var rel = new ChapterMediaPublishedRel()
{
ChapterId = chapter.Id,
RelationshipTypeId = 99,
MediaPublished = new MediaPublished()
{
MediaTypeId = 4,
ConfidentialityTypeId = 4,
DateCreated = DateTime.Now,
DateModified = DateTime.Now,
CreatedUserId = userId,
Name = "MavroImport-Chapter-" + chapter.ChapterName
}
};
db.ChapterMediaPublishedRels.AddOrUpdate(rel);
db.SaveChanges();
var context = new MediaPublishedContext()
{
ContextText = buffer,
MimeTypeId = 7,
DocumentExtension = ".pdf",
FileStreamID = Guid.NewGuid(),
FileName = "MavroImport-Chapter-" + chapter.ChapterName + ".pdf",
MediaPublishedId = rel.MediaPublishedId
};
db.MediaPublishedContexts.Add(context);
db.SaveChanges();
Console.WriteLine("Created publication {0}", rel.MediaPublished);
}
}
}
}
private static void ExtractLoadPersonPublications()
{
// Read file
var engine = new FileHelperEngine<MavroRecord>();
var results = engine.ReadFile(@"C:\temp\beholderArchiveUrl.csv").Where(r => r.RecordType == "PERSON");
var records = results as IList<MavroRecord> ?? results.ToList();
using (var db = new AppContext())
{
foreach (var record in records.Take(1))
{
var beholderPerson = db.BeholderPeople.Find(Convert.ToInt32(record.Id));
var commonPerson = db.CommonPeople.Find(beholderPerson.PersonId);
Console.WriteLine("Creating item for Person: {0}: BeholderId: {1}", commonPerson.FullName, beholderPerson.Id);
using (var client = new WebClient())
{
byte[] buffer = client.DownloadData(record.Url);
const int userId = 1;
var rel = new PersonMediaPublishedRel()
{
PersonId = beholderPerson.Id,
RelationshipTypeId = 99,
MediaPublished = new MediaPublished()
{
MediaTypeId = 4,
ConfidentialityTypeId = 4,
DateCreated = DateTime.Now,
DateModified = DateTime.Now,
CreatedUserId = userId,
Name = "MavroImport-Person-" + commonPerson.LName
}
};
db.PersonMediaPublishedRels.AddOrUpdate(rel);
db.SaveChanges();
var context = new MediaPublishedContext()
{
ContextText = buffer,
MimeTypeId = 7,
DocumentExtension = ".pdf",
FileStreamID = Guid.NewGuid(),
FileName = "MavroImport-Person-" + commonPerson.FullName + ".pdf",
MediaPublishedId = rel.MediaPublishedId
};
db.MediaPublishedContexts.Add(context);
db.SaveChanges();
}
}
}
}
