public static void AddCorrespondences(Organization org, ICollection<OrganizationMediaCorrespondenceRel> 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}" }); org.LogEntries.Add(new OrganizationLogEntry() { Note = $"Added correspondence {correspondence.Name}"}); org.Correspondence.Add(correspondence); } }
public static void LoadCorrespondence(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.MediaCorrespondences.Count(); var entityName = "Correspondence"; using (var context = new AppContext()) { using (var trans = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Correspondences ON"); w.White.Line($"Creating {takecount} {entityName}s"); foreach (var item in db.MediaCorrespondences.Take(takecount ?? 0)) { count++; var i = context.Correspondences.Find(item.Id); if (i != null) { w.Yellow.Line($"Adding {entityName} {count} of {takecount}: {entityName} {i.Name} already exists"); continue; } var newItem = new Correspondence() { Id = item.Id, Name = item.CorrespondenceName?.Trim(), CatalogId = item.CatalogId?.Trim(), DateReceived = item.DateReceived, Summary = item.Summary?.Trim(), SecurityLevel = item.ConfidentialityTypeId == 1 ? SecurityLevel.EyesOnly : SecurityLevel.Open, Sender = item.FromName?.Trim(), Receiver = item.FromName?.Trim(), Movement = Helpers.ConvertMovementId(item.MovementClassId), City = item.City?.Trim(), County = item.County?.Trim(), StateId = item.StateId, DateCreated = item.DateCreated, DateUpdated = item.DateModified }; newItem.LogEntries.Add(new CorrespondenceLogEntry() { Note = $"Added {entityName} {newItem.Name}" }); context.Correspondences.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 Correspondences 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)); } }