Point of Sale System With Remote Capabilities by

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 3 NF • 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 Data. View, Data. Table • WML • Login ties directly into Clemson network • Web Service – SOAP, PHP, Perl

Login Netware Authentication Hogwarts Client Web Space

Web Service Hogwarts Webservice Dirty Network PHP/Perl SOAP client MS Sql Server Client

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, Web. Services