public static Balance MapFrom(FS.Domain.Model.Balance model)
{
if (model is null)
{
return(null);
}
return(new Balance()
{
Id = model.Id,
Value = model.Value,
UserId = model.UserId,
AccountId = model.AccountId,
CreatedOn = model.CreatedOn,
UpdatedOn = model.UpdatedOn
});
}
public async Task Update(Guid id, FS.Domain.Model.Balance model)
{
var sql = $"UPDATE {table} SET Value = @value, UpdatedOn = @updatedOn WHERE ID = @id";
await using var connection = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection"));
connection.Open();
var dictionary = new Dictionary <string, object>
{
{ "@id", id },
{ "@value", model.Value },
{ "@updatedOn", model.UpdatedOn },
};
var parameters = new DynamicParameters(dictionary);
await connection.ExecuteScalarAsync <Balance>(sql, parameters);
await Task.CompletedTask;
}
public async Task Insert(FS.Domain.Model.Balance model)
{
var sql = $"INSERT INTO {table} (Id, AccountId, UserId, Value, CreatedOn)" +
$" VALUES (@id, @accountId, @userId, @value, @createdOn)";
await using var connection = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection"));
connection.Open();
var dictionary = new Dictionary <string, object>
{
{ "@id", model.Id },
{ "@accountId", model.AccountId },
{ "@userId", model.UserId },
{ "@value", model.Value },
{ "@createdOn", model.CreatedOn },
};
var parameters = new DynamicParameters(dictionary);
await connection.ExecuteScalarAsync <Balance>(sql, parameters);
await Task.CompletedTask;
}
