public HttpResponseMessage Create(AcademicScoresCreateRequest req)
{
if (req == null)
{
ModelState.AddModelError("", "You did not add any body data!");
}
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> itemResponse = new ItemResponse <int>();
itemResponse.Item = academicScoresService.Create(req);
return(Request.CreateResponse(HttpStatusCode.Created, itemResponse));
}
public int Create(AcademicScoresCreateRequest req)
{
int newId = 0;
dataProvider.ExecuteNonQuery(
"AcademicScores_Create",
inputParamMapper: (parameters) =>
{
parameters.AddWithValue("@UserId", req.UserId);
parameters.AddWithValue("@GPA", req.GPA ?? (object)DBNull.Value);
parameters.AddWithValue("@SAT", req.SAT ?? (object)DBNull.Value);
parameters.AddWithValue("@ACT", req.ACT ?? (object)DBNull.Value);
parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
},
returnParameters: (parameters) =>
{
newId = (int)parameters["@Id"].Value;
});
return(newId);
}
