public static void AddAliasList(Chapter chapter, ICollection<AliasChapterRel> list)
{
foreach (var rel in list)
{
var c = rel;
var @alias = new ChapterAlias()
{
Id = c.AliasId,
Name = c.Alias.AliasName,
PrimaryStatus = (PrimaryStatus)c.PrimaryStatusId,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified
};
chapter.ChapterAliases.Add(@alias);
chapter.LogEntries.Add(new ChapterLogEntry()
{
Note = $"Added Chapter {chapter.Name} alias {@alias.Name}"
});
}
}
public static void AddAddress(Chapter chapter, ICollection<AddressChapterRel> list)
{
foreach (var item in list)
{
var addr = new ChapterAddress()
{
Street = item.Address.Address1,
Street2 = item.Address.Address2,
City = item.Address.City,
StateId = item.Address.StateId,
County = item.Address.County,
ZipCode = $"{item.Address.Zip5}-{item.Address.Zip4}",
Country = item.Address.Country,
Latitude = item.Address.Latitude,
Longitude = item.Address.Longitude,
DateCreated = item.Address.DateCreated,
DateUpdated = item.Address.DateModified
//todo: need primarystatus here
};
chapter.ChapterAddresses.Add(addr);
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added address" });
}
}
public static void AddChapters(Organization org, ICollection<ChapterOrganizationRel> list)
{
foreach (var rel in list)
{
var c = rel.Chapter;
var chapter = new Domain.Models.Chapter()
{
Id = c.Id,
Name = c.ChapterName,
SecurityLevel = c.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
Description = c.ChapterDesc,
DateFormed = c.FormedDate,
DateDisbanded = c.DisbandDate,
Movement = Helpers.ConvertMovementId(c.MovementClassId),
IsHeadquarters = c.IsHeadquarters,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
OrganizationId = rel.OrganizationId,
Persons = new List<Person>(),
LogEntries = new List<ChapterLogEntry>()
};
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added chapter {chapter.Name}" });
org.Chapters.Add(chapter);
}
}
public static void AddAudioVideo(Chapter chapter, ICollection<ChapterMediaAudioVideoRel> list)
{
foreach (var rel in list)
{
var c = rel.MediaAudioVideo;
var audioVideo = new AudioVideo()
{
Id = c.Id,
Title = c.Title,
Summary = c.Summary,
SpeakerCommentator = c.SpeakerCommentator,
MediaLength = c.MediaLength,
CatalogId = c.CatalogId,
DateReceivedRecorded = c.DateReceivedRecorded,
DateAired = c.DateAired,
AudioVideoType = (AudioVideoType)c.AudioVideoTypeId,
SecurityLevel = c.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
Movement = Helpers.ConvertMovementId(c.MovementClassId),
City = c.City,
County = c.County,
StateId = c.StateId,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<AudioVideoLogEntry>()
};
audioVideo.LogEntries.Add(new AudioVideoLogEntry() { Note = $"Added audio video {audioVideo.Title}" });
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added audio video {audioVideo.Title}" });
chapter.AudioVideos.Add(audioVideo);
}
}
public static void AddWebsites(Chapter chapter, ICollection<ChapterMediaWebsiteEGroupRel> list)
{
foreach (var rel in list)
{
var c = rel.MediaWebsiteEGroup;
var existingWebsite = Helpers.GetWebsite(c.Id);
if (existingWebsite != null)
{
chapter.Websites.Add(existingWebsite);
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added website {existingWebsite.Name} to Chapter" });
return;
}
var website = new Website()
{
Id = c.Id,
Name = c.Name,
Type = (WebsiteType)c.WebsiteEGroupTypeId,
Url = c.URL,
Summary = c.Summary,
DateDiscovered = c.DateDiscovered,
DatePublished = c.DatePublished,
DateOffline = c.DateOffline,
WhoIs = c.WhoIsInfo,
Movement = Helpers.ConvertMovementId(c.MovementClassId),
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<WebsiteLogEntry>()
};
website.LogEntries.Add(new WebsiteLogEntry() { Note = $"Added website {website.Name}" });
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added website {website.Name} to Chapter" });
chapter.Websites.Add(website);
}
}
public static void AddPublished(Chapter chapter, ICollection<ChapterMediaPublishedRel> list)
{
foreach (var rel in list)
{
var c = rel.MediaPublished;
var publication = new Publication()
{
Id = c.Id,
Name = c.Name,
Summary = c.Summary,
DateReceived = c.DateReceived,
DatePublished = c.DatePublished,
Author = c.Author,
CatalogId = c.CatalogId,
RenewalType = Helpers.ConvertRenewalType(c.RenewalPermissionTypeId),
SecurityLevel = c.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
Movement = Helpers.ConvertMovementId(c.MovementClassId),
// PublicationTypeId = c.PublishedTypeId,
City = c.City,
County = c.County,
StateId = c.StateId,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<PublicationLogEntry>()
};
publication.LogEntries.Add(new PublicationLogEntry() { Note = $"Added publication {publication.Name}" });
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added publication {publication.Name}" });
chapter.Publications.Add(publication);
}
}
public static void AddSubscriptions(Chapter chapter, ICollection<ChapterSubscriptionRel> list)
{
foreach (var rel in list)
{
var c = rel.Subscription;
var subscription = new Domain.Models.Subscription()
{
Id = c.Id,
Name = c.PublicationName,
Rate = c.SubscriptionRate,
RenewalDate = c.RenewalPermissionDate,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<SubscriptionLogEntry>()
};
subscription.LogEntries.Add(new SubscriptionLogEntry() { Note = $"Added subscription {subscription.Name}" });
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added subscription {subscription.Name}" });
chapter.Subscriptions.Add(subscription);
}
}
public static void AddPeople(Chapter chapter, ICollection<ChapterPersonRel> list)
{
foreach (var r in list)
{
var p = r.BeholderPerson;
Gender gender;
Enum.TryParse(p.CommonPerson.GenderId.ToString(), out gender);
MaritialStatus maritialStatus;
Enum.TryParse(p.CommonPerson.MaritialStatusId.ToString(), out maritialStatus);
var person = new Person()
{
Id = p.CommonPersonId,
PrefixId = p.CommonPerson.PrefixId,
SuffixId = p.CommonPerson.SuffixId,
FirstName = p.CommonPerson.FName,
MiddleName = p.CommonPerson.MName,
LastName = p.CommonPerson.LName,
DOB = p.CommonPerson.DOB,
ActualDOB = p.CommonPerson.ActualDOBIndicator,
DeceasedDate = p.CommonPerson.DeceasedDate,
ActualDeceasedDate = p.CommonPerson.ActualDeceasedDateIndicator,
Height = p.CommonPerson.Height,
Weight = p.CommonPerson.Weight,
SSN = p.CommonPerson.SSN,
LicenseType = Helpers.GetLicenseType(p.CommonPerson.LicenseTypeId),
DriversLicenseNumber = p.CommonPerson.DriversLicenseNumber,
DriversLicenseStateId = p.CommonPerson.DriversLicenseStateId,
MaritialStatus = maritialStatus,
Gender = gender,
HairColorId = p.CommonPerson.HairColorId,
HairPatternId = p.CommonPerson.HairPatternId,
EyeColorId = p.CommonPerson.EyeColorId,
RaceId = p.CommonPerson.RaceId,
SecurityLevel = p.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
DistinguishableMarks = p.DistinguishableMarks,
Movement = Helpers.ConvertMovementId(p.MovementClassId),
DateCreated = p.CommonPerson.DateCreated,
DateUpdated = p.CommonPerson.DateModified,
LogEntries = new List<PersonLogEntry>()
};
person.LogEntries.Add(new PersonLogEntry() { Note = $"Added person {person.ReverseFullName}" });
chapter.Persons.Add(person);
chapter.LogEntries.Add(new ChapterLogEntry()
{
Note = $"Added Chapter {chapter.Name} person relationship {person.ReverseFullName}"
});
}
}
public static void AddImages(Chapter chapter, ICollection<ChapterMediaImageRel> list)
{
foreach (var rel in list)
{
var c = rel.MediaImage;
var mediaImage = new Domain.Models.MediaImage()
{
Id = c.Id,
Title = c.ImageTitle,
Summary = c.Summary,
FileName = c.ImageFileName,
CatalogId = c.CatalogId,
ContactOwner = c.ContactOwner,
BatchSortOrder = c.BatchSortOrder,
Photographer = c.PhotographerArtist,
DatePublished = c.DatePublished,
DateTaken = c.DateTaken,
RollFrame = c.RollFrameNumber,
ImageType = Helpers.ConvertImageType(c.ImageTypeId),
SecurityLevel = c.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
Movement = Helpers.ConvertMovementId(c.MovementClassId),
//// Image = c.Image.IMAGE1,
// MimeType = c.Image.MimeType.Name, //todo: make type
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<MediaImageLogEntry>()
};
mediaImage.LogEntries.Add(new MediaImageLogEntry() { Note = $"Added image {mediaImage.Title}" });
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added image {mediaImage.Title}" });
chapter.MediaImages.Add(mediaImage);
}
}
public static void AddEvents(Chapter chapter, ICollection<ChapterEventRel> list)
{
foreach (var rel in list)
{
var c = rel.Event;
var @event = new Domain.Models.Event()
{
Id = c.Id,
Name = c.EventName,
Summary = c.Summary,
SecurityLevel = c.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
DocumentationType = (DocumentationType)c.EventDocumentationTypeId,
//todo: EventType
// EventType =
Movement = Helpers.ConvertMovementId(c.MovementClassId),
EventDate = c.EventDate,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<EventLogEntry>()
};
@event.LogEntries.Add(new EventLogEntry() { Note = $"Added event {@event.Name}" });
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added event {@event.Name}" });
chapter.Events.Add(@event);
}
}
public static void AddCorrespondences(Chapter chapter, ICollection<ChapterMediaCorrespondenceRel> list)
{
foreach (var rel in list)
{
var c = rel.MediaCorrespondence;
var correspondence = new Correspondence()
{
Id = c.Id,
Name = c.CorrespondenceName,
CatalogId = c.CatalogId,
DateReceived = c.DateReceived,
Summary = c.Summary,
SecurityLevel = c.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
Sender = c.FromName,
Receiver = c.FromName,
Movement = Helpers.ConvertMovementId(c.MovementClassId),
City = c.City,
County = c.County,
StateId = c.StateId,
DateCreated = c.DateCreated,
DateUpdated = c.DateModified,
LogEntries = new List<CorrespondenceLogEntry>()
};
correspondence.LogEntries.Add(new CorrespondenceLogEntry()
{
Note = $"Added correspondence {correspondence.Name}"
});
chapter.LogEntries.Add(new ChapterLogEntry() { Note = $"Added correspondence {correspondence.Name}" });
chapter.Correspondence.Add(correspondence);
}
}
public static void LoadChapters(int? skip = 0, int? takecount = 0)
{
var startTime = DateTime.Now;
var w = FluentConsole.Instance;
var db = new ACDBContext();
var count = 0;
var savedCount = 0;
if (takecount == 0) takecount = db.Chapters.Count();
var entityName = "Chapter";
using (var context = new AppContext())
{
using (var trans = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Chapters ON");
w.White.Line($"Creating {takecount} {entityName}s");
foreach (var item in db.Chapters.OrderBy(x => x.Id).Skip(skip ?? 0).Take(takecount ?? 0))
{
count++;
var i = context.Chapters.Find(item.Id);
if (i != null)
{
w.Yellow.Line($"Adding {entityName} {count} of {takecount}: {entityName} {i.Name} already exists");
continue;
}
var newItem = new Domain.Models.Chapter()
{
Id = item.Id,
Name = item.ChapterName?.Trim(),
SecurityLevel =
item.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open,
Description = item.ChapterDesc?.Trim(),
DateFormed = item.FormedDate,
DateDisbanded = item.DisbandDate,
Movement = Helpers.ConvertMovementId(item.MovementClassId),
IsHeadquarters = item.IsHeadquarters,
DateCreated = item.DateCreated,
DateUpdated = item.DateModified
};
newItem.LogEntries.Add(new ChapterLogEntry() { Note = $"Added {entityName} {newItem.Name}" });
context.Chapters.Add(newItem);
w.Green.Line($"Adding {count} of {takecount} {entityName}: {newItem.Name}");
savedCount++;
context.SaveChanges();
}
w.Gray.Line($"Saving {entityName}s...");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Chapters OFF");
trans.Commit();
}
var totalTime = DateTime.Now - startTime;
w.Green.Line($"Saved {savedCount} {entityName}s in {totalTime.Hours}:{totalTime.Minutes}:{totalTime.Seconds} ");
w.White.Line(new String('-', 15));
}
}
