public async Task <bool> Handle(SeedCommand request, CancellationToken cancellationToken)
{
Consoler.TitleStart("seed database start");
var companies = CompanySpreadsheet.Import();
//var chance = new ChanceNET.Chance();
//var companies = new List<Company> {chance.Object<Company>()};
var bus = IocContainer.Container.Resolve <ICommandBus>();
/*
*
* DRGD - De-registered.
* EXAD - External administration (in receivership/liquidation).
* NOAC - Not active.
* NRGD - Not registered.
* PROV - Provisional (mentioned only under charges and refers
* to those which have not been fully registered).
* REGD – Registered.
* SOFF - Strike-off action in progress.
* DISS - Dissolved by Special Act of Parliament.
* DIV3 - Organisation Transferred Registration via DIV3.
* PEND - Pending - Schemes.
*
*/
foreach (var company in companies)//.Where(x=>x.Status =="REGD"))
{
var command = new CreateCompanyCommand(CompanyId.New)
{
Company = company
};
try
{
AsyncUtil.RunSync(() => bus.PublishAsync(command, cancellationToken));
await Task.CompletedTask;
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
Consoler.TitleEnd("seed database finished");
return(true);
}
private static void ExtractCompanies()
{
foreach (var item in CompanySpreadsheet.Import()
.Where(x => x.CompanyName.ToLowerInvariant().StartsWith(Letter))
//.Skip(000)
//.Take(1000)
)
{
item.Id = Guid.NewGuid();
_busControl.Publish(new CompanyRequest
{
Company = item
});
_busControl.Publish(new GoogleApiSearchRequest
{
SearchTerm = item.CompanyName
});
}
}
/// <summary>
/// DRGD - De-registered.
// EXAD - External administration(in receivership/liquidation).
// NOAC - Not active.
// NRGD - Not registered.
// PROV - Provisional (mentioned only under charges and refers
// to those which have not been fully registered).
// REGD – Registered.
// SOFF - Strike-off action in progress.
// DISS - Dissolved by Special Act of Parliament.
// DIV3 - Organisation Transferred Registration via DIV3.
// PEND - Pending - Schemes.
/// </summary>
private void ImportCompanies()
{
foreach (var item in CompanySpreadsheet.Import().Where(x => x.Status == ""))
{
var found = _companiesRepository
.Find(x => x.CompanyName == item.CompanyName && x.Status == "REGD");
var xxx = found.ToList();
if (xxx.Any())
{
Log.Debug("CompanyName skipped {desc}", item.CompanyName);
continue;
}
Util.WaitFor(1);
item.Id = Guid.NewGuid();
Log.Information(item.ToString());
_busControl.Publish(new CompanyRequest
{
Company = item.TrimAllStrings()
});
_companiesRepository.Insert(item);
}
}
