Skip to content

gigianni/formula-1-gcanavero0417

 
 

Repository files navigation

Formula One Project

Canavero Gianni - 5B INF

The solution is based on a complex database representing the whole Formula1's 2019 championship.
It provides a simple desktop crud and more complex WebApi structure for the display of the data.

Based on Visual Studio 2017 platform, the desktop application are done with C#.
The webpage of the fifth project works with jQuery.
The DB is done with SQL Server.

Projects

Project 1 - FormulaOneBatchConsole Project

C# console application to create and restore the DB.

Project 2 - FormulaOneDll

C# library for the DB connection, providing classes for every table and queries for the DB.

Project 3 - FormulaOneCrudForm

C# form that works as a simple crud.

Project 4 - FormulaOneWebForm

ASPX.NET webpage that just shows the tables.

Project 5 - FormulaOneWebApi

The core of the whole solution, with a complex C# Web Api 2.0 that returns data from the DB with several routes and DTOs
The FormulaOneWebApi contains also a webpage where you can see the majority of the Formula1 DB. Preview


Database Diagram

Preview

About

Mine old highschool project.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C# 61.9%
  • TSQL 19.0%
  • JavaScript 9.6%
  • HTML 5.6%
  • CSS 3.5%
  • Classic ASP 0.4%