This project introduces a simple C# and XAML WPF interface to the database originally developed in the LibraryInventoryTool repository. The program design utilizes models and views, whether it a strictly MVVM design pattern or not I'm not sure. All data manipulation and business logic is in the models, all presentation is in the views. It is a work in progress. It is only being worked on when there are no paid projects to be worked on. This is a development and proving ground for the model and view DLL's that will be part of the final product. This is also a self-training project for learning XAML, WPF and how to interface to MySQL using C# and Dot Net. The best way to learn is to do.
There are differences to the database originally posted in LibraryInventoryTool. Tables have been refactored and added. Additional functionality has been added as well.
- Add Author
- Add Author Series
- Add Book
- Edit Book
- The user can rename columns shown in the tables.
- The user can hide columns they are not interested in.
- The user can resize a table window to reduce or remove horizontal scrolling.
- MSI installer to easily install the application.
The current user requirements are in Documentation/Requirements/Requirements.xlsx
- Microsoft Visual Studio 2017
- Dot Net 4.7.2
- MySQL 8
- Run the 4 MySQL scripts in this order:
a. devMySql/LibInvDDL.sql
b. devMySql/LibInvFuncs.sql
c. devMySql/LibInvProcs.sql
d. devMySql/LibInvUnitTests.sql - This provides some data for testing and experimentation as well as testing all the stored procedures. - Open the solution file in Visual Studio 2017
- Build or Rebuild
- Run
- When the user closes the Add Book dialog without selecting an author the application quits.
I am not and never have been a graphic artist. I would value input on what might make it more attractive to users. The application may need a few more dialogs such as Buy Book.