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