public void SaveAssignment2(int course_id, string assignemnt_name, string assignment_desc, int max_points, DateTime due_date, string assignment_type, string submission_type)
        {
            LMS_GRINDEntities1 gds           = new LMS_GRINDEntities1();
            Assignment         newAssignment = new Assignment();

            var query = from course in gds.Courses
                        join insCourse in gds.InstructorCourses
                        on course.course_id equals insCourse.course_id
                        where course.course_id == course_id
                        select new
            {
                instructorCourseID = insCourse.instructor_course_id
            };

            foreach (var insCourse in query)
            {
                newAssignment.instructor_course_id = insCourse.instructorCourseID;
            }

            newAssignment.assignment_name = assignemnt_name;
            newAssignment.assignment_desc = assignment_desc;
            newAssignment.max_points      = max_points;
            newAssignment.due_date        = due_date;
            newAssignment.assignment_type = assignment_type;
            newAssignment.submission_type = submission_type;
            gds.Assignments.Add(newAssignment);
            gds.SaveChanges();
        }
        public void DeleteSubmission2(string text_submission)
        {
            LMS_GRINDEntities1 gds = new LMS_GRINDEntities1();
            StudentAssignment  sa  = gds.StudentAssignments.Where(x => x.text_submission == text_submission).FirstOrDefault();

            gds.StudentAssignments.Remove(sa);
            gds.SaveChanges();
        }
        public void DeleteAssignment2(string assignment_name)
        {
            LMS_GRINDEntities1 gds        = new LMS_GRINDEntities1();
            Assignment         assignment = gds.Assignments.Where(x => x.assignment_name == assignment_name).FirstOrDefault();

            gds.Assignments.Remove(assignment);
            gds.SaveChanges();
        }
        public void DeleteRegistration2(int studentId, int courseId)
        {
            LMS_GRINDEntities1 gds = new LMS_GRINDEntities1();
            Cours        course    = gds.Courses.Where(x => x.course_id == courseId).FirstOrDefault();
            StudentCours stCourse  = gds.StudentCourses.Where(x => (x.course_id == courseId) && (x.student_id == studentId)).FirstOrDefault();

            gds.StudentCourses.Remove(stCourse);
            gds.SaveChanges();
        }
        public void RegisterForCourse2(int studentId, int courseId)
        {
            LMS_GRINDEntities1 gds = new LMS_GRINDEntities1();
            Cours        course    = gds.Courses.Where(x => x.course_id == courseId).FirstOrDefault();
            StudentCours stCourse  = new StudentCours();

            stCourse.course_id    = courseId;
            stCourse.student_id   = studentId;
            stCourse.letter_grade = null;
            gds.StudentCourses.Add(stCourse);
            gds.SaveChanges();
        }
        public void SaveCourse2(string courseNum, string courseName, string courseDesc,
                                int courseCredits, int maxCapacity, string courseLocation,
                                int courseRoom, int departments, string monday, string tuesday, string wednesday,
                                string thursday, string friday, TimeSpan startTime, TimeSpan endTime, int instructor_id)
        {
            LMS_GRINDEntities1 gds = new LMS_GRINDEntities1();
            Cours course           = new Cours();

            course.course_name  = courseName;
            Course.courseName   = courseName;
            course.course_desc  = courseDesc;
            Course.courseDesc   = courseDesc;
            course.course_num   = courseNum;
            Course.courseNum    = courseNum;
            course.max_capacity = maxCapacity;
            Course.maxCapacity  = maxCapacity;
            course.dept_id      = departments;
            course.num_credits  = courseCredits;
            Course.numCredits   = courseCredits;
            course.days_of_week = monday + tuesday + wednesday + thursday + friday;
            Course.meetingDays  = monday + tuesday + wednesday + thursday + friday;
            course.start_time   = startTime;
            Course.startTime    = startTime;
            course.end_time     = endTime;
            Course.endTime      = endTime;
            course.building     = courseLocation;
            Course.location     = courseLocation;
            course.room_no      = courseRoom;
            Course.roomNum      = courseRoom;

            gds.Courses.Add(course);
            gds.SaveChanges();

            Course.courseId = course.course_id;

            InstructorCours insCourse = new InstructorCours();

            InstructorCourseContext.courseId = course.course_id;
            insCourse.course_id = course.course_id;
            InstructorCourseContext.instructorId = instructor_id;
            insCourse.instructor_id    = instructor_id;
            Course.instructorFullName  = Name.first_name + " " + Name.last_name;
            Course.instructorLastName  = Name.last_name;
            Course.instructorFirstName = Name.first_name;

            gds.InstructorCourses.Add(insCourse);
            gds.SaveChanges();

            CourseCardList.GenerateInstructorCourseList();
        }
        public void DeleteCourse2(int id)
        {
            LMS_GRINDEntities1 gds = new LMS_GRINDEntities1();

            Cours           course    = gds.Courses.Where(x => x.course_id == id).FirstOrDefault();
            InstructorCours insCourse = gds.InstructorCourses.Where(x => x.course_id == id).FirstOrDefault();
            //StudentCours[] enrolledStudents = new StudentCours[32];
            var count = gds.StudentCourses.Where(x => x.course_id == id).Count();

            for (int i = 0; i < count; i++)
            {
                //remove existing enrollments to the class
                StudentCours stdCourse = gds.StudentCourses.Where(x => x.course_id == id).FirstOrDefault();
                gds.StudentCourses.Remove(stdCourse);
                gds.SaveChanges();
            }

            gds.InstructorCourses.Remove(insCourse);
            gds.Courses.Remove(course);
            gds.SaveChanges();
        }