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