I need a paypal IPN script, written in [url removed, login to view] (visual basic), that will update my database (SQL Server 2005) upon a "verified" payment and send an email to the admin, the customer, and the employee that is associated with that transaction.
I am developing a website where a customer can reserve a "session" with one of my employees. Before they reserve the session, I need a way for them to make payment. There will only ever be 3-5 payment options, so I don't need a shopping cart or anything like that. I want to keep it simple.
Here's the process: A customer comes to my site, searches available sessions, then clicks a link to "reserve" the session with one of my employees. When a customer reserves a session, a record in the Session table is updated with the customer's email. The session_status is also changed from 'open' to 'reserved'. The problem is that I need to customer to make payment before they can officially reserve the session.
What I need to do is automate this process with paypal. Before a customer reserves a session, I need to send them to paypal to make payment. I'm thinking the script would need to pass two variables to paypal (which will be available in a formview on the the 'buy now' button page): session_id and employee_email. The IPN script should then check to make sure that payment was made, send emails to employee, admin, and customer, and update the Customer_email and Session_status fields in my DB.