We require a C# .net application which will periodically get any new emails in a defined Google Apps Email Inbox and insert into a MS SQL 2008 Database.
Each email would need inserting into a MS SQL Table and the following information stored in seperate fields i.e.
Subject
Date Sent
Sent to
Sent From
Reply To
Message Body
Headers
Attachments would need to be stored in the SQL Database in a seperate table, with the relevant information stored to record the relationship between the stored email and the attachments. In addition the database would need to store in fields the following information for each attachment:
File Type
File Size
Original File Name
The application would need to be either a Windows application or potentially a windows service as this will be running on a Windows 2008 Server.
We would require full source code to allow us to make changes to lookup times and email account information, also to integrate additional functionality at a later date.