PayPal IPN Transfer to ASP.NET C# and Update MSSQL and XML

This MICRO Project Requires the Integration of PayPal IPN transfer receipt page in C# as per standard PayPal setup. Once the transaction is processed the information needs to be transferred direct from PayPal to a C# Page on my server. The C# page on my server is required to perform 2 primary tasks/milestones. 1. Securely transfer and store the Data in MS SQL to 2 tables. One table will hold all available IPN fields as per the current PayPal IPN Schema. The second table needs to be updated with the subscription Level supplied in the “Custom” field that will “Activate” the Subscription and assign the appropriate Role to the Users account. The process is designed to Append/Update the SQL Tables. The data then needs to be appended to XML files of the same table schema. A boolean style switch for HTTPS should be included due to the sensitive content of the data. 2. Once the tables are appended the server page needs to send an email to the subscriber to notify them that their subscription is active and provide a link for them to verify their address. This activates the account, redirects them to a content page and filters a grid based on a role.