public async Task <TranslationTrouble> GetByIDAsync(Guid id) { try { string sqlQery = "SELECT * FROM translations_troubles WHERE Id = @Id"; TranslationTrouble trouble = null; using (var dbConnection = new NpgsqlConnection(connectionString)) { var param = new { id }; this.LogQuery(sqlQery, param); trouble = dbConnection.Query <TranslationTrouble>(sqlQery, param).FirstOrDefault(); } return(trouble); } catch (NpgsqlException exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(TranslationTroubleRepository)}.{nameof(TranslationTroubleRepository.GetByIDAsync)} {nameof(NpgsqlException)} ", exception); return(null); } catch (Exception exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(TranslationTroubleRepository)}.{nameof(TranslationTroubleRepository.GetByIDAsync)} {nameof(Exception)} ", exception); return(null); } }
public async Task <Guid?> AddNewGlossaryAsync(TranslationTrouble trouble) { try { return(await _translationTroubleRepository.AddAsync(trouble)); } catch (Exception exception) { throw new Exception(WriteLn(exception.Message, exception), exception); } }
public async Task <bool> UpdateAsync(TranslationTrouble item) { try { using (var dbConnection = new NpgsqlConnection(connectionString)) { var _sql = "UPDATE translations_troubles" + " SET id_trouble = @ID_Trouble, trouble = @Trouble, id_translation = @ID_Translation" + " WHERE id = @ID"; var _params = new { item.ID_Trouble, item.Trouble, item.ID_Translation, ID = item.id }; LogQuery(_sql, _params); await dbConnection.ExecuteScalarAsync <Guid>(_sql, _params); return(true); } } catch (NpgsqlException exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(TranslationTroubleRepository)}.{nameof(TranslationTroubleRepository.UpdateAsync)} {nameof(NpgsqlException)} ", exception); return(false); } catch (Exception exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(TranslationTroubleRepository)}.{nameof(TranslationTroubleRepository.UpdateAsync)} {nameof(Exception)} ", exception); return(false); } }
public async Task <Guid?> AddAsync(TranslationTrouble item) { try { using (var dbConnection = new NpgsqlConnection(connectionString)) { var _sql = "INSERT INTO translations_troubles" + " (id_trouble, trouble, id_translation) " + "VALUES (@ID_Trouble, @Trouble, @ID_Translation) RETURNING id"; var _params = new { item.ID_Trouble, item.Trouble, item.ID_Translation }; LogQuery(_sql, _params); var insertedId = await dbConnection.ExecuteScalarAsync <Guid>(_sql, _params); return(insertedId); } } catch (NpgsqlException exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(TranslationTroubleRepository)}.{nameof(TranslationTroubleRepository.AddAsync)} {nameof(NpgsqlException)} ", exception); return(null); } catch (Exception exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(TranslationTroubleRepository)}.{nameof(TranslationTroubleRepository.AddAsync)} {nameof(Exception)} ", exception); return(null); } }