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); }