This project is read-only.

Moved to GitHub - https://github.com/DzonnyDZ/Caps

  • The project has been moved to GitHub becase of ongoing problems with CodePlex SVN interface stability and reliability
  • Thanks a lot folks from CodePlex for running this site for years and for pioneering OpenSource on .NET
  • I'll miss SVN simplicity :-(

Welcome to the Caps project!
I'm collecting various caps from bottles - mainly from drinks. My collection currently contains about 2000 caps and is growing. I store the caps in boxes. When a new cap arrives it's very hard to determine if I already have the cap in collection or not.
  • First goal is to help organize collection of caps by allowing search using various criteria. (Of curse, I must first fill the database.)
  • Once I'll have information about all the caps in computer I'd be great to present my collection to entire world. So, second goal is web site of the caps collection.
  • Finally, nice to have: I usually add caps I find on the street (lucky that people make mess) to my collection. It'll be nice to examine the cap right on the street, if it is forth taking. So, I plan to create Windows Mobile version of caps catalog application.

Current status

  • Caps Console (WPF application with SQL Express 2008 database) - under development (beta version available)
  • Caps Web (Web site to show caps to public, maybe with add/edit functionality for admins) - awaiting development
  • Caps Mobile (.NET CF application with read-only SQL CE database) - planned

Details

The most important part of the application is database. Database structure is highly specialized for purposes of Caps collecting. Maybe it can be used for some similar products like cans, bottles, corks etc. It will not fit for collection of post marks!
The central part of database is table Cap storing various details of caps like texts, colors, size etc. Then there are several helper tables like CapType, Product, Keyword, Storage or Image. The database is designed as something between full caps details (very time consuming to fill-in) and only few details (easy to fill but uselles for search and presentation purposes). It should be possible for example to make queries as 'All caps from beer' or 'All red caps', 'All caps without text', 'All caps with image of house', 'All caps from Coca-Cola', 'All caps from cola', 'All metal caps', 'All round caps with 1cm diameter' etc.

This CodePlex project is set up to provide the code and later binary of applications mentioned above to everybody who may find it useful, and to provide me source control, or course.

Application code is written in Visual Basic 9 and I'll switch 10 VB 10 as soon as there will be some more stable release (maybe Beta 2).

Main.png
Main screen
Editor.png
Cap editor
Connection.png
Database setup
SearchSimilar.png
Search results / cap details view
ListEditor.png
Edit various lists

vicka.jpg

Last edited Sep 18, 2015 at 4:41 PM by Dzonny, version 7