public List <PurchasersTable> GetPurchasers() { List <PurchasersTable> purchasers = new List <PurchasersTable>(); try { connection.Open(); var command = new OleDbCommand(); command.Connection = connection; command.CommandText = "select * from Purchasers"; var reader = command.ExecuteReader(); while (reader.Read()) { PurchasersTable p = new PurchasersTable(); p.name_first = reader.GetString(1); p.name_last = reader.GetString(2); p.initials = reader.GetString(3); p.email = reader.GetString(4); p.isActive = reader.GetBoolean(5); purchasers.Add(p); } purchasers.Sort(); reader.Close(); } catch (Exception e) { } finally { } connection.Close(); return(purchasers); }
public int CompareTo(Object obj) { if (obj == null) { return(1); } PurchasersTable other = obj as PurchasersTable; if (this.name_last == other.name_last) { return(this.name_first.CompareTo(other.name_first)); } else { return(this.name_last.CompareTo(other.name_last)); } }