Tierra Media: Point Of Sale


"Tierra Media" is a store that sells trading game cards and related products, such card protectors, souvenirs and figures. The owner of this store told me about this project and how everything was going, in that explanation I identified an area of oportunity. All the processes of sell and buy products were being taken by hand, for this project. First, I made a rise of requerimients with him. Then, I made an Entity-Relation diagram to declare how this information was interactuing. After that, I put hands on into code, so, I develop the system in Windows Forms under the C# language. For the database, I used SQL server and for every Create, Upgrade and Delete Operation I created a stored procedure. For reports, I implement within the system a way to export the data shown in tables to PDF and Excel formats, and for retrive the data from the database I used views and store procedures. During all the development process I used Git and GitHub as version controller.


Business features

  • Validation with database for user login
  • Users, products, sales and categories management (CRUD)
  • User-role permissions
  • Export data to Excel file
  • Export data to PDF file
  • Export database backup
  • Import database backup

Technology

  • Windows Forms with C#
  • SQL Server
  • Git / GitHub
  • Monolithic architecture

Architecture

Due to Monolithic architecture of the project, the only diagram generated was entity-relation diagram

Entity relation diagram

Image Gallery

Admin page

Admin page

Inventory page

Inventory page

Login screen

Login screen

Main menu

Main menu

Reports

Reports

Entity-Relation diagram

Entity-Relation diagram

Return to projects