public static Room CreateForm(OdbcDataReader reader)
{
Room room = new Room();
Room.CreateForm(reader, room);
return(room);
}
public override bool LoadFromDB(DBManager db, string sqlCriteria)
{
OdbcDataReader reader = db.Query("SELECT * FROM room WHERE " + sqlCriteria);
if (!reader.Read())
{
return(false);
}
return(Room.CreateForm(reader, this));
}
public static Room[] LoadListFromDBCustom(DBManager db, string sqlAll)
{
OdbcDataReader reader = db.Query(sqlAll);
LinkedList <Room> list = new LinkedList <Room>();
while (reader.Read())
{
list.AddLast(Room.CreateForm(reader));
}
Room[] entities = new Room[list.Count];
int i = 0;
foreach (Room r in list)
{
entities[i++] = r;
}
return(entities);
}