public async Task Update(int id, BCParameter bcParameter)
{
var parameters = CreateDynamicBCParameterForUpdate(id, bcParameter);
await _sqlDataAccess.ExecuteStoredProcedureAsync(StoredProcedures.SpBcParameterUpdate, _dbConnectionString,
parameters);
}
private static DynamicParameters CreateDynamicBCParameterForUpdate(int id, BCParameter bcParameter)
{
var parameters = new DynamicParameters();
parameters.Add("@Id", id);
AddBCParameterProperties(parameters, bcParameter);
return(parameters);
}
private static DynamicParameters CreateDynamicBCParameterForInsert(BCParameter bcParameter)
{
var parameters = new DynamicParameters();
parameters.Add("@Id", 0, DbType.Int32, ParameterDirection.Output);
AddBCParameterProperties(parameters, bcParameter);
return(parameters);
}
public async Task <CreatedRow> Insert(BCParameter bcParameter)
{
var parameters = CreateDynamicBCParameterForInsert(bcParameter);
await _sqlDataAccess.ExecuteStoredProcedureAsync(StoredProcedures.SpBcParameterInsert, _dbConnectionString,
parameters);
return(new CreatedRow
{
Id = parameters.Get <int>("@Id")
});
}
public async Task <IActionResult> Put([FromRoute] int id, BCParameter bcParameter)
{
var row = await _bcParametersData.Get(id);
if (row.ToString() == "[]")
{
return(NotFound());
}
await _bcParametersData.Update(id, bcParameter);
return(NoContent());
}
public async Task PostReturns400ResponseTest()
{
// arrange
var expected = HttpStatusCode.BadRequest;
var client = GetFactory().CreateClient();
var bcParameter = new BCParameter();
// act
var actual = await client.PostAsJsonAsync("/api/BCParameter", bcParameter);
// assert
Assert.True(actual.StatusCode == expected, $"{actual.StatusCode} was returned instead of {expected}");
}
public async Task PutReturns204ResponseTest() //TODO transakcja żeby nie śmiecić?
{
// arrange
var expected = HttpStatusCode.NoContent;
var client = GetFactory().CreateClient();
var bcParameter = new BCParameter
{
Key = "newIntegrationTestKey",
Value = "newIntegrationTestValue"
};
// act
var actual = await client.PutAsJsonAsync("/api/BCParameter/1", bcParameter);
// assert
Assert.True(actual.StatusCode == expected, $"{actual.StatusCode} was returned instead of {expected}");
}
private static void AddBCParameterProperties(DynamicParameters parameters, BCParameter bcParameter)
{
parameters.Add("@Key", bcParameter.Key);
parameters.Add("@Value", bcParameter.Value);
}
public async Task <IActionResult> Post(BCParameter bcParameter)
{
var output = await _bcParametersData.Insert(bcParameter);
return(Created("", output));
}
