________ __ ____
\_ ___ \ | |__ _____ ____ ____ ____ | | ____ ____
/ \ \/ | | \ \__ \ / \ / ___\ _/ __ \ | | / _ \ / ___\
\ \____| Y \ / __ \_| | \ / /_/ >\ ___/ | |___ ( <_> ) / /_/ >
\______ /|___| /(____ /|___| / \___ / \___ >|_______ \ \____/ \___ /
\/ \/ \/ \/ /_____/ \/ \/ /_____/
## [1.3.0.0] / in development
## LOC:
## Fixed:
- XML export did not process reorder level and low stock warn level
- Bug in the Database update class which did not handle the versions correctly
## Added:
- expanded DB.DataUpdate with 1 overload
- new class which checks for update from a file store on the web if we hava program update abailable
- "export to excel" context menu entry
- New entry in DB.cfg: "ExportPath=" can be specified for Export XML or Excel.
- DB update-check for v1.3
- DBUpdate.cs adds new Table for Article Group
- DBUpdate.cs adds new column ArticleGroupID to the Article table
- Additional error check variable in DBUpdate.cs to prevent DB Version from being updated in case of error
- Added Article Group combobox to MainWindow.xaml in tab Article Data and handling
- new tab "Article Group" in Window Settings/options
## Changed:
- "Export to XML" window now handles XML and Excel dynamically
- Standard export path will be Desktop if config file does now specify anything else.
- added 2 pixel top margin in article data and handling dock panels. Looks nicer :)
## Removed:
## [1.2.0.1] / 2020-07-02
## LOC: 11362
### Fixed:
- application crashed when trying to create an article without measures or empty warn level fields.
## [1.2] / 2020-07-01
## LOC: 11325
### Fixed:
- DB.config is now properly filled when options are changed and saved
- DB.config is now probperly read with all fields
- one gazillion errors because of different MySQL-syntax of the code
- some inconsistent variable types (long / int) which caused crashes in connectiion with the MySQL database
- when changing from MSAccess to MySQL or vice versa in the settings this caused a DB error because the log.write()
was triggered after
the variables got filled with the new values. Now the log is written before the variables are being changed.
- Activating an article now puts it in the combobox of booking again
- Deactivating or activating an article now clears the fields in Booking tab. Relevant if the article had been
selected in the booking and its values were displayed in the textboxes.
### Added:
- New Project WWWMS_CreateNewSQLDatabase into solution
- WWWMS_CreateNewSQLDatabase connects to an existing MySQL Database and adds the required tables for WWWMS on from V1.1
- WWWMS_CreateNewSQLDatabase fills necessary roles and standard users and DB version
- DBMySQL.cs added. For now it only handles the ExecuteNonQuery statements, will be extended in future
- in article handling window the volume will be calculated when len, width and height are filled with values >0
- Startup now checks for database connection error and catches it with message and app shutdown
- MainWindow Article Handling now has 2 new textboxes for Article low stock warning and Reorder level amount
- DBUpdate.cs new Method CheckColumnsAlreadyExisting(table)
- DBUpdate.cs new Method GenerateReqString()
- DBUpdate.cs new Method AddAlterTableString
- ArticleAmountWarning -> will be added to db version 1.2
- ArticleAmountReorderLevel -> will be added to db version 1.2
- Handling of the 2 new columns for read, create and change article
- WarnLevelCheck.cs to check the applied warnlevels
- WarnLevelCheck.ReorderCheckForAllACtiveArticles() which is called when start booking window
- WarnLevelCheck.LowStockCheckForAllActiveArticles() which is called when start booking window
- Stock / Reorder / Warn amounts in top right corder of Booking tab in bold 16pt font
- low stock warning will also pop up after login when the main window loaded.
- low stock warning messages boxe ask if user wants to supress warnings temporarily until next logout
- Menu Settings got new entries to re-enable reorder and low stock warnings. They willy only allow to re-enable, not do disable
- context menu in Articles list: edit selected article
- context menu in articles list: do booking for selected article
### Changed:
- Help now points to help file on Gitlab.com
- DB.cs adapted to correct and different-from-Acces MySQL statements
- Status bar now shows Server and DB-Name when MySQL is active
- toolbar backgrounds changed from ghostwhite to white
- logo picture replaced by ASCII text again due to similarity to a new tv series logo
- tab indices in the article handling window
- DBUpdatecs some code was "outsourced" in new methods. See 'added' section of this file
- Booking combobox list now displays article number in front of article name
- Clicking refresh in the article list grid now looks for text in the search field refreshed based on this filter
- improved layout of window user settings
- enlarged search text box in list all articles
### Removed:
- old, already commented-out code which was no more in use for a longer time
## [1.1] / 2020-04-30
## LOC: 8536
### Added:
- Database field ArticleWeightNet (5 digits after decimal point)
- Database field ArticleWeightGross (5 digits after decimal point)
- Database field ArticleWeightTara (5 digits after decimal point)
- Database field ArticleLengthCM (5 digits after decimal point)
- Database field ArticleWidthCM (5 digits after decimal point)
- Database field ArticleHeightCM (5 digits after decimal point)
- Database field ArticlevolumeCBM (5 digits after decimal point)
- final, new first little help file which can be started from the menu
- errors are now logged with the method where it appeared via System.Reflection.MethodBase.GetCurrentMethod() added to the ex.Message
- Data entry fields for weight and measures in Article handling
- Calculation of volume based on measures (provided all 3 are > 0)
- Data view fields for weight and measures in article handling
- Data view fields for weight and measure in booking
- Creating new article fills the new database fields
- Editing article fills the new database fields
- automatic database update functionality added:
- Checkversion() in DB.cs
- CheckRequiredFields() for update in DB.cs
- DBUpdateinserNewRowsToTable() in DB.cs for update
- implemented update check in login window bootup
- when clicking in article measure or weight field the whole text now be highlighted. Necessary because the double fields carry a 0 by default.
- XmlHandler.cs will now do the XML-Export correctly with the new measures and weight fields.
### Changed:
- Version number is now displayed inthe logic of 1.1.*
- changelog in the app menu now points to https://gitlab.com/m0r0i/wwwms-bug-reports/-/wikis/ChangeLog
- Help file is now Help.txt, no more the dummy Help1.txt
- moved Dictionary shortArticleList from DB.cs to Article.cs
- moved Dictionary ArtCol from DB.cs to Article.cs
- Article Handling data fields now inactive unless "Edit" button is pressed
- Database field ArticleLengthCM is now ArticleLength
- Database field ArticleWidthCM is now ArticleWidth
- Database field ArticleHeightCM is now ArticleHeight
- Database field VolumeCM is now ArticleVolume
- Article handling: tab no more shows the first article when started.
- Edit button is inactive until an article is selected
- extracted code to own method VerifyArticleWeight()
- extracted code to own method VerifyLengthWidthHeightVolume()
- Sorted new methods to regions properly
### Fixed:
- fixed bug #72 which prevented reactivation of the "edit" button int the article handling after pressing the "clear" button
- fixed bug #59 which caused a null-reference-exception when all articles in the list were selected for XML-Export (Commit f61c22f7)
- empty double fields from the DB will now be filled with 0 to ensure proper handling of values in the frontend
- fixed bug #74 which could happen when somehow a too long article number (>8 digits) was already in the database. Legacy problem of very old entries.
- fixed bug #75, incorrect formatting of the calculated volume string which cause zero value display for very small sizes
## [1.0.0.0] / 2020-02-29 ---- VERY FIRST STABLE RELEASE ----
## LOC: 6,811
### Fixed:
- List all articles datagrid now properly adapts to each screen size and displays the scrollbars only when necessary
- menu width of main window now correctly stretches in the window size
### Added:
- static class XmlHandler.cs for writing export to XML file
- select and right click in "list all articles" offers s new context menu "Export to XML"
- user must select directory for export
- Keyboard shortcuts added:
- Ctrl+L List all articles
- Ctrl+B Booking
- Ctrl+H Article Handling
- Ctrl+Q Quit
- "Do you want to quit?" Dialogue
### Changed:
- added keyboard shortcut info to menu entries
- white menu bar background
- ghostwhite toolbar background
- replaced success Messageboxes against status bar messages
## [0.6.0.0] / 2020-01-25
## LOC: 6,448
### Added:
- Article has now a field for EAN/GTIN code string
- Disclaimer text in "about"-window
- Statusbar in User Settings which displays name, role and active-status of selected user
### Fixed:
- Some bugs which popped up after implementing the EAN/GTIN field
- Bug #56 ("Do you want to save changes?" in Option always appeared, even when nothing was changed)
### Changed:
- Article changes "Apply"-Button is only active when the "Edit" button was pushed before
## [0.5.0.0] / 2019-12-30
## LOC: 6,348
### Fixed:
- make sure DB connection closed when clicking cancel in login window
### Added:
- automatic Backup of ACCDB file
- backup location for ACCDB backup now displayed in DB settings window
- ACCDB database backup location can now be set in options
- ACCDB database location is stored in config/DB.config
- Articles can now be edited
### Changed:
- Layout of about window: last changed is now directly below the version number
- "List all articles" grid has now prettier column headers, no more only DB column header names
- "List all articles" search adapted with the new column header names
- Replaced \\/\// - text in About-Window by a logo .png
- Article description field now has word wrap on overflow
### Removed:
- immediate application restart after saving changes
## [0.4.0.0] / 2019-12-24 merry xMas :)
### Fixed:
- activate / deactivate articles caused troubles in different dropdown-lists in booking and article handling because of wrongly handled collections
### Added:
- non-admin users can now only see their own log entries
### Changed:
- status bar text of log now makes more sense when not all entries are displayed
<br><br><br>
## [0.3.3.1] / 2019-12-08
(source not yet merged to master branch)
### Fixed
- wrong check of permission for activate/deactivate user
<br><br><br>
## [0.3.3.0] / 2019-12-08
(source not yet merged to master branch)
### Added
- Button "Activate User"
- Button "Deactivate User"
- method to activate user in DB
- method to deactivate user in DB
### Changed
- added permissions for De-/Activate user in "CheckUserRoles" method of user settings
## [0.3.2.0] / 2019-12-01
(source not yet in master branch)
### Added
- DB Settings in Settings/Options Window
- ascii config file for Database (config\DB.cfg)
- read config and use values before login window opens
### Changed
- deactivated static prover string and datasource string
## [0.3.1.1] / 2019-11-24 (not pre-compiled for download)
### Added
- new window for settings / options
### Changed
- menu settings / options is now active and opens the new window
## [0.3.1.0] / 2019-11-24 (not pre-compiled for download)
### Added
- In user settings there is now a possibility to change the password
- Crypto class to en-/decrypt strings with Rijndael-Algorithm is prepared, but not in use
### Changed
- User settings window has now the fields for PW changing
## [0.3.0.14] / 2019-11-17 (not pre-compiled for download)
### Changed
- merged new article and de-/activate article tabs in one
>>> I don't compile it for download as the latest Microsoft security update put a bug in the MS Accedd UPDATE functions which causes errors when you try to update
## [0.3.0.13] / 2019-11-15 (not pre-compiled for download)
### Fixed
- bug (#37) which prevented proper shutdown when a subwindow was open
### Changed
- StockLocataion has its class now to hadle the places as objects
## [0.3.0.12] / 2019-11-01
### Fixed
- bug which in certain cases allowed user to login despite 3x wrong password and user deactivation
## [0.3.0.11] / 2019-10-30
### Changed
- status bar info of article list and log viewer is now hidden when one of the other tabs gets focus
## [0.3.0.10] / 2019-10-30
### Fixed
- fixed bug that caused crash when adding new article
### Changed
- limited article number to 8 digits length
- winodws can't resize anymore, except main window
## [0.3.0.9] / 2019-10-27
### Fixed
- bug 31 Error message when art nr not integer
- bug 32 Clicking "Activate article" and then immediately "deactivate article" causes error
- bug 33 Booking list does not refresh when open after activating an article
## [0.3.0.7] / 2019-10-27
### Fixed
- fixed bug in status bar which displayed wrong number of lines after grid views were readonly
### Changed
- made grid views readonly
## [0.3.0.6] / 2019-10-26
### Fixed
- bug fixed: possible crash when new article has non-integer number
- bug fixed: possible crash when article list max amount was non-integer
### Changed
- code cleanup
##### V0.3.0.2
## 2019-10-20
* user management is now complete. you can add, delete users in the program and change the user role
* user role implementation started:
- Admins can create, delete users and change roles
- SuperUsers can only change roles
- normal users cannot access the settings
##### V0.2.9.1019
## 2019-10-13
* user creation via frontend is now working
* fixed bug which did not reset the wrong-password-entries-counter when changing the username in the login-form.
Under certain circumstances this deactivated the wrong user ;)
##### V0.2.8.1019
## 2019-10-13
* Bugfix: empty stock place caused error message
* activated user Settings menu and window
* new User.cs and UserAction.cs classes
* not compiled for testing as much is still missing....
<br><br><br>
##### V0.2.7.1013
## 2019-10-13
* functionality for stock location added
* for new articles you can now add a stock location
* Booking window provides functionality to change stock location of selected article
<br><br><br>
##### V0.2.6.1013
## 2019-10-13
* some improvements in the WPF forms
* replaced some constants by variables
<br><br><br>
##### V0.2.5.1003
## 2019-10-03
* fixed bug in "list articles" and log viewer which let the user enter 0 max results and thus caused an SQL error
<br><br><br>
##### V0.2.4.1001
## 2019-10-01
* fixed bug which prevented the statusbar from showing the correct user
* fixed bug which caused a wrong error message in the log after successful user-login
* DB.cs code cosmetics and documentation summaries added
<br><br><br>
##### V0.2.3.0930
## 2019-09-30
* login form is active
* login requires a user in the database. You can use user/PW test/test for testing or create your own user directly in the accdb
* failed and successful logins will be logged in DB
* after 3x entering wrong password the user (except wmsadmin) will be deactivated. you can re-enable it in the database only for now.
<br><br><br>
##### V0.2.0.0928
## 2019-09-28
* Switched to WPF-UI
* LogViewer can now be sorted by LogLevel and max. Results
<br><br><br>
##### V0.1.7.0927
## 2019-09-27
* changed list-all-articles gridview display and search to full DB access
<br><br><br>
##### V0.1.6.0926
## 2019-09-26
* bugfix: Switching MDI childforms now works properly
* bugfix: log- and article grids now don't mix up any more
* search in article list can be started by hitting enter
<br><br><br>
##### V0.1.5.0923
## 2019-09-23
* basic funtionalities are working
<br><br><br>
## 2019-09-23
Very first pre-alpha development release for testing. I won't update this much in the pre-alpha-phase
