ReSCat

Company report creating application.

Main Window Code · Main Window View · App Themes

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.

(back to top)

Frameworks used in the project:

• Entity Framework
• ClosedXML
• ScottPlott

(back to top)

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.

(back to top)

Application was created to:

• Create empty database - In Menu after pressing New, then you have to choose the name of your DB.
• Edit existing xml - In Menu you could choose to edit existing XML raport to add missing data.
• Saving database as XML - In Menu you 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: Notes that could be saved in .txt file. Possibility to switch between in-build Calcultator and system Calculator. Calendar that 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.

(back to top)

• 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

(back to top)

Feel free to add something to my project!

1. Fork the Project
2. Create your Feature Branch
3. Commit your Changes
4. Push to the Branch
5. Open a Pull Request

(back to top)

Distributed under the MIT License (so basicilly you coul do whatever you want with my code).

(back to top)

Kamil Kaszuba - Linkedin - kamil.p.kaszuba@gmail.com

Project Link: https://github.com/Mileek/ReSCat

(back to top)

• Tim Corey
• Stack Overflow
• Entity Framework Tutorial
• ReadME Template

(back to top)