Project information

  • Category: Web Application
  • Project date: November 2021 - January 2022
  • Project URL: GuildCarMastery
  • Technologies Used:
  • .NET Framework
    ASP.NET MVC
    ASP.NET Web API
    C# and Razor syntax
    ADO.NET
    LINQ
    T-SQL
    NUnit

This is a web app for a vehicle dealership's retail inventory system.

  • Drafted and designed a database schema and an SQL database to store inventory, user information, and form data
  • Built an ASP.NET MVC server back-end to handle server-side logic, including database interactions and data validation, and a first-party Web API to provide inventory data access to the front-end
  • Created a web interface allowing customers to browse vehicle inventory by querying price range or keyword, view vehicle detail pages, and send requests for more information, and for employees to submit purchase forms and view sales reports
  • Conducted extensive unit testing using NUnit to verify accuracy of database queries and business logic of the application throughout development
  • Implemented stored procedures with ADO.NET SQL parameters to secure data from SQL injection attacks

The hardest challenge of this project was implementing dynamic dropdown options for car models based on the selected car make. To do this, I used jQuery, AJAX, and Razor syntax to make an HTTP request and retrieve the relevent data from the database. Through this process, I gained a better understanding of HTML dropdown implementation with Razor.