We have MS Sql database with tables and data. We need to develop an User Interface to generate reports and to provide API for the third party integration.
UI page with user login (new table required), and upon successful login display List of report available with tree view for the group of location from the table available in database.
Reporting could be mixed chart with various date selection such as today, this year, month, week, custom date. Data is available already on MS SQL database table.
Web API required with security, which could opening for third party access. Need a admin control page to configure the API to control which tables are allowed and restricted data access on some table with id .
Attached images for the reference only. this is old system, which needs to improved with multichart option, using jscript of other latest technoloty.
6 freelancers are bidding on average ₹19784 for this job
I have worked on Web API with MS Sql as database, I have also worked on charts. I shall meet the deadline for the project. Looking forward to communication from your end and share more details of the project.