My .asp based ecommerce cart is fully functional but only allows credit card processing through a payment gateway. Our company does not want to run credit cards at the time of the sale. We need to run the customer's card when the order is ready to ship. This means we need to retain the customer's card number in the SQL database along with the order information.
I need fields added to the order tables in the database. The following fields need to be added: card holder's name, Card Type, card number, Expiration date and CVC number. The card number field needs to be encrypted. These fields need to be added to the database and to the order page as well as the admin section for processing the order. No credit card processing is needed! Everything will be done offline in a sperate application.