public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptCourseChange rpt = new rptCourseChange(); rpt.Site = this.Site; return rpt; }
private void barButtonItem19_ItemClick(object sender, ItemClickEventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + GlobalProperties.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } var reason = new frmSubmitText("Reason", "Please enter reason for course change"); reason.ShowDialog(); var list = new ArrayList(); var courses = Database.Query("courses", "Not Type = 'CC'"); foreach (DataRow theRow in courses.Tables["courses"].Rows) { list.Add(theRow["Name"]); } var frmSelect = new frmSelectSingle("Select Course", "New Course to Enroll In", list); frmSelect.ShowDialog(); if (frmSelect.Selection == "***" || reason.Selection == "***") return; var report = new rptCourseChange(); var data = Database.Row(@"SELECT * FROM learner_details a JOIN enrollments b ON b.LearnerKey = a.LearnerKey LEFT JOIN enrollmentscourses c ON c.idEnrollments = b.idEnrollments LEFT JOIN courses d ON d.idCourses = c.idCourses WHERE a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND d.Type <> 'CC'"); if (data == null) { data = Database.Row(@"SELECT * FROM learner_details a JOIN enrollments b ON b.LearnerKey = a.LearnerKey LEFT JOIN enrollmentscourses c ON c.idEnrollments = b.idEnrollments LEFT JOIN courses d ON d.idCourses = c.idCourses WHERE a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "'"); } report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\""; report.DataDefinition.FormulaFields["college"].Text = "\"" + GlobalProperties.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + GlobalProperties.DivisionPrinciple + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["reason"].Text = "\"" + reason.Selection + "\""; report.DataDefinition.FormulaFields["currentProgramme"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"]) + "\""; report.DataDefinition.FormulaFields["newProgram"].Text = "\"" + frmSelect.Selection + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) { Text = "Cancellation Request" }; frmReport.ShowDialog(); }