public async Task <IActionResult> CreateNewCourt(NewCourtModel courtModel)
{
if (ModelState.IsValid == false)
{
return(ValidationProblem());
}
int courtId = await _courtsService.CreateAsync(courtModel);
return(Created("api/config/Court", courtId));
}
private static SqlParamsModel GetParams_CreateAsync(NewCourtModel courtModel)
{
var sqlModel = new SqlParamsModel
{
Sql = "pkg_courts.p_create_new_court",
Parameters = new OracleDynamicParameters()
};
sqlModel.Parameters.Add("pi_court_name", courtModel.CourtName, dbType: OracleMappingType.Varchar2, ParameterDirection.Input);
sqlModel.Parameters.Add("po_court_id", dbType: OracleMappingType.Int32, direction: ParameterDirection.Output);
return(sqlModel);
}
public async Task <int> CreateAsync(NewCourtModel courtModel)
{
var sqlModel = new SqlParamsModel
{
Sql = "pkg_courts.p_create_new_court",
Parameters = new OracleDynamicParameters()
};
sqlModel.Parameters.Add("pi_court_name", courtModel.CourtName, dbType: OracleMappingType.Varchar2, ParameterDirection.Input);
sqlModel.Parameters.Add("po_court_id", dbType: OracleMappingType.Int32, direction: ParameterDirection.Output);
await _dataAccess.ExecuteAsync(sqlModel);
int courtId = (int)sqlModel.Parameters.Get <decimal>("po_court_id");
return(courtId);
}
public Task <HttpResponseMessage> AddNewCourtAsync(NewCourtModel courtDetails)
{
return(_http.PostAsJsonAsync(courtBaseUrl, courtDetails));
}
