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 locBtn2_Click(object sender, EventArgs e)
{
roomsConn roomsConn = new roomsConn();
roomModel roomsModel = new roomModel();
String selectedSessionType = sessionType.Text.ToString();
roomsModel.roomName = assignRoom.Text;
roomsModel.subjectCode = asubjectCode.Text;
roomsModel.facultyNme = faculty.Text;
roomsConn.updateSessionTable(roomsModel, notavltime.Text.ToString(), selectedSessionType);
roomManagingSource.DataSource = roomsConn.load_con_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();
}
}
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();
}