public async Task UpdateAsync(ITradingRoute tradingRoute)
{
using (var conn = new SqlConnection(_connectionString))
{
await conn.ExecuteAsync(
$"update {TableName} set {GetUpdateClause} where Id=@Id",
_convertService.Convert <ITradingRoute, TradingRouteEntity>(tradingRoute));
}
}
public async Task <bool> TryInsertAsync(ITradingRoute tradingRoute)
{
using (var conn = new SqlConnection(_connectionString))
{
try
{
await conn.ExecuteAsync(
$"insert into {TableName} ({GetColumns}) values ({GetFields})",
_convertService.Convert <ITradingRoute, TradingRouteEntity>(tradingRoute));
}
catch (Exception ex)
{
_log?.WriteWarningAsync(nameof(TradingRoutesRepository), nameof(TryInsertAsync),
$"Failed to insert a trading route with Id {tradingRoute.Id}", ex);
return(false);
}
return(true);
}
}
