public async Task <int> Extract(DbExtract extract, DbProtocol dbProtocol)
{
var mapper = dbProtocol.SupportsDifferential ? ExtractDiffMapper.Instance : ExtractMapper.Instance;
int batch = 500;
DomainEvents.Dispatch(new HtsNotification(new ExtractProgress(nameof(HtsClientLinkage), "extracting...")));
//DomainEvents.Dispatch(new CbsStatusNotification(extract.Id,ExtractStatus.Loading));
var list = new List <TempHtsClientLinkage>();
int count = 0;
int totalCount = 0;
using (var rdr = await _reader.ExecuteReader(dbProtocol, extract))
{
while (rdr.Read())
{
totalCount++;
count++;
// AutoMapper profiles
var extractRecord = mapper.Map <IDataRecord, TempHtsClientLinkage>(rdr);
extractRecord.Id = LiveGuid.NewGuid();
list.Add(extractRecord);
if (count == batch)
{
// TODO: batch and save
_extractRepository.BatchInsert(list);
try
{
DomainEvents.Dispatch(new HtsNotification(new ExtractProgress(nameof(HtsClientLinkage), "extracting...", totalCount, count, 0, 0, 0)));
}
catch (Exception e)
{
Log.Error(e, "Notification error");
}
count = 0;
list = new List <TempHtsClientLinkage>();
}
// TODO: Notify progress...
}
if (count > 0)
{
_extractRepository.BatchInsert(list);
}
_extractRepository.CloseConnection();
}
try
{
DomainEvents.Dispatch(new HtsNotification(new ExtractProgress(nameof(HtsClientLinkage), "extracted", totalCount, 0, 0, 0, 0)));
DomainEvents.Dispatch(new HtsStatusNotification(extract.Id, ExtractStatus.Found, totalCount));
DomainEvents.Dispatch(new HtsStatusNotification(extract.Id, ExtractStatus.Loaded, totalCount));
}
catch (Exception e)
{
Log.Error(e, "Notification error");
}
return(totalCount);
}
