Example #1
0
        public ActionResult PrintPartialViewToPdf(int id)
        {
            if (CheckCookies())
            {
                var courseInDb     = _context.Courses.Single(c => c.CourseId == id);
                var doctorCourseId = _context.DoctorCourses.Single(c => c.CourseId == courseInDb.CourseId).UserId;
                var stuffIds       = _context.StuffCourses.Where(c => c.CourseId == courseInDb.CourseId)
                                     .Select(c => new { c.UserId }).ToList();
                List <string> stuffNames = new List <string>();
                foreach (var stuff in stuffIds)
                {
                    string temp = "";
                    temp = _context.Users.Single(c => c.UserId == stuff.UserId).FirstName + " " +
                           _context.Users.Single(c => c.UserId == stuff.UserId).LastName;
                    stuffNames.Add(temp);
                }

                var studentIds = _context.Registrations.Where(c => c.CourseId == courseInDb.CourseId)
                                 .Select(c => new { c.UserId }).ToList();
                List <StudentCourseDetVm> obj = new List <StudentCourseDetVm>();
                foreach (var student in studentIds)
                {
                    StudentCourseDetVm tempObj   = new StudentCourseDetVm();
                    string             studentId = _context.Users.Single(c => c.UserId == student.UserId).StudentID;
                    string             name      = _context.Users.Single(c => c.UserId == student.UserId).FirstName + " " +
                                                   _context.Users.Single(c => c.UserId == student.UserId).LastName;
                    string email   = _context.Users.Single(c => c.UserId == student.UserId).Email;
                    var    levelId = _context.Users.Single(c => c.UserId == student.UserId).AspStudentLvlId;
                    string level   = _context.StudentLvl.Single(c => c.Id == levelId).lvlName;
                    tempObj.Id    = studentId;
                    tempObj.Email = email;
                    tempObj.Name  = name;
                    tempObj.Level = level;
                    obj.Add(tempObj);
                }

                CourseDetailsVm model = new CourseDetailsVm
                {
                    CourseId         = courseInDb.CourseId,
                    Coursename       = courseInDb.CourseName,
                    CourseDepartment = _context.Departments.Single(c => c.DepId == courseInDb.AspDepartmentId).Name,
                    CourseCode       = courseInDb.CourseTitle,
                    CourseCredit     = "3",
                    CourseTime       = _context.CourseTimes.Single(c => c.Id == courseInDb.CourseTimeId).Time,
                    CourseDoctor     = _context.Users.Single(c => c.UserId == doctorCourseId).FirstName + " " +
                                       _context.Users.Single(c => c.UserId == doctorCourseId).LastName,
                    CourseStuffs = stuffNames,
                    students     = obj
                };

                var report = new PartialViewAsPdf("~/Views/Shared/_CourseResult.cshtml", model);
                return(report);
            }
            return(RedirectToAction("Logout", "User"));
        }
Example #2
0
        public ActionResult Details(int id)
        {
            if (CheckCookies())
            {
                Session["ID"] = id;
                var    courseInDb = _context.Courses.Single(c => c.CourseId == id);
                int    doctorCourseId;
                string doctorName = "";
                if (_context.DoctorCourses.Any(x => x.CourseId == courseInDb.CourseId))
                {
                    doctorCourseId = _context.DoctorCourses.Single(c => c.CourseId == courseInDb.CourseId).UserId;
                    doctorName     = _context.Users.Single(c => c.UserId == doctorCourseId).FirstName + " " +
                                     _context.Users.Single(c => c.UserId == doctorCourseId).LastName;
                }
                else
                {
                    doctorName = "No Doctor Assiged For this Course Until Now";
                }
                List <string>             stuffNames = new List <string>();
                List <StudentCourseDetVm> obj        = new List <StudentCourseDetVm>();
                if (_context.StuffCourses.Any(c => c.CourseId == courseInDb.CourseId))
                {
                    var stuffIds = _context.StuffCourses.Where(c => c.CourseId == courseInDb.CourseId)
                                   .Select(c => new { c.UserId }).ToList();

                    foreach (var stuff in stuffIds)
                    {
                        string temp = "";
                        temp = _context.Users.Single(c => c.UserId == stuff.UserId).FirstName + " " +
                               _context.Users.Single(c => c.UserId == stuff.UserId).LastName;
                        stuffNames.Add(temp);
                    }
                }
                if (_context.Registrations.Any(z => z.CourseId == courseInDb.CourseId))
                {
                    var studentIds = _context.Registrations.Where(c => c.CourseId == courseInDb.CourseId)
                                     .Select(c => new { c.UserId }).ToList();

                    foreach (var student in studentIds)
                    {
                        StudentCourseDetVm tempObj   = new StudentCourseDetVm();
                        string             studentId = _context.Users.Single(c => c.UserId == student.UserId).StudentID;
                        string             name      = _context.Users.Single(c => c.UserId == student.UserId).FirstName + " " +
                                                       _context.Users.Single(c => c.UserId == student.UserId).LastName;
                        string email   = _context.Users.Single(c => c.UserId == student.UserId).Email;
                        var    levelId = _context.Users.Single(c => c.UserId == student.UserId).AspStudentLvlId;
                        string level   = _context.StudentLvl.Single(c => c.Id == levelId).lvlName;
                        tempObj.Id    = studentId;
                        tempObj.Email = email;
                        tempObj.Name  = name;
                        tempObj.Level = level;
                        obj.Add(tempObj);
                    }
                }
                var viewModel = new CourseDetailsVm
                {
                    CourseId         = courseInDb.CourseId,
                    Coursename       = courseInDb.CourseName,
                    CourseDepartment = _context.Departments.Single(c => c.DepId == courseInDb.AspDepartmentId).Name,
                    CourseCode       = courseInDb.CourseTitle,
                    CourseCredit     = "3",
                    CourseTime       = _context.CourseTimes.Single(c => c.Id == courseInDb.CourseTimeId).Time,
                    CourseDoctor     = doctorName,
                    CourseStuffs     = stuffNames,
                    students         = obj
                };
                return(View(viewModel));
            }
            return(RedirectToAction("Logout", "User"));
        }