c#/.NET Email to Database Script

Email to Database Script I have a SQL data table containing credentials for n-email accounts (POP server, username, and password). I need a script that will loop through each account, pulling all new emails into a data table, saving all content into the table and all attachments to a specified file directory. Each account has its own table name for downloading the emails into (more than one account might use the same table, but each account could use a different table). The script is responsible for downloading the emails into the appropriate table and then deleting them from the POP account. It must be reliable, it must check for duplicates before saving (in case the script had downloaded but crashed before deleting last time) using the GUID that every email message contains, it must also store a record in an attachments table with the file name of the attachment (generated from the ID of the email and the ID of the attachment to make it unique). The directory each attachment should be saved to will also be account unique and stored in the accounts table. I have already coded this in Cold Fusion. I can provide detailed tech spec and SQL scripts. I just need someone who can write clean, well documented c# code to implement this in .NET. It should run as a service.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Sunday Apr 3, 2005 11:15:27 AM:

I have just realized .NET doesn't have a simple "POP3" class, but rather requires the use of System.Net.Sockets.

Please let me know if you plan to use [url removed, login to view] or a pre-built custom control for the POP3 piece. If control, please let me know which one you prefer and why (FYI I'll be needing a separate SMTP project later in the month, so if you do need to use a custom control, an affordable one including an all managed code SMTP solution would be a bonus!

Best Wishes,

Peter

* * *This broadcast message was sent to all bidders on Monday Apr 4, 2005 10:21:34 AM:

Hello All,

I am new to email apps in .NET, but after doing research I have decided to substantially simplify this project to stay within budget (I already have code and just need something more robust so budget is an issue as client will not be paying for this).

(i) Project must use [url removed, login to view] for POP connection so no socket programming required.

(ii) I will handle email assignments using triggers, so you just need to loop through accounts and save emails to database one at a time. POP control does the heavy lifting, you just need to handle looping, error handling and generation of notification email if consistent error. Please see updated bid request and spec zip file.

I have also provided very detailed psuedo code which should make this a fairly straightforward project.

Many thanks for bidding. Will be choosing bidder within 48 hours, so feel free to upda te bids if you are interested.

Best Wishes,

Peter

## Platform

Windows Server 2000/2003 .Net framework 1.1 Microsoft SQL Server 2000

ASP PHP

Project ID: #3641364

About the project