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); }