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