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