________   __                                       ____
\_   ___ \ |  |__  _____     ____     ____    ____  |    |      ____     ____  
/    \  \/ |  |  \ \__  \   /    \   / ___\ _/ __ \ |    |     /  _ \   / ___\ 
\     \____|   Y  \ / __ \_|   |  \ / /_/  >\  ___/ |    |___ (  <_> ) / /_/  >
 \______  /|___|  /(____  /|___|  / \___  /  \___  >|_______ \ \____/  \___  / 
        \/      \/      \/      \/ /_____/       \/         \/        /_____/  

## [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