Example #1
0
        private void button3_Click(object sender, EventArgs e)
        {
            var splitter = SplitByString(trvCourses.SelectedNode.Text, " - ");
            try
            {
                var update = Database.Query("Courses", "idCourses = '" + splitter[0] + "'");
                update.Tables[0].Rows[0]["Name"] = txtName.Text;
                update.Tables[0].Rows[0]["IDcourses"] = txtID.Text;
                update.Tables[0].Rows[0]["Type"] = clsFunctions.retrieveAbrev(lstTypes.Text);
                update.Tables[0].Rows[0]["hasElectives"] = txtElectives.Text;
                update.Tables[0].Rows[0]["maxElectives"] = txtElectivesMax.Text;
                update.Tables[0].Rows[0]["active"] = chkActive.Checked ? (object)"1" : DBNull.Value;
                Database.Update(update, "courses", "idCourses = '" + splitter[0] + "'");
                trvCourses.SelectedNode.Text = txtID.Text + " - " + txtName.Text;

            }
            catch
            {
                if (clsFunctions.retrieveAbrev(lstTypes.Text) == "PROJ"
                    && nqfTextBox.Text.Length == 0)
                {
                    MessageBox.Show("Please specify a NQF Level");
                    return;
                }

                string tempName;
                var update = Database.Query("components", "idCourseComponents = '" + splitter[0] + "'");
                update.Tables[0].Rows[0]["IsElective"] = chkElective.Checked ? (object)"1" : DBNull.Value;
                update.Tables[0].Rows[0]["showOnAssesment"] = chkAssesment.Checked ? (object)"yes" : DBNull.Value;
                tempName = update.Tables[0].Rows[0]["Name"].ToString();
                update.Tables[0].Rows[0]["Name"] = txtName.Text;
                update.Tables[0].Rows[0]["idCourseComponents"] = txtID.Text;
                update.Tables[0].Rows[0]["totalMark"] = txtMarks.Text;
                update.Tables[0].Rows[0]["ComponentAbrev"] = clsFunctions.retrieveAbrev(lstTypes.Text);
                update.Tables[0].Rows[0]["nqfLevel"] = Convert.ToInt16(nqfTextBox.Text);

                try
                {
                    update.Tables[0].Rows[0]["nqfLevel"] = nqfTextBox.Text.Length > 0 ? Convert.ToInt16(nqfTextBox.Text) : 0;
                }
                catch (FormatException)
                {
                    MessageBox.Show("Please enter a number for nqfLevel");
                    return;
                }
                try
                {
                    update.Tables[0].Rows[0]["credits"] = creditsTextBox.Text.Length > 0 ? Convert.ToInt16(creditsTextBox.Text) : 0;
                }
                catch (FormatException)
                {
                    MessageBox.Show("Please enter a number for credits");
                    return;
                }
                Database.Update(update, "components", "idCourseComponents = '" + splitter[0] + "'");

                if (clsFunctions.retrieveAbrev(lstTypes.Text) == "SC" || clsFunctions.retrieveAbrev(lstTypes.Text) == "PROJ")
                {
                    bool allColleges = DevExpress.XtraEditors.XtraMessageBox.Show("Would you like to apply this change to other components with the same name?", "Alert", MessageBoxButtons.YesNo) == DialogResult.Yes;
                    if (allColleges)
                    {

                        var list = Database.Query("SELECT * FROM components WHERE Name = '" + tempName + "' AND idCourseComponents <> '" + txtID.Text + "'");
                        var theListArray = new ArrayList();
                        foreach (DataRow theRow in list.Tables[0].Rows)
                        {
                            theListArray.Add(theRow["idCourseComponents"]);
                        }
                        var listSelect = new frmSelectMulti("Select Courses to Update", "Select Course", theListArray);
                        listSelect.ShowDialog();
                        if (listSelect.Selection == null) return;
                        string theInString = "";
                        foreach (string theString in listSelect.Selection)
                        {
                            theInString += "'" + theString + "',";
                        }
                        theInString = theInString.Remove(theInString.Length - 1);

                        var list2 = Database.Query("SELECT * FROM components WHERE idCourseComponents in(" + theInString + ")");
                        foreach (DataRow theRow in list2.Tables[0].Rows)
                        {
                            Database.Command("UPDATE components SET IsElective = " + (chkElective.Checked ? "1" : "Null") +
                                ", showOnAssesment = " + (chkAssesment.Checked ? "'yes'" : "Null") + ", Name = '" + txtName.Text +
                                "', totalMark = '" + txtMarks.Text + "', ComponentAbrev = '" + clsFunctions.retrieveAbrev(lstTypes.Text) +
                                "', nqfLevel = '" + nqfTextBox.Text + "', credits = '" + creditsTextBox.Text + "' WHERE idCourseComponents = '" + theRow["idCourseComponents"] + "'");
                        }
                    }
                }
                else
                {
                    bool allColleges = DevExpress.XtraEditors.XtraMessageBox.Show("Would you like to apply this change to other components that belong to short courses/projects with the same name?", "Alert", MessageBoxButtons.YesNo) == DialogResult.Yes;
                    if (allColleges)
                    {
                        var parent = Database.Row("SELECT * FROM components WHERE idCourseComponents = '" + bubbleParent(txtID.Text) + "'");
                        var list = Database.Query("SELECT * FROM components WHERE Name = '" + parent["Name"] + "' AND idCourseComponents <> '" + parent["idCourseComponents"] + "'");
                        var theListArray = new ArrayList();
                        foreach (DataRow theRow in list.Tables[0].Rows)
                        {
                            theListArray.Add(txtID.Text.Replace(parent["idCourseComponents"].ToString(),theRow["idCourseComponents"].ToString()));
                        }
                        var listSelect = new frmSelectMulti("Select Courses to Update", "Select Course", theListArray);
                        listSelect.ShowDialog();
                        if (listSelect.Selection == null) return;
                        string theInString = "";
                        foreach (string theString in listSelect.Selection)
                        {
                            theInString += "'" + theString + "',";
                        }
                        theInString = theInString.Remove(theInString.Length - 1);
                        var list2 = Database.Query("SELECT * FROM components WHERE idCourseComponents in(" + theInString + ")");
                        foreach (DataRow theRow in list2.Tables[0].Rows)
                        {
                            Database.Command("UPDATE components SET IsElective = " + (chkElective.Checked ? "1" : "Null") +
                                ", showOnAssesment = " + (chkAssesment.Checked ? "'yes'" : "Null") + ", Name = '" + txtName.Text +
                                "', totalMark = '" + txtMarks.Text + "', ComponentAbrev = '" + clsFunctions.retrieveAbrev(lstTypes.Text) +
                                "', nqfLevel = '" + nqfTextBox.Text + "', credits = '" + creditsTextBox.Text + "' WHERE idCourseComponents = '" + theRow["idCourseComponents"] + "'");
                        }
                    }
                }
                trvCourses.SelectedNode.Text = txtID.Text + " - " + txtName.Text;

            }
        }
