public static IList <Vendor> GetAll()
{
List <Vendor> vendors = new List <Vendor>();
string selectStatement =
"SELECT VendorID, Name FROM Vendors";
SqlConnection connection = PayablesDb.GetConnection();
SqlDataReader reader = null;
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
try
{
connection.Open();
reader = selectCommand.ExecuteReader();
int vendorIdOrdinal = reader.GetOrdinal("VendorID");
int nameOrdinal = reader.GetOrdinal("Name");
while (reader.Read())
{
var vendor = new Vendor
{
VendorId = reader.GetInt32(vendorIdOrdinal),
Name = reader.GetString(nameOrdinal)
};
vendors.Add(vendor);
}
}
finally
{
reader?.Close();
connection?.Close();
}
return(vendors);
}
public static IList <Invoice> GetAll()
{
List <Invoice> invoices = new List <Invoice>();
string selectStatement =
"SELECT InvoiceNumber, InvoiceDate, InvoiceTotal, " +
"PaymentTotal, CreditTotal, DueDate, VendorID " +
"FROM Invoices";
SqlConnection connection = PayablesDb.GetConnection();
SqlDataReader reader = null;
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
try
{
connection.Open();
reader = selectCommand.ExecuteReader();
int invoiceNumberOrdinal = reader.GetOrdinal("InvoiceNumber");
int invoiceDateOrdinal = reader.GetOrdinal("InvoiceDate");
int invoiceTotalOrdinal = reader.GetOrdinal("InvoiceTotal");
int paymentTotalOrdinal = reader.GetOrdinal("PaymentTotal");
int creditTotalOrdinal = reader.GetOrdinal("CreditTotal");
int dueDateOrdinal = reader.GetOrdinal("DueDate");
int vendorIdOrdinal = reader.GetOrdinal("VendorID");
while (reader.Read())
{
var invoice = new Invoice
{
InvoiceNumber = reader.GetString(invoiceNumberOrdinal),
InvoiceDate = reader.GetDateTime(invoiceDateOrdinal),
InvoiceTotal = reader.GetDecimal(invoiceTotalOrdinal),
PaymentTotal = reader.GetDecimal(paymentTotalOrdinal),
CreditTotal = reader.GetDecimal(creditTotalOrdinal),
DueDate = reader.GetDateTime(dueDateOrdinal),
VendorId = reader.GetInt32(vendorIdOrdinal)
};
invoices.Add(invoice);
}
}
finally
{
reader?.Close();
connection?.Close();
}
return(invoices);
}