private void button13_Click(object sender, EventArgs e) { if (comboBox2.Text.Length == 0) { MessageBox.Show("Please select a group to add the user to from the drop down box", "Select Group"); return; } var colleges = new ArrayList(); var tempDS = Database.Retrieve("users"); foreach (DataRow theRow in tempDS.Tables["users"].Rows) { colleges.Add(theRow["username"]); } var tempSelect = new frmSelectSingle("Transfer Learner", "Select College", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; Database.Command("INSERT INTO users_groups(idUserGroups,idUsers) VALUES('" + Database.Retrieve("userGroups","name = '" + comboBox2.Text + "'","idUserGroups") + "','" + Database.Retrieve("users", "Username = '******'", "idUsers") + "')"); var x1 = listView3.Items.Add(tempSelect.Selection); x1.ImageIndex = 0; }
private void barButtonItem19_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(); } 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(@"SELECT * FROM learner_details a JOIN enrollments b ON b.LearnerKey = a.LearnerKey LEFT JOIN enrollmentscourses c ON c.idEnrollments = b.idEnrollments LEFT JOIN courses d ON d.idCourses = c.idCourses WHERE a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND d.Type <> 'CC'"); if (data == null) { data = Database.Row(@"SELECT * FROM learner_details a JOIN enrollments b ON b.LearnerKey = a.LearnerKey LEFT JOIN enrollmentscourses c ON c.idEnrollments = b.idEnrollments LEFT JOIN courses d ON d.idCourses = c.idCourses WHERE a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "'"); } report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\""; report.DataDefinition.FormulaFields["college"].Text = "\"" + GlobalProperties.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + GlobalProperties.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 collegeButton_ItemClick(object sender, ItemClickEventArgs e) { var data = Database.Query("SELECT divisionAbrev FROM division"); var myList = new ArrayList(); foreach (DataRow theRow in data.Tables[0].Rows) { myList.Add(theRow["divisionAbrev"]); } var theForm = new frmSelectSingle("Colleges:", "Select College", myList); theForm.ShowDialog(); if (theForm.Selection == "***") return; GlobalProperties.loggedOnUserDivison = theForm.Selection; }
private void barButtonItem23_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(); } var response = InputDialog.Show("Contact Details", "Enter learner contact number:"); if (response.Result != DialogResult.OK) { return; } 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 new UCO branch", theList); select.ShowDialog(); //var report = new rptTransfer(); DataSet data; try { data = Database.Query(@"SELECT * FROM learner_details a LEFT JOIN enrollments b on b.LEarnerKEy = a.LearnerKey LEFT JOIN enrollmentscourses c on c.idEnrollments = b.idEnrollments LEFT JOIN courses d on d.idCourses = c.idCourses LEFT JOIN paymentinfo e ON e.idEnrollments = b.idEnrollments WHERE a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + @"' AND (d.Type <> 'CC' OR d.Type IS NULL) LIMIT 1"); //data.WriteXml(@"C:\LAD_DATA_DUMP\transfer.xml",XmlWriteMode.WriteSchema); } catch { MessageBox.Show("There is an error with this learner's enrollment. Please correct before trying to redo the transaction."); return; } var report = new rptTransfer(); report.transferLable.Text = select.Selection; report.responsibleClarkLabel.Text = GlobalProperties.loggedOnUser; report.contactNumberLabel.Text = response.Submission; report.divisionLabel.Text = GlobalProperties.LoggedOnUserDivision; //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 = "\"" + response.Submission + "\""; //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"); report.DataSource = data; report.ShowPreviewDialog(); }
private void barButtonItem20_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(); } var enrollments = Database.Query("learner_details a, enrollments b", "a.Division = '" + GlobalProperties.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey"); var myList = new ArrayList(); foreach (DataRow theRow in enrollments.Tables[0].Rows) { try { myList.Add((string)("ENR" + theRow["idEnrollments"] + " - " + ((DateTime)theRow["regDate1"]).ToString("dd/MM/yyyy"))); } catch { } } var theList = new frmSelectSingle("Please Select Enrollment","Select Enrollment",myList); theList.ShowDialog(); if (theList.Selection == "***") return; string[] theEnrollment = theList.Selection.Split(new string[] {" - "},StringSplitOptions.RemoveEmptyEntries); var endDateSelect = new frmSubmitDate("Submit Date", "Please submit end of studies date:"); endDateSelect.ShowDialog(); if (endDateSelect.status == false) return; var report = new rptDiplomaRequest(); var data = Database.Query("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 b.idEnrollments = " + theEnrollment[0].Replace("ENR","") + " ORDER BY d.Type DESC LIMIT 1"); report.startDateLabel.Text = theEnrollment[1]; report.endDateTraining.Text = endDateSelect.Selection.ToString("dd/MM/yyyy"); report.prinicipleLabel.Text = GlobalProperties.DivisionPrinciple; report.DataSource = data; report.ShowPreviewDialog(); //data.WriteXml(@"C:\LAD_DATA_DUMP\diploma.xml", XmlWriteMode.WriteSchema); //report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\""; //report.DataDefinition.FormulaFields["startdate"].Text = "\"" + theEnrollment[1] + "\""; //report.DataDefinition.FormulaFields["enddate"].Text = "\"" + endDateSelect.Selection.ToString("dd/MM/yyyy") + "\""; //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"]) + "\""; ////data.WriteXml(@"C:\LAD_DATA_DUMP\tmpXml.xml"); //var frmReport = new frmReport(report) { Text = "Diploma Request" }; //frmReport.ShowDialog(); }
private void addShortCourseToolStripMenuItem_Click(object sender, EventArgs e) { var colleges = new ArrayList(); var tempDS = Database.Query("Components", "(ComponentAbrev = 'PROJ' OR ComponentAbrev = 'SC') AND singleSubject = 1" + " ORDER BY Name"); foreach (DataRow theRow in tempDS.Tables["Components"].Rows) { colleges.Add(Convert.ToString(theRow["Name"]) + " - " + Convert.ToString(theRow["idCourseComponents"])); } var tempSelect = new frmSelectSingle("Replace Course", "Select Course", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; string[] separate = { " - " }; string[] select = tempSelect.Selection.Split(separate, StringSplitOptions.None); addComponent(txtID.Text, select[1]); try { var split = SplitByString(trvCourses.SelectedNode.Text, " - "); var component = Database.Query("SELECT * FROM courseComponents cc JOIN components c ON c.idCourseComponents = cc.idComponents" + " WHERE idCourses = '" + split[0] + "'"); trvCourses.SelectedNode.Nodes.Clear(); foreach (DataRow theRow in component.Tables[0].Rows) { trvCourses.SelectedNode.Nodes.Add((string)theRow["Name"], Convert.ToString(theRow["idCourseComponents"]) + " - " + (string)theRow["Name"]); if (Convert.ToString(theRow["isElective"]) == "1") trvCourses.SelectedNode.Nodes[(string)theRow["Name"]].ForeColor = Color.Blue; } } catch { load_items(); } }
private void approveButton_Click(object sender, EventArgs e) { if (comboBox1.Text.Contains("Marketing")) { var colleges = Database.Retrieve("division", "divisionName"); ArrayList myList = new ArrayList(); foreach (DataRow theRows in colleges.Tables[0].Rows) { myList.Add(theRows["divisionName"]); } frmSelectSingle myForm = new frmSelectSingle("Select College","Select college to reflect on marketing budget",myList); myForm.ShowDialog(); if (myForm.Selection == "***") return; DateTime entrydate = new DateTime(); var split = entryList.FocusedItem.Text.Split(new char[] { '/' }); if (!DateTime.TryParse(split[1] + "/" + split[0] + "/" + split[2], out entrydate) || entrydate.ToString("dd/MM/yyyy") != entryList.FocusedItem.Text) { // MessageBox.Show("Date was not detected properly from the first method."); DateTime.TryParse(split[0] + "/" + split[1] + "/" + split[2], out entrydate); //MessageBox.Show("Date now detected as " + entrydate.ToString("dd/MM/yyyy")); } else { //MessageBox.Show("Date WAS detected properly from the first method."); } Database.Command("INSERT INTO marketingentries(division, entryDate,details1,details2,cost,marketingTypeID,`status`) VALUES('" + clsFunctions.GetDivisionAbrev(myForm.Selection) + "'," + entrydate.ToString("yyyyMMdd") + ",'" + destinationText.Text + "','" + reasonText.Text + "'," + entryList.FocusedItem.SubItems[4].Text + "," + Database.Retrieve("marketingTypes", "Name = '" + comboBox1.Text.Replace("Marketing ","") + "'", "id") + ",'Planned')"); } entryList.FocusedItem.SubItems[5].Text = "Approved"; Database.Command("UPDATE travellingclaims SET approved = 'Approved' WHERE id = " + entryList.FocusedItem.SubItems[6].Text); var theRow = Database.Query("SELECT * FROM travellingClaims tc JOIN employees e on e.id = tc.EmployeeId WHERE tc.id = " + entryList.FocusedItem.SubItems[6].Text); //theRow.WriteXml(@"C:\LAD_DATA_DUMP\singleTravelClaim.xml", XmlWriteMode.WriteSchema); var Report = new Reports.rptTravelClaimSingle(); Report.headerLabel.Text = comboBox1.Text; Report.DataSource = theRow; FileInfo exportFile = new FileInfo(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\tempClaim" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".rtf"); var stream = exportFile.Create(); Report.ExportToRtf(stream); stream.Close(); clsFunctions.SendEmailAttachment("*****@*****.**", "Approved " + comboBox1.Text + " : " + employeeCombo.Text, "Please find attached Travel Claim", exportFile); clsFunctions.WriteLog(comboBox1.Text + " Approved for " + employeeCombo.Text); //exportFile.Delete(); loadEntries(); }
private void btnTransfer_Click(object sender, EventArgs e) { var colleges = new ArrayList(); var tempDS = Database.Retrieve("division"); foreach (DataRow theRow in tempDS.Tables["division"].Rows) { colleges.Add(theRow["DivisionName"]); } var tempSelect = new frmSelectSingle("Transfer Learner", "Select College", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; if (Database.Count("oldlearnernumbers", "divisionAbrev = '" + clsFunctions.GetDivisionAbrev(GlobalProperties.selection) + "' AND ID = '" + GlobalProperties.varLearner_id + "'") > 0) { MessageBox.Show( "This learner already has a learner number at the destination College.\r\nThe old number will be used."); tempDS = Database.Query("learner_details", "ID = '" + GlobalProperties.varLearner_id + "'"); string oldNumber = (string)tempDS.Tables[0].Rows[0]["LearnerNumber"]; string oldDivision = (string)tempDS.Tables[0].Rows[0]["division"]; Database.Command("INSERT INTO oldLearnerNumbers(divisionAbrev,ID,LearnerNumber) VALUES('" + GlobalProperties.loggedOnUserDivison + "','" + GlobalProperties.varLearner_id + "','" + oldNumber + "')"); tempDS = Database.Query("learner_details", "ID = '" + GlobalProperties.varLearner_id + "'"); tempDS.Tables[0].Rows[0]["Division"] = clsFunctions.GetDivisionAbrev(GlobalProperties.selection); tempDS.Tables[0].Rows[0]["LearnerNumber"] = Database.Retrieve("oldlearnernumbers", "divisionAbrev = '" + clsFunctions.GetDivisionAbrev( GlobalProperties.selection) + "' AND ID = '" + GlobalProperties.varLearner_id + "'", "LearnerNumber"); Database.Delete("oldlearnerNumbers", "divisionAbrev = '" + clsFunctions.GetDivisionAbrev(GlobalProperties.selection) + "' AND ID = '" + GlobalProperties.varLearner_id + "'"); var number = Convert.ToString(tempDS.Tables[0].Rows[0]["LearnerNumber"]); Database.Update(tempDS, "learner_details", "ID = '" + GlobalProperties.varLearner_id + "'"); var division = clsFunctions.GetDivisionAbrev(GlobalProperties.selection); Database.Command("UPDATE photos SET division = '" + division + "', learnerNumber = '" + number + "' WHERE learnerNumber = '" + oldNumber + "' AND division = '" + GlobalProperties.loggedOnUserDivison + "'"); Database.Command("UPDATE learnerActivity SET division = '" + division + "', learnerNumber = '" + number + "' WHERE division = '" + oldDivision + "' AND learnerNumber = '" + oldNumber + "'"); MessageBox.Show("Learner has been transferred.\r\nNew learner number: " + number); } else { tempDS = Database.Query("learner_details", "ID = '" + GlobalProperties.varLearner_id + "'"); string oldNumber = (string)tempDS.Tables[0].Rows[0]["LearnerNumber"]; string oldDivision = (string)tempDS.Tables[0].Rows[0]["division"]; tempDS.Tables[0].Rows[0]["Division"] = clsFunctions.GetDivisionAbrev(GlobalProperties.selection); Database.Command("INSERT INTO oldLearnerNumbers(divisionAbrev,ID,LearnerNumber) VALUES('" + GlobalProperties.loggedOnUserDivison + "','" + GlobalProperties.varLearner_id + "','" + Convert.ToString(tempDS.Tables[0].Rows[0]["LearnerNumber"]) + "')"); tempDS.Tables[0].Rows[0]["LearnerNumber"] = clsFunctions.nextLearnerNumber(clsFunctions.GetDivisionAbrev(GlobalProperties.selection)); var number = Convert.ToString(tempDS.Tables[0].Rows[0]["LearnerNumber"]); var division = clsFunctions.GetDivisionAbrev(GlobalProperties.selection); var learnerNumber = Convert.ToString(tempDS.Tables[0].Rows[0]["LearnerNumber"]); Database.Command("UPDATE photos SET division = '" + clsFunctions.GetDivisionAbrev(GlobalProperties.selection) + "', learnerNumber = '" + learnerNumber + "' WHERE learnerNumber = '" + oldNumber + "' AND division = '" + GlobalProperties.loggedOnUserDivison + "'"); Database.Update(tempDS, "learner_details", "ID = '" + GlobalProperties.varLearner_id + "'"); Database.Command("UPDATE learnerActivity SET division = '" + division + "', learnerNumber = '" + learnerNumber + "' WHERE division = '" + oldDivision + "' AND learnerNumber = '" + oldNumber + "'"); MessageBox.Show("Learner has been transferred.\r\nNew learner number: " + number); } updated_LearnerInfo = false; Close(); }
private void button6_Click(object sender, EventArgs e) { if (comboBox1.Text.Length == 0) { MessageBox.Show("Please select a group to add the college to from the drop down box", "Select Group"); return; } var colleges = new ArrayList(); var tempDS = Database.Retrieve("division"); foreach (DataRow theRow in tempDS.Tables["division"].Rows) { colleges.Add(theRow["DivisionName"]); } var tempSelect = new frmSelectSingle("Transfer Learner", "Select College", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; Database.Command("INSERT INTO divisions_groups(idDivision,iddivisionGroups) VALUES('" + clsFunctions.GetDivisionAbrev(tempSelect.Selection) + "','" + Database.Retrieve("divisionGroups","Name = '" + comboBox1.Text + "'","iddivisionGroups")+"')"); var x1 = listView2.Items.Add(tempSelect.Selection); x1.ImageIndex = 0; }
private void subjectEnrollmentToolStripMenuItem_Click(object sender, EventArgs e) { //ArrayList list = new ArrayList(); //DataSet courses = Database.Query("courses", "Not Type = 'CC'"); //foreach (DataRow theRow in courses.Tables["courses"].Rows) //{ // list.Add(theRow["idCourses"] + " - " + theRow["Name"]); //} DataSet temp = Database.Query("enrollments", "idEnrollments = 0"); string[] columns = { "LearnerKey", "regDate", "numRegistrations", "dateOfFirstLesson" }; string[] values = new string[temp.Tables[0].Columns.Count - 3]; values[0] = Database.Retrieve("learner_details", "division = '" + GlobalProperties.loggedOnUserDivison + "' AND learnerNumber = '" + GlobalProperties.strLearnerNumber + "'", "LearnerKey"); var dateSelect = new frmSubmitDate("Please select registration date", "Please select registration date"); dateSelect.ShowDialog(); if (dateSelect.status == false) return; values[1] = dateSelect.Selection.ToString("yyyyMMdd"); values[2] = "1"; values[3] = DateTime.Now.ToString("yyyyMMdd"); Database.Insert("enrollments", columns, values); DataSet tempe = Database.Query("enrollments", "LearnerKey = '" + clsFunctions.GetLearnerKey(GlobalProperties.varLearner_id) + "' AND regDate = '" + dateSelect.Selection.ToString("yyyyMMdd") + "' ORDER BY idEnrollments DESC"); string[] coursescolumns = { "idcourses", "Name", "Status", "xPeriod", "Type" }; string[] coursesvalues = new string[5]; coursesvalues[0] = "ENR" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]); coursesvalues[1] = "Custom Course Selection"; coursesvalues[2] = "1"; coursesvalues[3] = "0"; coursesvalues[4] = "CC"; Database.Insert("courses", coursescolumns, coursesvalues); //check if this course has electives //columns = new string[2]; //values = new string[2]; //values[0] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]); //values[1] = arrSplit3[0]; //Database.Insert("enrollmentscourses", columns, values); //frmSelect.Dispose(); columns = new string[2]; values = new string[2]; columns[0] = "idEnrollments"; columns[1] = "idCourses"; values[0] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]); values[1] = "ENR" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]); Database.Insert("enrollmentscourses", columns, values); var colleges = new ArrayList(); var tempDS = Database.Query("Components", "(ComponentAbrev = 'PROJ' OR ComponentAbrev = 'SC') AND singleSubject = 1" + " ORDER BY Name"); foreach (DataRow theRow in tempDS.Tables["Components"].Rows) { colleges.Add(Convert.ToString(theRow["Name"]) + " - " + Convert.ToString(theRow["idCourseComponents"])); } var tempSelect = new frmSelectSingle("Replace Course", "Select Course", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; string[] separate = { " - " }; string[] select = tempSelect.Selection.Split(separate, StringSplitOptions.None); DataSet Check = Database.Query("components", "idCourseComponents = '" + select[1] + "'"); string[] columns2 = { "idCourses", "idComponents" }; string[] values2 = { "ENR" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]), select[1] }; Database.Insert("coursecomponents", columns2, values2); if (Convert.ToString(Check.Tables[0].Rows[0]["isElective"]) == "1") { columns2 = new string[2]; columns2[0] = "idEnrollments"; columns2[1] = "idCourseComponents"; values2[0] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]); values2[1] = select[1]; Database.Insert("enrollmentcomponents", columns, values); } clsFunctions.WriteLog("Created new enrollment for learner (" + GlobalProperties.strLearnerNumber + ") : Course " + select[1] + ": Enrollment (" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]) + ")\nEnrolled By:" + GlobalProperties.loggedOnUser); string subject = (cboEnrollments.Items.Count >= 1 ? "Additional Enrollment :" : "NewEnrollment :"); string message = "Created new enrollment for learner (" + GlobalProperties.strLearnerNumber + ") : Project/Short Course " + select[1] + ": Enrollment (" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]) + ")\nEnrolled By:" + GlobalProperties.loggedOnUser; clsFunctions.SendEmail("*****@*****.**", subject + GlobalProperties.LoggedOnUserDivision, message); DataSet payment = Database.Query("paymentinfo", "idenrollments = '0'"); columns = new string[12]; values = new string[12]; for (int i = 0; i < payment.Tables[0].Columns.Count; i++) { DataColumn theColumn = payment.Tables[0].Columns[i]; columns[i] = theColumn.ColumnName; } values[0] = "0"; values[1] = "0"; values[2] = "0"; values[3] = "0"; values[4] = "0"; values[5] = "0"; values[6] = "0"; values[7] = "0"; values[8] = "No"; values[9] = "No"; values[10] = "0"; values[11] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]); Database.Insert("paymentinfo", columns, values); load_enrollmentstab(); cboEnrollments.SelectedIndex = cboEnrollments.Items.Count - 1; string[] arrEnrollmentID = new string[5]; arrEnrollmentID = SplitByString(cboEnrollments.Text, "-"); load_enrollments(arrEnrollmentID[1]); panel1.Visible = true; }
private void statementOfResultsToolStripMenuItem1_Click(object sender, EventArgs e) { if (lstEnrollments.Items.Count == 0) return; var items = new ArrayList(); foreach (ListViewItem item in lstEnrollments.Items) { if (item.SubItems[2].Text == "PROJ") { items.Add(String.Format("{0} - {1}", item.Text, item.SubItems[1].Text)); } } if (items.Count == 0) { MessageBox.Show("No projects in enrollment!"); return; } var myForm = new frmSelectSingle("Select Project", "Project", items); myForm.ShowDialog(); if (myForm.Selection == "***") return; var courseSplit = SplitByString(myForm.Selection, " - "); string[] splitter = SplitByString(cboEnrollments.Text, "-"); new StatementOfResultsAction().Execute(splitter[1], courseSplit[0]); }
private void reToolStripMenuItem_Click(object sender, EventArgs e) { string[] splitter = SplitByString(cboEnrollments.Text, "-"); if (lstEnrollments.FocusedItem == null) return; Regex regex = new Regex(@"-\d{4}-"); if (regex.IsMatch(lstEnrollments.FocusedItem.Text)) { var theRow = Database.Row("SELECT * FROM courseComponents WHERE idComponents = '" + lstEnrollments.FocusedItem.Text + "'"); string locate = Convert.ToString(theRow["idCourses"]); string year = locate.Substring(locate.LastIndexOf('-') + 1); if (Database.Count(@"SELECT COUNT(*) FROM components c LEFT JOIN courseComponents CC on cc.idComponents = c.idCourseComponents WHERE c.Name = '" + lstEnrollments.FocusedItem.SubItems[1].Text.Replace("*", "") + @"' AND RIGHT(idCourses,LOCATE('-',REVERSE(idCourses))-1) = " + year + @" AND c.idCourseComponents = myParent AND (idCourses is Null OR (NOT idCourses LIKE 'ENR%')) AND c.idCourseComponents <> '" + lstEnrollments.FocusedItem.Text + "'") > 0) { var theList = Database.Query(@"SELECT c.idCourseComponents, componentAbrev, Name, myParent, cc.*, RIGHT(idCourses,LOCATE('-',REVERSE(idCourses))-1) as year FROM components c LEFT JOIN courseComponents CC on cc.idComponents = c.idCourseComponents WHERE c.Name = '" + lstEnrollments.FocusedItem.SubItems[1].Text.Replace("*", "") + @"' AND RIGHT(idCourses,LOCATE('-',REVERSE(idCourses))-1) = " + year + @" AND c.idCourseComponents = myParent AND (idCourses is Null OR (NOT idCourses LIKE 'ENR%')) AND c.idCourseComponents <> '" + lstEnrollments.FocusedItem.Text + "'"); clsFunctions.WriteLog("Enrollment " + splitter[1] + ": Re-Enrolled Subject(" + lstEnrollments.FocusedItem.Text + ") with " + Convert.ToString(theList.Tables[0].Rows[0]["idCourseComponents"])); addToExisting(Convert.ToString(theList.Tables[0].Rows[0]["idCourseComponents"])); } } else { var theList = Database.Query(@"SELECT c.idCourseComponents, componentAbrev, Name, myParent, cc.*, RIGHT(idCourses,LOCATE('-',REVERSE(idCourses))-1) as year FROM components c LEFT JOIN courseComponents CC on cc.idComponents = c.idCourseComponents WHERE c.Name = '" + lstEnrollments.FocusedItem.SubItems[1].Text.Replace("*", "") + @"' AND c.idCourseComponents = myParent AND (idCourses is Null OR (NOT idCourses LIKE 'ENR%')) AND c.idCourseComponents <> '" + lstEnrollments.FocusedItem.Text + @"' GROUP BY RIGHT(idCourses,LOCATE('-',REVERSE(idCourses))-1) ORDER BY RIGHT(idCourses,LOCATE('-',REVERSE(idCourses))-1)"); ArrayList theDisplayList = new ArrayList(); foreach (DataRow theRow in theList.Tables[0].Rows) { theDisplayList.Add(theRow["idCourseComponents"] + "(" + theRow["year"] + ")"); } frmSelectSingle theForm = new frmSelectSingle("Please select closest match:", "Select the Closest Matching Subject", theDisplayList); theForm.ShowDialog(); if (theForm.Selection == "***") return; var theStuff = theForm.Selection.Split(new char[] { '(' }); clsFunctions.WriteLog("Enrollment " + splitter[1] + ": Re-Enrolled Subject(" + lstEnrollments.FocusedItem.Text + ") with " + theStuff[0]); addToExisting(theStuff[0]); } }
private void replaceComponentToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("This is only reversible by head office.\r\nDo you wish to continue?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) return; var arrEnrollmentID = SplitByString(cboEnrollments.Text, "-"); string serialNumber = null; DateTime serialDate = new DateTime(); if (lstEnrollments.SelectedItems.Count <= 0) return; var enrollment = Database.Query("enrollmentcomponents", "idEnrollments = '" + arrEnrollmentID[1] + "' AND idCourseComponents = '" + lstEnrollments.SelectedItems[0].Text + "'"); if (enrollment.Tables[0].Rows.Count <= 0) { string[] columns = { "idEnrollments", "idCourseComponents", "status" }; string[] values = { arrEnrollmentID[1], lstEnrollments.SelectedItems[0].Text, "inactive" }; Database.Insert("enrollmentcomponents", columns, values); } else { if (enrollment.Tables[0].Rows[0]["serialNumber"] != DBNull.Value) { serialNumber = (string)enrollment.Tables[0].Rows[0]["serialNumber"]; serialDate = Convert.ToDateTime(enrollment.Tables[0].Rows[0]["dateIssued"]); } Database.Command("UPDATE enrollmentComponents SET serialNumber = null, status = 'inactive' WHERE idEnrollments = '" + arrEnrollmentID[1] + "' AND idCourseComponents = '" + lstEnrollments.SelectedItems[0].Text + "'"); } var colleges = new ArrayList(); var tempDS = Database.Query("Components", "(ComponentAbrev = 'PROJ' OR ComponentAbrev = 'SC') AND singleSubject = 1" + " ORDER BY Name"); foreach (DataRow theRow in tempDS.Tables["Components"].Rows) { colleges.Add(Convert.ToString(theRow["idCourseComponents"]) + " - " + Convert.ToString(theRow["Name"])); } var tempSelect = new frmSelectSingle("Replace Course", "Select Course", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; string[] separate = { " - " }; string[] select = tempSelect.Selection.Split(separate, StringSplitOptions.None); DataSet Check = Database.Query("components", "idCourseComponents = '" + select[0] + "'"); if ( Database.Count("coursecomponents", "idCourses = 'ENR" + arrEnrollmentID[1] + "' AND idComponents = '" + select[1] + "'") == 0) { string[] columns2 = { "idCourses", "idComponents" }; string[] values2 = { "ENR" + arrEnrollmentID[1], select[0] }; Database.Insert("coursecomponents", columns2, values2); } if ((Convert.ToString(Check.Tables[0].Rows[0]["isElective"]) == "1" || serialNumber != null) && Database.Count("enrollmentComponents", "idEnrollments = '" + arrEnrollmentID[1] + "' AND idCourseComponents = '" + select[0] + "'") == 0) { Database.Command( @"INSERT INTO enrollmentComponents(idEnrollments, idCourseComponents, serialNumber, dateIssued) VALUES(" + arrEnrollmentID[1] + ",'" + select[0] + "'," + (serialNumber == null ? "null" : "'" + serialNumber + "'") + "," + (serialNumber == null ? "null" : serialDate.ToString("yyyyMMdd")) + ")"); } else { Database.Command("UPDATE enrollmentcomponents SET status = Null, serialNumber = " + (serialNumber == null ? "null" : "'" + serialNumber + "'") + ", dateIssued = " + (serialNumber == null ? "null" : serialDate.ToString("yyyyMMdd")) + " WHERE idEnrollments = '" + arrEnrollmentID[1] + "' AND idCourseComponents = '" + select[0] + "'"); } clsFunctions.WriteLog("Replaced Course from Enrolment (" + lstEnrollments.FocusedItem.Text + ") with (" + select[0] + ") : " + txtSurname.Text + ", " + txtFullName.Text + " : with learner number : " + GlobalProperties.strLearnerNumber + " - EnrolmentID = " + cboEnrollments.Text); load_enrollments(arrEnrollmentID[1]); }
private void addToExistingEnrollmentToolStripMenuItem_Click(object sender, EventArgs e) { var colleges = new ArrayList(); var tempDS = Database.Query("Components", "(ComponentAbrev = 'PROJ' OR ComponentAbrev = 'SC') AND singleSubject = 1" + " ORDER BY Name"); foreach (DataRow theRow in tempDS.Tables["Components"].Rows) { colleges.Add(Convert.ToString(theRow["Name"]) + " - " + Convert.ToString(theRow["idCourseComponents"])); } var tempSelect = new frmSelectSingle("Replace Course", "Select Course", colleges); tempSelect.ShowDialog(); if (tempSelect.Selection == "***") return; string[] separate = { " - " }; string[] select = tempSelect.Selection.Split(separate, StringSplitOptions.None); //frmSubmitText tempfrm = new frmSubmitText("Enter ID", "Please enter Component ID"); //tempfrm.ShowDialog(); //if (Check.Tables[0].Rows.Count == 0) //{ // MessageBox.Show("Component doesn't exist", "Error"); // return; //} DataSet Check = Database.Query("components", "idCourseComponents = '" + select[1] + "'"); string[] arrEnrollmentID = SplitByString(cboEnrollments.Text, "-"); if ( Database.Count("coursecomponents", "idCourses = 'ENR" + arrEnrollmentID[1] + "' AND idComponents = '" + select[1] + "'") == 0 && Database.Count("enrollmentComponents", "idEnrollments = '" + arrEnrollmentID[1] + "' AND idCourseComponents = '" + select[1] + "'") == 0 ) { string[] columns = { "idCourses", "idComponents" }; string[] values = { "ENR" + arrEnrollmentID[1], select[1] }; Database.Insert("coursecomponents", columns, values); if (Convert.ToString(Check.Tables[0].Rows[0]["isElective"]) == "1") { columns = new string[2]; columns[0] = "idEnrollments"; columns[1] = "idCourseComponents"; values[0] = arrEnrollmentID[1]; values[1] = select[1]; Database.Insert("enrollmentcomponents", columns, values); } } else { Database.Command("UPDATE enrollmentcomponents SET status = Null WHERE idEnrollments = '" + arrEnrollmentID[1] + "' AND idCourseComponents = '" + select[1] + "'"); } clsFunctions.WriteLog("Added to Enrollment (" + arrEnrollmentID[1] + ") : " + select[1]); load_enrollments(arrEnrollmentID[1]); }