public List<Payment> GetPayments()
{
List<Payment> payments = new List<Payment>();
DataSet ds = new DataSet();
DataSetTableAdapters.paymentsTableAdapter adapter = new DataSetTableAdapters.paymentsTableAdapter();
adapter.Fill(ds.payments);
DataSet.paymentsDataTable table = adapter.GetPaymentData();
// load all payments into the list
foreach (DataSet.paymentsRow row in table.Rows)
{
// create memory for new payment & fill in properties
Payment p = new Payment();
p.ID = row.paymentId;
p.CardholderName = row.cardholderName;
p.CardType = row.cardType;
p.CardNumber = row.cardNumber;
p.CardExpiration = row.cardExpiration;
// add this payment to the list
payments.Add(p);
}
// returns the list w/ 0 or more Payments
return payments;
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns>A payment if found; null if payment not found</returns>
public Payment GetPaymentById(int id)
{
DataSet ds = new DataSet();
DataSetTableAdapters.paymentsTableAdapter adapter = new DataSetTableAdapters.paymentsTableAdapter();
adapter.Fill(ds.payments);
Payment p = new Payment();
// find the payment
DataSet.paymentsDataTable table = adapter.GetPaymentById(id);
// if a payment was found, then fill in the details
if (table.Rows.Count > 0)
{
// use the 1st row's data
DataSet.paymentsRow row = (DataSet.paymentsRow)table.Rows[0];
p.ID = row.paymentId;
p.CardholderName = row.cardholderName;
p.CardType = row.cardType;
p.CardNumber = row.cardNumber;
p.CardExpiration = row.cardExpiration;
return p;
}
else
{
return null;
}
}
public int DeletePayment(int id)
{
DataSet ds = new DataSet();
DataSetTableAdapters.paymentsTableAdapter adapter = new DataSetTableAdapters.paymentsTableAdapter();
return adapter.Delete(id);
}
public int UpdatePayment(int id, String cardholderName, String cardType, String cardNumber, DateTime cardExpiration)
{
DataSet ds = new DataSet();
DataSetTableAdapters.paymentsTableAdapter adapter = new DataSetTableAdapters.paymentsTableAdapter();
return adapter.Update(cardholderName, cardType, cardNumber, cardExpiration, id);
}
public int InsertPayment(String cardholderName, String cardType, String cardNumber, DateTime cardExpiration)
{
DataSet ds = new DataSet();
DataSetTableAdapters.paymentsTableAdapter adapter = new DataSetTableAdapters.paymentsTableAdapter();
adapter.Insert(cardholderName, cardType, cardNumber, cardExpiration);
// this is a *bad* way of getting the record's identity, but MS Access doesn't support batch SQL statements
// a real DB would be able to combine the insert statement and a select statement in one batch call!
int identity = (int)adapter.GetIdentity();
return identity;
}