Back office for mystery shopping and market research company
Budget: $1,500 – $3,000 USD
My company does mystery shopping and market research for private businesses to measure the sales and customer service experience. We have been in business since 1999 and are considered a well known and respected company.
We are looking to build a basic back office portal to run certain aspects of our business:
The desired architecture will use C#, MVC, API, Azure Functions. Azure Data Gateway will provide access to a MSSQL Express database hosted on a server in Azure. Using good design practices, this site would be the foundation for future core services of our business to use. Eventually we will want to deploy a mobile app using MAUI, using API features being built now as part of this project.
Pages:
/Default (Home)
/About
/Register
/login (using Azure Active Directory guest account created from registration)
/secure/profile
/secure/jobs/listing (e.g. /secure/jobs/listing/<company>/<location>)
Registration, Access and Authentication will be handled via guest accounts in our Azure Active Directory tenant. You will write C# code to interact with this PaaS identity platform.
Registered users will be able to view a) their profile, b) available jobs c) have jobs assigned to their profile administratively via our back office team or allow the shopper to apply to do the job d) shopper can mark job as submitted, e) back office can mark job as completed.
The shoppers profile will link to work previously performed (history). The back office would be allowed to post a private rating of the shopper only visible to the back office.
Ideas:
Customers -> Locations = 1-M relationship
Locations -> Shops = 1-M relationship
Shoppers -> Shops = 1-M relationship
ShopHistory = transaction table for scheduled and completed shops
Shop Status:
Available
Requested
Assigned
In Progress
In Review
Pending Payment
Completed
This should be a good starting point to have a discussion and define requirements, deliverables and timeline.
We are looking to build a basic back office portal to run certain aspects of our business:
The desired architecture will use C#, MVC, API, Azure Functions. Azure Data Gateway will provide access to a MSSQL Express database hosted on a server in Azure. Using good design practices, this site would be the foundation for future core services of our business to use. Eventually we will want to deploy a mobile app using MAUI, using API features being built now as part of this project.
Pages:
/Default (Home)
/About
/Register
/login (using Azure Active Directory guest account created from registration)
/secure/profile
/secure/jobs/listing (e.g. /secure/jobs/listing/<company>/<location>)
Registration, Access and Authentication will be handled via guest accounts in our Azure Active Directory tenant. You will write C# code to interact with this PaaS identity platform.
Registered users will be able to view a) their profile, b) available jobs c) have jobs assigned to their profile administratively via our back office team or allow the shopper to apply to do the job d) shopper can mark job as submitted, e) back office can mark job as completed.
The shoppers profile will link to work previously performed (history). The back office would be allowed to post a private rating of the shopper only visible to the back office.
Ideas:
Customers -> Locations = 1-M relationship
Locations -> Shops = 1-M relationship
Shoppers -> Shops = 1-M relationship
ShopHistory = transaction table for scheduled and completed shops
Shop Status:
Available
Requested
Assigned
In Progress
In Review
Pending Payment
Completed
This should be a good starting point to have a discussion and define requirements, deliverables and timeline.