public HttpResponseMessage GetById(int id)
{
AcademicScores academicScores = academicScoresService.GetById(id);
ItemResponse <AcademicScores> itemResponse = new ItemResponse <AcademicScores>();
itemResponse.Item = academicScores;
return(Request.CreateResponse(HttpStatusCode.OK, itemResponse));
}
public List <AcademicScores> GetAll()
{
List <AcademicScores> results = new List <AcademicScores>();
dataProvider.ExecuteCmd(
"AcademicScores_GetAll",
inputParamMapper: null,
singleRecordMapper: (reader, resultSetNumber) =>
{
AcademicScores academicScores = new AcademicScores();
academicScores.Id = (int)reader["Id"];
academicScores.UserId = (int)reader["UserId"];
academicScores.GPA = reader.GetSafeDecimalNullable("GPA");
academicScores.SAT = reader.GetSafeInt32Nullable("SAT");
academicScores.ACT = reader.GetSafeInt32Nullable("ACT");
academicScores.DateCreated = (DateTime)reader["DateCreated"];
academicScores.DateModified = (DateTime)reader["DateModified"];
results.Add(academicScores);
});
return(results);
}
public AcademicScores GetById(int Id)
{
AcademicScores academicScores = null;
dataProvider.ExecuteCmd(
"academicscores_getbyid",
inputParamMapper: parameters =>
{
parameters.AddWithValue("@Id", Id);
},
singleRecordMapper: (reader, resultsetnumber) =>
{
academicScores = new AcademicScores();
academicScores.Id = (int)reader["id"];
academicScores.UserId = (int)reader["userid"];
academicScores.GPA = reader.GetSafeDecimalNullable("gpa");
academicScores.SAT = reader.GetSafeInt32Nullable("sat");
academicScores.ACT = reader.GetSafeInt32Nullable("act");
academicScores.DateCreated = (DateTime)reader["datecreated"];
academicScores.DateModified = (DateTime)reader["datemodified"];
});
return(academicScores);
}
