public static List <EstabEstabTransaction> getAllTransactions()
{
List <EstabEstabTransaction> transactions = new List <EstabEstabTransaction>();
try
{
SqlCommand command = new SqlCommand("Select * from BplTransactionEstabToEstab");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
EstabEstabTransaction t = new EstabEstabTransaction();
t.ID = reader["bplEstabTrasactionID"].ToString();
t.Match = EstabEstabMatchDB.getMatchByID(reader["bpMatchEstabID"].ToString());
t.Units = Convert.ToInt32(reader["unitsPossible"]);
t.Status = reader["status"].ToString();
transactions.Add(t);
}
reader.Close();
}
finally
{
connection.Close();
}
return(transactions);
}
