Skip to content

ErikKhan/assestsTracking2EntityFramework

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Asset Tracking with database Using Entity Framework Core

This project is the start of an Asset Tracking database.
Asset Tracking is a way to keep track of the company assets, like Laptops, Stationary computers, phones
All assets have an end life which for simplicity reasons is 3 years.
All assets are stored in database using Entity Framework Core. One can Post Data and Get Data from the Database.
It has 4 different offices around the world which will use the appropriate currency for that country. The program is able to input values in dollars and convert them to each currency (based on todays currency charts). Built in methods were used to get the currency rates in Euro, Dollar, SEK, NOK.
Default Data has also been used in the Database so the database is not empty.

  1. The Table is shown to the console and also in the Microsoft SQL Server:
  • Sorted first by office ✔️
  • Then Purchase date ✔️
  • Items RED if date less than 3 months away from 3 years ✔️
  • Items Yellow if date less than 6 months away from 3 years ✔️
  • Each item should have currency according to the country ✔️
  • Extra Feature has also been added in this project, in which products will be shown depending on the Country. ✔️

    anotherone

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages