private void barButtonItem15_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(); } clsFunctions.WriteLog("Generated confirmation letter for learner: " + number.Selection); var date = new frmSubmitDate("Submit Date", "Please select Expiry Date"); date.ShowDialog(); if (date.status) { var report2 = new rptConfrimationLetter(); var report = new rptBankConfirmation(); var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses and not d.Type = 'CC'"); if (data == null) { data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses"); } report.date.Text = DateTime.Today.ToString("dd/MM/yyyy"); report.regDate.Text = ((DateTime)data["regDate1"]).ToString("dd/MM/yyyy"); report.expiryDate.Text = ((DateTime)data["regDate1"]).AddYears(2 * Convert.ToInt16(data["numRegistrations"])).ToString("dd/MM/yyyy"); report.learnerNumber.Text = number.Selection; report.principal.Text = GlobalProperties.DivisionPrinciple; report.fullName.Text = Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"]); report.header.Rtf = report.header.Rtf.Replace("?formalName?", Convert.ToString(data["surname"]) + ", " + Convert.ToString(data["name"])) .Replace("?fullName?", Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"])); report.course.Text = Convert.ToString(data["Name1"]); report.idNumber.Text = Convert.ToString(data["ID"]); report.footer.Rtf = report.footer.Rtf.Replace("?expiryDate?", date.Selection.ToString("dd/MM/yyyy")); report.learnerType.Text = (MessageBox.Show("Is this a part time learner?", "Part Time Learner", MessageBoxButtons.YesNo) == DialogResult.Yes ? "Part Time" : "Full Time"); report.street.Text = Convert.ToString(data["street"]); report.suburb.Text = Convert.ToString(data["subburb"]); report.city.Text = Convert.ToString(data["city"]); report.code.Text = Convert.ToString(data["postalCode"]); //report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); //var frmReport = new frmReport(report2) { Text = "Bank Confirmation Request" }; report.ShowPreviewDialog(); //frmReport.ShowDialog(); } }
private void bankConfirmationLetterToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } clsFunctions.WriteLog("Generated confirmation letter for learner: " + number.Selection); var date = new frmSubmitDate("Submit Date", "Please select Expiry Date"); date.ShowDialog(); if (date.status) { var report = new rptConfrimationLetter(); var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses and not d.Type = 'CC'"); report.DataDefinition.FormulaFields["registrationDate"].Text = "\"" + data["regDate1"] + "\""; //report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + clsGlobal.DivisionPrinciple + "\""; report.DataDefinition.FormulaFields["name"].Text = "\"" + Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"]) + "\""; report.DataDefinition.FormulaFields["reverseName"].Text = "\"" + Convert.ToString(data["surname"]) + ", " + Convert.ToString(data["name"]) + "\""; report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; report.DataDefinition.FormulaFields["ID"].Text = "\"" + Convert.ToString(data["ID"]) + "\""; report.DataDefinition.FormulaFields["expiryDate"].Text = "\"" + date.Selection.ToString("yyyyMMdd") + "\""; report.DataDefinition.FormulaFields["learnerType"].Text = "\"" + (MessageBox.Show("Is this a part time learner?","Part Time Learner",MessageBoxButtons.YesNo)==DialogResult.Yes?"Part Time":"Full Time") + "\""; //report.DataDefinition.FormulaFields["respParty"].Text = "\"" + clsGlobal.loggedOnUser + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) {Text = "Bank Confirmation Request"}; frmReport.ShowDialog(); } }