public IActionResult Put([FromBody] Models.Activity activity)
{
Models.Activity result = _activityRepository.UpdateActivity(activity);
if (result != null)
{
return(Accepted(result));
}
else
{
return(StatusCode(500));
}
}
public IActionResult Post([FromBody] Models.Activity activity)
{
var result = _activityRepository.CreateActivity(activity);
if (result > 0)
{
return(StatusCode(201, result));
}
else
{
return(StatusCode(500));
}
}
public int CreateActivity(Models.Activity activity)
{
int newId;
string sql = $@"INSERT INTO dbo.Activity (AccountId, ActivityTypeId, Amount)
VALUES (@AccountId, @ActivityTypeId, @Amount)
SELECT CAST(SCOPE_IDENTITY() as int)";
try
{
_logger.LogDebug($@"{_className}: Creating Activity for Account {activity.AccountId}");
using (var connection = new SqlConnection(_connectionString))
{
newId = connection.Query <int>(sql, new { AccountId = activity.AccountId, ActivityTypeId = activity.ActivityTypeId, Amount = activity.Amount }).Single();
}
return(newId);
}
catch (Exception e)
{
_logger.LogError($@"{_className}: Error creating Activity for Account {activity.AccountId} - {e.Message}");
return(-1);
}
}
public Models.Activity UpdateActivity(Models.Activity activity)
{
string sql = $@"UPDATE dbo.Activity
SET AccountId = @AccountId,
ActivityTypeId = @ActivityTypeId,
Amount = @Amount
WHERE Id = @Id";
try
{
_logger.LogDebug($@"{_className}: Updating Activity {activity.Id} to AccountId {activity.AccountId}, ActivityTypeId {activity.ActivityTypeId}, Amount {activity.Amount}");
using (var connection = new SqlConnection(_connectionString))
{
connection.Execute(sql, new { Id = activity.Id, AccountId = activity.AccountId, ActivityTypeId = activity.ActivityTypeId, Amount = activity.Amount });
}
return(GetActivityById(activity.Id));
}
catch (Exception e)
{
_logger.LogError($@"{_className}: Error updating Activity {activity.Id} - {e.Message}");
return(null);
}
}