private void lroomtype_SelectedIndexChanged(object sender, EventArgs e)
        {
            String          selectedRoomType = lroomtype.Text.ToString();
            roomsWithLecCon rwl = new roomsWithLecCon();

            lroomName.DataSource = rwl.LoadTagsWithRooms(selectedRoomType);
        }
        private void button3_Click(object sender, EventArgs e)
        {
            String          lecName   = electurenme.Text.ToString();
            String          roomType  = lroomtype.Text.ToString();
            String          roomName  = lroomName.Text.ToString();
            String          roomTyp   = sesType.Text.ToString();
            roomsWithLecCon rwl       = new roomsWithLecCon();
            roomsConn       roomsConn = new roomsConn();

            rwl.insertLecWithPrefereedRoom(lecName, roomType, roomName, roomTyp);
            lecWithRoomsGrid.DataSource = roomsConn.load_Lec_with_rooms();
        }
        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();
        }