A ASP.NET Core web app + API that will be able to receive and show data.
- Description -
The app's data will be submitted by an Uploader (uploader app is separate project) via HTTP POST requests.
Uploader and App clients will authenticate and authorize to gain access.
The received data will need to be inserted into a database so that it can be queried.
Users will log on to the site to perform queries. Users can have one of several roles
The database will be queried to generate web pages that will show the data as a table.
It should be possible to download the table as an Excel file.
It should be possible to send the table via Email as an Excel File
- App Domain -
Technicians are Super Users that can act as tennants or customers for viewing data
The app can have multiple tennants. Each tennant has a group of sites
The tennant's information will include
There are multiple customers. A customer may consume at several sites and across several tennants. A customer can have several vehicles.
The customer's information will include
There are multiple sites. Each site belongs to a single tennant
The site's information will inclue
- Tennant that it belongs to
There are multiple vehicles. Each vehicle belongs to a single customer. Vehicles visit a tennant's site.
The vehicle's information will include
When a Customer's Vehicle visits a Tennants Site. A visit will be . The visit is uploaded by the uploader to the app.
The Visits's information will include
- Site Id
- Site's visit id (reference number)
- Fuel Grade
- Use Cases -
A tennant can sign in to the app
A customer can sign in to the app
A support technician can sign in to the app
A tennant can view all customers activity for all his sites or a single site for a date range
A tennant can view a single customer's activity for all his sites or a single site for a date range
A tennant can download the visualized data as a spreadsheet
A tennant can email the visualized data as a spreadsheet
A Customer can view all visit data for all his vehicles or a single vehicle for a date range
A customer can download the visualized data as a spreadsheet
A customer can email the visualized data as a spreadsheet
A support technician can perform all customer and tennant use cases
- Technical details -
The app should be developed using ASP.Net Core (better if V2)
It's better if user auth is done using Auth0 with JWT.
The finished app will be hosted in Microsoft Azure
The database should be a SQL Azure Database accessed with EF Core
19 freelancers are bidding on average $667 for this job
Hello Sir, I have been through the details and feel nothing out of my reach as I strongly possess .net skills. Relevant Skills and Experience .net and all its ins and outs Proposed Milestones $750 USD - .net