public async Task RebuildSearchLegalPartyIndexByLegalPartyId(IEnumerable <int> legalPartyIdList)
{
_context.Database.SetCommandTimeout(_timeout);
var idList = string.Join(",", legalPartyIdList);
_logger.LogDebug($"Id List: {idList}");
var sql = string.Format(RebuildSearchLegalPartyIndex.GetRebuildVersion(), idList);
//File.WriteAllText(@"d:\rebuildQueryFinal.sql", sql);
await _context.Database.ExecuteSqlCommandAsync(sql);
}
public async Task RebuildSearchLegalPartyIndexAll()
{
_context.Database.SetCommandTimeout(_timeout);
try
{
await _context.Database.ExecuteSqlCommandAsync(RebuildSearchLegalPartyIndex.GetRebuildAllVersion());
}
catch (SqlException e)
{
if (e.Number != int.Parse(RebuildSearchLegalPartyIndex.SqlErrorNumberForLocked))
{
throw;
}
_logger.LogInformation(e.Message);
throw new LockedException(e.Message);
}
}
