/// <summary>
/// Returns all Rooms currently in this Group
/// </summary>
/// <param name="GroupId"></param>
/// <returns></returns>
public Rooms ALLRooms(int GroupId)
{
try
{
Rooms X = new Rooms();
string sSQL = "Select g.RoomId FROM tblGroupRoomRel g " +
"left outer join tblRoom r ON r.Id = g.RoomId " +
"WHERE g.GroupId = " + GroupId +
" ORDER BY r.Name";
DataTable DT = GetDataTable(sSQL);
foreach(DataRow R in DT.Rows)
{
Room Ro = GetRoom(Convert.ToInt32((object)R[0]));
if(Ro != null)
X.Add(Ro);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
/// <summary>
/// Returns all Rooms currently in the System
/// </summary>
/// <returns></returns>
public Rooms ALLRooms()
{
try
{
Rooms X = new Rooms();
string sSQL = "Select * FROM tblRoom ORDER BY Name";
DataTable DT = GetDataTable(sSQL);
foreach(DataRow R in DT.Rows)
{
Room Ro = GetRoom(Convert.ToInt32((object)R[0]));
if(Ro != null)
X.Add(Ro);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}