/// <summary> /// Initializes the Buffer Class /// </summary> public static void Initialize() { _utDisposed = false; _ptDisposed = false; _rqDisposed = false; _userTable = new UsersTableAdapter(); _pkmnTable = new PokemonTableAdapter(); _requTable = new RequirementsTableAdapter(); _userTable.Disposed += (sender, args) => _utDisposed = true; _pkmnTable.Disposed += (sender, args) => _ptDisposed = true; _requTable.Disposed += (sender, args) => _rqDisposed = true; }
public ActionResult Report(string ReportType, string ListOfStudents, string CurrentFormer, string FromDateParam, string ToDateParam) { DataSet1 ds = new DataSet1(); ReportParameter[] paramsArray; ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.SizeToReportContent = true; reportViewer.Width = Unit.Percentage(100); reportViewer.Height = Unit.Percentage(100); switch (ReportType) { case "Background": paramsArray = new ReportParameter[4]; paramsArray[0] = new ReportParameter("FromDateParam", FromDateParam.ToString()); paramsArray[1] = new ReportParameter("ToDateParam", ToDateParam.ToString()); paramsArray[2] = new ReportParameter("Student", ListOfStudents.ToString()); paramsArray[3] = new ReportParameter("CurrentFormer", CurrentFormer.ToString()); BackgroundTableAdapter bta = new BackgroundTableAdapter(); bta.Fill(ds.Background, FromDateParam, ToDateParam, ListOfStudents, CurrentFormer); reportViewer.LocalReport.DataSources.Clear(); reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\Rpt1-Background.rdlc"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Background", ds.Tables[0])); reportViewer.LocalReport.SetParameters(paramsArray); reportViewer.LocalReport.Refresh(); break; case "Coursework": paramsArray = new ReportParameter[1]; paramsArray[0] = new ReportParameter("Student", ListOfStudents.ToString()); CourseworkTableAdapter cta = new CourseworkTableAdapter(); cta.Fill(ds.Coursework, ListOfStudents); reportViewer.LocalReport.DataSources.Clear(); reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\Rpt2-Coursework.rdlc"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Coursework", ds.Tables[1])); reportViewer.LocalReport.SetParameters(paramsArray); reportViewer.LocalReport.Refresh(); break; case "Performance": paramsArray = new ReportParameter[1]; paramsArray[0] = new ReportParameter("Student", ListOfStudents.ToString()); PerformanceTableAdapter pta = new PerformanceTableAdapter(); pta.Fill(ds.Performance, ListOfStudents); reportViewer.LocalReport.DataSources.Clear(); reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\Rpt3-Performance.rdlc"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Performance", ds.Tables[2])); reportViewer.LocalReport.SetParameters(paramsArray); reportViewer.LocalReport.Refresh(); break; case "Requirements": paramsArray = new ReportParameter[4]; paramsArray[0] = new ReportParameter("Student", ListOfStudents.ToString()); paramsArray[1] = new ReportParameter("CurrentFormer", CurrentFormer.ToString()); paramsArray[2] = new ReportParameter("FromDateParam", FromDateParam.ToString()); paramsArray[3] = new ReportParameter("ToDateParam", ToDateParam.ToString()); RequirementsTableAdapter rta = new RequirementsTableAdapter(); rta.Fill(ds.Requirements, FromDateParam, ToDateParam, ListOfStudents, CurrentFormer); reportViewer.LocalReport.DataSources.Clear(); reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\Rpt4-Requirements.rdlc"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Requirements", ds.Tables[3])); reportViewer.LocalReport.SetParameters(paramsArray); reportViewer.LocalReport.Refresh(); break; case "PostGraduation": paramsArray = new ReportParameter[1]; paramsArray[0] = new ReportParameter("Student", ListOfStudents.ToString()); PostgraduationTableAdapter pgta = new PostgraduationTableAdapter(); pgta.Fill(ds.Postgraduation, ListOfStudents); reportViewer.LocalReport.DataSources.Clear(); reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\Rpt5-Postgraduation.rdlc"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Postgraduation", ds.Tables[4])); reportViewer.LocalReport.SetParameters(paramsArray); reportViewer.LocalReport.Refresh(); break; default: break; } var students = db.Students.AsEnumerable().Select(s => new { //ID = s.Id, FullName = string.Format("{0} {1}", s.FirstName, s.LastName) }).OrderBy(s => s.FullName).ToList(); ViewBag.ListOfStudents = new SelectList(students, "FullName", "FullName"); ViewBag.ReportViewer = reportViewer; return(View()); }