public static bool CreateForm(OdbcDataReader reader, Role role) { int fCount = reader.FieldCount; for (int i = 0; i < fCount; i++) { string name = reader.GetName(i); // Map to DB field. Need to change if db changed switch (name) { case "name": role._name = reader.GetString(i); break; case "role_id": role._roleId = reader.GetInt32(i); break; } } return reader.HasRows; }
public static Role[] LoadListFromDB(DBManager db, string sqlCriteria) { OdbcDataReader reader = db.Query("SELECT * FROM role " + sqlCriteria); LinkedList<Role> list = new LinkedList<Role>(); while (reader.Read()) { list.AddLast(Role.CreateForm(reader)); } Role[] entities = new Role[list.Count]; int i = 0; foreach (Role t in list) { entities[i++] = t; } return entities; }
public static Role CreateForm(OdbcDataReader reader) { Role role = new Role(); Role.CreateForm(reader, role); return role; }