private void releaceBtn_Click(object sender, EventArgs e)
        {
            roomsConn roomsConn = new roomsConn();

            roomsConn.insertNotAvailableTimes(rName.Text.ToString(), rfaculty.Text.ToString(), rntime.Text.ToString());
            notAvailableGridView.DataSource = roomsConn.load_not_available_details();
            rrrname.DataSource = roomsConn.getNotAvailableRooms();
        }
        private void rrbtn_Click(object sender, EventArgs e)
        {
            roomsConn roomsConn        = new roomsConn();
            String    selectedRoomName = rrrname.Text.ToString();

            roomsConn.DeleteNotAvailableRooms(selectedRoomName);
            notAvailableGridView.DataSource = roomsConn.load_not_available_details();
            rrrname.DataSource = roomsConn.getNotAvailableRooms();
        }
        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();
        }