The application will be written as a Windows service, written in C#, that connects to a POP3 or IMAP (developer’s choice) mailbox and processes email messages based on predefined criteria. The emails are being generated by SolarWinds Web Help Desk and follow a consistent format.
Sample email messages will be forwarded to the selected developer.
There are three potential email messages: Case Opened, Case Updated, and Case Closed.
Once received, specific fields from within the email message will be saved to an MSSQL database. The following fields will be saved:
Ticket Number
Client Name
Client Location
Department
Status
Request Type
Subject
Request Detail
If the status is updated, most recent notes date
If the status is updated, most recent notes name
If the status is updated, most recent notes text
In addition, any attachments to the email must be saved and must be referenced in the database data row.
The MSSQL table must also contain a timestamp, a numeric field (18,0) of callNumber set to 0 (zero) by default, and an “isProcessed” integer flag that is set to 0 (zero) by default. This will be used as the data is later processed by another software program.
The email account, email credentials, email server, email check frequency, database name, database credentials, and database server all must be configurable options (within a configuration file or another method that does not require code modification).
Source code must be delivered with the final deliverable, and only full payment will be provided (partial payment will not be released for partial work completed).
Bidders are required to confirm they have read the project requirements and fully understand them to be considered for this project.