“Plan-B Web Hosting Reselling Services
Panel”
A PROJECT REPORT
Submitted by
RATHOD BIPIN J (110160116085)
&
SHAH UMESH L (110160116044)
In fulfillment for the award of the degree
of
BACHELOR OF ENGINEERING
in
GOVERNMENT ENGINEERING COLLEGE, MODASA
Gujarat Technological University, Ahmedabad
December, 2014
Government Engineering College, Modasa
Information Technology
2014
CERTIFICATE
Date: 17/10/2014 This is to certify that the dissertation entitled “PLAN-B WEB HOSTING RESELLING SERVICES PANEL” has been carried out by RATHOD BIPIN J & SHAH UMESH L under my guidance in fulfillment of the degree of Bachelor of Engineering in Information Technology (7th Semester) of Gujarat Technological University, Ahmedabad during the academic year 2014-15.
Guides:
ACKNOWLEDGEMENT
I am Very grateful to my project Guide Mr. Janak Suthar for giving his valuable time and constructive guidance in preparing the project in short period of time without his kind encouragement and valuable guidance.
I would like to take this opportunity to thank my college, Government Engineering College, Modasa to give me this tremendous opportunity to work in the industry for the real time project. I am grateful to all the staff of the Computer Department of our college, and especially to Mr. J S Dhobi, H.O.D of the CE/IT
Department to provide required information and help whenever necessary.
I sincerely thank Mr. J S Dhobi for granting permission and providing all the necessary resources to develop a project.
I heartily thank the project Leader Mr. Chetan Kapadiya who was always there to guide us through the development of the project. We immediately appreciate the tips he has constantly given us during the project be it technology or communication. He is one of major sources behind the success of the project.
Bipin Rathod Umesh Shah
ABSTRACT
Plan-B Web hosting Reselling services panel is when a company
utilizes the resources of a parent web hosting company and sells it as their own.
Most web hosting companies have reseller packages available. There are those
who can benefit from choosing to host their site with a reseller. There are also
those who have been dissatisfied with their reseller host and those who may be
interested in opening their own reseller hosting account. Web Hosting Reseller
refers to an arrangement in which you purchase web hosting services at a
wholesale price and resell those services to customers of your own. As a
reseller, you are essentially playing the middle man by helping the parent
company sell their solutions. On the plus side, you have the opportunity to start
a legitimate online business and generate a consistent stream of income.
Although reseller hosting is primarily used to provide web hosting plans to
others, it can be used for much more than reselling.
LIST OF TABLES
Table No Table Description Page No
Table 5.1 Registration Table 5.2 Login master Table 5.2 Super admin Table 5.2 Feedback Table 5.2 Platform Table 5.2 Category Table 5.2 Plan master Table 5.2 Plan description Table 5.2 Commission master Table 5.2 Employee registration Table 5.2 Offer master
Table 5.2 News master Table 5.2 Payment gateway Table 5.2 Support master Table 5.2 Submit ticket Table 5.2 Billing cycle Table 5.2 Cart master Table 5.2 Order master Table 5.2 Payment status Table 5.2 Download master Table 5.2 Knowledgebase master Table 5.2 Hosting service detail Table 5.2 Mailing detail master
Figure No Figure Description Page No
Figure 5.1 Flow chart
Figure 5.2 Use case diagram Figure 5.2 Activity diagram Figure 5.2 Class diagram Figure 5.2 Sequence diagram
Figure 5.2 Data flow Diagram Level 0 Figure 5.2 Data flow Diagram Level 1 Figure 5.2 Data flow Diagram Level 2 Figure 5.2 E-R Diagram
LIST OF SYMBOLS, ABBREVIATIONS, AND NOMENCLATURE
SYMBOLE
OPERATION
Binary Association Association class Generalization Initial state Final State Flow Action state Decision Join
Object Lifeline Activation, massage call Actor Use case Uses State Tranjection
Double Tranjection
ABBREVATIONS
TERM DEFINATION
HTML -Hyper Text Mark-up Language WWW -World Wide Web
SQL -SQL(Structured Query Language) Server Management Studio Express (SQL Server 2005)
WIMS -Web Inventory Management System LAN -Local Area Network
OS -Operating System GUI -Graphical User Interface RAM -Random Access Memory
MB -Mega Bytes
GB -Giga Bytes
Mbps -Mega bits per second HDD -Hard Disk Drive
TABLE OF CONTENT
Acknowledgement I
Abstract II
List of Figures III
List of Abbreviations V
List of Contents VI
Chapter : 1 Introduction to Project 1.1 Project Summary 1.2 Purpose
1.3 Scope
Chapter : 2 Brief History of the work
2.1 Software Requirement Tools 2.2 Hardware Requirement Tools Chapter : 3 Literature Survey
3.1 Microsoft’s .Net Framework and ASP .Net 4.0 3.2 Microsoft SQL 2008
Chapter : 4 Working / Implementation of the project work / simulation
4.1 Flow Diagram 4.2 Use case Diagram 4.3 Activity Diagram 4.4 Class Diagram 4.5 Sequence Diagram 4.6 Data Flow Diagram 4.7 E-R Diagram 4.8 Data Dictionary Chapter : 5 Result Analysis
5.1 Chapter : 6 Conclusion List of References
CHAPTER 1
Introduction to Project
Project Summary
A designer might use it to offer their clients space for a website as an additional service. Following are some of the advantages that make it such a highly sought Hassle-free Hosting, Extensive Management Capabilities, Easy Upgrades etc.. Web hosting comes in many different flavors, but one of its most unique variations is reseller hosting. Reseller hosting is the type of hosting plan where you purchase an account and are provided with a certain amount of disk space and bandwidth which can be sold to other people. It essentially gives you a way to purchase bulk amounts of server capacity and then sell hosting packages
to your own customers. Reseller accounts offer a means for average people to break into the industry and earn money from the hosting business.
Purpose
The overall advantage of system is empowering by decreasing the latency that arises while operating through the manual process. The system acts as information for User and Admin. It acts as a bridge of communication between the user, guest and administration. Generating the required reports as per the requirements becomes much easier and information availability at the hand. Feasibility study is an important phase in the software development process. It enables the developer to have an assessment of the product being developed. It refers to the feasibility study of the hosting plan in the terms of outcomes of the different plans, operational use and technical supported required for implementing it.
Scope
The application is also security oriented and gets associated with in the system, as the general structure of accessibility is fairly demandable. By applying this, we can get much faster and accurate results from World Wide Web as per the user requirements. By this system, user could solve his problem by getting the advice from the experts of web hosting portal. Hosting reselling business one thing about a web hosting reselling services panel is that the market is a bit satur
Chapter 2
Brief History of the work
Software Requirement Tools
Client Side Requirement :
Web Browser : Internet Explorer 9.0 or Any compatible browser
Operating System : Windows XP or above Server Side Requirement :
Front End : PHP 5.0 Back End : My SQL 5.5.8 Web server : IIS 6.0
Hardware Requirement Tools
Client Side Requirement :
Processor : Minimum Pentium IV Hard Disk : Minimum 40 GB RAM : Minimum 256 MB
Server Side Requirement : Processor : Pentium IV Hard Disk : Minimum 80 GB RAM : Minimum 512MB
Existing System
In existing system there wasn’t advance search option about particular platform , design ,language.
In existing system, the website create by only based on given requirement. The website the work is based on point
User Can’t see multiple watch in existing System
In existing system there weren’t large no of bonus option and good offers
Current System
In new system user can search the web templates of their choice at anywhere and anytime and get the full information about material
This system the work & payment based on percentage(%) User can see multiple watch in current system
New system can provides
Many bonus option and good offers
Advantages
New System provides all the option related to order project.
There are many types of better security & policy to upload product than System
o New system can provides bonus option and good offers
Chapter 3
Literature Survey
Microsoft's .Net Framework and ASP.NET 4.0
The .NET Framework is a new computing platform that simplifies application development in the highly distributed environment of the Internet. The .NET Framework is designed to fulfill the following objectives:
To provide a consistent object-oriented programming environment whether object code is stored and executed locally, executed locally but Internet-distributed, or executed remotely.
To provide a code-execution environment that minimizes software deployment and versioning conflicts.
To provide a code-execution environment that guarantees safe execution of code, including code created by an unknown or semi-trusted third party.
To provide a code-execution environment that eliminates the performance problems of scripted or interpreted environments.
To make the developer experience consistent across widely varying types of applications, such as Windows-based applications and Web-based applications.
The .NET Framework has two main components: the common language runtime and the .NET Framework class library. The common language runtime is the foundation of the .NET Framework. You can think of the runtime as an agent that manages code at execution time, providing core services such as memory management, thread management, and remoting , while also enforcing strict type safety and other forms of code accuracy that ensure security and robustness. Code that targets the runtime is known as managed code, while code that does not target the runtime is known as unmanaged code. The class library, the other main component of the .NET Framework, is a comprehensive, object-oriented collection of reusable types that you can use to develop applications ranging from traditional command-line or graphical user interface (GUI) applications to applications based on the latest innovations provided by ASP.NET, such as Web Forms and XML Web services.
Microsoft SQL SERVER 2008
Overview:
SQL Server for windows XP provide relational database power to give the information need to make better decisions. It integrates data from the different columns and rows created in a particular table. SQL Server allows generating, analyzing and creating the tables without hours of work.
Features:
Tables and Queries: SQL provides very easy was to create a table and even laymen can do it without much trouble. Also query facility provides powerful way of getting the required information.
Database Utilities: We can reduce the redundancy of the data using the extensive database facilities. The ADODB object allows the database
to be used at the run time. Password project it also provides password mechanism to the database so that it can’t be opened directly. Data handling is done very nicely as there are many options like create, update, delete.
System Integration :
SQL Server 2000 works with other products to form a stable and secure data store for Internet and intranet systems:
SQL Server 2000 works with Windows 2000 Server and Windows NT Server security
and encryption facilities to implement secure data storage.
SQL Server 2000 forms a high-performance data storage service for Web applications
running under Microsoft Internet Information Services.
SQL Server 2000 can be used with Site Server to build and maintain large,
sophisticated e commerce Web sites.
Literature Review
I refer the many online shopping sites like flipcart, quicker , snap deal ,………etc & take many contents from there.
Chapter 4
Working / Implementation of the Project Work / Simulation
Flow Chart
Data Flow Diagram Level 1
DATA Dictonary
1) Registration
:-•
Table Name : Registration
•
Primary Key : r_id
•
Description :
This table is used for registration.
No Field name Data type Size Constrain Description 1 User_Id Numeric - Primary key Unique id
for table 2 F_name Varchar 50 Not null User First
name 3 L_name Varchar 50 Not null User Last
name 4 Co_name Varchar 50 Not null Company
name 5 EMAIL Varchar 50 Not null Email
address of user 6 Address1 Varchar 250 Not null Address of
user 7 Address2 Varchar 250 Not null Address of
user 8 City Varchar 50 Not null City of user 9 State_region Varchar 50 Not null State region 10 Z_code Numeric Not null Zip code 11 Country Varchar 50 Not null Country of
user 12 P_no Numeric 20 Not null Phone
number 13 CreateDate DateTime 30 Not null Date and
time
2) Login Master
:-•
Table Name : Login
•
Primary Key : User_id
•
Description :
This table is used for registration.
No Field name Data type Size Constrain Description 1 User_Id Numeric - Primary key Unique id
for table 2 Password Varchar 50 Not null User
Password 3 Last login date Datetime 30 Not null Date and
time 4 Verification code Varchar 50 Not null Verification
5 Status Varchar 50 Not null Status of login
3)
SuperAdmin:-•
Table Name : Super_admin
•
Primary Key : s_id
•
Description :
This table is used for super admin.
No Field name Data type Size Constrain Description 1 S_id Numeric - Primary key Unique id
for table 2 S_Username Varchar 50 Not null Super admin
username 3 S_Pswrd Varchar 50 Not null Super admin
password 4 S_last login date Datetime 30 Not null Super admin
last login date
4)
Feedback:-•
Table Name :Feedback
•
Primary Key : F_id
•
Description
:This table is used to describe the feedback which is given by the users.No Field name Data type Size Constrain Description 1 F_id Numeric - Primary key Unique id
for table 2 User_Id Numeric - Foreign key User id 3 Message varchar 200 Not null Message of
feedback 4 DT DateTime 30 Not null Date and
time
:-•
Table Name :platform
•
Primary Key : P_id
•
Description :
This table is used for selecting
platform .
No Field name Data type Size Constrain Description 1 P_id Numeric - Primary key Unique id
for table 2 Platform Varchar 50 Not null Platform 3 Description varchar 250 Not null Description
about platform
6) Category
:-•
Table Name :category
•
Primary Key : C_id
•
Description :
This table is used for category .
No Field name Data type Size Constrain Description 1 C_id Numeric - Primary key Unique id
for table 2 P_id Numeric - Foreign key Platform id 3 Category varchar 100 Not null Category of platform
7)
Plan_master:-•
Table Name :plan_master
•
Primary Key : pl_id
No Field name Data type Size Constrain Description 1 Pl_id Numeric - Primary key Unique id
for table 2 C_id Numeric - Foreign key Category
id 3 Plan Varchar 50 Not null Description
of plan
8)
Plan_Description:-•
Table Name :Plan_Description
•
Primary Key : pd_id
•
Description :
This table is used for description of
planning .
No Field name Data type Size Constrain Description 1 Pd_id Numeric - Primary key Unique id
for table 2 Pl_id Numeric - Foreign key Plan id 3 Nor_description varchar 250 Not null Normal
description 4 Controlpanel varchar 250 Not null Control
panel 5 E_feature Varchar 250 Not null Email feature 6 Web_scripting Varchar 250 Not null Web
scripting 7 Database_feature Varchar 250 Not null Feature of
database 8 Logs_feature Varchar 250 Not null Logs feature
9)
Commission_master:-•
Table Name :Commission_master
•
Primary Key : C_id
•
Description :
This table is used for commission.
No Field name Data type Size Constrain Description 1 C_id Numeric - Primary key Unique id
for table 2 User_id Numeric - Foreign key User id 3 Commission Numeric - Not null Description
of commission
10)
Employee_Registration:-•
Table Name : Employee_registration
•
Primary Key : E_id
•
Description :
This table is used for employee
regisration .
No Field name Data type Size Constrain Description 1 E_id Numeric - Primary key Unique id
for table 2 F_name Varchar 50 Not null First name of
employee 3 L_name Varchar 50 Not null Last name of
employee 4 User_id Numeric - Foreign key User id 5 Pswrd Varchar 50 Not null Password of
employee
11)
Offer_Master:-•
Table Name :offer_master
•
Primary Key : o_id
•
Description :
This table is used for offer.
No Field name Data type Size Constrain Description 1 O_id Numeric - Primary key Unique id
for table 2 Pl_id Numeric - Foreign key Plan id 3 Offer_description Varchar 250 Not null Description
of plan 4 C_date Datetime - Not null Create date
12)
News_master:-•
Table Name :News_master
•
Primary Key : N_id
•
Description :
This table is used for news .
No Field name Data type Size Constrain Description 1 N_id Numeric - Primary key Unique id
for table 2 N_title Varchar 50 Not null News title 3 News Varchar 250 Not null News 4 C_date Datetime 30 Not null Create date
13)
Paymen_Gateway:-•
Table Name :payment_gateway
•
Primary Key : pg_id
•
Description :
This table is used for payment
gateway
No Field name Data type Size Constrain Description 1 Pg_id Numeric - Primary key Unique id
for table 2 Pg Varchar 100 Not null Payment gateway 3 Pg_discription Varchar 250 Not null Payment gateway description 4 C_date Datetime 30 Not null Create date
14)
Support_master:-•
Table Name :Support_master
•
Primary Key : S_id
•
Description :
This table is used for support .
No Field name Data type Size Constrain Description 1 S_id Numeric - Primary key Unique id
for table 2 S_title Varchar 50 Not null Support title
15)
Submit_ticket:-•
Table Name :Submit_ticket
•
Primary Key : st_id
•
Description :
This table is used for submit ticket.
No Field name Data type Size Constrain Description 1 St_id Numeric - Primary key Unique id
for table 2 S_id Numeric - Foreign key Department
id 3 User-id Numeric - Foreign key User id 4 Subject Varchar 150 Not null
5 Urgency Varchar 150 Not null
6 Related services Varchar 200 Not null Description of related
services 7 Message Varchar 250 Not null Message 8 St_Attachments Varchar 150 Not null Submit
ticket attachment 9 C_date Datetime 30 Not null Create date
16)
Biling_cycle:-•
Table Name :Biling_cycle
•
Primary Key : BC_id
•
Description :
This table is used for biling cycle .
No Field name Data type Size Constrain Description 1 BC_id Numeric - Primary key Unique id
for table 2 BC_title Varchar 50 Not null Billing cycle
title 3 Price Numeric - Not null Price in
percentage per year
17)
Cart_master:-•
Table Name :Cart_master
•
Primary Key : C_id
•
Description :
This table is used for cart.
No Field name Data type Size Constrain Description 1 C_id Numeric - Primary key Unique id
for table 2 Pl_id Numeric - Foreign key Plan id 3 User_id Numeric - Foreign key User id 4 Domain_name Varchar 150 Not null Domain name 5 BC_id Numeric - Foreign key Biling cycle 6 Other_services Varchar 250 Not null Description
of other services 7 C_date Datetime 30 Not null Create date
Order_master:-•
Table Name :Order_master
•
Primary Key : o_id
•
Description :
This table is used for order master.
No Field name Data type Size Constrain Description 1 O_id Numeric - Primary key Unique id
for table 2 Invoice_no Varchar Char(8) Not null Generate invoice no 3 User_id Numeric - Foreign key User id 4 Pl_id Numeric - Foreign key Plan id 5 Domain_name Varchar 150 Not null Domain
name 6 BC_id Numeric - Foreign key Biling cycle
id 7 Other_services Varchar 250 Not null Description
of other services 8 C_date Datetime 30 Not null Create date
19)
Payment_status:-•
Table Name :payment_status
•
Primary Key : ps_id
No Field name Data type Size Constrain Description 1 Ps_id Numeric - Primary key Unique id
for table 2 Invoice_no Varchar Char(8) Not null Generate invoice no 3 Pg_id Numeric - Foreign key Payment
gateway id 4 Total_amount Numeric - Not null Total amount 5 Total_item Varchar 50 Not null Total iteam 6 Transaction_date Numeric - Not null Date of
transaction 7 Invoice_status Varchar 50 Not null Description Invoice
status 8 C_date Datetime 30 Not null Create date
20)
Download_master:-•
Table Name :Dowmload_master
•
Primary Key : D_id
•
Description :
This table is used for download
processing .
No Field name Data type Size Constrain Description 1 D_id Numeric - Primary key Unique id
for table 2 Fle_title Varchar 50 Not null File title 3 Attach_file Varchar 250 Not null Attachment
of file 4 C_date Datetime 30 Not null Create date
21)
Knowledgebase_master:-•
Table Name :knowledgebase_master
•
Primary Key : KB_id
•
Description :
This table is used for knowledgebse .
No Field name Data type Size Constrain Description 1 KB_id Numeric - Primary key Unique id
for table 2 Topic_title Varchar 50 Not null Title of topic 3 Topic_sol Varchar 250 Not null Topic
solution 4 Attachments Numeric - Not null Attachments 5 C_date Datetime 30 Not null Create date
22)
Hosting_service_detail:-•
Table Name :Hosting_service_detail
•
Primary Key : HS_id
•
Description :
This table is used for hosting services .
No Field name Data type Size Constrain Description 1 HS_id Numeric - Primary key Unique id
2 User_id Numeric - Foreign key User id 3 Pl_id Numeric - Foreign key Plan id 4 Next_due_date Numeric - Not null Next due
date 5 Domain_name Varchar 150 Not null Domain
name
23)
Mailing_detail:-•
Table Name :Mailing_detail
•
Primary Key : M_id
•
Description :
This table is used for mailing detail .
No Field name Data type Size Constrain Description 1 M_id Numeric - Primary key Unique id
for table 2 User_id Numeric - Foreign key User id 3 Message_subject Varchar 150 Not null Message
subject 4 Message_body Varchar 250 Not null Body of
message 5 C_date Datetime 30 Not null Create date
CHAPTER 5
Result Analysis
In future enhancement we are going to develop android application… This android application will provide the facility of selling and purchasing In Future developers can add more templates and design facilities for blogs
In Future developers can add the facility to purchase Domain & group chatting in forum
Helpful to perform paperless work and manage all data. Provides easy, accurate, unambiguous and faster data access.
Chapter 6
Conclusion
System describes the overview of the whole work carried out at particular
organisation. There is no compulsion on physical presence of any person because it works online.
The main objective of the system is that an organizer could keep an eye on work performed in his absence. He gets the current status regarding all his work performed so that he could take decisions accordingly.
It maintains the records regarding the raw material available, how much quantity is in firing zone, how much is ready to dispatch & work performed by labourer along with its daily attendance. Bill form & particular order no. are being maintained. We could also update, delete the entry as our convenience
