/Sage-Pace

A WPF Library Management System with an Oracle Database back-end. Remote deployable!

Primary LanguageC#

badge

NPM Version Build Status Downloads Stats

Sage | Pace

TODO: Convert Framework model from event based programming to: MVVM (Model-View-ViewModel)

Sage is a theoretical design implementation to resolve the needs of an existing physical system as they adapt into paper-less data record keeping. Also, My first attempt at using WPF to control the front-end within the .NET framework. Using XAML for the interface was a different experience yet very similar to embedded css in html markup. Once I get the hang of data binding with a View Model, things will be stranger yet!

The program was designed with the goal of utilizing Oracle SQL knowledge attained from the CCS014 ITEDBASE-01 class of 2018

Installation

Windows:

Install .Net Framework 4.7.2.
Install Oracle Database XE 11gRE3.
Locate Data Pump from within SQL Devevloper and select View > DBA > Import on the export dump file provided.
Install Oracle Data Access Client Managed Driver.
Then..
Download file from releases & extract
Run Sage.exe

*Note: The connection string target is given by the app.config file included in the program.

Logical Design

Ldesign

You will notice that Author Master and Genre Master were broken down from their place in the Book Table, this is to allow any book to possess more than a single author, or more than a single genre. One tag may exist as multiple entries in the other table, thus, not their ID but an auto incremental dummy column was devised to allow insertion of records without constraints. This was modeled after the data of the client; thus, the scope may be small or unexpected. Until their model changes, the data dictionary will adapt to its needs. A part of their design is to only allow borrowing of books in single intervals. Because of this, each created order will only reduce the quantity of a record by 1 per transaction, and increase the quantity by 1 for each resolved transaction

Relational Design

Rdesign

Feeding the Excel Document

To batch import data into the program, click the import/export tab and select your Table target from the combo box.

Then, click the export button and select the SageLedger.xlsx file provided. Certain columns are omitted by default and the entered data needs to be carefully sanitized.

For more examples and usage, please refer to the Wiki.

Keeping track of inventory

Inventory screen

Manage quantity reductions and overdue balances

Orders screen

CRUD Manipulation

select screen

TBD

Release History

  • 0.0.1
    • Initial release

Meta

August Bryan N. Florese – @Aroueterra – aroueterra@gmail.com

Distributed under the Mit license. See LICENSE for more information.

https://github.com/Aroueterra/

Contributing

  1. Fork it
  2. Create your feature branch (git checkout -b feature/fooBar)
  3. Commit your changes (git commit -am 'Add some fooBar')
  4. Push to the branch (git push origin feature/fooBar)
  5. Create a new Pull Request