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