示例#1
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            if (cboSearchCriteria.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboSearchCriteria.Focus();
            }
            else if (txtSearchValue.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtSearchValue.Focus();
            }
            else if (cboSemesterSearch.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboSemesterSearch.Focus();
            }
            else if (cboAcYrSearch.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboAcYrSearch.Focus();
            }
            else
            {
                Conn connect = new Conn();
                if (connect.OpenConnection() == true)
                {
                    string searchval = "%" + txtSearchValue.Text + "%";
                    if (cboSearchCriteria.Text == "All")
                    {
                        query = "SELECT * FROM loading WHERE Semester='" + cboSemesterSearch.Text + "' and Academic_Year='" + cboAcYrSearch.Text + "' ORDER BY Loading_Code ASC";
                    }
                    else if (cboSearchCriteria.Text == "Course Code")
                    {
                        query = "SELECT * FROM loading WHERE ProgCourse_Code LIKE '" + searchval + "' and Semester='" + cboSemesterSearch.Text + "' and Academic_Year='" + cboAcYrSearch.Text + "' ORDER BY Loading_Code ASC";
                    }
                    else if (cboSearchCriteria.Text == "Program Code")
                    {
                        query = "SELECT * FROM loading WHERE ProgCourse_Code LIKE '" + searchval + "' and Semester='" + cboSemesterSearch.Text + "' and Academic_Year='" + cboAcYrSearch.Text + "' ORDER BY Loading_Code ASC";
                    }
                    else
                    {
                        MessageBox.Show("Invalid Criteria", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        cboSearchCriteria.Focus();
                    }


                    MySqlCommand    cmd        = new MySqlCommand(query, connect.connection);
                    MySqlDataReader dataReader = cmd.ExecuteReader();
                    //Read the data and store them in the list
                    this.dataGridView1.Rows.Clear();
                    while (dataReader.Read())
                    {
                        if (dataReader["Loading_Code"].ToString().Replace(" ", "") != "")
                        {
                            string[] row = new string[] { dataReader["Loading_Code"].ToString(), dataReader["ProgCourse_Code"].ToString(), dataReader["Venue"].ToString(), dataReader["Lecture_Time"].ToString(), dataReader["Semester"].ToString(), dataReader["Academic_Year"].ToString(), dataReader["Staff_No"].ToString(), GetStaff(dataReader["Staff_No"].ToString()) };
                            dataGridView1.Rows.Add(row);
                        }
                    }


                    connect.CloseConnection();
                    PrintDialog printDial = new PrintDialog();
                    printDial.Document    = printDocument1;
                    printDial.UseEXDialog = true;
                    if (DialogResult.OK == printDial.ShowDialog())
                    {
                        printDocument1.DocumentName = "Loading Details";
                        printDocument1.Print();
                    }
                }
            }
        }
示例#2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (txtLoadingCode.Text.Replace(" ", "") == "" && cboLoadingCode.Visible == false)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtLoadingCode.Focus();
            }
            else if (cboLoadingCode.Text.Replace(" ", "") == "" && cboLoadingCode.Visible == true)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtLoadingCode.Focus();
            }
            else if (cboCourse.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboCourse.Focus();
            }
            else if (txtVenue.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtVenue.Focus();
            }
            else if (txtTime.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtTime.Focus();
            }
            else if (cboSemester.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboSemester.Focus();
            }
            else if (cboAcYr.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboAcYr.Focus();
            }
            else if (cboStaffName.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboStaffName.Focus();
            }
            else
            {
                string msg = "";
                int    op;
                if (lodCode == "")
                {
                    if (FindRecord(txtLoadingCode.Text.ToString()) == false)
                    {
                        query = "INSERT INTO loading VALUES('" + txtLoadingCode.Text.ToString() + "', '" + cboCourse.Text.ToString() + "','" + txtVenue.Text + "', '" + txtTime.Text.ToString() + "','" + cboSemester.Text.ToString() + "','" + cboAcYr.Text.ToString() + "','" + lblStaffNo.Text + "')";
                        msg   = "Records have been successfully saved";
                        op    = 0;
                    }
                    else
                    {
                        query = "UPDATE loading SET Loading_Code='" + txtLoadingCode.Text + "',ProgCourse_Code='" + cboCourse.Text.ToString() + "', Venue= '" + txtVenue.Text.ToString() + "', Lecture_Time='" + txtTime.Text.ToString() + "', Semester='" + cboSemester.Text.ToString() + "', Academic_Year='" + cboAcYr.Text + "',Staff_No='" + lblStaffNo.Text + "' WHERE Loading_Code='" + txtLoadingCode.Text.ToString() + "'";
                        msg   = "Records have been Successfully updated!";
                        op    = 1;
                    }
                }
                else
                {
                    query = "UPDATE loading SET Loading_Code='" + cboLoadingCode.Text + "',ProgCourse_Code='" + cboCourse.Text.ToString() + "', Venue= '" + txtVenue.Text.ToString() + "', Lecture_Time='" + txtTime.Text.ToString() + "',Semester='" + cboSemester.Text.ToString() + "',Academic_Year='" + cboAcYr.Text + "',Staff_No='" + lblStaffNo.Text + "' WHERE Loading_Code='" + lodCode + "'";
                    msg   = "Records have been Successfully updated!";
                    op    = 1;
                }

                //open connection
                Conn connect = new Conn();
                connect.CloseConnection();
                if (connect.OpenConnection() == true)
                {
                    if (op == 0)
                    {
                        optn = "Are you sure you want to Insert these details?";
                        //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question);
                    }
                    else
                    {
                        optn = optn = "Are you sure you want to update these details?";
                        //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question);
                    }
                    if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        //create command and assign the query and connection from the constructor
                        MySqlCommand cmd = new MySqlCommand(query, connect.connection);

                        //Execute command
                        cmd.ExecuteNonQuery();

                        //close connection


                        clean();
                        MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        clean();
                        MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    connect.CloseConnection();
                    GetLoadings();
                }
            }
        }
