예제 #1
0
        //
        // TODO: Add constructor logic here
        //
        public void UpdateCourses2()
        {
            #region VariablesDeclaration

            Dictionary <string, List <int> > emailandattendance;
            List <int> studentAttendanceInfo;
            //variables to store unique identifiers
            Dictionary <string, string>   customGradebookCategoryAndGuid = new Dictionary <string, string>();
            Dictionary <string, string>   customGradebookItemAndGuid     = new Dictionary <string, string>();
            Dictionary <string, int>      emailanduserId = new Dictionary <string, int>();
            Dictionary <int, List <int> > userIdAndgrades = new Dictionary <int, List <int> >();
            int    gradeId = 0, present = 0, missed = 0;
            double percentage = 0;
            string courseHomeUnitId = "";
            string customCategoryGuidOfAttended = "", gradebookItemGuidOfAttended = "";
            string customCategoryGuidOfMissed = "", gradebookItemGuidOfMissed = "";
            string customCategoryGuidOfPercentage = "", gradebookItemGuidOfPercentage = "";

            bool isAttendedAttendancePercentageExists = false;
            bool isMissedAttendancePercentageExists   = false;
            int  courseCount = 0;
            bool isAttendedMissedAttendancePercentageExists = false;
            #endregion //VariablesDeclaration
            // File.WriteAllText(@"C:\Thread3.txt", String.Empty);

            try
            {
                ApplicationLog.WriteThread3Log("Updating Gradebook in this thread started at: " + DateTime.Now + "_" + DateTime.Now.DayOfWeek);
                ApplicationLog.WriteThread3Log("Total courses updating in this thread are:" + callNumbersCount);
                #region Updating all courses
                foreach (string callNum in callNumbers)
                {
                    emailandattendance = new Dictionary <string, List <int> >();
                    //courseCount variable is to log the current number of course which is updating
                    courseCount++;
                    ApplicationLog.WriteThread3Log(courseCount + "." + "Course updating: _" + callNum);
                    //getting enrolled students ina course from our database
                    using (AttendanceTrackingDBDataContext db = new AttendanceTrackingDBDataContext())
                    {
                        int count = (from stu in db.students.ToList()
                                     join en in db.enrollments
                                     on stu.student_id equals en.student_id
                                     where en.call_number == callNum
                                     select stu).Count();


                        ApplicationLog.WriteThread1Log(courseCount + "." + "Total number of students in " + callNum + " are " + count);
                        //getting total number of classes for that course


                        //var totalClasses1 = (from at in db.attendances.ToList()
                        //                     where at.call_number == callNum
                        //                     select DateTime.Parse(at.created_at.ToString("MM-dd-yyyy")));

                        int totalClasses = (from at in db.attendances.ToList()
                                            where at.call_number == callNum
                                            select DateTime.Parse(at.created_at.Date.ToString("MM-dd-yyyy"))).Distinct().Count();

                        ApplicationLog.WriteThread1Log(courseCount + "." + "Total classes for " + callNum + " " + totalClasses);
                        //int count = studentEnrolls2.Count();
                        var studentEnrolls = from stu in db.students
                                             join en in db.enrollments
                                             on stu.student_id equals en.student_id
                                             where en.call_number == callNum
                                             select new { stu.s_number, stu.student_id };


                        //getting student attendance details from database and adding it to emailandattendace list
                        #region studentattendaceInfo
                        if (count != 0)
                        {
                            foreach (var students in studentEnrolls.ToList())
                            {
                                studentAttendanceInfo = new List <int>();
                                present = (from att in db.attendances.ToList()
                                           where att.call_number == callNum && att.student_id == students.student_id
                                           select DateTime.Parse(att.created_at.Date.ToString("MM-dd-yyyy"))).Distinct().Count();
                                studentAttendanceInfo.Add(present);
                                missed = totalClasses - present;
                                studentAttendanceInfo.Add(missed);
                                emailandattendance.Add(students.s_number, studentAttendanceInfo);
                            }
                            #endregion

                            //"8969167";
                            string httpMethod = "GET";
                            string body       = "";
                            //to get the Northwest Online courseId for a course
                            Uri    url      = new Uri(String.Format("{0}ccn={1}", "https://api.learningstudio.com/courses/", callNum));
                            string courseID = "";
                            using (CourseIdReportDataContext Cid = new CourseIdReportDataContext())
                            {
                                courseID = (from ecourse in Cid.CourseIdReports.ToList()
                                            where ecourse.callNumber == callNum
                                            select ecourse.courseId).First();
                            }

                            ApplicationLog.WriteThread3Log(courseCount + "." + "Northwest Online course id for  " + callNum + " is " + courseID);
                            httpMethod = "GET";
                            body       = "";

                            //to get all the existing gradebook categories in a course and save them in customGradebookCategoryAndGuid
                            url = new Uri(String.Format("{0}{1}/gradebook/customCategories", "https://api.learningstudio.com/courses/", courseID));
                            customGradebookCategoryAndGuid = getGradebookCategory(httpMethod, url, body);

                            //Gets the list of students registered in course
                            httpMethod      = "GET";
                            url             = new Uri(String.Format("{0}{1}/students", "https://api.learningstudio.com/courses/", courseID));
                            body            = "";
                            emailanduserId  = getStudents(httpMethod, url, body);
                            userIdAndgrades = UserIdAndGrades(emailandattendance, emailanduserId);

                            //to get unit ID for course home gradebook item
                            httpMethod       = "GET";
                            url              = new Uri(String.Format("{0}{1}/items", "https://api.learningstudio.com/courses/", courseID));
                            courseHomeUnitId = getCoureHomeId(httpMethod, url, body);


                            #region secondTime
                            //creates custom gradebook categories if they are not present in course
                            if (customGradebookCategoryAndGuid.ContainsValue("Attended") && customGradebookCategoryAndGuid.ContainsValue("Missed"))
                            {
                                //check if custom gradebook items are created for custom gradebook categories
                                httpMethod = "GET";
                                url        = new Uri(String.Format("{0}{1}/gradebookItems", "https://api.learningstudio.com/courses/", courseID));
                                customGradebookItemAndGuid = getGradebookItems(httpMethod, url, body);

                                //getting the GUID values of custome gradebook items
                                gradebookItemGuidOfAttended = customGradebookItemAndGuid.FirstOrDefault(x => x.Value.ToLower() == "attended").Key;
                                gradebookItemGuidOfMissed   = customGradebookItemAndGuid.FirstOrDefault(x => x.Value.ToLower() == "missed").Key;
                                //gradebookItemGuidOfPercentage = customGradebookItemAndGuid.FirstOrDefault(x => x.Value.ToLower() == "attendance percentage").Key;

                                //getting isIncludedingrade or extra credit values for gradebook item attended
                                httpMethod = "GET";
                                url        = new Uri(String.Format("{0}{1}/gradebookItems/{2}", "https://api.learningstudio.com/courses/", courseID, gradebookItemGuidOfAttended));
                                bool[] isIncludedAndExtraCredit = getIncludedAndextraCreditForItem(httpMethod, url, body);

                                //updating the gradebook item attended for the course with possible points
                                httpMethod = "PUT";
                                url        = new Uri(String.Format("{0}{1}/gradebook/gradebookItems/{2}", "https://api.learningstudio.com/courses/", courseID, gradebookItemGuidOfAttended));
                                body       = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": " + isIncludedAndExtraCredit[0].ToString().ToLower() + ",\"isExtraCredit\": " + isIncludedAndExtraCredit[1].ToString().ToLower() + ",\"pointsPossible\": " + totalClasses + "}}";
                                connectingAPI(httpMethod, url, body);

                                //to update the registered students grades for the gradebook items in the course
                                foreach (int userId in userIdAndgrades.Keys)
                                {
                                    percentage = ((((double)userIdAndgrades[userId][0]) / totalClasses) * 100);
                                    httpMethod = "GET";
                                    url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebook/userGradebookItems?expand=grade"));
                                    body       = "";
                                    isAttendedAttendancePercentageExists = getAllGradebookItemIdsOfUser(httpMethod, url, body);
                                    if (isAttendedAttendancePercentageExists)
                                    {
                                        //to get the grade Id's of user for attended
                                        httpMethod = "GET";
                                        url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfAttended + "/grade"));
                                        body       = "";
                                        gradeId    = getGradeId(httpMethod, url, body);
                                        //to update the grade of the user for item attended
                                        httpMethod = "PUT";
                                        url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfAttended + "/grade"));
                                        body       = "{\"grade\": {\"id\":" + gradeId + ", \"points\": " + userIdAndgrades[userId][0] + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                        connectingAPI(httpMethod, url, body);
                                    }
                                    else
                                    {
                                        httpMethod = "POST";
                                        url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfAttended + "/grade"));
                                        body       = "{\"grade\": {\"points\": " + userIdAndgrades[userId][0] + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                        connectingAPI(httpMethod, url, body);
                                    }
                                    percentage = ((((double)userIdAndgrades[userId][0]) / totalClasses) * 100);
                                    httpMethod = "GET";
                                    url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebook/userGradebookItems?expand=grade"));
                                    body       = "";
                                    isMissedAttendancePercentageExists = getMissedGradebookItemIdOfUser(httpMethod, url, body);
                                    if (isMissedAttendancePercentageExists)
                                    {
                                        //to get the grade Id's of user for missed
                                        httpMethod = "GET";
                                        url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfMissed + "/grade"));
                                        body       = "";
                                        gradeId    = getGradeId(httpMethod, url, body);
                                        //to update the grade of the user for item missed
                                        httpMethod = "PUT";
                                        url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfMissed + "/grade"));
                                        body       = "{\"grade\": {\"id\":" + gradeId + ", \"points\": " + userIdAndgrades[userId][1] + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                        connectingAPI(httpMethod, url, body);
                                    }
                                    else
                                    {
                                        httpMethod = "POST";
                                        url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfMissed + "/grade"));
                                        body       = "{\"grade\": {\"points\": " + userIdAndgrades[userId][1] + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                        connectingAPI(httpMethod, url, body);
                                    }
                                }
                            }
                            #endregion
                            #region firstTime
                            else
                            {
                                url        = new Uri(String.Format("{0}{1}/gradebook/customCategories", "https://api.learningstudio.com/courses/", courseID));
                                httpMethod = "POST";

                                //creates a custom gradebook category in course with name attended
                                body = "{\"customCategories\": {\"title\":\"Attended\",\"isAssignable\": true}}";
                                connectingAPI(httpMethod, url, body);

                                //creates a custom gradebook category in course with name Missed
                                body = "{\"customCategories\": {\"title\":\"Missed\",\"isAssignable\": true}}";
                                connectingAPI(httpMethod, url, body);

                                //creates a custom gradebook category in course with name Attendance Percentage
                                //body = "{\"customCategories\": {\"title\":\"Attendance Percentage\",\"isAssignable\": true}}";
                                //connectingAPI(httpMethod, url, body);

                                //to get GUID's of created gradebook categories in a course and save them in customGradebookCategoryAndGuid to create gradebook items
                                httpMethod = "GET";
                                body       = "";
                                url        = new Uri(String.Format("{0}{1}/gradebook/customCategories", "https://api.learningstudio.com/courses/", courseID));
                                customGradebookCategoryAndGuid = getGradebookCategory(httpMethod, url, body);

                                //getting the GUID values of custom gradebook  categories
                                //customCategoryGuidOfPercentage = customGradebookCategoryAndGuid.FirstOrDefault(x => x.Value.ToLower() == "attendance percentage").Key;
                                customCategoryGuidOfMissed   = customGradebookCategoryAndGuid.FirstOrDefault(x => x.Value.ToLower() == "missed").Key;
                                customCategoryGuidOfAttended = customGradebookCategoryAndGuid.FirstOrDefault(x => x.Value.ToLower() == "attended").Key;

                                //creates custom gradebook items  in course

                                //Creating a custom gradebook item for gradebook category attended
                                httpMethod = "POST";
                                url        = new Uri(String.Format("{0}{1}/gradebook/customCategories/{2}/customItems", "https://api.learningstudio.com/courses/", courseID, customCategoryGuidOfAttended));

                                body = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": false,\"isExtraCredit\": false,\"pointsPossible\": " + totalClasses + "}}";
                                connectingAPI(httpMethod, url, body);

                                //Creating a custom gradebook item for gradebook category missed
                                url = new Uri(String.Format("{0}{1}/gradebook/customCategories/{2}/customItems", "https://api.learningstudio.com/courses/", courseID, customCategoryGuidOfMissed));

                                body = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": false,\"isExtraCredit\": false,\"pointsPossible\": " + 0 + "}}";
                                connectingAPI(httpMethod, url, body);

                                //Creating a custom gradebook item for gradebook category Attendane Percentage
                                //url = new Uri(String.Format("{0}{1}/gradebook/customCategories/{2}/customItems", "https://api.learningstudio.com/courses/", courseID, customCategoryGuidOfPercentage));

                                //body = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": false,\"isExtraCredit\": false,\"pointsPossible\": " + 0 + "}}";
                                //connectingAPI(httpMethod, url, body);

                                //to get the GUID'S of newly created gradebook items
                                httpMethod = "GET";
                                url        = new Uri(String.Format("{0}{1}/gradebookItems", "https://api.learningstudio.com/courses/", courseID));
                                customGradebookItemAndGuid = getGradebookItems(httpMethod, url, body);

                                //getting the GUID values of custome gradebook items
                                gradebookItemGuidOfAttended = customGradebookItemAndGuid.FirstOrDefault(x => x.Value.ToLower() == "attended").Key;
                                gradebookItemGuidOfMissed   = customGradebookItemAndGuid.FirstOrDefault(x => x.Value.ToLower() == "missed").Key;
                                //gradebookItemGuidOfPercentage = customGradebookItemAndGuid.FirstOrDefault(x => x.Value.ToLower() == "attendance percentage").Key;

                                //updating the gradebook item attended for the course with possible points
                                httpMethod = "PUT";
                                url        = new Uri(String.Format("{0}{1}/gradebook/gradebookItems/{2}", "https://api.learningstudio.com/courses/", courseID, gradebookItemGuidOfAttended));
                                body       = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": false,\"isExtraCredit\": false,\"pointsPossible\": " + totalClasses + "}}";
                                connectingAPI(httpMethod, url, body);

                                url  = new Uri(String.Format("{0}{1}/gradebook/gradebookItems/{2}", "https://api.learningstudio.com/courses/", courseID, gradebookItemGuidOfMissed));
                                body = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": false,\"isExtraCredit\": false,\"pointsPossible\":0}}";

                                connectingAPI(httpMethod, url, body);

                                //url = new Uri(String.Format("{0}{1}/gradebook/gradebookItems/{2}", "https://api.learningstudio.com/courses/", courseID, gradebookItemGuidOfPercentage));
                                //body = "{\"customItem\": {\"unitID\":" + courseHomeUnitId + ",\"isIncludedInGrade\": false,\"isExtraCredit\": false,\"pointsPossible\": 0}}";

                                //connectingAPI(httpMethod, url, body);

                                foreach (int userId in userIdAndgrades.Keys)
                                {
                                    httpMethod = "POST";
                                    url        = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfMissed + "/grade"));
                                    body       = "{\"grade\": {\"points\": " + userIdAndgrades[userId][1] + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                    connectingAPI(httpMethod, url, body);

                                    url  = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfAttended + "/grade"));
                                    body = "{\"grade\": {\"points\": " + userIdAndgrades[userId][0] + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                    connectingAPI(httpMethod, url, body);

                                    ////calculates attendance percentage of a student
                                    //percentage = ((((double)userIdAndgrades[userId][0]) / totalClasses) * 100);


                                    //url = new Uri(String.Format("https://api.learningstudio.com/users/" + userId + "/courses/" + courseID + "/gradebookItems/" + gradebookItemGuidOfPercentage + "/grade"));
                                    //body = "{\"grade\": {\"points\": " + percentage + ",\"letterGrade\": \"\",\"comments\":\"\", }}";
                                    //connectingAPI(httpMethod, url, body);
                                }
                            }
                            #endregion //end of updating second time
                        }
                    }
                    ApplicationLog.WriteThread3Log(courseCount + "." + "Gradebook with attendance information is updated for " + callNum + " at " + DateTime.Now + "_" + DateTime.Now.DayOfWeek);
                    ApplicationLog.WriteThread3Log("------------------------------------------------------------------------");
                }
                #endregion //end of updating all courses
            }//end of try
            catch (Exception ex)
            {
                ApplicationLog.WriteThread3Log(ex.Message + " " + DateTime.Now + "_" + DateTime.Now.DayOfWeek);
                throw ex;
            }
        }