The purpose of the Software Asset Management System is to enable the organization to create a dynamic system, to meet the demands of the rapidly changing business environment, to adapt to new situations and to manage the software inventory in the best way. With the technology they use; It helps the institution in determining strategies that improve the dynamic characteristics of the units, system infrastructure and platforms in the institution.
This system is a database management system course project.
Microsoft SQL Server Management Studio 2018 version 15.0.00.5 is used as the database system. ASP.NET project and MVC framework are used on Visual Studio 2017 Community.
- Interface design with HTML, CSS, JS and Bootstrap libraries was designed for user convenience.
- The database was included in the project with the Entity Framework Code First approach.
- Complex SQL queries were created for various operations.
- Stored procedures and triggers were created that record and store complex queries to be used over and over and make the database organized.
- Stored procedures are used in the project with the Entity Framework Code First approach.
- The project was built on Model-View-Controller architectural pattern.
- Entity Framework is used for operations such as CRUD transactions on the system.
- 90% of CRUD transactions were coded using stored procedures.
- The department and user information to be taken from the institution was included in the project with xml import-export.
- Time and Cost reports were created. Reports can be sent as e-mail when requested.
- PDF import, save as excel, print and copy operations for page tables were done with JavaScript.
- SEO settings were made for the system.
