public override string[] LoadCprNumbers()
{
using (var dataContext = new CprBroker.Data.Part.PartDataContext(BrokerConnectionString))
{
return(dataContext.PersonRegistrations
.Select(pr => pr.UUID.ToString()).Distinct().OrderBy(pr => pr).ToArray());
}
}
public override void ProcessPerson(string uuid)
{
using (var dataContext = new CprBroker.Data.Part.PartDataContext(BrokerConnectionString))
{
var reg = dataContext.PersonRegistrations.Where(pr => pr.UUID == new Guid(uuid))
.OrderByDescending(pr => pr.RegistrationDate)
.ThenByDescending(pr => pr.BrokerUpdateDate)
.First();
dataContext.ExecuteCommand("UPDATE PersonRegistration SET Contents = Contents WHERE UUID={0} AND PersonRegistrationId = {1}", uuid, reg.PersonRegistrationId);
}
}
public void PreLoadExistingMappings()
{
using (var dataContext = new CprBroker.Data.Part.PartDataContext())
{
var all = dataContext.PersonMappings.Select(pm => new KeyValuePair <string, Guid>(pm.CprNumber, pm.UUID)).ToArray();
int count = all.Length;
Console.WriteLine("Found <{0}> mappings", count);
for (int i = 0; i < count; i++)
{
_Cache[all[i].Key] = all[i].Value;
if (i % 10000 == 9999)
{
Console.WriteLine("UUID Cache : <{0}> rows loaded", _Cache.Count);
}
}
}
}
