Point of Sale System

With Remote Capabilities

by Justin Dansby

CPSC 463 SPRING 2004 Dr. Pargas

Introduction

• Design new Point of Sale System (POS) for Mellow Mushroom

• Current POS system ALOHA is limited in remote access

• Incorporate new functions

• Decrease time to access data

Problem Statement

• Current POS System does not allow an easy means of remote access

• Current POS tracks inventory by what is sold

• Use ASP.NET to create real-time database functionality

• Use ASP.NET to ease access to data

• Current POS System food database hard to maintain and requires a restart between changes

• Develop a new POS System that solves these problems

Tables Used

• All tables are in 3NF

• Kitchen Tickets Table – tick#, svrid, ourcost, salecost, food id, date sold

• Employee Tickets Table – tick#, svrid, tableid, date, description

• Clock Table – svrid, clock in time, clock out time

• Inventory – pizza id, quantity

Employee Functions

• Clock In/Clock Out

• View timesheet

• Open a new ticket

• Sell pizza

• Close ticket

• Open closed ticket

Manager Functions

• Obtain quantity, profit, and sales information remotely

• View employees currently working

• View inventory

• Update inventory

Technology Used

• C#, PHP, Perl, VB.NET

• ASP.NET Calendar control

• ASP.NET DataView, DataTable

• WML

• Login ties directly into Clemson network

• Web Service – SOAP, PHP, Perl

Login

Netware

Authentication

Hogwarts Web Space

Client

Web Service

Hogwarts Webservice

Dirty Network PHP/Perl SOAP client Client

MS Sql Server

Future Work

• Increase WML functionality

• Increase Efficiency

• POS system will determine what supplies kitchen needs

• Add a drop down list of login names

Conclusions

Spend more time seeing what is available before trying solution

I learned a lot of SQL, WML, SOAP, PHP, C#, VB.NET, WebServices