public Boolean checkRoomIsAvailable(String roomName)
{
ArrayList arrayList = new ArrayList();
roomsConn roomsConn = new roomsConn();
SqlDataReader dr = roomsConn.loadNotAvailableRooms();
while (dr.Read())
{
if (con.State.ToString() != "Open")
{
con.Open();
}
String roomID = Convert.ToString(dr["roomName"]);
if (roomName.Equals(roomID))
{
MessageBox.Show("Rooms is already Assign!");
return(false);
}
}
Console.WriteLine("awdwadaw", arrayList);
return(true);
}
public Boolean checkRoomIsAvailable(String roomName)
{
ArrayList arrayList = new ArrayList();
if (con.State.ToString() != "Open")
{
con.Open();
}
DataTable dataTable = new DataTable();
roomsConn roomsConn = new roomsConn();
SqlDataReader dr = load_ALL_Normal_sesssion_rooms_details();
while (dr.Read())
{
String TableroomName = Convert.ToString(dr["roomName"]);
if (roomName.Equals(TableroomName))
{
return(false);
}
}
return(true);
}
public ArrayList updateSessionTable(roomModel roommodel, String notavlTime, String sessionType)
{
ArrayList arrayList = new ArrayList();
if (con.State.ToString() != "Open")
{
con.Open();
}
DataTable dataTable = new DataTable();
roomsConn roomsConn = new roomsConn();
if (sessionType.Equals("Consecutive"))
{
SqlDataReader dr = roomsConn.load_sesssion_rooms_details(sessionType);
while (dr.Read())
{
if (con.State.ToString() != "Open")
{
con.Open();
}
String subjectCode = Convert.ToString(dr["subjectCode"]);
if (roommodel.subjectCode.Equals(subjectCode))
{
string query = "update Consecutivetbl set roomName = '" + roommodel.roomName + "'where subjectCode = '" + roommodel.subjectCode + "'";
SqlCommand com = new SqlCommand(query, con);
MessageBox.Show("Updated!");
com.ExecuteNonQuery();
// insertNotAvailableTimes(roommodel.roomName, roommodel.facultyNme, notavlTime);
}
}
Console.WriteLine("awdwadaw", arrayList);
return(arrayList);
}
else if (sessionType.Equals("Parallel"))
{
SqlDataReader dr = roomsConn.load_sesssion_rooms_details(sessionType);
while (dr.Read())
{
if (con.State.ToString() != "Open")
{
con.Open();
}
String subjectCode = Convert.ToString(dr["subjectCode"]);
if (roommodel.subjectCode.Equals(subjectCode))
{
string query = "update Consecutivetbl set roomName = '" + roommodel.roomName + "'where subjectCode = '" + roommodel.subjectCode + "'";
SqlCommand com = new SqlCommand(query, con);
MessageBox.Show("Updated!");
com.ExecuteNonQuery();
// insertNotAvailableTimes(roommodel.roomName, roommodel.facultyNme, notavlTime);
}
}
return(arrayList);
}
else
{
SqlDataReader dr = roomsConn.load_sesssion_rooms_details(sessionType);
while (dr.Read())
{
if (con.State.ToString() != "Open")
{
con.Open();
}
String subjectCode = Convert.ToString(dr["subjectCode"]);
if (roommodel.subjectCode.Equals(subjectCode))
{
string query = "update Session set roomName = '" + roommodel.roomName + "'where subjectCode = '" + roommodel.subjectCode + "'";
SqlCommand com = new SqlCommand(query, con);
MessageBox.Show("Updated!");
com.ExecuteNonQuery();
// insertNotAvailableTimes(roommodel.roomName, roommodel.facultyNme, notavlTime);
}
}
return(arrayList);
}
}
