ASP.NET MVC Currency Project

Table of contents

• General info
• Technologies
• Setup
• Code Examples
• Screenshots

General info

This project is made using technologies like C#,ASP.NET MVC,JavaScript,HTML5,CSS3,Entity Framework.

This project created for the get last six month Dollar,Euro and Sterling data from the TCMB(Turkish Central Bank) and save it to the your SQL server. Client side use this data and draw a lot graphs (Eur/Usd,Eur,Dollar,Sterling etc.)

Technologies

Project is created with:

• Visual Studio version: 2019
• Bootstrap version: 3.4.1
• Jquery library version: 3.4.1
• Entity Framework version: 6.0.0
• SQL Server 2014

Setup

1. Open Dovizkurlari.sln with Visual Studio.
   

2. Create a database table like this
   

3.Example TCMB XML data

4.Connect your SQL Server and Entity Framework

5.You should Uncomment SaveSixMonthData() for ONCE! After that you must comment it AGAIN!

Because it's save to database last six month data just one time.When it's do that once, it doesn't need anymore.

6.Run project once, when it's data scraping job done stop the project and don't forget comment the SaveSixMonthData() function.

7.Now project is ready!!

Code Examples

• Fetching six month data with dynamic url:

• Using Javascript get data from the Backend, filter json as a EUR,USD,GBP. Call draw graph function.

• Get weekly data from SQL Server on the backend and return JSON:

Screenshots

• EUR/TL, USD/TL, GBP/TL graphs

• EUR/TL, USD/TL, GBP/TL in same graph

• EUR/USD Graph

Have Fun!!