private void diplomaToolStripMenuItem_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();
}
var report = new rptDiploma();
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");
report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\"";
report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\"";
report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\"";
report.DataDefinition.FormulaFields["principle"].Text = "\"" + clsGlobal.DivisionPrinciple + "\"";
report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Convert.ToString(data["Name"]) + "\"";
report.DataDefinition.FormulaFields["surname"].Text = "\"" + Convert.ToString(data["Surname"]) + "\"";
report.DataDefinition.FormulaFields["diplomaName"].Text = "\"" + Convert.ToString(data["Name1"]) + "\"";
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 = "Cancellation Request" };
frmReport.ShowDialog();
}
private void handOverToolStripMenuItem_Click(object sender, EventArgs e)
{
var number = new frmSubmitText("Please enter Learner Number:", "Please enter Learner Number:");
number.ShowDialog();
var learner = new frmSubmitText("Please enter amount:", "Please enter amount");
learner.ShowDialog();
if (learner.Selection == "***" || number.Selection == "***")
return;
DataRow data;
try
{
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");
}
catch
{
MessageBox.Show("Error Finding Student.");
return;
}
var report = new rptSny();
report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\"";
report.DataDefinition.FormulaFields["ClientNr"].Text = "\"" + Database.Retrieve("division","DivisionAbrev = '" +
clsGlobal.loggedOnUserDivison +"'","SnyVen") + "\"";
report.DataDefinition.FormulaFields["RespSurname"].Text = "\"" + data["RespPartySurname"] + "\"";
report.DataDefinition.FormulaFields["Employer"].Text = "\"" + data["RespPartyEmployer"] + "\"";
report.DataDefinition.FormulaFields["RespName"].Text = "\"" + data["RespPartyName"] + "\"";
report.DataDefinition.FormulaFields["Title"].Text = "\"" + data["RespPartyTitle"] + "\"";
report.DataDefinition.FormulaFields["HandOverDate"].Text = "\"" + DateTime.Now.ToLongDateString() + "\"";
report.DataDefinition.FormulaFields["Amount"].Text = "\"" + learner.Selection + "\"";
report.DataDefinition.FormulaFields["RespID"].Text = "\"" + data["RespPartyID"] + "\"";
report.DataDefinition.FormulaFields["Name"].Text = "\"" + data["Name"] + "\"";
report.DataDefinition.FormulaFields["Surname"].Text = "\"" + data["Surname"] + "\"";
report.DataDefinition.FormulaFields["ID"].Text = "\"" + data["ID"] + "\"";
report.DataDefinition.FormulaFields["LearnerNr"].Text = "\"" + number.Selection + "\"";
report.DataDefinition.FormulaFields["startDate"].Text = "\"" + data["respPartyStreet"] + "\"";
report.DataDefinition.FormulaFields["RespPartyAdd"].Text = "\"" + data["respPartyStreet"] + "\"+Chr(13)+\" " +
data["RespPartySubburb"] + "\"+Chr(13)+\" " + data["RespPartyCity"] + "\"+Chr(13)+\" " +
data["RespPartyCountry"] + "\"+Chr(13)+\" " + data["RespPartyCode"] +"\"";
report.DataDefinition.FormulaFields["Add"].Text = "\"" + data["Street"] + "\"+Chr(13)+\" " +
data["Subburb"] + "\"+Chr(13)+\" " + data["City"] + "\"+Chr(13)+\" " +
data["Country"] + "\"+Chr(13)+\" " + data["postCode"] + "\"";
report.DataDefinition.FormulaFields["PostalAdd"].Text = "\"" + data["PostalStreet"] + "\"+Chr(13)+\" " +
data["PostalSubburb"] + "\"+Chr(13)+\" " + data["PostalCity"] + "\"+Chr(13)+\" " +
data["PostalCountry"] + "\"+Chr(13)+\" " + data["PostalCode"] + "\"";
report.DataDefinition.FormulaFields["RespTelWork"].Text = "\"" + data["RespPartyTel2"] + "\"";
report.DataDefinition.FormulaFields["RespTel"].Text = "\"" + data["RespPartyTel1"] + "\"";
report.DataDefinition.FormulaFields["RespCell"].Text = "\"" + data["RespPartyCell"] + "\"";
report.DataDefinition.FormulaFields["TelWork"].Text = "\"" + data["Tel1"] + "\"";
report.DataDefinition.FormulaFields["Tel"].Text = "\"" + data["Tel2"] + "\"";
report.DataDefinition.FormulaFields["Cell"].Text = "\"" + data["Cell"] + "\"";
var frmReport = new frmReport(report) { Text = "Hand Over Request" };
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();
}
}
private void courseChangeToolStripMenuItem_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();
}
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("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");
report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\"";
report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\"";
report.DataDefinition.FormulaFields["principle"].Text = "\"" + clsGlobal.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();
}
private void withdrawToolStripMenuItem_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();
}
var reason = new frmSubmitText("Reason", "Please enter reason forwithdrawel");
reason.ShowDialog();
if (reason.Selection == "***")
return;
var Data = Database.Row("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" +
clsGlobal.loggedOnUserDivison + "'");
var report = new rptWithdrawn();
report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\"";
report.DataDefinition.FormulaFields["clerk"].Text = "\"" + clsGlobal.loggedOnUser + "\"";
report.DataDefinition.FormulaFields["Name"].Text = "\"" + Data["Name"] + " " +Data["Surname"] + "\"";
report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\"";
report.DataDefinition.FormulaFields["Reason"].Text = "\"" + reason.Selection + "\"";
var frmReport = new frmReport(report) { Text = "Withdrawel Request" };
frmReport.ShowDialog();
}
private void transfersToolStripMenuItem_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();
}
var divisions = Database.Retrieve("division");
var theList = new ArrayList();
foreach (DataRow theRow in divisions.Tables[0].Rows)
{
theList.Add(Convert.ToString(theRow["DivisionName"]));
}
var select = new frmSelectSingle("Division", "Please select division", theList);
select.ShowDialog();
var report = new rptTransfer();
var data =
Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d, paymentinfo e",
"a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" +
number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND"+
" e.idEnrollments = c.idEnrollments AND d.idCourses = c.idCourses");
report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\"";
report.DataDefinition.FormulaFields["transferBranch"].Text = "\"" + select.Selection + "\"";
report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Convert.ToString(data["Name"]) + " " +
Convert.ToString(data["Surname"]) + "\"";
report.DataDefinition.FormulaFields["learnerTel"].Text = "\"" + Convert.ToString(data["Tel1"]) + "\"";
report.DataDefinition.FormulaFields["Date"].Text = "\"" + DateTime.Now.ToString("dd/MM/yyyy") + "\"";
report.DataDefinition.FormulaFields["Branch"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\"";
report.DataDefinition.FormulaFields["clerk"].Text = "\"" + clsGlobal.LoggedOnUser + "\"";
report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\"";
report.DataDefinition.FormulaFields["coursePrice"].Text = "\"" + Convert.ToString(data["totalContractPrice"]) + "\"";
//report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\"";
//logs.WriteXml(@"C:\tmpXml.xml");
var frmReport = new frmReport(report) {Text = "Transfer Request"};
frmReport.ShowDialog();
}
private void traceSerialNoToolStripMenuItem_Click(object sender, EventArgs e)
{
var select = new frmSubmitText("Serial Number search", "Serial Number Search:\r\nPlease enter serial number");
select.ShowDialog();
if (select.Selection == "***")
{
return;
}
try
{
var row = Database.Row("enrollmentcomponents a, enrollments b, learner_details c, components d, division e",
"a.idEnrollments = b.idEnrollments AND b.LearnerKey = c.LearnerKey and serialNumber = '" +
select.Selection + "' AND a.idCourseComponents = d.idCourseComponents AND e.DivisionAbrev = division");
MessageBox.Show("Serial number is booked out for " + Convert.ToString(row["Name1"]) +"\r\nCollege: " + Convert.ToString(row["division"]) +
"\r\nLearner Number: " + Convert.ToString(row["LearnerNumber"]) + "\r\nPlease Contact " + Convert.ToString(row["Tel"]), "Serial Number");
}
catch
{
MessageBox.Show("Serial number not in database", "Serial Number Not Found");
return;
}
select.Dispose();
}
private void testimonialToolStripMenuItem_Click(object sender, EventArgs e)
{
var learner = new frmSubmitText("Please enter learner number:", "Please enter learner number:");
learner.ShowDialog();
while (Database.Count("learner_details","division = '" + clsGlobal.loggedOnUserDivison +
"' AND learnerNumber = '" + learner.Selection + "'") == 0)
{
if (learner.Selection != "***")
return;
MessageBox.Show("Invalid student number");
}
clsFunctions.WriteLog("Generated Testimonial for learner: " + learner.Selection);
var theForm = new frmTestimonial(learner.Selection);
theForm.ShowDialog();
}
private void reactivationToolStripMenuItem_Click_1(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();
}
string reactivate =
MessageBox.Show("Would you like to request a re-activation?", "Re-Activation Request",
MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes
? "Yes"
: "No";
var Data = Database.Row("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" +
clsGlobal.loggedOnUserDivison + "'");
var report = new rptEnquiry();
report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\"";
report.DataDefinition.FormulaFields["clerk"].Text = "\"" + clsGlobal.loggedOnUser + "\"";
report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Data["Name"] + " " + Data["Surname"] + "\"";
report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\"";
report.DataDefinition.FormulaFields["reactivate"].Text = "\"" +reactivate + "\"";
var frmReport = new frmReport(report) { Text = "Enquiry on Handover / Re-Activation" };
frmReport.ShowDialog();
}
