//Reports public ActionResult GenerateReportCourses() { DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111(); var List = db.RegisteredCourses.Where(x => x.StudentId == LoginClass.LoginId).ToList(); List <RegisteredCourseViewModel> PassList = new List <RegisteredCourseViewModel>(); foreach (var i in List) { RegisteredCourseViewModel r = new RegisteredCourseViewModel(); var c = db.Courses.Where(x => x.Id == i.CourseId).First(); r.Name = c.Title; r.Date = Convert.ToDateTime(i.RegisterationDate); PassList.Add(r); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CrystalReportCourses.rpt")); rd.SetDataSource(PassList); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "RegisteredCoursesList.pdf")); } catch { throw; } }
public ActionResult ViewRegCourses() { DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111(); var List = db.RegisteredCourses.Where(x => x.StudentId == LoginClass.LoginId).ToList(); List <RegisteredCourseViewModel> PassList = new List <RegisteredCourseViewModel>(); foreach (var i in List) { RegisteredCourseViewModel r = new RegisteredCourseViewModel(); var c = db.Courses.Where(x => x.Id == i.CourseId).First(); r.Name = c.Title; r.Date = Convert.ToDateTime(i.RegisterationDate); PassList.Add(r); } return(View(PassList)); }
public ActionResult RegisterCourse(RegisteredCourseViewModel collection) { DBSmartSchoolWebPortalEntities111 db = new DBSmartSchoolWebPortalEntities111(); RegisteredCourse course = new RegisteredCourse(); course.CourseId = collection.CourseId; var student = db.Students.Where(x => x.RegisterationNumber == collection.StudentId).First(); course.StudentId = student.Id; course.RegisterationDate = DateTime.Now; db.RegisteredCourses.Add(course); db.SaveChanges(); string message = "Course Registered!"; return(RedirectToAction("Account", "Management", new { Message = message })); }