private void sessionType_SelectedIndexChanged(object sender, EventArgs e)
        {
            roomsConn roomsConn           = new roomsConn();
            String    selectedSessionType = sessionType.Text.ToString();

            asubjectCode.DataSource = roomsConn.getSessionTypeTable(selectedSessionType);
            if (selectedSessionType.Equals("Normal"))
            {
                atag2.Hide();
                label1.Hide();
                roomManagingSource.DataSource = roomsConn.load_normal_sesssion_details();
            }
            else
            {
                atag2.Show();
                label1.Show();
                // comboBox1.Show();
                // label7.Show();
            }
            if (selectedSessionType.Equals("Normal"))
            {
                roomManagingSource.DataSource = roomsConn.load_normal_sesssion_details();
            }
            else if (selectedSessionType.Equals("Consecutive"))
            {
                roomManagingSource.DataSource = roomsConn.load_con_sesssion_details();
            }
            else if (selectedSessionType.Equals("Parallel"))
            {
                roomManagingSource.DataSource = roomsConn.load_parallel_sesssion_details();
            }
        }
        private void sType_SelectedIndexChanged(object sender, EventArgs e)
        {
            BatchesConn bt              = new BatchesConn();
            roomsConn   roomsConn       = new roomsConn();
            String      selectedSession = sType.Text.ToString();
            String      selectedSubject = subGNme.Text.ToString();

            sname.DataSource = bt.getSubjectAccourdingToSession(selectedSession);

            if (selectedSession.Equals("Normal"))
            {
                grpWithRoomsGrid.DataSource = roomsConn.load_normal_sesssion_details();
            }
            else if (selectedSession.Equals("Consecutive"))
            {
                grpWithRoomsGrid.DataSource = roomsConn.load_con_sesssion_details();
            }
            else if (selectedSession.Equals("Parallel"))
            {
                grpWithRoomsGrid.DataSource = roomsConn.load_parallel_sesssion_details();
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            String      selectedGroupName    = grpNme.Text.ToString();
            String      selectedSubGroupName = subGNme.Text.ToString();
            String      selectedSessionType  = sType.Text.ToString();
            String      selectedTagType      = tagType.Text.ToString();
            String      selectedroomName     = rmName.Text.ToString();
            BatchesConn bc        = new BatchesConn();
            roomsConn   roomsConn = new roomsConn();

            bc.SR_updateGroupsWithAssignedRoom(selectedGroupName, selectedSubGroupName, selectedSessionType, selectedTagType, selectedroomName);
            if (selectedSessionType.Equals("Normal"))
            {
                roomManagingSource.DataSource = roomsConn.load_normal_sesssion_details();
            }
            else if (selectedSessionType.Equals("Consecutive"))
            {
                roomManagingSource.DataSource = roomsConn.load_con_sesssion_details();
            }
            else if (selectedSessionType.Equals("Parallel"))
            {
                roomManagingSource.DataSource = roomsConn.load_parallel_sesssion_details();
            }
        }