Please read fully. We will not accept bids that are generic responses.
The end goal of this project is to build and keep updated a centralized database of all user emails (from gmail) across the company. Next, do some analytics on the data, and keep it updated.
We need an Azure application that builds a database and a test application for reviewing the data.
The system needs to:
-Authenticate the azure service with the users gmail
-Keep track of users. A list of users should be visible in the test application. Add/delete a user through the test application.
-Each user authenticates with the Azure Service/gmail, so the service can automatically connect and access all email folders
-First pass, the server gets all archived and current emails across all folders
-Regularly the system connects and gets processes emails. Test application should have an “update” button which processes all updates.
All emails should be stored in a MSSQL database. The test application should be done in C# using the .NET framework. The test app will connect to the database.
After each user’s email is collected, the emails should be processed to determine the total count of emails sent and received to/from each person. This will be a relationships table associated with each user.
Example: if john AT [url removed, login to view] (john) is the user and he sent 22 emails to frank AT [url removed, login to view] (frank) and frank sent john 12 emails, then the following values would be detailed
frank AT [url removed, login to view]
sent = 22
received = 11
The test app is for reviewing data. It needs to show the following grids:
-MainAll: Grid of all emails, by organization and by user: org, user, from, to, from, cc, bcc, subject, body, attachments (body can be detail memo field, attachments should be clickable to open.)
-ViewUser: For the selected user in ViewAll, show every unique email with sent/received stats
-ViewOrg. For each selected user in ViewAll. show the combined sent/received (all user stats) across all users
Each time the service updates (processes recent emails) the to/from stats should be updated. Make sure the system allows any gmail user to be added to a group/org (they may not be part of a specific domain).
The service needs to be able to scale to many users, so plan accordingly.
If you have had experience with Azure/C#/gmail apps and similar projects, let us know specifically. The GUI in the test application needs to be functional, not user-facing. Focus on functionality & the ability to see the data from different angles.