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); } }