示例#3
0
        private void btnPostLoading_Click(object sender, EventArgs e)
        {
            string msg = "";
            Conn   connect = new Conn();
            Conn   connect1 = new Conn();
            Conn   connect2 = new Conn();
            Conn   connect3 = new Conn();
            Conn   connect4 = new Conn();
            Conn   connect5 = new Conn();
            string query1, query2, query3, query4, query5;

            connect.CloseConnection();
            if (connect.OpenConnection() == true)
            {
                query = "DELETE FROM lecturer_enquiry";
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connect.connection);
                //Execute command
                cmd.ExecuteNonQuery();
                //close connection
            }
            connect.CloseConnection();

            if (connect1.OpenConnection() == true)
            {
                query1 = "SELECT DISTINCT Staff_No FROM loading ORDER BY Staff_No ASC";
                MySqlCommand    cmd1        = new MySqlCommand(query1, connect1.connection);
                MySqlDataReader dataReader1 = cmd1.ExecuteReader();
                //Read the data and store them in the list
                while (dataReader1.Read())
                {
                    if (connect2.OpenConnection() == true)
                    {
                        query2 = "SELECT DISTINCT Academic_Year FROM loading WHERE Staff_No='" + dataReader1["Staff_No"].ToString() + "' ORDER BY Academic_Year ASC";
                        MySqlCommand    cmd2        = new MySqlCommand(query2, connect2.connection);
                        MySqlDataReader dataReader2 = cmd2.ExecuteReader();
                        while (dataReader2.Read())
                        {
                            if (connect3.OpenConnection() == true)
                            {
                                query3 = "SELECT DISTINCT Semester FROM loading WHERE Academic_Year='" + dataReader2["Academic_Year"].ToString() + "' AND Staff_No='" + dataReader1["Staff_No"].ToString() + "' ORDER BY Semester ASC";
                                MySqlCommand    cmd3        = new MySqlCommand(query3, connect3.connection);
                                MySqlDataReader dataReader3 = cmd3.ExecuteReader();
                                while (dataReader3.Read())
                                {
                                    if (connect4.OpenConnection() == true)
                                    {
                                        query4 = "SELECT * FROM loading WHERE Semester='" + dataReader3["Semester"] + "' and  Academic_Year='" + dataReader2["Academic_Year"] + "' and Staff_No='" + dataReader1["Staff_No"].ToString() + "' ORDER BY Semester ASC";
                                        MySqlCommand    cmd4        = new MySqlCommand(query4, connect4.connection);
                                        MySqlDataReader dataReader4 = cmd4.ExecuteReader();
                                        msg = "";
                                        while (dataReader4.Read())
                                        {
                                            msg = msg + " " + dataReader4["ProgCourse_Code"];
                                        }
                                        if (connect5.OpenConnection() == true)
                                        {
                                            query5 = "INSERT INTO lecturer_enquiry(Academic_Year,Semester,Staff_No,Message) VALUES('" + dataReader4["Academic_Year"] + "', '" + dataReader4["Semester"] + "', '" + dataReader4["Staff_No"] + "','" + msg + "')";

                                            MySqlCommand cmd5 = new MySqlCommand(query5, connect5.connection);

                                            //Execute command
                                            cmd5.ExecuteNonQuery();
                                        }
                                        connect5.CloseConnection();
                                    }
                                    connect4.CloseConnection();
                                }
                                //MessageBox.Show("Connection3");
                            }
                            connect3.CloseConnection();
                        }
                        //MessageBox.Show("Connection2");
                    }
                    connect2.CloseConnection();
                }
                //MessageBox.Show("Connection1");
            }
            connect1.CloseConnection();
            MessageBox.Show("Posting Complete!", "MMUST", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
        }
