Donor Payment Card Management System

[kismetgerald]

Hey guys,

So as you all may know (or not) I'm very new to programming and to the VB language. Most of my online studies have come from Brandon's tutorials on Youtube.

With the knowledge gleamed from those tutorials, I've been able to put together an application that stores credit card information for our donors at Church. The application is working very well, but I'd like to add a new functionality that allows me to notify the donor via email that their card is about to expire.

I've studied the MailMessage and SmtpClient classes and been able to create and send a message successfully. But now I don't know how I'm going to do that from my application - i.e, to query the database for the cards that are expiring and then create an HTML formatted message that includes the relevant card information for each of the donors affected.

I was wondering if any of you would be willing to take a look at the entire solution and see what they can do to assist. Please let me know and I can make the source and sample DB available for use. Thanks.

//Kismet

[manishshrestha60]

i think you posted on the wrong place

[kismetgerald]

You mean the wrong thread or the wrong forum?

[brandonio21]

You mean the wrong thread or the wrong forum?

Well you posted in "Share your programs!" - but I guess this also falls under the category of "Share your programs' source code", so you're good!

I can check it out, if you'd like!

[kismetgerald]

Okay Brandon,

I just got home from a concert that I played at. I'm quite tired so I'll rest up and will provide a dropbox link later in the morning - along with the necessary MySQL DB Info.

[brandonio21]

Fantastic!

Hope that the concert went well! <!-- s --><img src="{SMILIES_PATH}/icon_e_wink.gif" alt="" title="Wink" /><!-- s -->

[kismetgerald]

My apologies for the delay - was in Church today. By the way the concert was great yesterday, my fingers are just a bit sore though.

So, below is the link to a zip file containing the entire VS solution. I've taken the liberty to create a user on my MySQL Server. The details are as follows:

Username: bpforums
Password: sculete

File location: https://dl.dropbox.com/u/55174425/Custom..._Vault.zip

I did my best to comment most of my code, but if you have any question just let me know.

//Kismet

[kismetgerald]

I forgot to add that you can use the username/password (parts/parts) to log into the application. Then again I'm sure you'll probably figure your way around.

Feel free do whatever you need to do with the MySQL server - it's a development one so I can always wipe it clean and start over.