Inventory Manager

------------------------------------------------------ | | Product - Inventory Manager | Version - 1.9.0.0 | Author - Tim Bare | Copyright - 2011-2013 - Tim Bare | | Author Website - http://www.tbare.com | Project Website - http://www.simple-im.com | | Description: | A fairly simple inventory manager with | check in / checkout functionality, | and barcode field (working with most | typical bar code scanners), check out | reports, and many other features. | ------------------------------------------------------ Things to note: **** SQLServer Express (min 2008 R2) with default SQLEXPRESS instance must be installed. **** History: Revision: v1.9.0.0 ======================== -Enhancement - Added Quick Check Out functionality - check the checkbox, and the window stay open until you close it manually, even after the item is checked out Revision: v1.8.9.0 ======================== -Enhancement - Fixed export to Excel to only export visible columns and also retain column order. -Minor bug fixes / improvements to other code Revision: v1.8.8.0 ======================== -Perfomance issues - Fixed issue where tables with many (over 1,500) records would take a long time to load / not sort properly Revision: v1.8.7.0 ======================== -Bug Fix - Disallow deleting items when any quantity checked out. -Bug Fix - Adding images was setting the image to the wrong ID ONLY from "Add New" - "Edit Item" was not affected. -Minor Enhancements Revision: v1.8.6.0 ======================== -Bug Fix - Typos (oops) -Enhancement - Improved reporting for Added to "Currently Checked Out" report. -Enhancement - Improved filtering for Items (now filter by Item name and Barcode, as well as by Type). Revision: v1.8.5.0 ======================== -Bug Fix - Fixed error where updating Quantity from 0 to more than 0 was not unmarking item as "checked out," thus not allowing the item to be checked out again. -Enhancement - MUCH improved reporting for All Check Out History (will likely be added to "Currently Checked Out" in next release). Revision: v1.8.4.0 ======================== -Bug Fix - Fixed error where attempting to "Check In" an item without inputting a quantity would crash the program -Minor Bug Fix - Updated code to show "Quantity Out" correctly when opening "Check In" screen Revision: v1.8.3.0 ======================== -Bug Fix - Fixed the "Delete check Out Record" error on the All Check Out Reports screen -Enhancement - updated the Export to Excel function to work a little cleaner Revision: v1.8.2.0 ======================== -Enhancement - Added ability to specify quantity checked out and in Revision: v1.8.1.0 ======================== -Bug fix - Fixed error when starting up for user when generating Registration Code. Revision: v1.8.0.0 ======================== -Enhancement - Added support for Quantities. See how many of a certain item you have in stock and checked out. Can be disabled in Options (registered users). -- Users that are upgrading from a previous version -- all items will be set to quantity of "1" - if the item is currently checked out, "Quantity In Hand" will show as "0" and "Qty Checked Out" will show as 1. -Other code enhancements - always making it better Revision: v1.7.2.0 ======================== -Update - Point downloads and application to new website (http://www.simple-im.com) -Update - Support for newer versions of Sql Express, with download links for 32 and 64 bit versions of SQL Server Express 2008 R2 (modified installers for minimal user interaction) -Update - Paving the way for Affiliate builds - Ready to get paid for recommending IM? -Update - Updated the way "Check For Updates" verifies if there's a newer version available -Bug fix - Fixed "Buy Now" link on "All Check Out History" report for non-registered users -Other code enhancements - always making it better! Revision: v1.7.1.0 ======================== -Bug Fix - Allow deletion of Check Out records after item has been deleted -Fixed the default database to not have more than 1 record pre entered Revision: v1.7.0.0 ======================== -Enhancement - Arrange columns the way you want, and hide the ones you don't want to see in Items, and both Check Out reports -Bug Fix - dealing with errors when checking for special news (such as for users behind a proxy). -Various other minor bug fixes and code improvements Revision: v1.6.5.0 ======================== -Bug Fix - "Check In" was selecting the wrong item in some cases when using a barcode. Revision: v1.6.4.0 ======================== -Enhancement - Added checkbox for "Quick Check In" on Check In screen - checking the box will keep the "Check In" window open after an item is checked in. -Minor Bug Fix - Check In screen results updates when Type is changed. -Splash Screen window now shows up in Task Bar as to not get hidden if another program is clicked -Other minor bug fixes Revision: v1.6.3.0 ======================== -BUG FIX - Checking items in from "Currently Checked Out" report was messed up. - Also added code to fix items that were messed up by this bug (still showing as "Checked Out" after they were checked in) -Enchancement - Added "Check Out Notes" and "Check In Notes", along with ability to modify the Check Out Notes while an item is checked out Revision: v1.6.2.0 ======================== -Registered User Request - Enhancement - Added "Checked Out To" to Items page -Enhancement - Updated "News" page to be HTML to be further configurable -Enhancement - Clicking "Buy Now" buttons now enter Registration Number in order form. -Changed "Bug Report" in Help menu to point to http://forum.tbare.com -Pointed "Download Update" to https://sourceforge.net/projects/tbare-im/files/latest/download for increased reliability for updates -Minor enhancements to code, etc. Revision: v1.6.1.0 ======================== -Bug Fix - Item search on Check In and Check Out screens were not updating descriptions when items were found -Bug Fix - When Permanent Check Out was disabled, reports were still showing the column -Minor enhancements to code, etc. Revision: v1.6.0.0 ======================== -Bug Fix - Versions greater than x.y.z.0 where z is greater than 9 were not alerting of new versions available. -Bug Fix - Items marked as Permanent Check Out were allowed to be checked in with Context Menu on reports and Items screens -Enhancement - Barcodes field added to both reports -Enhancement - Permanent Checkout option can now be disabled for registered users Revision: v1.5.10.0 ======================== -Bug Fix - 64 bit SQLServer Express 2005 download link was pointing to 32 bit file. -Bug Fix - Overseas user reported errors when checking in and checking out - fixed Revision: v1.5.9.0 ======================== -New feature - Get alerted of special news, including special pricing if you're not registered -Added Pictures on the home screen buttons -Various small bug fixes Revision: v1.5.8.0 ======================== -New feature - Export reports to Excel (Registered Users Only). Clicking this menue option will open excel, and automatically import all rows into a nice Excel spreadsheet, and, if you're using the Cost field, even total up the total cost for that report. -New feature - Report a bug from within the program (with file attachment). Help > Report a Bug. now you can report a bug, and add a file attachment to the report, and it will be emailed directly to me. Revision: v1.5.7.0 ======================== -Bug fix - Printed reports no longer show hidden columns (Cost, for example) -Bug fix - Fixed Line Breaks in descriptions showing up properly on reports, both on screen and printed -Bug fix - Printed "All Check Out History" Report no longer shows "12-31-1949" for non-checked out items -Bug fix - Closing program using File > Exit menu option now asks if you're sure and backs up database on exit (if option is set) -Enhancement - Double-clicking Types and Items now opens "Edit" window -Minor Enhancement - Added underlines for all menu items all the time for "Alt + ..." keyboard shortcuts -Minor Enhancement - Added keyboard shortcuts for main window menu options (visible by clicking on the menu item) Revision: v1.5.6.0 ======================== -Bug fix - blank cost field and hitting save no long throws error and cancels save. -Bug fix - Splash screen wasn't showing up for XP users. -Enhancement - Removed SQLServer Express auto-install during setup -Enhancement - Changed "SQL Server Missing" dialog box - added buttons to download 32 and 64 bit versions from tbare.com Revision: v1.5.5.0 ======================== -Added more menu options -Added file menu and context menu icons -Other minor enhancements Revision: v1.5.4.0 ======================== -Added context menus allowing various actions to selected row: --Edit, Delete, and Check In for "Items" --Edit and Delete for "Types" --Check In for "Currently Checked Out report" --Delete and Check In for "All Check Out History." -Minor bug fix - arrow now follows selected row when you edit a type and item. -Minor tweaks / enhancements including regulating which windows show up in the taskbar Revision: v1.5.3.0 ======================== -Major Bug Fix - Checking for updates from within the app was looking at SwithMail version (oops!), and also not alerting if new version was available when "Check Now" button pushed from Options menu and also Help Menu. All issues now resolved. -New splash screen background -Removed "what's happening" text as some users were noticing a display refresh issues. -Minor bug fix - fixed tab-order on Add Items and Add Types for buttons added in 1.5.2.0 -Easter Eggs! can you find them? Revision: v1.5.2.0 ======================== -Registered user request: added additional "Save" options for items and types - "Save & Add Another," and "Save & Add Similar" - both keep the "Add" window open. -Added "Print" menu for Types -"Delete" key now deletes Items and types - user is still prompted to ensure they want to delete the object -Minor bug fixes including - fields being cleared and focus being set properly when going into "Add Items" and "Add Types" windows repeatedly. Revision: v1.5.1.0 ======================== -Bug Fix - Editing and saving an item when "All Items" checkbox checked would sometimes throw an error - Item DID always save -Bug Fix - Editing and saving an item when "All Items" checkbox checked did not show all items - related to previous bug -Minor bug fixes including Check In / Out Item information correctly displaying and tab indexes for multiple windows -Other Check In / Out Filter enhancements Revision: v1.5.0.0 ======================== -Unregistered version is now fully functional, except for checking for updates on startup, backing up database on close, and deleting Check Out History. -Unregistered users can now add images to items. -Changed unregistered version to 3 type and 10 item maximum - upgraded version will keep all current items and types, but not allow adding any more. -Added "Item name filter" in Check In and Check Out windows. Now you can search for your items by name. -Barcodes are now OPTIONAL for registered users. -Barcodes no longer have to be unique - option is available to force unique barcode for registered users. -When searching for barcodes in Check In and Check Out windows, if multiple barcodes are found, all items with that barcode are listed in the items drop down -Added option to Hide disabled options for registered users - don't want to use Cost, Images, or Barcodes? Disable them, and hide them and keep the program nice and tidy. -Other minor bug fixes, optimizations, and spelling corrections Revision: v1.4.3.0 ======================== -REGISTERED USER REQUEST- Added image functionality to items - now you can SEE what you have! (Registered users only). -Images appear in the Edit Item, Check Out, and Check In windows. -New Icon! -About screen now closes when "Esc" key pressed. -Big Fix - Edited item or type is now the selected row after "Save" is clicked Revision: v1.4.2.0 ======================== -minor bug fix Revision: v1.4.1.0 ======================== -Registered User request: Added functionality to view all items, and print report -Added functionality to delete check out history for registered users. Option to enable / disable in Options menu -Added "Check For Updates" to Help menu -Bug Fix - Items with prior check out history now able to search by barcode without "Item not found" message appearing Revision: v1.4.0.0 ======================== -Registered User request: Added optional "Cost" field - can be turned on/off in Options for registered users -Registered User request: Added "Permanent Check Out" option - Items marked will not show up in "Check In" dialog -Added option to copy Item changes to Checked Out history -Registered users can set default to "Always update," "Never update," or "Always ask" -Bug fix - disabled "Edit Item" and "Delete Item" buttons when no items are available for type -Bug fix - "Barcode" and "Check Out to" fields blanked when "Check Out" and "Check In" closed and re-opened -Database update - Added columns in InventoryItems for Cost and Permanent Check Out -Database update - Added columns in CheckOutInfo for Cost -Added code to automatically add columns to table on startup for existing databases, and copy information from existing tables to new columns on first launch (if updating). Revision: v1.3.1.0 ======================== -Bug fix - Deleted items no longer blank out fields in Check Out history report. -Bug fix - Now forcing "Updates Available" and Registration screen to the front so they don't hide behind the splash screen -Database update - Added columns in CheckOutInfo table to store item information -Added code to automatically add columns to table on startup for existing databases, and copy information from existing tables to new columns on first launch (if updating). Revision: v1.3.0.0 ======================== -Added registration -Changed license from 'Free for all' to 'Free for home' - business use MUST register -Purchase a serial for $25.00 / computer from http://inventorymanager.tbare.com -Removed ability to back up files and check for updates from non-registered users. Revision: v1.2.1.0 ======================== -Added "Check for updates" functionality -Added link to project homepage (http://inventorymanager.tbare.com) on About form Revision: v1.2.0.0 ======================== -Added installer -Moved database to /data subfolder -Added "Backup DB On Exit" option (available in 'Tools > Options...' menu) -Added splash screen to pre-load datasets and check for SQL EXPRESS. Revision: v1.1.0.0 ======================== -Added ability to print reports from the application -Changed second level forms to Modal forms -Minor bug fixes / tweaks Revision: v1.0.0.0 ======================== -Initial release License: This software is free for non-commercial (home) use. The caveat being that there are limitations to the non-registered version – the functionality to automatically backup the database on exit, automatically check for updates from inside the app are disabled, as well as image support, and other features that are continually added to the software. Additionally, there is a 10 second ‘nag’ screen when you launch the unregistered version. Business use of any kind must register the software in order to be properly licensed. For a regularly updated list of features that are available to registered users, visit http://inventorymanager.tbare.com/#whyRegister Disclaimer: This software is provided by the copyright holder and contributors "as is" and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services; loss of use, data, or profits; or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this software, even if advised of the possibility of such damage.