示例#4
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (cboLoadingCode.Visible == false)
            {
                MessageBox.Show("Select Records to Delete", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboLoadingCode.Visible = true;
                cboLoadingCode.Focus();
            }
            else if (cboLoadingCode.Text.Replace(" ", "") == "" && cboLoadingCode.Visible == true)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtLoadingCode.Focus();
            }
            else if (cboCourse.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboCourse.Focus();
            }
            else if (txtVenue.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtVenue.Focus();
            }
            else if (txtTime.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtTime.Focus();
            }
            else if (cboSemester.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboSemester.Focus();
            }
            else if (cboAcYr.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboAcYr.Focus();
            }
            else if (cboStaffName.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboStaffName.Focus();
            }
            else
            {
                Conn connect = new Conn();
                connect.CloseConnection();
                if (connect.OpenConnection() == true)
                {
                    if (MessageBox.Show("Are you sure you want to delete these details?", "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        query = "DELETE FROM loading WHERE Loading_Code='" + cboLoadingCode.Text + "'";
                        //create command and assign the query and connection from the constructor
                        MySqlCommand cmd = new MySqlCommand(query, connect.connection);

                        //Execute command
                        cmd.ExecuteNonQuery();

                        //close connection

                        clean();

                        MessageBox.Show("Records Successfully Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        clean();
                        MessageBox.Show("Records Not Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    connect.CloseConnection();
                    GetLoadings();
                }
            }
        }
示例#5
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            int    units;
            string unt = txtUnits.Text.Trim().ToString();

            txtCourseCode.Text = txtCourseCode.Text.ToUpper();
            cboCourseCode.Text = cboCourseCode.Text.ToUpper();
            if (txtCourseCode.Text.Replace(" ", "") == "" && cboCourseCode.Visible == false)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtCourseCode.Focus();
            }
            else if (cboCourseCode.Text.Replace(" ", "") == "" && cboCourseCode.Visible == true)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtCourseCode.Focus();
            }
            else if (txtCourseName.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtCourseName.Focus();
            }
            else if (txtDescription.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtDescription.Focus();
            }
            else if (cboSemCode.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboSemCode.Focus();
            }
            else if (cboYoS.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboYoS.Focus();
            }
            else if (txtUnits.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtUnits.Focus();
            }
            else if (!int.TryParse(unt, out units))
            {
                MessageBox.Show("Invalid data!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtUnits.Focus();
            }
            else
            {
                string msg = "";
                int    op;
                if (cosCode == "")
                {
                    if (FindRecord(txtCourseCode.Text.ToString()) == false)
                    {
                        query = "INSERT INTO course VALUES('" + txtCourseCode.Text.ToString() + "', '" + txtCourseName.Text.ToString() + "','" + txtDescription.Text + "', '" + cboSemCode.Text.ToString() + "','" + cboYoS.Text.ToString() + "'," + units + ")";
                        msg   = "Records have been successfully saved";
                        op    = 0;
                    }
                    else
                    {
                        query = "UPDATE course SET Course_Code='" + txtCourseCode.Text.ToString() + "', Course_Name= '" + txtCourseName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "', Semester='" + cboSemCode.Text.ToString() + "', Year_of_Study='" + cboYoS.Text + "',Units=" + units + " WHERE Course_Code='" + txtCourseCode.Text.ToString() + "'";
                        msg   = "Records have been Successfully updated!";
                        op    = 1;
                    }
                }
                else
                {
                    query = "UPDATE course SET Course_Code='" + cboCourseCode.Text.ToString() + "', Course_Name= '" + txtCourseName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "',Semester='" + cboSemCode.Text.ToString() + "',Year_of_Study='" + cboYoS.Text + "',Units=" + units + " WHERE Course_Code='" + cosCode + "'";
                    msg   = "Records have been Successfully updated!";
                    op    = 1;
                }

                //open connection
                Conn connect = new Conn();
                connect.CloseConnection();
                if (connect.OpenConnection() == true)
                {
                    if (op == 0)
                    {
                        optn = "Are you sure you want to Insert these details?";
                        //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question);
                    }
                    else
                    {
                        optn = optn = "Are you sure you want to update these details?";
                        //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question);
                    }
                    if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        //create command and assign the query and connection from the constructor
                        MySqlCommand cmd = new MySqlCommand(query, connect.connection);

                        //Execute command
                        cmd.ExecuteNonQuery();

                        //close connection


                        clean();
                        MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        clean();
                        MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    connect.CloseConnection();
                    GetCourses();
                }
            }
        }
示例#6
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            txtFacultyCode.Text = txtFacultyCode.Text.ToUpper();
            cboFacultyCode.Text = cboFacultyCode.Text.ToUpper();
            if (txtFacultyCode.Text.Replace(" ", "") == "" && cboFacultyCode.Visible == false)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtFacultyCode.Focus();
            }
            else if (cboFacultyCode.Text.Replace(" ", "") == "" && cboFacultyCode.Visible == true)
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboFacultyCode.Focus();
            }
            else if (txtFacultyName.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtFacultyName.Focus();
            }
            else if (txtDescription.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtDescription.Focus();
            }
            else
            {
                string msg = "";
                int    op;
                if (facCode == "")
                {
                    if (FindRecord(txtFacultyCode.Text.ToString()) == false)
                    {
                        query = "INSERT INTO faculty VALUES('" + txtFacultyCode.Text.ToString() + "', '" + txtFacultyName.Text.ToString() + "', '" + txtDescription.Text.ToString() + "')";
                        msg   = "Records have been successfully saved";
                        op    = 0;
                    }
                    else
                    {
                        query = "UPDATE faculty SET Faculty_Code='" + txtFacultyCode.Text.ToString() + "', Faculty_Name= '" + txtFacultyName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "' WHERE Faculty_Code='" + txtFacultyCode.Text.ToString() + "'";
                        msg   = "Records have been Successfully updated!";
                        op    = 1;
                    }
                }
                else
                {
                    query = "UPDATE faculty SET Faculty_Code='" + cboFacultyCode.Text.ToString() + "', Faculty_Name= '" + txtFacultyName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "' WHERE Faculty_Code='" + facCode + "'";
                    msg   = "Records have been Successfully updated!";
                    op    = 1;
                }

                //open connection
                Conn connect = new Conn();
                if (connect.OpenConnection() == true)
                {
                    if (op == 0)
                    {
                        optn = "Are you sure you want to Insert these details?";
                        //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question);
                    }
                    else
                    {
                        optn = optn = "Are you sure you want to update these details?";
                        //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question);
                    }
                    if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        //create command and assign the query and connection from the constructor
                        MySqlCommand cmd = new MySqlCommand(query, connect.connection);

                        //Execute command
                        cmd.ExecuteNonQuery();

                        //close connection


                        clean();
                        MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        clean();
                        MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    connect.CloseConnection();
                    GetFaculties();
                }
            }
        }
