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