Beispiel #1
0
        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);
        }
Beispiel #2
0
        public HttpResponseMessage GetUserGrades(ShortenedUserId userId)
        {
            ItemsResponse <BaseGradebookEntry> response = new ItemsResponse <BaseGradebookEntry>();

            response.Items = GradebookService.GetUserGrades(userId);

            return(Request.CreateResponse(response));
        }