Example #2
0
        private void courseEnrollmentToolStripMenuItem_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"]);
            //}
            var frmSelect = new frmCourseSelect("Select Course", "Course to Enroll In");
            frmSelect.ShowDialog();
            if (frmSelect.Selection == "***")
                return;

            string[] arrSplit = new string[5];
            string[] splitter = { " - " };

            arrSplit = SplitByString(frmSelect.Selection, " - ");

            DataSet temp = Database.Query("enrollments", "idEnrollments = 0");

            string[] columns = new string[4];
            string[] values = new string[4];

            for (int i2 = 1; i2 <= 4; i2++)
            {
                DataColumn theColumn = temp.Tables[0].Columns[i2];

                columns[i2 - 1] = theColumn.ColumnName;

            }

            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");

            DataSet haselectives = Database.Query("courses", "idCourses = '" + arrSplit[0] + "'");
            if (haselectives.Tables[0].Rows.Count > 0)
            {
                if (Convert.ToString(haselectives.Tables[0].Rows[0]["hasElectives"]) != "0")
                {
                    //Retrieve Elective Component Links
                    DataSet electives = Database.Query("coursecomponents", "idCourses = '" + arrSplit[0] + "'");
                    //foreach elective
                    ArrayList theList = new ArrayList();
                    foreach (DataRow theRow in electives.Tables[0].Rows)
                    {
                        DataSet row = Database.Query("components", "idCourseComponents = '" + theRow["idComponents"] + "'");
                        DataRow thetheRow = row.Tables[0].Rows[0];
                        if (Convert.ToString(thetheRow["isElective"]) == "1")
                            theList.Add(Convert.ToString(thetheRow["idCourseComponents"]) + " - " + Convert.ToString(thetheRow["Name"]));
                    }
                    frmSelectMulti frmMultiSelect = null;
                    try
                    {
                        frmMultiSelect = new frmSelectMulti("Select Electives",
                                                                           "Please Select Electives:",
                                                                           Convert.ToInt16(
                                                                               haselectives.Tables[0].Rows[0][
                                                                                   "hasElectives"]),
                                                                           Convert.ToInt16(
                                                                               haselectives.Tables[0].Rows[0][
                                                                                   "maxElectives"]), theList);

                    }
                    catch
                    {
                        MessageBox.Show(
                            "An error has occured with this action. This is most likely due to no elective information for the course.");
                        return;
                    }
                    if (frmMultiSelect != null)
                    {
                        frmMultiSelect.ShowDialog();
                        if (frmMultiSelect.Selection == null)
                            return;
                        foreach (object item in frmMultiSelect.Selection)
                        {
                            string[] arrSplit2 = new string[5];

                            arrSplit2 = SplitByString((string)item, " - ");
                            string[] columns2 = { "idEnrollments", "idCourseComponents" };
                            string[] values2 = new string[2];
                            values2[0] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]);
                            values2[1] = arrSplit2[0];
                            Database.Insert("enrollmentcomponents", columns2, values2);
                        }
                        if (frmMultiSelect.Selection.Count == 0)
                            return;
                    }
                }
            }

            string[] arrSplit3 = new string[5];

            arrSplit3 = SplitByString(frmSelect.Selection, " - ");

            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

            clsFunctions.WriteLog("Created new enrollment for learner (" + GlobalProperties.strLearnerNumber + ") : Course " + arrSplit[0] + ": Enrollment (" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]) + ")");
            columns = new string[2];
            columns[0] = "idEnrollments";
            columns[1] = "idCourses";
            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();

            values[0] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]);
            values[1] = "ENR" + Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]);
            string subject = (cboEnrollments.Items.Count >= 1 ? "Additional Enrollment :" : "NewEnrollment :");
            Database.Insert("enrollmentscourses", columns, values);
            string message = GlobalProperties.LoggedOnUserDivision + " Learner " + GlobalProperties.strLearnerNumber + " has enrolled for " + arrSplit[1] + ".\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] = "";
            values[1] = "";
            values[2] = "";
            values[3] = "";
            values[4] = "";
            values[5] = "";
            values[6] = "";
            values[7] = "";
            values[8] = "No";
            values[9] = "No";
            values[10] = "";
            values[11] = Convert.ToString(tempe.Tables[0].Rows[0]["idEnrollments"]);
            Database.Insert("paymentinfo", columns, values);
            frmSelect.Dispose();

            load_enrollmentstab();
            cboEnrollments.SelectedIndex = cboEnrollments.Items.Count - 1;
            string[] arrEnrollmentID = new string[5];

            arrEnrollmentID = SplitByString(cboEnrollments.Text, "-");

            load_enrollments(arrEnrollmentID[1]);
            panel1.Visible = true;
            txtTotalContractPrice.Focus();
        }