Category Archives: Uncategorized

Warrant Search Client

Warrant Search Client

Written for a local city court to access their warrant database easily from within the office and remotely. Works in conjunction with the warrant importer app that connects to the local Microsoft SQL and then imports that data into an external MySql database to access.

App info to be posted:

COA Certificate of Analysis

COA Certificate of Analysis

An app developed with LaMarKa for creating the Certificate of Analysis. This connects to a MySql database and generates a printable COA as well as updating a database accessible via the web site for their users.

More Info to come…

MS SQL Connection Test

MS SQL Connection Test

A basic app that I use to test a SQL connection from the workstation. It shows me a list of Windows host machines that are available, and if MSSQL is running, make a connection.

App info to be posted

Remote Inventory Client

Remote Inventory Client

This is an inventory app written for Microsoft surface tablets that LMK was using for offsite inventory management. Contacts a MySql database for the required inventory via the internet. Once the user gets the required inventory, no internet is required. The user can now take the inventory count in areas that a wifi signal might be week. Once done, the user saves the results and can submit them once wifi is re-established.

Operator can use a barcode scanner for quick entry

Submits order back to database for processing

Copies of submitted orders are kept in archive as csv files

Designed to eliminate paper processing and faster order submissions. The app currently hooks to a MySql database, but can configured to any database with a .Net connector.

Sage50 Sales Order Generator

bSageSalesOrderSage50 Sales Order Generator

  • Connects directly to a store fronts MySql database
  • Grabs the current orders
  • Connects directly to Sage50 via the .net api
  • Auto fills the shipping and order info
  • Simply confirm the order and save

Designed to get orders produced from an online shopping cart, and create sales orders in Sage50 from them. The shopping cart used in development was MySql driven, so it can be adapted to most projects.

Network IP / MAC List

bNetworkView1Network IP / MAC List

  • Lists IP addresses in use by DHCP
  • Lists the associated MAC address

A basic .net app that obtains all IP/MAC addresses that DHCP has handed out. It can also be expanded on to include the host names for the devices.

Something portable and handy to list out workstations using the network.

Workstation System Info

Workstation System Info

  • Displays Windows Activation Code
  • CPU Information
  • Windows OS Information
  • NIC Information
  • Hard Drive Information

This is a basic c# project that displays all the needed info I required when sitting down with a Windows workstation, in one simple click, with minimal digging. Serves as information consolidation.

Built using 4.5 .net framework