public async Task <bool> PostTrackingUpdateDB()
{
try
{
using (var dbCtxScope = _dbContextScopeFactory.Create())
{
SettingsDto versionTask = _settingsService
.GetByKey("CurrentTaskVersion");
string currentVersion = versionTask.Value;
int version = Int32.Parse(currentVersion);
List <string> queries = GetQueryUpdate(version);
foreach (string item in queries)
{
try
{
string query = item.Replace("GO", "");
await _projectCategoryRepository.SqlQueryAsync(typeof(bool), item);
}
catch (Exception ex)
{
_loggerServices.WriteError("PostTrackingUpdateDB at: " + item + " message: " + ex.ToString());
continue;
}
}
return(true);
}
}
catch (Exception ex)
{
_loggerServices.WriteError(ex.ToString());
return(false);
}
}
public SettingsDto GetByKey(string key)
{
var result = new SettingsDto();
using (var scope = _dbContextScopeFactory.CreateReadOnly())
{
var data = _settingsRepository.GetAll().Where(e => key == e.Code).FirstOrDefault();
result = _mapper.Map <SettingsDto>(data);
}
return(result);
}
