public static List <BaseGradebookEntry> GetUserGrades(ShortenedUserId model) { List <BaseGradebookEntry> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.GetUserGradesByUserId" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@UserId", model.UserId); } , map : delegate(IDataReader reader, short set) { BaseGradebookEntry p = new BaseGradebookEntry(); int startingIndex = 0; //startingOrdinal p.GradebookEntryId = reader.GetSafeInt32(startingIndex++); p.AssignmentId = reader.GetSafeInt32(startingIndex++); p.AssignmentName = reader.GetSafeString(startingIndex++); p.AssignmentTypeId = reader.GetSafeInt32(startingIndex++); p.PointsEarned = reader.GetSafeInt32(startingIndex++); p.TotalPoints = reader.GetSafeInt32(startingIndex++); p.DateAdded = reader.GetSafeDateTime(startingIndex++); p.InstructorComments = reader.GetSafeString(startingIndex++); if (list == null) { list = new List <BaseGradebookEntry>(); } list.Add(p); } ); return(list); }
public HttpResponseMessage GetUserGrades(ShortenedUserId userId) { ItemsResponse <BaseGradebookEntry> response = new ItemsResponse <BaseGradebookEntry>(); response.Items = GradebookService.GetUserGrades(userId); return(Request.CreateResponse(response)); }