Prerequiste: MSSQL Server, .NetCore 5, angular 8 Steps for setup repository in your local machine
- Clone repository
- Update appsettings.json Connections with local db credentials.
- Open Package-Manager Console and type Update-Database
- Let migration happen. Once command complete, connect to localdb and verify database "SamplePOC" present. Also verify tables Countries, ExchangeRate and Products.If any error comes refer step 5 else refer step 6.
- If there is any problem occurs in migration step please run Add-Migration <<Migration_name>> and then Update-database.
- After migration run below insert query commands to have predefined data.You can add data according to your choice also. use samplePOC insert into Products values( 'TV', 'A brand new TV', 1); insert into Products values('Fridge','abc',10); insert into Products values('TV2', 'A brand new TV', 15); insert into Products values( 'Fridge2','abc',20); insert into Products values( 'TV3', 'A brand new TV', 25); insert into Countries values( 'United States','UK','GBP'); insert into Countries values ('United States','US','USD'); insert into countries values('Germany','DE','EUR'); insert into ExchangeRates values(1.28,'USD','2024-01-01',null); insert into ExchangeRates values(1.00,'GBP','2024-01-01',null); insert into ExchangeRates values(1.16,'EUR','2024-01-01',null);
Please note Products table has cost in GBP.
7.Launch application.