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