private void tabControl1_Click(object sender, EventArgs e)
        {
            session lec = new session();

            lecturerbox.DataSource = lec.getLectures();

            subjectBox.DataSource = lec.getSubjects();

            GroupBox.DataSource = lec.getGroupID();

            sessionList.DataSource = lec.getSessiondatatoTable();

            findSessionList.DataSource = lec.getSessiondatatoTable();
        }
        public CreateSession()
        {
            InitializeComponent();



            session lecturer = new session();

            for (int i = 0; i < lecturer.getSessiondatatoTable().Rows.Count; i++)
            {
                show_data(lecturer.getSessiondatatoTable(), i);
            }
            lecturerlist.DataSource = lecturer.getLectures();

            subNamelist.DataSource = lecturer.getSubjects();


            sessionList.DataSource = lecturer.getSessiondatatoTable();

            findSessionList.DataSource = lecturer.getSessiondatatoTable();
        }
        public roomsManaging()
        {
            InitializeComponent();
            roomsConn          roomsConn          = new roomsConn();
            roomsWithLecCon    rql                = new roomsWithLecCon();
            session            lecturer           = new session();
            BatchesConn        bc                 = new BatchesConn();
            consecutivesession consecutivesession = new consecutivesession();

            assignRoom.DataSource           = roomsConn.getRooms();
            asubjectCode.DataSource         = roomsConn.getSession();
            roomManagingSource.DataSource   = roomsConn.load_con_sesssion_details();
            notAvailableGridView.DataSource = roomsConn.load_not_available_details();
            lecWithRoomsGrid.DataSource     = roomsConn.load_Lec_with_rooms();
            faculty.DataSource     = roomsConn.getFaultyRooms();
            rfaculty.DataSource    = roomsConn.getFaultyRooms();
            electurenme.DataSource = lecturer.getLectures();
            grpNme.DataSource      = bc.getAllGroupIds();
            subGNme.DataSource     = bc.getAllSubGroupIds();

            //           lroomtype.DataSource = roomsConn.
            loadLecturerPreferedTags();
            loadSessionItems();
        }
        private void Createsessions_Click(object sender, EventArgs e)
        {
            if (type.Text != "" && Gid.Text != "" && Scount.Text != "" && subNamelist.Text != "" && subcodeList.Text != "" && lecList.Items.Count != 0)
            {
                foreach (DataGridViewRow row in sessionList.Rows)
                {
                    if (row.Cells[1].Value.ToString().Equals(subcodeList.Text) && row.Cells[2].Value.ToString().Equals(type.Text) && row.Cells[3].Value.ToString().Equals(Gid.Text))
                    {
                        if (type.Text == "Practical")
                        {
                            if (row.Cells[4].Value.ToString().Equals(subBox.Text))
                            {
                                System.Windows.Forms.MessageBox.Show("This session already added !", "Warning").ToString();
                                return;
                            }
                        }
                        else
                        {
                            System.Windows.Forms.MessageBox.Show("This session already added !", "Warning").ToString();
                            return;
                        }
                    }
                }

                sessionModel sessionmodel = new sessionModel();
                sessionmodel.SubName = subNamelist.Text;
                sessionmodel.subCode = subcodeList.Text;
                sessionmodel.Type    = type.Text;
                sessionmodel.groupId = Int32.Parse(Gid.Text);

                sessionmodel.subgId       = subBox.Text;
                sessionmodel.studentcount = Int32.Parse(Scount.Text);

                sessionmodel.lec = "";

                for (int i = 0; i < lecList.Items.Count; i++)
                {
                    sessionmodel.lec = sessionmodel.lec + lecList.Items[i].Text + ",";
                }

                sessionmodel.lecturers = lec;
                session session = new session();
                session.insertSessions(sessionmodel);

                lecList.Items.Clear();
                lecturerlist.Text = "";
                subNamelist.Text  = "";
                subcodeList.Text  = "";

                lecturerbox.DataSource = session.getLectures();

                subjectBox.DataSource = session.getSubjects();

                GroupBox.DataSource = session.getGroupID();

                //sessionList.DataSource = session.getSessiondatatoTable();


                sessionList.DataSource = session.getSessiondatatoTable();

                flowLayoutPanel1.Controls.Clear();

                for (int i = 0; i < session.getSessiondatatoTable().Rows.Count; i++)
                {
                    show_data(session.getSessiondatatoTable(), i);
                }
            }
            else
            {
                string ans = System.Windows.Forms.MessageBox.Show("Please fill all the require fields !", "Warning").ToString();
            }
        }