Project Report On
Online Sales Order Management System
Submitted Submitted By :By :--Patel Chinmay P.(060) Patel Chinmay P.(060) Gandhi Himil M.(022) Gandhi Himil M.(022) Guided by :-Savan. K.Patel Submitted to
:-ACHARYA MOTIBHAI PATEL INSTITUTE OF COMPUTER STUDIES, ( CONSTITUENT COLLEGE OF GANPAT UNIVERSITY)
GANPAT VIDYA NAGAR,KHERVA-38271 2011-2012
BCA –SEM:-VI MARCH-APRIL 2012
Online Sales Order Management System
For Riwasa Tiles
PROJECT PROFILE
Project title :- Online Sales Order Management System Develop For :- RiwasaTiles Pvt.Ltd
Develop At :- AMPICS
Front-End Visual Basic 2005
Back-End Microsoft Office 2003
Develop By:- Patel Chinmay P.
Gandhi Himil M. Project Guide :- Patel Ketan P. Project Coordinator :- Patel Savan K.
NAME OF NAME OF COMPANNY COMPANNY
RIWASA TILES PVT.LTD (ORACLE GRANITO)
ADDRESS ADDRESS
CONTACT
CONTACT NO NO
Riwasa tiles pvt.ltd (Oracle granito) Sabar Dairy-Talod Road,Gadhoda, Himatnagar-383001.(Gujarat-India) Office:- (02772-239931) DATE OF DATE OF ESTABLISHED ESTABLISHED 6/6/2011 OWNER
OWNER Patel Harshadbhai. D, Patel Manilal .P,
Patel Devchandbhai .M
EMPLOYEE
EMPLOYEE 446 Employee in different department
PRODUCT PRODUCT
INFORMATION INFORMATION
Micro Polish Double Vitrified Tiles ABOUT COMPANY
EXISTING SYSTEM
In the existing system the company give information about product in the newspapers and printed catalog.
Customer come personaly and select the product and make payment.
If product is not available then the customer give order prior with some advance payment.
NEED FOR NEW SYSTEM
Future Old
System
New System Get Online Sales Order No Yes
Easy Marketing No Yes
Online Product Information
No Yes
Online Tiles Calculator No Yes
Hardware Pentium IV Processor 1 GB RAM SERVER-SIDE Software Windows 2003 server .NET 2.0 Runtime Crystal Report 10.2.3600 Ms Access 2007 CLIENT-SIDE Software Windows 7
Internet Explorer 5.0 or above
Hardware
Celeron or above Processor 64 MB RAM
HARDWARE & SOFTWARE
REQUIREMENT
SYSTEM FLOW CHART FOR
ADMIN
Start Username -Password Login Add, Update, Products Add, Update, Delete Products View Feedback Check Order Details Stop ADMIN No Yes Generate Generate Report
SYSTEM FLOW CHART FOR
USER
Start Username -Password Username -Password Login USER View Product Details View Product Details Calculate tiles Give Order Product Configuration Product Configuration Create Registration Create Registration View Status Stop YES NO Feedback
0.0 ONLINE SALES ORDER MANAGEMET SYSTEM ADMIN
Context level DFD For Online
Sales Order Management
System
Manage pro. info View pro. info
Request/Order of Product info
FIRST LEVEL DFD
FOR ADMIN
Admin
Report info REPORT6.0
5.0 FEED-BACK 4.0 ORDER DETAIL 2.0 MANAGE PRODUCT 1.0 LOGIN PROCESS Report Feedback info Feedback info
Order info Order info
Product info Product info Request for Login
Invalid
Check Id /pass
Valid /Invalid
Login
Update product info Update product info
PRODUCT_MST ORDER_MST FEEDBACK_MST REPORT LOGIN_MST 3.0 USER DETAIL REGISTRATION _MST Registration. info Registration. info Response Feedback Response Feedback
FIRST LEVEL DFD
FOR USER
USER 4.0 ORDER 3.0 VIEW PRODUCT
Product info Product info
Response product info
PRODUCT_MST Response product info Product info Product info 1.0 REGI-STRATION REGISTRATION _MST 2.0 LOGIN
Registration info Registration info
ID/Password
ORDER_MST Order info
Product Order info
response Feedback info 5.0 FEED-BACK
Feedback info
FEEDBACK_MST Id/Password
DATA DICTIONARY
LOGIN_MST
USER_MST
PRODUCT_MST
ORDER_MST
FEEDBACK_MST
USER_FEEDBACK
Field Data Type Size Description Constrain
User Name Text 12 User Name Primary Key Password Text 8 Password Not Null
Field Data Type Size Description Constrain
User_Id Number 8 User Id Primary Key Name Text 25 User Name Not Null Office_Name Text 25 User Office Name Not Null Address Text 50 User Address Not Null City Text 15 User City Not Null Pincode_No Number 6 Pincode No Not Null Contact_No Number 10 Contact No Not Null Email_Id Text 25 User Email Id Not Null Date Date/Time - User Date/Time Not Null
Field Data Type Size Description Constrain
Product_Id Number 8 Product Id Primary Key Product_Name Text 25 Product Name Not Null Series Text 10 Product Series Not Null Size Text 8 Product Size Not Null Rate Number 5 Product Rate Not Null Image Uploaded Text 200 Image Uploaded Not Null
Table :: Order_MST
Field Data Type Size Description Constrain
Order_Id Number 8 Product Id Primary Key User_Id Number 8 User_Id Not Null Billing_Address Text 50 Billing Address Not Null Series Text 20 Series Not Null Product_Name Text 8 Product Name Not Null Order_Type Text 12 Order Type Not Null Quantity Number 6 Product Quantity Not Null Date Date/Time - Date/Time Not Null
Field Data Type Size Description Constrain
User_FeedBack Number 8 FeedBack Id Primary Key
Name Text 20 Name Not Null
Address Text 40 Address Not Null FeedBack Text 8 FeedBack Of User Not Null Date Date/Time - Date/Time Not Null
Field Data Type Size Description Constrain
FeedBack_Id Number 8 FeedBack Id Primary Key FeedBack Text 8 FeedBack Of User Not Null Order_Id Number 10 Order_Id Not Null Date Date/Time - Date/Time Not Null
M 1 M MANAGE ADD VIEW 1 M MANAGE REGIST-RATION USER ADMIN PRODUCT M 1 HAVE 1 1 ORDER M M GIVE 1 M FEEDBACK GIVE 1 M M USER-NAME PASS-WORD USER-ID EMAIL-ID USER-NAME
Brief Description of
Process
PROCESS DESCRIPTION
There Are Tow Process Work By System
1.ADMIN
2.USER
ADMIN PROCESS
Admin First Login And Has The Right To Handle
The Entire System.
Admin Can Add, Update And Delete Products.
Admin Can Check Order Details.
Admin Can View FeedBack.
USER PROCESS
User View The Product Details.
User can Get The Products Configuration.
User Now Give The FeedBack.
User can Calculate The Tiles.
User Need To Login.
If A User Is Not Register Then He Has To First Get
Register.
If He Is A Already User Provide User Name Password
And Get Login.
User can now give order.
Step1: - Admin Login The Application If User
Name And Password Is Correct Then Go to Step 2
Else If Not Then Re enter UserName And Password.
Step2:-Add, Update and Delete Products,
Check Order Details, View FeedBack.
Step3:-Create Report Of Order.
Step4:-Stop
USER PROCESS
Step1
:-User View The Product Details And Get
The Product Configuration.
Step2
:- User Can View The FeedBack.
Step3
:-User Will Calculate Tiles.
Step4
:-To Give Order User need To Login.
Step5
:-If A User Is New User Then It Has To Be
Register It Self.
Step6
:-Give The UserName And Password To
Step7
:-User Can Give Order.
Step8
:-User Can View Order Status .
TESTING
We have use following method for testing the system.
Specification Testing:->
- The specification testing is what program does in some various condition is.
- we check this system to give wrong userneme,password,wrong data then system display message for input correct data.
Code Testing:->
- The code testing is examining the logic of program.
- we have testing all path of program, path means to specific combination of condition that handle by program.
- when the any User give order that check correct id,password & User number etc.
Unit Testing
:-- unit testing is focused on verifying small portion of functionality. Unit testing is important part where each module and process of application is to be test by possible input sets and desired output. - we have check different type of modules like admin module, User module etc.
POST IMPLEMENTATION REVIEW
After the system is implemented and conversation iscomplete, a review of system is usually conducted by users, this is called post implementation.
the most fundamental concern post implementation review is determining whether the system has met its objectives; that is analyst want to know if the performance level of user has
improved and if the system is producing the result intended. If neither is happening, one may question whether the system can be considered successful.
In future Payment Gateway can be use for the transaction related to the Order of the Products.
We will think to make this web application more interactive in design.
In future we can try to implement the advertisement also can be implemented in the web page.
BIBLIOGRAPHY
NAME AUTHORE
> ASP. NET UNLEASED Stephan Wither >Professional ASP.NET WROX Publication >ASP.NET Black Book Dreamtech Publication
>These books acted as our tutor during the system development
>We had been used the reference of the following websites.
I. http://www.asiangranito.com II. http://www.w3schools.com