Table of Contents
What you are seeing is a simple wpf application, in which i used to learn: WPF, C#, XAML, SQL and Entity Framework and ClosedXML. Everything written inside is based on my own insights, tips from stackoverflow or diffrent pages.
The application is based on the work i did in my last company. Basing on main entity that is pattern, you can create whole database with elements that are manufactured in company. There are buttons responsible to: add, delete, update, show (which are used to write/modify records) new records into db. Datagrid is used to display all records inside db (based on entity using SQL). On the left side there is a possibility of searching specific records from database (or loaded XML file). Program also have functionality that allows you to create XML file from your current records. You can also load previously created XML file, edit, add, update and save your changes so that you don't need to use another program to work with it.
There are also functions like:
-
Calendar which shows selected week (for production purposes),
-
In-Build calculator (it is possible to choose Windows calculator),
-
Simple notepad,
-
Nawigation menu,
** Charts
** Log menu.
Frameworks used in the project:
Application is still in development and many of its functionalities are not bug-proof.
- Currently I do not know what functionalities to add to the application.
You need to have SQL Server Express LocalDB installed due to .mdf file with main data base info (LocalDB will be installed from exe file). Unfortunately I am unable to test the app.
To run the application all you have to do is download pre-relese version and then install it.
Application was created to:
- Create empty database - In
Menuafter pressingNew, then you have to choose the name of your DB. - Edit existing xml - In
Menuyou could choose to edit existing XML raport to add missing data. - Saving database as XML - In
Menuyou could save the file to create XML file as a report. - Modifying data - It is the main feature of the application. It is possible to add, delete and update records in database. There is also an option to check the elements as finished products. All recors may be filtered by finished products.
- Searching through the data - there is also a special panel to search the data by selecting appropriate header.
- Hall box - Allows you to select on which hall the element is manufactured.
- Special buttons on right panel - There are also buttons responsible for:
Notesthat could be saved in.txtfile. Possibility to switch between in-buildCalcultatorand systemCalculator.Calendarthat is probably most helpful function, it show you the week selected day to write it into the appropriate boxes.
The application was meant to be self-sufficient. In my previous company I had to use many different XML files to add new record, create new rows (It's not so efficient!), use browser to check production week of th element, calculator to count the weight, notepad to create simple notes. As you could probably imagine it was not so fast, and not so plesant to work with it. You probably also know that after sharing an XML file, someone else might open it (So you can't edit it) then forget about it and so your work stops.
- Add Week Calendar
- Add Nawigation Panel
- XML Files Handling
- Bug, expection handling
- Add New Panels (Charts, Logs)
- Add New Functions
- Add functional minimalize and close buttons
- [/] Implementing MVVM model
- Add Login Menu
- Admin Functionalities
- [~] Notepad And Calculator full functionality
Feel free to add something to my project!
- Fork the Project
- Create your Feature Branch
- Commit your Changes
- Push to the Branch
- Open a Pull Request
Distributed under the MIT License (so basicilly you coul do whatever you want with my code).
Kamil Kaszuba - Linkedin - kamil.p.kaszuba@gmail.com
Project Link: https://github.com/Mileek/ReSCat
Use this space to list resources you find helpful and would like to give credit to. I've included a few of my favorites to kick things off!