Пример #1
0
        }//End of Load

        public List <EnrolledStudents> CountStudInSection()
        {
            try
            {
                //prepare connection string
                using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
                {
                    //try to open connection
                    con.Open();

                    //prepare sql query
                    string sql = "SELECT * FROM enrolled_grade_11  WHERE section =@section;";


                    MySqlCommand cmd = new MySqlCommand(sql, con);
                    cmd.Parameters.AddWithValue("section", section);

                    MySqlDataReader reader = cmd.ExecuteReader();

                    //loop while have record
                    while (reader.Read())
                    {
                        //instantiate model
                        EnrolledStudents enroll = new EnrolledStudents();

                        //prepare properties
                        enroll.id         = Convert.ToInt32(reader["id"].ToString());
                        enroll.regNo      = reader["regno"].ToString();
                        enroll.theGOCNo   = reader["gocno"].ToString();
                        enroll.fullName   = reader["full_name"].ToString();
                        enroll.gradeLevel = reader["grade_level"].ToString();
                        enroll.strand     = reader["strand"].ToString();
                        enroll.section    = reader["section"].ToString();
                        enroll.semester   = reader["semester"].ToString();
                        enroll.syEnroll   = reader["sy_enrolled"].ToString();

                        //  MessageBox.Show("sasa");

                        enrollees.Add(enroll);
                    }
                }
            }
            catch (MySqlException ex)
            {
                MessageBox.Show("ERROR : " + ex.ToString(), "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return(enrollees);
        }
Пример #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            string            message = "Do you want to assign all " + lblCount.Text + " Student(s) to section " + cmbToAssign.Text + "?";
            string            title   = "GOC_INFOSYS";
            MessageBoxButtons buttons = MessageBoxButtons.YesNo;
            DialogResult      result  = MessageBox.Show(message, title, buttons);

            if (result == DialogResult.Yes)
            {
                for (int i = 0; i < dgvSectionBefore.Rows.Count; i++)
                {
                    studProfile.StudGOCNo = dgvSectionBefore.Rows[i].Cells[0].FormattedValue.ToString();
                    studProfile.Section   = cmbToAssign.Text;
                    studProfile.UpdateTheSectionWithGOCNO();

                    EnrolledStudents enroll = new EnrolledStudents();
                    enroll.RegNo      = dgvSectionBefore.Rows[i].Cells[7].FormattedValue.ToString();
                    enroll.TheGOCNo   = dgvSectionBefore.Rows[i].Cells[0].FormattedValue.ToString();
                    enroll.FullName   = dgvSectionBefore.Rows[i].Cells[3].FormattedValue.ToString() + ", " + dgvSectionBefore.Rows[i].Cells[1].FormattedValue.ToString() + " " + dgvSectionBefore.Rows[i].Cells[2].FormattedValue.ToString();
                    enroll.GradeLevel = dgvSectionBefore.Rows[i].Cells[5].FormattedValue.ToString();
                    enroll.Strand     = dgvSectionBefore.Rows[i].Cells[4].FormattedValue.ToString();
                    enroll.Section    = cmbToAssign.Text;
                    enroll.Semester   = lblSemester.Text;
                    enroll.SyEnroll   = dgvSectionBefore.Rows[i].Cells[9].FormattedValue.ToString();

                    if (dgvSectionBefore.Rows[i].Cells[5].FormattedValue.ToString() == "11")
                    {
                        enroll.Save();//grade 11
                    }
                    else
                    {
                        enroll.SaveGrade12();//grade 12
                    }
                }
                MessageBox.Show("Section Saved!", "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                a = 0;
                WithSectionStudents();
                CountStudPerSection();
                strand = cmbStrand.Text;
                CheckSectionInfo();
                CheckRoomInfo();
            }
            else
            {
                string input = Microsoft.VisualBasic.Interaction.InputBox("How many student do you want to assign to section " + cmbToAssign.Text + "?", "GOC_INFOSYS", "", -1, -1);
                int    listSize;
                bool   success = int.TryParse(input, out listSize);

                if (listSize > dgvSectionBefore.Rows.Count)//check if the current no is not greaterthan the input
                {
                    MessageBox.Show("Sorry you cannot assign morethan " + dgvSectionBefore.Rows.Count + " students.");
                }
                else
                {
                    for (int i = 0; i < listSize; i++)
                    {
                        studProfile.StudGOCNo = dgvSectionBefore.Rows[i].Cells[0].FormattedValue.ToString();
                        studProfile.Section   = cmbToAssign.Text;
                        studProfile.UpdateTheSectionWithGOCNO();

                        EnrolledStudents enroll = new EnrolledStudents();
                        enroll.RegNo      = dgvSectionBefore.Rows[i].Cells[7].FormattedValue.ToString();
                        enroll.TheGOCNo   = dgvSectionBefore.Rows[i].Cells[0].FormattedValue.ToString();
                        enroll.FullName   = dgvSectionBefore.Rows[i].Cells[3].FormattedValue.ToString() + ", " + dgvSectionBefore.Rows[i].Cells[1].FormattedValue.ToString() + " " + dgvSectionBefore.Rows[i].Cells[2].FormattedValue.ToString();
                        enroll.GradeLevel = dgvSectionBefore.Rows[i].Cells[5].FormattedValue.ToString();
                        enroll.Strand     = dgvSectionBefore.Rows[i].Cells[4].FormattedValue.ToString();
                        enroll.Section    = cmbToAssign.Text;
                        enroll.Semester   = lblSemester.Text;
                        enroll.SyEnroll   = dgvSectionBefore.Rows[i].Cells[9].FormattedValue.ToString();

                        if (dgvSectionBefore.Rows[i].Cells[5].FormattedValue.ToString() == "11")
                        {
                            enroll.Save();//grade 11
                            MessageBox.Show("Section Saved!", "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            enroll.SaveGrade12();//grade 12
                            MessageBox.Show("Section Saved!", "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }

                    a = 0;
                    WithSectionStudents();
                    CountStudPerSection();
                    strand = cmbStrand.Text;
                    CheckSectionInfo();
                    CheckRoomInfo();
                }
                return;
            }
        }