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 ScanFromTextBox(object sender, EventArgs e) { panel1.Visible = false; noteLabel.Text = ""; specialNeedsLabel.Text = ""; alertLabel.Text = ""; nameLabel.Text = ""; statusLabel.Text = ""; _pastelString = ""; _scanNumber = scanText.Text; _checkNotesFlag = false; #region Employees if (Database.Count("employees", "idNumber = '" + _scanNumber + "'") > 0) { var employee = Database.Row("employees", "idNumber = '" + _scanNumber + "'"); _scanNumber = (string)employee["employeeNumber"]; if (radOut.Checked) { if (Database.Count("scannedEmployees", "employeeNumber = '" + _scanNumber + "'") == 0) { MessageBox.Show("This Employee: " + _scanNumber + " is not scanned in.", "Employee Not Scanned In"); return; } Database.Command("INSERT INTO employeeActivity(`employeeNumber`,`dateTime`,division, `type`, details,`user`) VALUES('" + _scanNumber + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + GlobalProperties.loggedOnUserDivison + "','Scan','Out','" + GlobalProperties.LoggedOnUser + "')"); int insertId = (int)Database.RetrieveDouble("SELECT MAX(id) FROM employeeActivity WHERE employeeNumber = '" + _scanNumber + "'"); var link = Database.Row(@"SELECT * FROM scannedEmployees se JOIN employees e ON e.employeeNumber = se.employeeNumber WHERE se.employeeNumber = '" + _scanNumber + "'"); Database.Command("UPDATE employeeActivity SET partnerID = '" + insertId + "' WHERE id = " + link["scanID"]); Database.Command("DELETE FROM scannedEmployees WHERE employeeNumber = '" + _scanNumber + "'"); AddNode(new ListNode(DateTime.Now, _scanNumber, Convert.ToString(link["Name"]) + " " + Convert.ToString(link["Surname"]), "Out", "Access Granted",null,null,null)); } else { if (Database.Count("scannedEmployees", "employeeNumber = '" + _scanNumber + "'") > 0) { MessageBox.Show("This Employee: " + _scanNumber + " is already scanned in.", "Employee Already Scanned In"); return; } var link = Database.Row(@"SELECT * FROM scannedEmployees se RIGHT JOIN employees e ON e.employeeNumber = se.employeeNumber WHERE e.employeeNumber = '" + _scanNumber + "'"); if (Convert.ToString(link["status"]) == "Maternity Leave") { AddNode(new ListNode(DateTime.Now, _scanNumber, Convert.ToString(link["Name"]) + " " + Convert.ToString(link["Surname"]), "In", "Access Denied",null,"This Employee is on Maternity Leave", "This employee has not been scanned in.")); return; } Database.Command("INSERT INTO employeeActivity(`employeeNumber`,`dateTime`,division, `type`, details, `user`) VALUES('" + _scanNumber + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + GlobalProperties.loggedOnUserDivison + "','Scan','In','" + GlobalProperties.LoggedOnUser + "')"); int insertId = (int)Database.RetrieveDouble("SELECT MAX(id) FROM employeeActivity WHERE employeeNumber = '" + _scanNumber + "'"); Database.Command("INSERT INTO scannedEmployees(employeeNumber,scanId) VALUES('" + _scanNumber + "'," + insertId + ")"); AddNode(new ListNode(DateTime.Now, _scanNumber, Convert.ToString(link["Name"]) + " " + Convert.ToString(link["Surname"]), "In", "Access Granted",null,null,null)); } scanText.Text = ""; } #endregion #region Learners else { _scanNumber = LearnerNumberHelpers.PrefixedLearnerNumber(CleanBarcode(scanText.Text), GlobalProperties.loggedOnUserDivison); if (!LearnerExistsQuery.Run(_scanNumber, GlobalProperties.loggedOnUserDivison)) { MessageBox.Show("Learner doesn't exist!"); return; } var learner = Database.Row("learner_details", "LearnerNumber = '" + _scanNumber + "' AND division = '" + GlobalProperties.loggedOnUserDivison + "'"); if (learner["matricCert"] == DBNull.Value) { var levels = Database.Retrieve("qualificationLevels"); var theList = new ArrayList(); foreach (DataRow theRow in levels.Tables[0].Rows) { theList.Add(theRow["Name"]); } var listForm = new frmSelectSingle("Select Level", "Please select highest qualification for learner:", theList); listForm.ShowDialog(); if (listForm.Selection == "***") return; Database.Command("UPDATE learner_details SET matricCert = "+ Database.Retrieve("qualificationLevels","Name = '" + listForm.Selection + "'","idQualificationLevels") + " WHERE ID = '" + learner["ID"] + "'"); } var id = Convert.ToString(learner["ID"]); var name = Convert.ToString(learner["Name"]) + " " + Convert.ToString(learner["Surname"]); if (radOut.Checked && !radAdmin.Checked) { ScanOutLearner(_scanNumber, name); scanText.Text = ""; CheckNotes(id); } else { if (!radAdmin.Checked && (radIn.Checked || radWorkshop.Checked || radMeeting.Checked)) { if (!ScannedInCheck(_scanNumber)) { MessageBox.Show("User already scanned in"); scanText.Text = ""; return; } } if (radIn.Checked && !SessionCheck()) { MessageBox.Show( "Cannot Scan in new learners before previous session's learners are scanned out"); scanText.Text = ""; return; } if (!radAdmin.Checked && clsFunctions.GetCurrentSession() == "Out of Session") { MessageBox.Show("Not acception scan in's now: Out of Session"); scanText.Text = ""; return; } try { id = Convert.ToString(learner["ID"]); var accesGranted = AccessGrant(); if (!accesGranted) { if (!radAdmin.Checked) AddNode(new ListNode(DateTime.Now, _scanNumber, name, "In", "Access Denied", _pastelString, CheckNotes(id), _accessDeniedReason)); else SetNotes(AccessState.Denied,name, _scanNumber,_pastelString,CheckNotes(id),_accessDeniedReason); } else { alertLabel.Text += CheckResubs(); alertLabel.Text += CheckBirthday(); specialNeedsLabel.Text += CheckNotes(id); alertLabel.Text += CheckRegistration(); noteLabel.Text = _pastelString; if (!radAdmin.Checked) AddNode(new ListNode(DateTime.Now, _scanNumber, name, "In", "Access Granted", noteLabel.Text, specialNeedsLabel.Text, alertLabel.Text)); else SetNotes(AccessState.Granted, name, _scanNumber, _pastelString, CheckNotes(id), _accessDeniedReason); } if (!radAdmin.Checked) { if (radIn.Checked) ScanInLearner(_scanNumber, ScanType.Attendance,accesGranted); if (radWorkshop.Checked) ScanInLearner(_scanNumber, ScanType.Workshop,accesGranted); if (radMeeting.Checked) ScanInLearner(_scanNumber, ScanType.Meeting,accesGranted); if (radExam.Checked) ScanInLearner(_scanNumber, ScanType.Exam,accesGranted); } } catch(Exception error) { new ExceptionHandler { Mode = Mode.Offiline, LoggedOnUser = GlobalProperties.loggedOnUser, Exception = error }.handleException(); MessageBox.Show(@"An error occurred when trying to scan learner!"); } scanText.Text = ""; scanText.Focus(); } } #endregion MyHandler(); }
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(); }