I am going todo a simple editpage for all my digital musicfiles. My main table id “Fiels” which contains all my MP3 files with extracted ID3 tags. I have split out the related info (like artist, album etc) to separate tables. My database is not complete and a lots of data needs to te changed. I want an online editor for this.
Design for Web
There are no need for “good looking” design at this point, just all fields are mapped to right type of editor (An related ID needs to be an droppdownList which should be populated with data from the related table)
I have done the models
I haven’t done any views yet, but I own Telerik UI for .Core and Telerik Kendo so feel free to use this components.
Data is saved in MS SQL Server 2017 and uses mainly Stored Procedures for maximum performance/Security. It contains of 8 tables with relations as seen in image attached. All need SP is already done by me, so no need for SQL handling in your offer, I love SQL! ?
In this part its not necessary to collect data by API/JSON, it can be done direct from repository, but if you choose to use API/JSON then there must be API-address in appsettings so we easy can separate Backend from Frontend
I haven’t done any repository yet, but I have one demand, not using EF but Dapper instead. Since Dapper handle StoredProcedures much better with CRUD
To be able to get the project you first need to include the word DJProject so you proove you are human. Secondly you must give an offer with fixed price, if you just give an estimate and demands much discussion then you are disqualified, this is a simple project with plain editviews and some repositoriesk, artist and genre