________   __                                       ____
\_   ___ \ |  |__  _____     ____     ____    ____  |    |      ____     ____  
/    \  \/ |  |  \ \__  \   /    \   / ___\ _/ __ \ |    |     /  _ \   / ___\ 
\     \____|   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
Save
Cookies user prefences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Cookies