//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 }));
}
