Project must be done using C# with OOP. Must use a Microsoft Access Database to store backend data.
Separate classes to be created please especially for connecting to the database.
comments in your code explaining
I've attached a sample of the user interface
GridView1: backend data
GridView2: Combined data which is a sum of the TOP 20 vendors data which you will find a sample in the List of [login to view URL] Tab called (Combined).
There must be three roles: Admin | User | Power User
Login Screen to enter username and password
Admin only will have permission to upload data to the database
Admin can give permission to other users to upload data like Power User
Admin can also email on behalf of other users
When user login, they can only have access to their own information
User can email to a vendor their own specific information only
User to have option to select whether to email to single or to email multiple vendors by selecting a checkbox
I want to search for a vendor and send an email for that specific vendor.
Email must be exported and saved in folder
Excel file for that specific vendor must be attached to the email when sending.
Email message to be written in HTML format and have the data displayed in a table within the body of the email as per Email_Template sample
Email signature with logo
List of [login to view URL] is the data that will need to be loaded to the backend
Claretta [login to view URL] for example is the data that gets exported to a folder and then get attached to the email message.