public async Task <JsonEntityBase> Handle(SaveExecuterCmd request, CancellationToken cancellationToken)
{
if (_validationNotificationContext.HasErrorNotifications)
{
return(_validationNotificationContext.GetErrorNotifications().Error());
}
var model = request.VM;
JobExecuter executer = null;
if (model.IsNew)
{
// add
executer = new JobExecuter()
{
RegistryKey = model.RegistryKey,
InTime = DateTime.Now,
Name = model.ExecuterName,
UpdateTime = DateTime.Now,
Auto = model.Auto
};
await _dbContext.JobExecuter.AddAsync(executer);
if (!model.Auto)
{
var registryHosts = model.RegistryHosts?.Where(x => x.Url.NotNullOrEmpty()).Select(x => new RegistryHost()
{
ExecuterId = executer.Id,
Host = x.Url,
Order = 0
});
if (registryHosts != null && registryHosts.Any())
{
// Z.EntityFramework.Extensions.EFCore.dll is commercial and required payment
//await _dbContext.RegistryHost.BulkInsertAsync(registryHosts, options =>
//{
// options.InsertIfNotExists = true;
// options.ColumnPrimaryKeyExpression = x => x.Host;
//});
_dbContext.ChangeTracker.AutoDetectChangesEnabled = false;
_dbContext.AddRange(registryHosts);
}
}
else
{
var regList = await _dbContext.RegistryInfo.OrderBy(x => x.InTime)
.Where(x => x.Name == model.RegistryKey).ToListAsync();
if (regList != null && executer != null)
{
var registryHosts = regList.Select(x => new RegistryHost()
{
ExecuterId = executer.Id,
Host = x.Host,
Order = 0
});
// Z.EntityFramework.Extensions.EFCore.dll is commercial and required payment
//await _dbContext.RegistryHost.BulkInsertAsync(registryHosts, options =>
//{
// options.InsertIfNotExists = true;
// options.ColumnPrimaryKeyExpression = x => x.Host;
//});
_dbContext.ChangeTracker.AutoDetectChangesEnabled = false;
_dbContext.AddRange(registryHosts);
}
}
}
else
{
executer = await _dbContext.JobExecuter.Include(x => x.RegistryHosts).FirstOrDefaultAsync(x => x.Id == model.ExecuterId);
executer.RegistryKey = model.RegistryKey;
executer.Name = model.ExecuterName;
executer.UpdateTime = DateTime.Now;
executer.Auto = model.Auto;
if (!model.Auto && model.RegistryHosts != null)
{
var registryHosts = model.RegistryHosts.Where(x => x.Url.NotNullOrEmpty())
.Select(x => new RegistryHost()
{
ExecuterId = executer.Id,
Host = x.Url,
Order = 0,
Id = x.Id
});
if (registryHosts != null && registryHosts.Any())
{
// Z.EntityFramework.Extensions.EFCore.dll is commercial and required payment
// BLT.EntityFramework.Extensions.EFCore.dll was hack this code:
// if (LicenseManager.\uE000.Count == 0)
// {
// if (DateTime.Now < new DateTime(2199, 2, 1))
//await _dbContext.RegistryHost.BulkMergeAsync(registryHosts, options =>
//{
// options.InsertIfNotExists = true;
// options.ColumnPrimaryKeyExpression = x => x.Host;
//});
_dbContext.ChangeTracker.AutoDetectChangesEnabled = false;
var groups = registryHosts.GroupBy(x => x.Id == 0).ToDictionary(x => x.Key, y => y.ToList());
if (groups.ContainsKey(true) && groups[true].Any())
{
_dbContext.AddRange(groups[true]);
}
if (groups.ContainsKey(false) && groups[false].Any())
{
_dbContext.UpdateRange(groups[false]);
}
}
}
}
await _dbContext.SaveChangesAsync();
return(new { }.Success());
}