public Models.Account UpdateAccount(Models.Account account)
{
string sql = $@"UPDATE dbo.Account
SET TwitchId = @twitchId
WHERE Id = @id";
try
{
_logger.LogDebug($@"{_className}: Updating Account {account.Id} to {account.TwitchId}");
using (var connection = new SqlConnection(_connectionString))
{
connection.Execute(sql, new { id = account.Id, twitchId = account.TwitchId });
}
return(GetAccountById(account.Id));
}
catch (Exception e)
{
_logger.LogError($@"{_className}: Error updating Account {account.Id} - {e.Message}");
return(null);
}
}
public int CreateAccount(Models.Account account)
{
int newId;
string sql = $@"INSERT INTO dbo.Account (@twitchId)
VALUES (@TwitchId)
SELECT CAST(SCOPE_IDENTITY() as int)";
try
{
_logger.LogDebug($@"{_className}: Creating Account {account.TwitchId}");
using (var connection = new SqlConnection(_connectionString))
{
newId = connection.Query <int>(sql, new { twitchId = account.TwitchId }).Single();
}
return(newId);
}
catch (Exception e)
{
_logger.LogError($@"{_className}: Error creating Account {account.TwitchId} - {e.Message}");
return(-1);
}
}
