public async Task CleanAsync(SetorContext context, IHostingEnvironment env, IOptions <SetorSettings> settings, ILogger <SetorContextSeed> logger)
{
var policy = CreatePolicy(logger, nameof(SetorContextSeed));
try {
await policy.ExecuteAsync(async() =>
{
var useCustomizationData = settings.Value.UseCustomizationData;
var contentRootPath = env.ContentRootPath;
context.SetorItems.FromSql("SELECT * FROM SETOR");
IEnumerable <SetorItem> st;
st = useCustomizationData ? GetSetorItemsFromFile(contentRootPath, context, logger) : GetPreconfiguredItems();
foreach (SetorItem it in st)
{
var item = await context.SetorItems.SingleOrDefaultAsync(ci => ci.id_Setor == it.id_Setor);
if (item != null)
{
context.SetorItems.Remove(item);
}
}
await context.SaveChangesAsync();
});
}
catch (DbUpdateConcurrencyException ex)
{
}
}
public async Task SeedAsync(SetorContext context, IHostingEnvironment env, IOptions <SetorSettings> settings, ILogger <SetorContextSeed> logger)
{
var policy = CreatePolicy(logger, nameof(SetorContextSeed));
await policy.ExecuteAsync(async() =>
{
var useCustomizationData = settings.Value.UseCustomizationData;
var contentRootPath = env.ContentRootPath;
await context.SetorItems.AddRangeAsync(useCustomizationData
? GetSetorItemsFromFile(contentRootPath, context, logger)
: GetPreconfiguredItems());
await context.SaveChangesAsync();
});
}
private IEnumerable <SetorItem> GetSetorItemsFromFile(string contentRootPath, SetorContext context, ILogger <SetorContextSeed> logger)
{
string csvFileSetorItems = Path.Combine(contentRootPath, "Setup", "SetorItems.csv");
if (!File.Exists(csvFileSetorItems))
{
return(GetPreconfiguredItems());
}
string[] csvheaders;
try
{
string[] requiredHeaders = { "id_empresa", "id_setor", "nome_setor" };
string[] optionalheaders = { };
csvheaders = GetHeaders(csvFileSetorItems, requiredHeaders, optionalheaders);
}
catch (Exception ex)
{
logger.LogError(ex.Message);
return(GetPreconfiguredItems());
}
return(File.ReadAllLines(csvFileSetorItems)
.Skip(1) // skip header row
.Select(row => Regex.Split(row, ",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)"))
.Select(column => CreateSetorItem(column, csvheaders))
.Where(x => x != null));
}
public EmpresaInclusaoIntegrationEventHandler(SetorContext setorContext, ISetorIntegrationEventService setorIntegrationEventService)
{
_setorContext = setorContext;
_setorIntegrationEventService = setorIntegrationEventService;
}
