private void detach_ExtractPersonStagings(ExtractPersonStaging entity)
{
this.SendPropertyChanging();
entity.Extract = null;
}
partial void DeleteExtractPersonStaging(ExtractPersonStaging instance);
partial void InsertExtractPersonStaging(ExtractPersonStaging instance);
partial void UpdateExtractPersonStaging(ExtractPersonStaging instance);
public static void ConvertPersons(int batchSize)
{
Admin.LogFormattedSuccess("ExtractManager.ConvertPersons() started, batch size <{0}>", batchSize);
List <Guid> succeeded = new List <Guid>(), failed = new List <Guid>();
using (var dataContext = new ExtractDataContext())
{
var dataLoadOptions = new System.Data.Linq.DataLoadOptions();
dataLoadOptions.LoadWith <ExtractItem>(ei => ei.Extract);
dataContext.LoadOptions = dataLoadOptions;
var persons = ExtractPersonStaging.SelectTop(dataContext, batchSize);
Admin.LogFormattedSuccess("ExtractManager.ConvertPersons() - <{0}> persons found", persons.Length);
var conversionExtracts = ExtractConversion.CreateFromPersonStagings(persons);
ExtractConversion.FillExtractItems(conversionExtracts, dataContext);
// Preload UUIDs
var pnrs = ExtractConversion.AllPNRs(conversionExtracts);
var cache = new UuidCache();
cache.FillCache(pnrs);
int personIndex = 0;
foreach (var personGroup in conversionExtracts)
{
Admin.LogFormattedSuccess("ExtractManager.ConvertPersons() - converting persons from extract <{0}>", personGroup.Extract.ExtractId);
foreach (var person in personGroup.Persons)
{
personIndex++;
try
{
Admin.LogFormattedSuccess("ExtractManager.ConvertPersons() - processing PNR <{0}>, person <{1}> of <{2}>", person.ExtractPersonStaging.PNR, personIndex, persons.Length);
var uuid = cache.GetUuid(person.ExtractPersonStaging.PNR);
var response = Extract.ToIndividualResponseType(person.ExtractPersonStaging.Extract, person.ExtractItems.AsQueryable(), Constants.DataObjectMap);
var oioPerson = response.ToRegistreringType1(cache.GetUuid);
var personIdentifier = new Schemas.PersonIdentifier()
{
CprNumber = person.ExtractPersonStaging.PNR, UUID = uuid
};
UpdateDatabase.UpdatePersonRegistration(personIdentifier, oioPerson);
succeeded.Add(person.ExtractPersonStaging.ExtractPersonStagingId);
Admin.LogFormattedSuccess("ExtractManager.ConvertPersons() - finished PNR <{0}>, person <{1}> of <{2}>", person.ExtractPersonStaging.PNR, personIndex, persons.Length);
}
catch (Exception ex)
{
failed.Add(person.ExtractPersonStaging.ExtractPersonStagingId);
Admin.LogException(ex);
}
}
}
}
// Delete the staging tables from a new data context to maximize performance
using (var dataContext = new ExtractDataContext())
{
var persons = dataContext.ExtractPersonStagings.Where(ep => succeeded.Contains(ep.ExtractPersonStagingId));
dataContext.ExtractPersonStagings.DeleteAllOnSubmit(persons);
dataContext.SubmitChanges();
}
Admin.LogFormattedSuccess("ExtractManager.ConvertPersons() ending, batch size: <{0}>, succeeded: <{1}>, failed: <{2}>", batchSize, succeeded.Count, failed.Count);
}