示例#7
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            if (cboSearchCriteria.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                cboSearchCriteria.Focus();
            }
            else if (txtSearchValue.Text.Replace(" ", "") == "")
            {
                MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                txtSearchValue.Focus();
            }
            else
            {
                Conn connect = new Conn();
                if (connect.OpenConnection() == true)
                {
                    string searchval = "%" + txtSearchValue.Text + "%";
                    if (cboSearchCriteria.Text == "All")
                    {
                        query = "SELECT * FROM faculty ORDER BY Faculty_Code ASC";
                    }
                    else if (cboSearchCriteria.Text == "Faculty Code")
                    {
                        query = "SELECT * FROM faculty WHERE Faculty_Code LIKE '" + searchval + "' ORDER BY Faculty_Code ASC";
                    }
                    else if (cboSearchCriteria.Text == "Faculty Name")
                    {
                        query = "SELECT * FROM faculty WHERE Faculty_Name LIKE '" + searchval + "' ORDER BY Faculty_Code ASC";
                    }
                    else
                    {
                        MessageBox.Show("Invalid Criteria", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        cboSearchCriteria.Focus();
                    }


                    MySqlCommand    cmd        = new MySqlCommand(query, connect.connection);
                    MySqlDataReader dataReader = cmd.ExecuteReader();
                    //Read the data and store them in the list
                    this.dataGridView1.Rows.Clear();
                    while (dataReader.Read())
                    {
                        if (dataReader["Faculty_Code"].ToString().Replace(" ", "") != "")
                        {
                            string[] row = new string[] { dataReader["Faculty_Code"].ToString(), dataReader["Faculty_Name"].ToString(), dataReader["Description"].ToString() };
                            dataGridView1.Rows.Add(row);
                        }
                    }

                    connect.CloseConnection();
                    PrintDialog printDial = new PrintDialog();
                    printDial.Document    = printDocument1;
                    printDial.UseEXDialog = true;
                    if (DialogResult.OK == printDial.ShowDialog())
                    {
                        printDocument1.DocumentName = "Faculty Details";
                        printDocument1.Print();
                    }
                }
            }
        }