c#.net command program - TSS_TravelReminder

I want to add a new c# command program to my visual studio solution. There are other command programs inside that solution so you can use same methods to connect on the database and same methods to send mail. This new program, that we will call TSS_TravelReminder has to connect to a table with travels list and search for records with departure_datetime <= (now + 24hours) and column "reminder" = false. Then the program has to retrieve the value matricola for each travel, search email on ldap (method already present in the vs solution), finally send a mail with some information about the travel. This is used to remember the trip to the traveler 24 hours before the departure. When the email is sent the program has to update the travel record setting true the boolean column "reminder" and saving email into column "reminderEmail". Will share with you the source code about the vs solution using [login to view URL] repository.