public async Task <IActionResult> UpdateBankUser([FromBody] BankUserDto bodyPayload)
{
/* TODO
* Update FK refererences too
* Transaction
*/
long timeStamp = TimeStamp.GetDateTimeOffsetNowAsUnixTimeStampInSeconds();
bodyPayload.ModifiedAt = timeStamp;
using (var connection = _databaseContext.Connection)
{
var result = await connection.ExecuteAsync(@"update BankUser set UserId = @UserId, ModifiedAt = @ModifiedAt where Id = @Id ", bodyPayload);
if (result == 1)
{
return new ObjectResult("BankUser updated.")
{
StatusCode = StatusCodes.Status204NoContent
}
}
;
else
{
return(NotFound("BankUser not found or could not be updated."));
}
}
}
public async Task <IActionResult> CreateBankUser([FromBody] BankUserDto bodyInput)
{
try
{
long timeStamp = TimeStamp.GetDateTimeOffsetNowAsUnixTimeStampInSeconds();
bodyInput.CreatedAt = timeStamp;
bodyInput.ModifiedAt = timeStamp;
using (var connection = _databaseContext.Connection)
{
var result = await connection.ExecuteAsync(@"insert into BankUser (UserId, CreatedAt, ModifiedAt) values (@UserId, @CreatedAt, @ModifiedAt )", bodyInput);
if (result == 1)
{
return new ObjectResult("BankUser created.")
{
StatusCode = StatusCodes.Status204NoContent
}
}
;
else
{
return(NotFound("BankUser could not be created."));
}
}
}
catch (Exception ex)
{
return(NotFound(ex.ToString()));
}
}
