Important: Specs are alos attached in a word document.
Purpose: this utility will have to automatically run a program when an email is received in a specific inbox (e.g. ) on our Exchange 2010 server.
Architecture: The functionality that calls the Exchange server and obtains the attachment should be developed as a separate library that could be called from Future dot net applications
Platform: C# under windows. Source code should be delivered to the Bank
1- A config file will be used to store the parameters used in this utility
2- Receiving Email address should be a parameter,
3- Emails received will have Excel attachment(s) up to 5.
4- Attachments will have to be detached to a folder (path will be a parameter). If the attachments already exist they will be replaced.
5- One folder will be created by month and year
6- A master record will be added in a Master table holding the following information:
a. Master Reference Key
b. Sender email address
c. Email addresses in the cc, if any
d. Date and time of the received email
f. Body of the message up to 200 characters
g. Attachment1 File Name
h. Attachment2 File Name
i. Attachment3 File Name.
j. Attachment4 File Name.
k. Attachment5 File Name.
Note: even if no attached files, an entry should be added.
7- The detached files should be loaded in MS SQL2008 database. The structures of the Excel is attached. And the Table structure in the database is as follow:
a. Master Reference Key (see above)
b. Sequence number - At the database this is an integer
c. Name of employee - Char(50)
d. Account Number - Char(28)
e. Amount – Decimal(18,2)
8- If a flag (Parameter) is set to true, amounts should be encrypted in the database based on Triple DES 1024 algorithm and using the Account Number of the record (see excel file) in addition to a salt value defined as a parameter.
9- If a flag (Parameter) is set to true, an email will be sent to email address(es) defined as parameter (in case of multiple email addresses they will be separated by “;”). The email content will be identical to the data listed above.
12 freelancers are bidding on average $724 for this job
Thank you for invitation. The requested functionality should be deployed as Exchange Transfer Agent; however in this case you won't be able to reuse the library, so I am considering that you want an additional library Daha Fazla
Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. We are 100% sure that we can achieve Daha Fazla
Hi, I have total of 7 years of experience in .Net and well versed with both windows and web applications. Also built many applications during my carrier. Additional knowledge: C#, SQL, Silverlight, SSRS, SSIS, A Daha Fazla
Hello you! i can do it and finish 5 days. Please let me know.I looking forward on work your project. Thanks! Khoa-Skype ID: huynhminhkhoa
I have MS in Information Security with research interest of Cryptography. I have implemented Cryptography algorithms in Java and C, written security solutions in J2EE and Java, have implemented datastructures in Ja Daha Fazla
Dear Employer, I have read and understood your concept regarding this system. A well defined and secure implementation is required to do this. Require so many discussion and planning are required to complete this. I Daha Fazla
Hi, My name is Rui Sousa and I've experience in development with C# and exchange integration. I can deliver this project to you quickly. Please fell free to contact me if you've any question. Regards, Rui Daha Fazla
Hi, I have more than Three year of experience. so we can do your project easily but Please come on chat for further discussion. Benefits u get: 1. 2 Months Free Tech Support 2. W3C Compliant Code, So Pages L Daha Fazla
Hello, Greetings for the day !! We, are a registered Pvt. Ltd. company has grown exponentially last 8.5 years with an excellent client base in worldwide, we are proud to be continually increasing the client co Daha Fazla
Hi. I'm an experienced C# Developer with Systems Administration experience. I should be able to complete this in 5 days. Damien
I have expertise in Microsoft Technologies. Architect & Design Web application using ASP.NET, C#, SharePoint, Safes force App Development, mySQL, MS-SQL & Oracle . I will help you in future Strategic Planning & Support Daha Fazla