ONLINE MULTI-LEVEL MARKETING SYSTEM PROJECT REPORT | ONLINE MULTI-LEVEL MARKETING SYSTEM

Project Overview

This project entitled as "MULTI-LEVEL MARKETING SYSTEM" is a Multi Level Marketing (MLM) is a business model or marketing strategy in which the distributors' income includes their own sales, and a percentage of the sales group they recruit, which is commonly known as their 'downline'.

INTRODUCTION

If we talk about multi-level marketing the first question which strikes in our mind is what is actually the Multilevel Marketing? Multilevel Marketing is nothing but types of marketing which needs the joining of new member as much as the new members join this MLM business more the company gets profit and more the member get benefit from it.

MLM is improved version of traditional marketing. It takes out the people from the traditional marketing and chain and provide cheap (in term of cost) product to the consumer. For example if any product manufactured by the manufacturer and then goes to stockiest after that to the dealer their after retailer and finally comes to consumer. Due to all this chain the cost of the product increase very much.

After the introduction of MLM people between manufacturers and consumers are taken off and with the month advertisement the products are consumed by the customer. Along with that they can earn some money. Since the MLM company provides some commission against it.

Due to so many members in MLM Company it is not easy to keep record of all those people manually by the company so they are compassing of good software which keep all record about member, this joins his up liner his down lines etc. The software develops by us in the best one which full fill their entire requirement.

OBJECTIVE

The objective of the software is that the software has following qualities:

ü Faster retrieval of information the ability in conducting complex searches.

ü To provide a user friendly that the person who have basic knowledge about the computer can run the software.

ü To provide a simple interface or step by step queries passing.

ü To facilitate in better utilization of executive time by focusing on main issue rather than actual processing.

ü To generate various reports regarding to selected Agent, Registration, stock etc.

ü To be able to get the detail of various Agents, Items, Commission etc.

ü To provide a security mechanism to secure the data from unauthorized access.

PROJECT CATEGORY

RELATION DATABASE MANAGEMENT SYSTEM

When we design software and store information into a system, we need a database to manage the stored data, for this purpose we use Relation database management system. The relation data model are use to define a ‘Relationship’ in the data to be represented in the database.

Data structure that show the relationship among entities, are useful for graphically determining how data can be organized. Relation data base management system is the physical repository of data. We use relation data base management system for bulk amount record. Relation database consist of collection, each of which assigned a unique name. A relation data base management contains row (Record) and column (Field). Relation data base management system must maintain data integrity that is relation data base need to insure that if data in multiple table is updated, all of the updated take place every RDBMS provide some sort of security for the database that is managed. Most RDBMS strive to maintain separation between the actual data and the business logic, which ensure that the data in the database maintained in a constant state.

TOOLS & PLATFORM

ASP.NET 2008(C#)

ASP.NET is Microsoft’s new version of ASP for the managed environment. ASP.NET brings about significant changes from its predecessor, most notably by supporting strongly typed and precompiled languages such as C# and VB. With ASP.NET you can also design web application GUIs using the drag-and-drop form design approach that made Visual Basic popular. ASP.NET is a server-side technology that requires the installation of Microsoft Internet Information Server (IIS).

With .NET, Microsoft has completely redesigned ASP to address its limitations. To accomplish this task, backwards-compatibility with ASP had to be sacrificed. As we will see, migrating ASP scripts to the managed environment is not always a straightforward task. Since ASP is in such wide use, however, Microsoft ensured that ASP scripts execute without modification on a machine with the .NET Framework (the ASP engine, ASP.DLL, is not modified when installing the .NET Framework). Thus, IIS can house both ASP and ASP.NET scripts on the same machine.

Some features of ASP.NET are as follows:-

· Separation of code from content.

· Support for compiled languages

· Greater support for different browsers via server-side

· Intuitive GUI design.

MICROSOFT SQL SERVER 2005

Microsoft SQL SERVER 2000 is a full featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. SQL server include the complete set of administrative and development tools. SQL server2000 also support standards based programming model making the use of SQL database and data warehouse a seamless part of building powerful system. These features enable us to rapidly SQL server application that can be implemented with a minimum of installation and administrative overhead.

SQL server 2005 programming model is integrated with window architecture web application development, SQL support English based query and Microsoft search service to allow for user friendly queries and powerful search capability in web application. There are more frequently used tools:-

v Enterprise Manager

v Query Analyzer

v SQL Profiler

v Service Manager.

v Data Transformation Services

v Features of SQL Server

v XML support.

v Federated database server.

REQUIREMENT SPECIFICATIONS

WEB SERVER SOFTWARE REQUIREMENTS

Following Web server software are required for this application:

ü Windows Server 2008 Editions

ü Windows Internet Information Services (IIS) 7.0, running in IIS 7.0 worker process isolation mode

ü Microsoft ASP.NET version 3.5

DATABASE REQUIREMENTS

In addition to the operating system and Web server software, you must also have a database installed on your server (or on a separate server) to run it. The following database is supported:

ü Microsoft SQL Server 2005

WEB SEVER HARDWARE REQUIREMENTS

ü Processor : P3 (333MHz)

ü RAM : 128 MB Recommended

ü HDD : 20 GB (Min 10 MB Virtual Memory

Recommended)

ü Monitor : 17” CRT

ü Keyboard : 108 Key Normal Keyboard

ü Mouse : 3 Button Normal Mouse

ü Speaker : Normal Speaker

CLIENT SOFTWARE REQUIREMENTS

ü Windows Internet Explorer 6 or upgraded version / Mozilla Firefox.

ANALYSIS (DFD, ED, ER DIAGRAM)

DATA FLOW DAIGRAM:-

0- Level DFD

1- Level DFD

2- Level DFD

ENTITY DIAGRAM:-

ENTITY RELATIONSHIP DIAGRAM:-

MODULE AND THEIR DESCRIPTION

The project is divided in to three sub-modules. Which are:-

1. MEMBER MASTER-:

The member management deals with maintaining record of the member in the company. Company’s need is that each time a new member is joining the company the software should store the detailed record of the agent, automatically add the commission to its each parent level agent’s database. In the case he is joining the company directly, the software any old member, or otherwise

In case the new member joining the company directly, the software should make the parent member to the company and should not generate any commission. if and member has attached four child agents below his level, he cannot attach this new member below his level, he cannot attach fifth one to get a commission of 5%, either he can attach this new agent below, it’s any level child agent to get a commission of less than 5%and to increase number of child agent in his tree or he can attach this new agent by starting to construct a new tree of agent parallel to the first one.

2. PRODUCT MANAGEMENT-:

Product management system deal’s in maintaining the record of product in the company. Company should have record of each their item they are providing to the agent.

Company’s need is that each time a new agent is joining the company the software should ask for kit of predefined item or list of individual item to issue to new agent and automatically decrease the quantity of items from the table of stock (quantity) information. And if at any time the quantity of an item in stock becomes less than the reorder level software should automatically produce a message and make a record of that item separately.

3. VARIABLE MANAGEMENT

Variable management system deals in maintaining the record of variable like percentage of an agent, no of child agent in a tree to become a bronze/silver/gold/platinum agent, items and their quantity in a kit etc..Any time when the company wants to change the value of this variable it can be done here more easily.

Another sub module are used for intermediate transactions and to generate report or content of required tables where desired. Number of these sub modules is not defined exactly at this stage because they can very much more at the time of implementation of software according to requirement.

DATA STRUCTURE

Table: Agent_info

Field name Data type Size Key

Agent_id number 10 Primary

Agent-name varchar 15 ---

Paraller_id number 10 ---

Parent_id number 10 ---

Agent_add varchar 15 ---

Agent_ph_no number 10 ---

Agent_email_add varchar 25 ---

Date_of_joining date/time --- ---

Purchase_cost number 10 ---

Category varchar 15 ---

Table: Agent_payment

Field name Data type Size Key

Agent_id number 10 Primary

Agent_name varchar 15 ---

Payment number 10 ---

Data date/time --- ---

Table: Category_child

Field name Data type Size Key

Category_id number 10 Primary

Category_name varchar 15 ---

No_of_child varchar 15 ---

Table: Commission_register

Field name Data type Size Key

Agent_id number 10 Primary

Category varchar 15 ---

Total_salary number 10 ---

Commission number 10 ---

Date date/time --- ---

Table: Company_info

Field name Data type Size Key

Com_id number 10 Primary

Com_name varchar 15 ---

Com_add varchar 25 ---

Com_ph_no number 10 ---

Com_fax number 10 ---

Com_email varchar 25 ---

Table: Directory

Field name Data type Size Key

Name varchar 15 Primary

Phone_no number 10 ---

Table: Item_info

Field name Data type Size Key

Item_code number 10 Primary

Item_name varchar 15 ---

Item_price number 10 ---

Date_of_manu date/time --- ---

Date_of_exp date/time --- ---

Table: Kit_item

Field name Data type Size Key

Item_code number 10 Primary

Quantity number 10 ---

Table: Registration

Field name Data type Size Key

Agent_id number 10 Primary

Agent_name varchar 15 ---

Parent_id number 10 ---

Agent_add varchar 25 ---

Agent_ph_no number 10 ---

Agent_email_add varchar 25 ---

Date_of_joining date/time --- ---

Category varchar 15 ---

Table: Level_percentage

Field name Data type Size Key

Level_no number 10 Primary

Percentage number 10 ---

Table: Security

Field name Data type Size Key

Username varchar 15 Primary

Password varchar 15 ---

Table: Stock_info

Field name Data type Size Key

Item_code number 10 Primary

Unit_id number 10 ---

Item_qty varchar 15 ---

Item_recorder_qty varchar 15 ---

Date_of_curtrans date/time --- ---

Table: Transaction

Field name Data type Size Key

Item_code number 10 Primary

Agent_no number 10 ---

Unit_id number 10 ---

Item_qty varchar 15 ---

Date_of_trans date/time --- ---

Total_payment number 10 ---

Table: Unit-info

Field name Data type Size Key

Unit_id number 10 Primary

Unit_name varchar 15 ---

Table: Employee Register

Field name Data type Size Key

Employee_id number 10 Primary

Employee_name varchar 15 ---

Employee_address varchar 15 ---

Employee_ph_No number 10 ---

Designation_id number 10 ---

Date_of_joining date/time -- ---

Table: Leave

Field name Data type Size Key

Designation_id number 10 Primary

Leave_type varchar 15 ---

Leave_id number 10 ---

Max_leave number 10 ---

Table: Designation

Field name Data type Size Key

Unit_id number 10 Primary

Unit_name varchar 15 ---

Table: Deduction

Field name Data type Size Key

Designation_id number 10 Primary

Deduction_type varchar 15 ---

Percentage number 10 ---

Table: Allowance

Field name Data type Size Key

Designation_id number 10 Primary

Allowance_type varchar 15 ---

Percentage number 10 ---

PROCESS LOGIC OF EACH MODULE

The software produces a main menu that provides following five operations to the user.

Ø Primary setup

Ø General entries

Ø Report

Ø Utilities

Ø Help

PRIMARY SETUP

Primary setup contains information about entries that are fed

Only once. These covers-

1. Category information: -

Through this we maintain the category of the product.

2. Company information: -

Through this we maintain record of the company, which gives

The product to the supplier.

3. Unit information: -

Through this we maintain the unit record of the product.

4. Agent information: -

Through this we maintain record of the agent attached to

The company.

5. Item information:-

Through this we maintain the record of the item (product) that are given by the company to the agent.

GENERAL ENTRIES

1 Registration of agent: -

Through this from we maintain the record of the new agent who Join the company.

2 Stock Transactions: -

Through this from we maintain the record of the product, which is issue to the agent.

3 Level Percentages: -

Through this from we maintain the record of the level wise

Percentage commission given by company to its agent.

4 Commission register: -

This table is used to store the information of the amount of the commission of a particular agent.

5 Payment modes: -

This from is used to store the information of the payment mode to the agent. Related entries are made during time of payment.

Report:-

Report is generated to retrieve the desired information according to requirement. Following report is supposed during this stage of software development. In this stage we generate four type of report –

Ø Monthly Report

Ø Product wise Report

Ø Member Wise Report

Ø Final Report.

Utilities: -

This option provide following facilities to the user of the

Software

Ø Calculator

Ø Calendar

Ø User creation

Ø User Permission.

REPORT & QUERIES

Reports provide the most flexible way of viewing & printing information in your database. They enable you to display detailed information in almost any format. Reports take information from other object of your database & then organize that information according to your instructions.

Database is a combination of tables, queries, form & reports. So, queries are the medium to access selective information in the table or forms & finally generate a report i.e. output of query.

ID Wise Reports ->

v Agent Id wise detail

v Allowance Id wise detail

v Deduction Id detail

v Employee Id wise salary detail

Date Wise Reports ->

v Agent Date wise detail

v Commission date wise detail

v Date wise airline detail

v Date wise railway detail

v Date of supply wise vehicle parts detail.

SECURITY MECHANISM

System Security Measures:

Computer system security mechanism includes authentication access control flow control, auditing and cryptography.

Authentication:

The primary goal of authentication is to allow access to legitimate system users and to deny access to unauthorized parties. The two primary measures of authentication effectiveness are

The false acceptance rate, that is the percentage of illegitimate users erroneously admitted, and
The false rejection ratio. That is the percentage of legitimate users who are denied access due to failure of the authentication mechanism. Obviously the objective is to minimize both the false acceptance and the false rejection ratio. One way authentication is usually based on:
Possession of the secret (password)
Possession of an artifact.
Unique physiological or behavioral characteristics of the user but for my software, I have chosen the authentication based on password.

The password is the most common authentication mechanism based on sharing of the secret in a password based system each user has a password which may initially be assigned by the system or an administrator.

FUTURE SCOPE

Our software is made to survive the company only, if an agent wants to know the some information about the company he has to contact to company, but in future if we can move our software towards on-line system, the agent can also get the information; they need, from anywhere the area.

If we can move the software on-line a new agent can join the company from his own city without going to the company thus a wide area of network the company can cover

Our software is design to increase the company’s business, profitability, marketing of products, and interaction to the customers, and make customers enable to understand the company and the benefits he will get.

In future company can add their financial aspects this will help them to understand the company’s financial strength. Also company can open a help center where a customer can ask his queries and will get the solution also customer can give any kind of suggestion if he feels like it will help company to understand the customers attitude about the company or company’s working.

PROJECT REPORT

PROJECT TITLE

Introduction

If we talk about multi level marketing the first question which strikes in our mind is what is actually the Multilevel Marketing? Multilevel Marketing is nothing but types of marketing which needs the joining of new member as much as the new members join this MLM business more the company gets profit and more the member get benefit from it.

Objectives of Project

The objective of the software is that the software has following qualities:

ü Faster retrieval of information the ability in conducting complex searches.

ü To provide a user friendly that the person who have basic knowledge about the computer can run the software.

ü To provide a simple interface or step by step queries passing.

ü To facilitate in better utilization of executive time by focusing on main issue rather than actual processing.

ü To generate various reports regarding to select Agent, Registration, stock etc.

ü To be able to get the detail of various Agents, Items, Commission etc.

To provide a security mechanism to secure the data from unauthorized access.

System Analysis

1.1 Identification Of Need

The complete understanding of software requirements is essential to the success of a software development effort. The requirements analysis task is a process of discovery, refinement modeling and specification. The software scope initially established by the system engineer and refined during software project planning is refined in detail. Modular of the required data, information and control flow, and operational behavior are created. Alternative solution are analyzed and allocated to various software elements.

Both developer and customer take an active role in requirements analysis and specification. The customer attempts to reformulate a sometimes-nebulous concept of software function and performance into concrete detail. The developer acts as interrogator consultant and problem solver.

Requirements analysis is a software engineering task that bridges the gap between system level software allocation and software design.

Requirement analysis enabler the system engineer to specify software function and performance indicate software’s interface with other system elements and establish constraints that software must meet.

Software requirements analysis may be divided into five areas of effort:

(a) Problem recognition.

(b) Evaluation and synthesis

(c) Modeling

(d) Specification

(e) Review

Initially, the analyst studies the system specification and the software project plan. Problem evaluation and solution synthesis is the next major area of effort for analysis. Upon evaluating current problems and desired information (input and output) the analyst begins to synthesize one or more solutions.

During the evaluation and solution synthesis activity, the analyst creates models of the system in an effort to better understand data and control flow, functional processing and behavioral operation, and information content. The model serves as a foundation for software design and as the basis for the creation of a specification for the software.

1.2 Preliminary Investigation

With the existing system, the biggest problem was the low functionality. The problem faced hampered the work. For small tasks in advertising of a single product, there is lot of investments and the outcome of such an investment takes time because of the low functionality in terms of the development of the final promotional campaign associated with the product. In shopping, searching manually for a product in the market takes a lot of time

Feasibility Study

A) Technical Feasibility

As we know the technical feasibility is concerned with specifying equipment and software that will successfully satisfy the user requirement. The technical needs of the system may vary considerably, but might include:

· The facility to produce outputs of advertisements, shopping and mailing in a given time for ease of use.

· Response time under certain condition is minimal.

· Ability to process a certain volume of transaction at a particular speed.

· Facility to communicate data to distinct location.

In examining the technical feasibility, configuration of the system is given more importance than the actual make of hardware. The configuration should give the complete picture about the system’s requirements- how many workstations are required, how these units are interconnected so that they could operate and communicate smoothly.

B) Economic Feasibility

Economic analysis is the most frequently used technique for evaluating the effectiveness of the proposed system. More commonly known as cost/benefits analysis, the procedure is to determine the benefits and savings that are expected from the purposed system and compared with costs.

If benefits outweigh cost, a decision is taken to design and implement the system. Otherwise, further justification or alternative of the proposed system will have to be made if it has a chance of being approved. This is an ongoing effort that improves in accuracy at each phase of the system life cycle.

The analysis part also clears the doubt of economic problems which could be possible in developing the system. As already mentioned that the company has to just pay the developed software cost and not other investment is needed at the time of implementation of the new system as the preliminary requirements already exist in the company.

C) Operational Feasibility

Proposed projects are beneficial only if they can be turned into information system that will meet the operating requirements of the organization. This test of feasibility asks if the system will work when it developed and installed. Are there major barriers to implementation?

Some of the important questions that are useful to test the operational feasibility of a project are given below:

· Is there sufficient support for the project from the implementation? From user? If the present system is well liked and used to the extent that persons will not be able to see reasons for change, there may be resistance.

· Are current business methods acceptable to the user? If they are not, user may welcome a change that will bring about a more operational and useful system.

· Have the user been involved in the planning and development of the project? If they are involved at the earliest stage of project development, the chances of resistance can be possibly reduced.

· Will the proposed system cause harm? Will it produce poorer result in any case or area?

· Will the performance of staff member fall down after implementation? Issue that appears to be quite minor at the early stage can grow into major problem after implementation.

Therefore, it is always advisable to consider operational aspects carefully. The system is developed keeping in mind that it should be user friendly and easy to operate hence the system is operational feasible.

Software Engineering Paradigm applied

In this project, the spiral model is used for development. Spiral model has features of prototyping and linear sequential model. It helps to develop incremental versions of the software rapidly. Because software evolves as the process progresses, the developer and user better understand and react to risks at each evolutionary level. This is a very powerful model to develop large-scale system and software.

spiral2

This model is divided into a number of task regions. Each of the regions is populated by a set of work tasks called a task set that are done according to the requirement of the project to be developed. For small projects the number of tasks and their formality is low. Conversely, for large projects the reverse is true.

These task regions of spiral model are:

Customer communication:-

In this task region user is asked about his requirements from the system, through a dialog between developer and the user.

Planning:-

In this task region, resources, timelines and other project related information are considered and appropriate decision taken.

Risk analysis:-

In this region technical and management risks are identified and suitable measures taken wherever feasible.

Engineering:-

In this region one or more representations of application are built.

Construction and Release:-

In this region, application is constructed, tested, installed and user support is provided.

User evaluation:-

In this region, feedback is taken from the user about the overall performance of the application built during the engineering and implemented during installation stage.

The evolutionary process begins at the centre position and moves in a clockwise direction. Each traversal of the spiral typically results in a deliverable. For example, the first and second spiral traversals may result in the production of a product specification and a prototype, respectively. In this way a more stochastic version of the software is produced after some subsequent traversal.

A key difference between the spiral model and other software models is that risk analysis is performed in former and not in later.

Advantages of the Spiral Model

The spiral model is a very good approach to develop large-scale software because of its evolutionary approach to develop software. Besides this both user and developer can identify and remove the risks that can occur during the software development.
Prototyping is used to reduce the risk as it can be developed at any stage of the evolutionary level.
Due to its demand to consider technical risks at all stages, it reduces risks that may become a big problem in future.
Its combined iterative and linear feature results in better software.

Thus following the steps of spiral model first of all I collected the requirements and developed partial site fulfilling basic requirements (based on the requirement collected). As I discussed with users what information they want to put on web site and the manner in which they want to fetch the information, the technical risk were reduced. After designing and creation of some pages of site, I asked for feedback from the users. According to the feedback of users, I further refined the pages of the site, wherever required. This procedure was followed until the whole site was completely developed. Thus the complete website was developed in an iterative and sequential way to the entire satisfaction of the users of EarnMoney.com.

Software Requirement Specification

The software requirements specification is produced at the culmination of the analysis task. The function and performance allocated to software as part of system engineering are refined by establishing a complete information description a detailed functional and behavioral description, a indications of performance requirements and design constraints, appropriate validation criteria and other data pertinent to requirements.

1. Introduction

a. Purpose

b. Scope

c. Definition, Acronyms, Abbreviations

d. References

e. Developer’s Responsibilities Overview

2. General Description

a. Vehicle Functions Overview

b. User Characteristics

c. General Constraints

d. General Assumptions and Dependencies

3. Specific Requirements

a. Inputs and Outputs

b. Functional Requirements

c. External Interface Requirements

d. Performance Constraints

e. Design Constraints

(i) Software Constraints

(ii) Hardware Constraints

4. Validation and Criteria

a. Performance bounds

b. Classes of tests

c. Expected Software response

d. Special Considerations

5. Acceptance Criteria

1. Introduction: -

This is the requirements document for the project that will be used throughout the work. The system to be developed is for front office and financial work of agency, based on the inputs given. This document follows the IEEE standard for a requirement specification document, with some variations.

a). Purpose:

The purpose of this document is to describe the requirements of agency. It also describes the interfaces for the system.

b). Scope:

This document is the only one that describes the requirements of the system. It is meant for use by the developers and will be the basis for validating the final delivered system. Any changes made to the requirements in the future have to go through a formal change approval process. The developer is responsible for asking for clarifications, where necessary, and will not make any alterations without the permission of the client.

c). Definitions, Acronyms, Abbreviations:

Not applicable.

d). References:

Not applicable.

e). Developer’s Responsibilities Overview:

The developer is responsible for (i) developing the system, (ii) installing the software on the client’s hardware, (iii) conducting any user training that might be needed for using the system, and (iv) maintaining the system for a period of one year after installation.

2.General Description: -

a). Functions Overview:

In agency there is a counter for booking and various queries of the customers can be solved with ease on one table. As the software provide all information customer, registration etc provided by the agency.

b). User Characteristics:

The main users of this system will be the registration department and accounts department, who are somewhat literate with computers and can use programs efficiently.

c). General Constraints:

The system should run on win 95 /98/2000 or above.

d). General Assumptions and Dependencies:

Not applicable.

3. Specific Requirements:

a). Inputs and Outputs:

The system has all the details regarding the Customer, Agents, Product, Kit, employee, etc are maintained etc. The system has several inputs in form of data entry and several outputs in form of bills, reports etc.

The forms under the heading General Entries are registration; salary, leave etc are maintained.

From one the bill is generated and the other helps in report generation. Here also, the customer gets the desired registration and accordingly the bills and report are generated.

b). Functional Requirements:

It present description of each function required to solve the problem. A processing narrative is provided for each function, design constraints are stated and justified, performance characteristics are stated, and one or more diagrams are included to graphically represent the overall structure of the software and interplay among software functions and other system elements under this topic, the functional working of the various modules where give the complete picture for the data flow from one location to other.

c). External Interface Requirements:

Only one user command is required. The file name must be prompted by the system in status bar.

d). Performance Constraints:

The reports and bills should be printed in less than 1 minute.

e). Design Constraints:

The system is to run under the WINDOWS operating system.

4.Validation Criteria:

Probably the most important section of a software requirements specification is validation Criteria. The specification of validation criteria acts as an implicit review of all other requirements. The tests must be conducted to validate function, performance and constraints.

In this project I have try the various steps in testing the links and connectivity of the data Directorate of public grievances takes up a grievances where it is satisfied that eh matter has not been dealt with by the concerned SSA in a fair, just or objective manner or has been unduly delayed. It may take up such a care for investigation, call for a report and or file from the concerned SSA and ask them to reconsider the matter and to arrive at a fair decision in a time bound manner.

5. Acceptance Criteria:

Before accepting the system, the developer must demonstrate that the system works on the course data for the last 4 semesters. The developer will have to show through test cases that all conditions are satisfied.

Software Requirement

Platforms:	Windows Server 2000/2003
For Application Development:	Visual C#.NET & ASP.NET
Database Application:	SQL SERVER
Web Server:	IIS

Hardware Requirement

Pentium IV Processor

512 MB RAM

40 GB HDD

52X Combo Drive

Color Monitor

Keyboard, Mouse

System Design

1. Input Design:

When designing input, the objective is to ensure that the data that will be processed by the system is collected and entered into the system efficiently, according to the specified requirements, and with the minimum of errors. In description with the client, the designer will choose a method of input, which is cost effective and acceptable to the end users. The process of input design, like output design, which was described earlier, consists of four stages.

· Firstly, identifying the inputs into the system, by listing the data flows on the required logical data flow diagram which cross the system boundary on their way in

· Then determining the content of these inputs by inspecting the data dictionary

· Next choosing an appropriate input device to change the user's data into a form which can be read and processed by the computer system

· And finally completing the detailed design work involved in specifying forms, input screens and other data collection documents.

Project development required complete analysis of system right from the scratch Analysis of the system required great attention on big as well as minute transactions This required exhaustive study of Manual management system. Manual system was divided in various sections, which were dealt individually. Getting detail of each section was a tedious and a time consuming task. This involved various meetings with head of each individual section. After getting detail of each section whole process was re-evaluated and a proper design for the system was brought into existence. Design was discussed with the Workshop’s Manager and was further improved by eliminating some loopholes. Designing process is carried on very carefully as this serves as backbone for development of any software. Thus synopsis of the package was prepared.

After Design phase attention was laid upon source code of the package.

Whole project was divided into small modules. Source code for each module was individually prepared and tested both syntactically and logically (Modular Testing). In cases modules were further divided into units and tested (Unit Testing). These units were merged to get modules and these modules were further available for integration. This sort of testing comes under Integration Testing. Various tests were conducted on the package to demonstrate that the system satisfies all the requirements stated in requirements documentation. This is Acceptance Testing.

Phase 1 of the package has been prepared and is running successfully (Implementation).

Maintenance of the package would require further enhancement of the package as per requirements of the company.

2. Data Base Model Apply:

The data in a database is organized according to the data structure 'imposed' upon it by the physical data model. The physical data model is normally produced during the physical data design stage in the development life cycle and tailored specifically to the selected, or imposed, database type.

The rules regarding this implementation and its subsequent optimization will vary widely according to the type of DBMS.

The Database Management Systems available today can be grouped into four types.

These are:

File Management Systems (FMS)
Hierarchical Databases (HDS)
Network Databases (NDS)
Relational Databases (RDBMS)- The relational database model resulted from an IBM-sponsored research project by Dr. E.F.Codd. The relation model attempts to overcome some the failings of the hierarchical and network database model, and provides easy-to-use and flexible data structure.
The relational model includes data structure (table), operators that can be used to manage the data in data structure, and some integrity rules that ensure that the data obeys the business rules defined for the system.
The relational model is based on relational algebra concepts and theory and, in the early days, used some of the same technology to describe the processing that could be performed on the data structures For example, relational theory uses the words "relations" to mean tables, "tuples" to mean rows, and "attributes" to mean columns in table
Relational database are the most common type of database management systems in use today.

Relational database includes Oracle, DB2, Ingress, Informix, Sybase, and SQL Server.

Another important concept in relational databases is that relationships between tables are not hard-coded in the structure of the data that is there are no pointers in the data to relate one table to another. This means that you can specify the relationships between two sets of data at development time rather than when the tables are first created. This greatly improves the flexibility of the database management system.
Relational Database Properties- A relational database management system (RDBMS) has the following properties:

§ Represents data in the form of tables

§ Does not hard-code relationships between tables

§ Doesn't require the user to understand its physical implementation

§ Provides information about its contents and structure in system tables

§ Can be manipulated through SQL commands

§ Supports the concept of NULL values

In this project the database used is SQL.

Overview of SQL:

A relational database is an extremely simple way of thinking about and managing the data used in a business. It is nothing more than a collection of tables of data.

A relational database management system such as SQL server gives you a way of doing things in an understandable and reasonably uncompelled way. SQL server basically does three things:

Lets you put data into it.
Keeps the data.
Lets you get the data out and work with it.

The information stored in SQL server is kept in tables. There are three major characteristics of the tables.

Ø Columns

Ø Rows

Ø Name

3. Tables of Information:

SQL stores information in tables. These tables have one or more columns. The columns heading describe the kind of information kept in the column. The information is stored row after row. Each unique set of data gets is own row.

Even though the tables are independent, we can easily see that they are related. A column in one table is related to a column in the other table. This relationship is the basis for the name relational database. This is the basic idea of a relational (sometimes called a relational model). Data is stored in tables. Tables have columns, rows, and names. Tables can be related to each other if each has a column with a common type of information.

The retrieval of data from a database can be faster with primary key. A primary key is a field that uniquely identifies each record in a table is called a foreign key.

To cascade updating and deletion of related fields, we enforce the referential integrity. Whenever a change is made to primary key.

When two tables have single common field, they are said to be 'related'. The types of relationships, which the tables in SQL can have, are:

Ø One to One

Ø One to many

Ø Many to One

Ø Many to many

SQL server, objects can be defined as reusable software codes which are location independent and perform a specific task on any application environment with little or no change to the code. SQL Brands, Models are based on a concept known as the “Client/Server Technology”. This concept involves segregating the processing of an application between two systems. A client or front-end database application also interacts with the database by requesting and receiving information from the ‘database server’. It acts as an interface between the user and the database. Further, it also checks for validation against the data entered by the user. The database server or backend is used to manage the database tables optimally among multiple clients who concurrently request the server for the same data. It also enforces data integrity across all client applications and controls database access and controls database access and other security requirements.

SQL is a RDBMS and consists of a comprehensive set of application building and end-user Brands, Models, aimed at providing complete solutions. SQL applications are potable across a variety of platforms and operating systems. It provides a flexible DBMS called SQL server for storage and management of information used by all applications.

An object relational database management system (ORDBMS) extends the capabilities of the RDBMS to support object-oriented concepts. We can use Oracle as an RDBMS or take advantage of its object-oriented features. The information stored in SQL is kept in tables. The three major characteristics of most tables are columns, rows and a name.

Tables can be related to each other if each has a column with a common type of information.

SQL avoids specialized, academic terminology in order to make the vehicle more approachable. A column may be called an “attribute”, a row may be called a “tuple”, and a table may be called an entity.

SQL was the first company to release a vehicle that used the English-based Structured Query Language or SQL. This language allows end users to extract information themselves, without using a systems group for every little report. Oracle’s query language has rules of grammar and syntax. SQL is an astonishingly capable tool.

Some benefits of using SQL are:

Ø Large Databases

Ø Many Users (multiple user can work)

Ø Portable

Ø Backup & Recovery features

Ø Security

Ø Client/Server Support

Ø Data entities & Key Fields

Ø Entity & Attributes

Entity-

An entity is an object, place, person, concept, or activity about which an enterprises record data.

Attribute-

An attribute is the characteristic property of an existing entity. The difference between attribute type and attribute instance has to be understood.

4.Relationship Diagrams

A relationship is defined as "an association among entities". A relationship type is an association of entity, while a relationship instance is an association of entity instances.

· One-to-One

If in an entity there is a one field, which is not repeated, and another entity it is related and also entered once is called One-to-One relationship.

· One-to-Many (or Many-to-One)

In One-to-Many relationship in one table field is not repeated and in another table which is related to the first table the field has to be repeated like in the current project in consumer master file consumer number is not repeated and booking file there is repetitions of consumer number whenever consumer booked the refill.

· Many-to-Many

In many to many relationship both table can have repetitive data.

5. Screen Designs

The quality of screen design can have a direct impact on the performance of the users of the system, and the designer needs to consider the format as well as the content of the screens on which the dialogue, or interaction, between the user and the system is based. A number of features of screen design are worth discussing here:

· Text – Must be easily readable. In addition to choosing an appropriate font and size for the characters, readability can be improve by using lower and upper case letters, rather than the approach some times adapted in screen design of using all upper case evenly

Space text, with an unjustified right margin is easier to read than right justified text, which has spaces of varying sizes between the words. The use of concise phrase, familiar vocabulary and appropriate abbreviations make it easier for the reader to understand the text. The most visible section of the screen is the upper left-hand corner

And it is a good idea to locate important messages in this area. Again it is important that

The designers understand the characteristics of the in user in order to deliver quality Brands, Models. Beginners, who are usually looking at their fingers, will noticed error messages

Which appear on the button line on the screen, where as the top right corner of the screen is a more appropriate location for experienced keyboard operators.

· Colour- another set of the design option is possible, in addition to those described above, if the display is in colour. Being in a different colour to be rest or being enclosed in a coloured box can highlight text. Background colours can be changed or a design convention can be used in which different types of information are displayed in different colours. The consistent use of colours on screens within the same system is important, and the designer must be wary of using to many colors or creating lurid combination as these will work against the effectiveness of the screen design.

· Graphics –

can be used to good effect for displaying information, especially trends in numerical data. They can be coloured, solid, three-dimensional or animated, and the designer must decided on what is appropriate to the purpose. Another use of graphics is as an integral part of the structure of the dialogue-known as a graphical user interface (GUI).

· Animation-

although this is little used in screen design, it can be a powerful technique for attracting the attention of the user, because the eye is always drawn to a moving object; to mark the position of an object, for example, a blinking cursor can be used; or to communicate a message, a clock with a moving hand , or an hourglass with moving sand, indicate to the user that they have to wait while some processing is carried out by the machine.

7.File Design

The way in which data is organized and accessed can be crucial to the effectiveness of a computer system. Data can be stored in files or in a database.

Types of Files

Master file contain records, which are critical to the system and its users. The records in master file store permanent information of long-term value to an organization and are used regularly in the organization’s key system.

Transaction files contain transient data relating to business activities, such as telephone calls logged. They are used mainly to update master files. Transaction files usually contain records relating to a particular period part of time.

8. Dialog Types

A. Common Dialogs

There are a number of different approaches which can be taken when design conversation or dialog between the user and the computer system. Essentially a dialogue consists of the user responding to a prompt from the computer by providing input. The computer processes this input and a response is output to the screen, which in turn may prompt the user for the next input. The main dialogue types are summarized below. It is up to the designers having considered the alternatives, to decide which of these is most appropriate, based on the requirements and characteristic of the end users.

B. Menus

Menus are widely used in screen design because they require minimal effort, and skill, on the part of the user. This in turn reduces the training requirement when preparing individuals to used the system. A common approach is to structure the menus hierarchically in a' nest'; selecting an option is chosen, and so on. This allows the number of alternatives on any one screen to be kept to a minimum.

C. User Support

When designing off-line help, which is usually paper-based but which could also be in the form of audio or videotapes, a key principle is to think the needs of the users who will be referring to them. They will be keen to find a quick solution to their problem.

And will frequently be anxious and in a hurry. Manuals should therefore be kept simple and not overloaded with information, and should be relevant to the common types of problems encountered by users. The most useful way of developing such material is by working closely with end users and modifying the text in the light of the difficulties they experience when using the system.

On-Line help can be basic, usually in a concise form with reference to a manual where more detailed information can be obtained; it can be context-sensitive, providing appropriate information about the particular function being used at the time the help is requested; or it can be intelligent, responsive to the route a user has followed while navigating through an application and their needs when the help screen is called.

User support will also take the form of training for those who will be interacting with the computer system. Again, this can be provided off-line,

in the form of a training event (either a taught course or an open learning program), or on-line, as a tutorial, which takes the user through the functions of the system and then through a series of structured exercises.

It must not be forgotten, when designing a computer system that users are part of this system, and can be considered almost as an extension of the computer. Their role must be defined and designed like any other component of the system, and thought must be given early on as to how they can best be supported in carrying out this role.

Screen Shots

Page Name: administrator.aspx

Page Name: accountdetail.aspx

Page Name: aboutus.aspx

Page Name: btree.aspx

Page Name: changepass.aspx

Page Name: contactus.aspx

Page Name: feedback.aspx

Page Name: forgetpassword.aspx

Page Name: getcash.aspx

Page Name: home.aspx

Page Name: login.aspx

Page Name: welcome.aspx

Page Name: myaccount.aspx

Page Name: products.aspx

Page Name: Registration.aspx

Page Name: userdetail.aspx

Page Name: shop_item.aspx

Page Name: shoping_cart.aspx

Page Name: userinfo.aspx

Source Code:

Page Name: accountdetail.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="accountdetail.aspx.cs" Inherits="accountdetail" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

</td>

Pair Income:</td>

<asp:TextBox ID="txtpincome" runat="server" Enabled="False"

ontextchanged="txtpincome_TextChanged"></asp:TextBox>

</td>

</td>

</tr>

<tr>

<td>

 </td>

Child Income:</td>

<td>

<asp:TextBox ID="txtcincome" runat="server" Enabled="False"

EnableTheming="True"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Product Selling Income:</td>

<td>

<asp:TextBox ID="txtpsincome" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

  Amount Left:</td>

<td>

<asp:TextBox ID="txttincome" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

</td>

 </td>

 </td>

</td>

</tr>

<tr>

<td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

 </td>

<asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="~/getcash.aspx">Get

Cash</asp:LinkButton>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: accountdetail.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class accountdetail : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlDataAdapter adp;

string status = "Unused";

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

int tin, ause, left;

string str_select = "select * from commission where user_name='" + Session["uid"].ToString() + "'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

txtpincome.Text = dt.Rows[0][1].ToString();

txtcincome.Text = dt.Rows[0][2].ToString();

txtpsincome.Text = dt.Rows[0][3].ToString();

string str1_select = "select * from tbl_totalincome where user_name='" + Session["uid"].ToString() + "'";

SqlDataAdapter adp1 = new SqlDataAdapter(str1_select, con);

DataTable dt1 = new DataTable();

adp1.Fill(dt1);

txttincome.Text = dt1.Rows[0][1].ToString();

}

protected void Button1_Click(object sender, EventArgs e)

{

}

protected void txtpincome_TextChanged(object sender, EventArgs e)

{

}

Page Name: administrator.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="administrator.aspx.cs" Inherits="administrator" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

User Name:</td>

<td>

<asp:TextBox ID="txtuname" runat="server" Height="25px" Width="166px"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click"

Text="See Detail" />

</td>

<asp:Button ID="Button2" runat="server" Text="Delete User"

onclick="Button2_Click" />

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

</td>

Generate Subscription Code:</td>

<asp:TextBox ID="txtsubcode" runat="server" Height="21px" Width="165px"></asp:TextBox>

</td>

</td>

</tr>

<tr>

<td>

 </td>

<asp:Button ID="Button3" runat="server" onclick="Button3_Click"

Text="Generate Subscription Code" />

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: administrator.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class administrator : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlDataAdapter adp;

string status = "Unused";

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

//string str_select = "select * from registration where user_name='" + Session["sid"].ToString() + "'";

//adp = new SqlDataAdapter(str_select, con);

//adp.Fill(dt);

//txtuname.Text = dt.Rows[0][0].ToString();

Session["uid"]=txtuname.Text;

Response.Redirect("userinfo.aspx");

}

protected void Button3_Click(object sender, EventArgs e)

{

string strcode = System.Guid.NewGuid().ToString();

txtsubcode.Text = strcode.Substring(0, 6);

string strins="insert into subcode values('"+txtsubcode.Text+"','Unused')";

con.Open();

SqlCommand cmd = new SqlCommand(strins, con);

cmd.ExecuteNonQuery();

con.Close();

gridshow();

}

public void gridshow()

{

string strgrid = "select * from subcode where status='Unused'";

SqlDataAdapter adp1 = new SqlDataAdapter(strgrid,con);

DataTable dt1=new DataTable();

adp1.Fill(dt1);

GridView1.DataSource = dt1;

GridView1.DataBind();

}

protected void Button2_Click(object sender, EventArgs e)

{

string strdel = "delete from registration where user_name='" + txtuname.Text + "'";

SqlCommand cmd1 = new SqlCommand(strdel, con);

con.Open();

cmd1.ExecuteNonQuery();

string strdel1 = "delete from tbl_totalincome where user_name='" + txtuname.Text + "'";

SqlCommand cmd2 = new SqlCommand(strdel1, con);

cmd1.ExecuteNonQuery();

string strdel2 = "delete from tbl_totalincome where user_name='" + txtuname.Text + "'";

SqlCommand cmd3 = new SqlCommand(strdel2, con);

cmd2.ExecuteNonQuery();

con.Close();

}

Page Name: btree.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="btree.aspx.cs" Inherits="btree" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<asp:Label ID="Label4" runat="server" Text="Label"></asp:Label>

</td>

 </td>

<td>

<asp:Label ID="Label6" runat="server" Text="Label"></asp:Label>

</td>

<td>

 </td>

<td>

<asp:Label ID="Label7" runat="server" Text="Label"></asp:Label>

</td>

<td>

 </td>

<td>

<asp:Label ID="Label5" runat="server" Text="Label"></asp:Label>

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: btree.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class btree : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

string str_select = "select * from registration where sponser_name='" + Session["uid"].ToString() + "'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

Label1.Text = Session["uid"].ToString();

foreach(DataRow dr in dt.Rows)

{

if (dr["placement"] == "Left")

{

Label2.Text = dr["placement"].ToString();

}

else

{

Label3.Text = dr["placement"].ToString();

}

Page Name: changepass.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="changepass.aspx.cs" Inherits="changepass" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

<tr>

<td align="center" bgcolor="#999966" colspan="3"

style="color: #FFFFFF; font-style: italic; font-weight: bold; font-size: large;">

PASSWORD CHANGE!!!!!</td>

</tr>

<tr>

 </td>

 </td>

 </td>

</tr>

<tr>

User Id :</td>

<asp:TextBox ID="txt_userid" runat="server"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

Old Password :</td>

<asp:TextBox ID="txtoldpass" runat="server" TextMode="Password"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

New Password :</td>

<asp:TextBox ID="txt_newpass" runat="server" TextMode="Password"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

Confirm Password :</td>

<asp:TextBox ID="txt_confmpass" runat="server" TextMode="Password"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

 </td>

<asp:Label ID="lblmessage" runat="server"></asp:Label>

</td>

 </td>

</tr>

<tr>

 </td>

<asp:Button ID="Butt_changepass" runat="server" Text="CHANGE MY PASSWORD"

onclick="Butt_changepass_Click" />

</td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</asp:Content>

Page Name: changepass.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class changepass : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlDataAdapter adp;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Butt_changepass_Click(object sender, EventArgs e)

{

string strupdate = "update registration set password='" + txt_newpass.Text + "' where user_name='" + txt_userid.Text + "' and password='" + txtoldpass.Text + "'";

SqlCommand cmd = new SqlCommand(strupdate,con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

lblmessage.Text = "Your Password Change Success Fully";

}

Page Name: contactus.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="contactus.aspx.cs" Inherits="contactus" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<b>Contact Us</b></td>

<b>Send Your Message Here!!!</b></td>

</tr>

<tr>

<asp:Image ID="Image1" runat="server" ImageUrl="~/image/ContactUsHeader.jpg"

Width="301px" Height="267px" style="margin-right: 0px" />

</td>

<tr>

<td>

<table cellpadding="3" cellspacing="3"

style="width: 100%; height: 249px; background-color: #999999;">

<tr>

Name :</td>

<td>

<asp:TextBox ID="Txt_name" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Address :</td>

<td>

<asp:TextBox ID="Txt_address" runat="server" Height="64px" TextMode="MultiLine"

Width="267px"></asp:TextBox>

</td>

</tr>

<tr>

Mobile Number :</td>

<td>

<asp:TextBox ID="Txt_contactno" runat="server" ontextchanged="T_TextChanged"></asp:TextBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"

ControlToValidate="Txt_contactno" ErrorMessage="Enter 10 Digit Mobile Number"

ValidationExpression="\d{10}"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

Email Id :</td>

<td>

<asp:TextBox ID="Txt_emailid" runat="server"></asp:TextBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"

ControlToValidate="Txt_emailid" ErrorMessage="Enter Correct Email Id"

ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

Message :</td>

<td>

<asp:TextBox ID="Txt_message" runat="server" Height="67px" TextMode="MultiLine"

Width="274px"></asp:TextBox>

</td>

</tr>

<tr>

<td>

 </td>

<td>

<asp:Button ID="Button1" runat="server" Text="submit" Width="66px"

onclick="Button1_Click" />

</td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</td>

<td>

      <span style="color: #990000">*OUR OFFICE*</span><br />

 L.I.G 3/745 Sector-H<br />

 Jankipuram, Kursi Road<br />

 Lucknow-226021<br />

 Uttar Pradesh<br />

 India<br />

 Mobile-+91 9044644404<br />

 <a href="mailto:Emai-contact@earnmoney.com">Emai : contact@earnmoney.com</a><br />

<br />

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

Page Name: contactus.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class contactus : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmdcontact;

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

}

protected void T_TextChanged(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

string str_insert = "insert into contactus values('" + Txt_name.Text + "','" + Txt_address.Text + "','" + Txt_emailid.Text + "','" + Txt_contactno.Text + "','" + Txt_message.Text + "')";

cmdcontact = new SqlCommand(str_insert, con);

con.Open();

cmdcontact.ExecuteNonQuery();

con.Close();

Txt_name.Text = "";

Txt_address.Text = "";

Txt_contactno.Text = "";

Txt_emailid.Text = "";

Txt_message.Text = "";

}

Page Name: feedback.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="feedback.aspx.cs" Inherits="feedback" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<b>Send Your Comment Here!!!</b></td>

</tr>

<tr>

<td>

<tr>

<asp:Image ID="Image1" runat="server" ImageUrl="~/image/feedbackBox.jpg"

Width="341px" />

</td>

<td>

<table cellpadding="3" cellspacing="3"

style="width: 100%; margin-left: 0px; background-color: #669999;">

<tr>

Name :</td>

<td>

<asp:TextBox ID="Txt_name" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Address :</td>

<td>

<asp:TextBox ID="Txt_address" runat="server" Height="48px" TextMode="MultiLine"

Width="205px"></asp:TextBox>

</td>

</tr>

<tr>

Contact Number :</td>

<td>

<asp:TextBox ID="Txt_contactno" runat="server" ></asp:TextBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"

ControlToValidate="Txt_contactno" ErrorMessage="PLZ enter 10 digit number"

ValidationExpression="\d{10}"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

Email Id :</td>

<td>

<asp:TextBox ID="Txt_emailid" runat="server"></asp:TextBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"

ControlToValidate="Txt_emailid" ErrorMessage="Plz enter valid email id"

ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

Comment:</td>

<td>

<asp:TextBox ID="Txt_message" runat="server" Height="59px" TextMode="MultiLine"

Width="237px"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

<asp:Button ID="Button1" runat="server" Text="submit" Width="66px"

onclick="Button1_Click" />

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

Page Name: feedback.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class feedback : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

string str_insert = "insert into feedback values('" + Txt_name.Text + "','" + Txt_address.Text + "'," + Txt_contactno.Text + ",'" + Txt_emailid.Text + "','" + Txt_message.Text + "')";

cmd=new SqlCommand(str_insert,con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Txt_name.Text="";

Txt_address.Text="";

Txt_contactno.Text="";

Txt_emailid.Text="";

Txt_message.Text="";

}

Page Name: forgetpassword.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="forgetpassword.aspx.cs" Inherits="forgetpassword" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

User Name :</td>

<td>

<asp:TextBox ID="txtunam" runat="server" Width="256px"

ontextchanged="txtunam_TextChanged"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Sequrity Question :</td>

<td>

<asp:DropDownList ID="ddlsquestion" runat="server">

<asp:ListItem>--Select--</asp:ListItem>

<asp:ListItem>Your Favoroute Colour</asp:ListItem>

<asp:ListItem>Your fathers mid name</asp:ListItem>

<asp:ListItem>your pets name</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Sequrity Answwer :</td>

<td>

<asp:TextBox ID="txtans" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

<asp:Label ID="lblmessage" runat="server" Width="256px" ForeColor="#006666"

style="font-weight: 700"></asp:Label>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

<asp:Button ID="Button1" runat="server" Text="Get Password"

onclick="Button1_Click" />

</td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: forgetpassword.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class forgetpassword : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

string str_select = "select password from registration where user_name='" + txtunam.Text + "' and squestion='" + ddlsquestion.SelectedItem.Text + "' and sans='" + txtans.Text + "'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

int a = dt.Rows.Count;

if (a>0)

{

lblmessage.ForeColor = System.Drawing.Color.Green;

lblmessage.Text = dt.Rows[0][0].ToString();

}

else

{

lblmessage.ForeColor = System.Drawing.Color.Red;

lblmessage.Text = "Invalid User Name Or Password";

}

protected void txtunam_TextChanged(object sender, EventArgs e)

{

}

Page Name: getcash.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="getcash.aspx.cs" Inherits="getcash" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Amount You Have:</td>

<td>

<asp:TextBox ID="txtamount" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

User Name:</td>

<td>

<asp:TextBox ID="txtuname" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Date:</td>

<td>

<asp:TextBox ID="txtdate" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Enter Amount To Cash:</td>

<td>

<asp:TextBox ID="txtcash" runat="server" AutoPostBack="True"

ontextchanged="txtcash_TextChanged" style="height: 22px"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

ControlToValidate="txtamount" ErrorMessage="You Dont Have Enough Balance"></asp:RequiredFieldValidator>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<asp:Button ID="Button3" runat="server" Text="Submit" onclick="Button3_Click" />

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: getcash.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class getcash : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlDataAdapter adp;

DataTable dt = new DataTable();

int tincome = 0, totali, cash;

protected void Page_Load(object sender, EventArgs e)

{

txtuname.Text = Session["uid"].ToString();

txtdate.Text = System.DateTime.Now.ToShortDateString();

string strsel = "select total_income from tbl_totalincome where user_name='" + Session["uid"].ToString() + "'";

SqlDataAdapter adp = new SqlDataAdapter(strsel, con);

DataTable dt = new DataTable();

adp.Fill(dt);

txtamount.Text = dt.Rows[0][0].ToString();

}

protected void txtcash_TextChanged(object sender, EventArgs e)

{

}

protected void Button3_Click(object sender, EventArgs e)

{

totali = Convert.ToInt16(dt.Rows[0][0].ToString());

cash =Convert.ToInt16(txtcash.Text);

tincome = totali - cash;

string str_update = "update tbl_totalincome set total_income='" + txtuname.Text + "'";

cmd = new SqlCommand(str_update, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

Page Name: home.aspx

Page Name: home.aspx.cs

Page Name: income.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="income.aspx.cs" Inherits="income" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

Sponsor Income</td>

<td>

<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

Pair Income :</td>

<td>

<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

Total Income :</td>

<td>

<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>

</td>

</tr>

</table>

</asp:Content>

Page Name: income.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class income : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

string left,right;

int intleft, intright,pair,incom;

protected void Page_Load(object sender, EventArgs e)

{

string str_select = "select count(placement) from registration where user_name='" + Session["uid"].ToString() + "' and placement='Left'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

left= dt.Rows[0][0].ToString();

string str_select1 = "select count(placement) from registration where user_name='" + Session["uid"].ToString() + "' and placement='Right'";

SqlDataAdapter adp1 = new SqlDataAdapter(str_select1, con);

DataTable dt1 = new DataTable();

adp.Fill(dt1);

right = dt1.Rows[0][0].ToString();

intleft = Convert.ToInt16(left.ToString());

intright = Convert.ToInt16(right.ToString());

if (intleft >= intright)

{

pair = intright;

}

else

{

pair = intleft;

}

incom = pair * 1000;

Label2.Text = incom.ToString();

}

Page Name: login.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="login.aspx.cs" Inherits="login" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<asp:Image ID="Image1" runat="server" Height="291px"

ImageUrl="~/image/login_welcome.jpg" Width="409px" />

</td>

<td>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

<asp:Label ID="lblmsg" runat="server" Width="200px" ForeColor="#FF0066"></asp:Label>

</td>

<td>

 </td>

</tr>

<tr>

User Name :</td>

<td>

<asp:TextBox ID="txtunam" runat="server" Width="256px"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

Password :

<td>

<asp:TextBox ID="txtpass" runat="server" Width="256px" TextMode="Password"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

</td>

</td>

</td>

</tr>

<tr>

 </td>

<asp:Button ID="Button1" runat="server" Text="Login" onclick="Button1_Click" />

</td>

</td>

</tr>

<tr>

 </td>

<td>

<asp:LinkButton ID="LinkButton1" runat="server"

PostBackUrl="~/Registration.aspx">Not Registered Register Now.</asp:LinkButton>

</td>

<td>

 </td>

</tr>

<tr>

 </td>

<td>

<asp:HyperLink ID="HyperLink1" runat="server"

NavigateUrl="~/forgetpassword.aspx">Forget Password</asp:HyperLink>

</td>

<td>

 </td>

</tr>

<tr>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

Page Name: login.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class login : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

LinkButton1.Visible = false;

}

protected void Button1_Click(object sender, EventArgs e)

{

if (txtunam.Text == "admin" && txtpass.Text == "admin")

{

Response.Redirect("administrator.aspx");

}

else

{

string str_select = "select * from registration where user_name='" + txtunam.Text + "' and password='" + txtpass.Text + "'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

int a = dt.Rows.Count;

if (a == 1)

{

Session["uid"] = txtunam.Text;

Session["name"] = dt.Rows[0][15].ToString();

Response.Redirect("welcome.aspx");

}

else

{

LinkButton1.Visible = true;

lblmsg.Text = ("Invalid User Name Or Password");

}

Page Name: myaccount.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="myaccount.aspx.cs" Inherits="myaccount" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Total Balance:</td>

<td>

<asp:TextBox ID="txttotal" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

<asp:Button ID="Button1" runat="server" Text="Check Detail" Width="100px"

onclick="Button1_Click" />

</td>

<td>

 </td>

</tr>

<tr>

</td>

</td>

</td>

<asp:Button ID="Button2" runat="server" Text="Get Cash" Width="100px"

onclick="Button2_Click" />

</td>

</td>

</tr>

<tr>

<td>

 </td>

 </td>

 </td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: myaccount.aspx.s

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class myaccount : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlDataAdapter adp;

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

string strsel = "select total_income from tbl_totalincome where user_name='" + Session["uid"].ToString() + "'";

SqlDataAdapter adp = new SqlDataAdapter(strsel, con);

DataTable dt = new DataTable();

adp.Fill(dt);

txttotal.Text = dt.Rows[0][0].ToString();

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Redirect("accountdetail.aspx");

}

protected void Button2_Click(object sender, EventArgs e)

{

Response.Redirect("getcash.aspx");

}

Page Name: products.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="products.aspx.cs" Inherits="products" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<asp:DataList ID="dlGallery" runat="server" DataKeyField="product_id"

ForeColor="black" RepeatColumns="3" Width="941px">

<asp:ImageButton ID="ImageButton1" runat="server" BorderColor="Black"

BorderWidth="2px" Height="150px" ImageUrl='<%# Eval("Picture") %>'

PostBackUrl='<%# Eval("product_id", "ShopItem.aspx?product_id={0}") %>'

Width="150px" />

</td>

</tr>

<tr>

Name :Name :<asp:Label ID="lbl1" runat="server"

Text='<%#Eval("Product_Name") %>'></asp:Label>

<asp:Label ID="ProductIDLabel" runat="server" ForeColor="#800000"

Text='<%# Eval("product_id") %>' Visible="false"></asp:Label>

</td>

</tr>

<tr>

Price :Rs.Price :Rs.<asp:Label ID="Label2" runat="server"

Text='<%#Eval("product_cost") %>'></asp:Label>

</td>

</tr>

<tr>

</td>

</tr>

</table>

</ItemTemplate>

</asp:DataList>

</asp:Content>

Page Name: products.aspx.s

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class products : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DataTable dt = new DataTable();

string st = "select * from product";

SqlDataAdapter adp = new SqlDataAdapter(st, con);

adp.Fill(dt);

dlGallery.DataSource = dt;

dlGallery.DataBind();

}

Page Name: Registration.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Registration.aspx.cs" Inherits="Registration" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Sponser Id :</td>

<td>

<asp:TextBox ID="txtsid" runat="server" Width="256px" AutoPostBack="True"

ontextchanged="txtsid_TextChanged"></asp:TextBox>

<asp:Label ID="lblsid" runat="server"></asp:Label>

</td>

<td>

 </td>

</tr>

<tr>

</td>

Confirm Sponser Id :</td>

<asp:TextBox ID="txtcsid" runat="server" Width="256px"></asp:TextBox>

<asp:CompareValidator ID="CompareValidator1" runat="server"

ControlToCompare="txtsid" ControlToValidate="txtcsid"

ErrorMessage="mismatch Sponsor id"></asp:CompareValidator>

</td>

</td>

</tr>

<tr>

<td>

 </td>

Subscription Code :</td>

<asp:TextBox ID="txtscode" runat="server" Width="256px" AutoPostBack="True"

ontextchanged="txtscode_TextChanged"></asp:TextBox>

<asp:Label ID="lblscode" runat="server"></asp:Label>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Applicant's Email :</td>

<asp:TextBox ID="txtemail" runat="server" Width="256px"></asp:TextBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"

ControlToValidate="txtemail" ErrorMessage="Enter Correct Email Id"

ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Confirm Applicant's Email :</td>

<asp:TextBox ID="txtcemail" runat="server" Width="256px"></asp:TextBox>

<asp:CompareValidator ID="CompareValidator2" runat="server"

ControlToCompare="txtemail" ControlToValidate="txtcemail"

ErrorMessage="Miss Match Email ID"></asp:CompareValidator>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Applicant's Contact Number :</td>

<asp:TextBox ID="txtcnum" runat="server" Width="256px"></asp:TextBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"

ControlToValidate="txtcnum" ErrorMessage="Enter 10 Digit Mobile Number"

ValidationExpression="\d{10}"></asp:RegularExpressionValidator>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

Country :</td>

<asp:DropDownList ID="ddlcountry" runat="server" Width="256px">

<asp:ListItem>Select</asp:ListItem>

<asp:ListItem>India</asp:ListItem>

</asp:DropDownList>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

State :</td>

<asp:DropDownList ID="ddlstate" runat="server" Width="256px">

<asp:ListItem>Uttar Pradesh</asp:ListItem>

<asp:ListItem>Bihar</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

</td>

</td>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click"

Text="Continue >>" />

</td>

</td>

</tr>

</table>

</asp:Content>

Page Name: Registration.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.Drawing.Text;

public partial class Registration : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlDataAdapter adp ;

SqlDataAdapter adp1;

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

string str_id = System.Guid.NewGuid().ToString();

str_id = str_id.Substring(0, 6);

String str_insert = "insert into registration(regid,str_id,sponser_id,subscription_code,email,contact_no,country,state) values('"+str_id+"','" + str_id + "','" + txtsid.Text + "','" + txtscode.Text + "','" + txtemail.Text + "','" + txtcnum.Text + "','" + ddlcountry.SelectedItem.Text + "','" + ddlstate.SelectedItem.Text + "')";

cmd = new SqlCommand(str_insert, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Session["sid"] = txtsid.Text;

Session["regid"] = str_id.ToString();

Session["scode"] = txtscode.Text;

Session["email"] = txtemail.Text;

Session["cnum"] = txtcnum.Text;

Session["country"] = ddlcountry.SelectedItem.Text;

Session["state"] = ddlstate.SelectedItem.Text;

Response.Redirect("userdetail.aspx");

}

protected void txtsid_TextChanged(object sender, EventArgs e)

{

string str_select = "select user_name from registration where user_name='" + txtsid.Text + "'";

adp = new SqlDataAdapter(str_select,con);

adp.Fill(dt);

int count = dt.Rows.Count;

if (count > 0)

{

txtsid.Focus();

lblsid.ForeColor = System.Drawing.Color.Green;

lblsid.Text = "Sponsor Id Found ";

}

else

{

lblsid.ForeColor = System.Drawing.Color.Red;

lblsid.Text = "Sponsor id not exist ";

}

protected void txtscode_TextChanged(object sender, EventArgs e)

{

string str_scode = "select scode from subcode where scode='" + txtscode.Text + "'";

adp1 = new SqlDataAdapter(str_scode, con);

DataTable dt1 = new DataTable();

adp1.Fill(dt1);

int count1 = dt1.Rows.Count;

if (count1 > 0)

{

txtscode.Focus();

lblscode.ForeColor = System.Drawing.Color.Green;

lblscode.Text = "Subscription Code Found !";

}

else

{

lblscode.ForeColor = System.Drawing.Color.Red;

lblscode.Text = "Invalid Subscription Code !";

}

Page Name: shop_item.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="shop_item.aspx.cs" Inherits="shop_item" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<asp:DataList ID="dlGallery" runat="server" DataKeyField="product_id"

ForeColor="black" RepeatColumns="3" Width="689px">

<asp:ImageButton ID="ImageButton1" runat="server" BorderColor="Black"

BorderWidth="2px" Height="150px" ImageUrl='<%# Eval("Picture") %>'

PostBackUrl='<%# Eval("product_id", "ShopItem.aspx?product_id={0}") %>'

Width="150px" />

</td>

</tr>

<tr>

Name :<asp:Label ID="lbl1" runat="server" Text='<%#Eval("Product_Name") %>'></asp:Label>

<asp:Label ID="ProductIDLabel" runat="server" ForeColor="#800000"

Text='<%# Eval("product_id") %>' Visible="false"></asp:Label>

</td>

</tr>

<tr>

Price :Rs.<asp:Label ID="Label2" runat="server" Text='<%#Eval("product_cost") %>'></asp:Label>

</td>

</tr>

<tr>

</td>

</tr>

</table>

</ItemTemplate>

</asp:DataList>

</asp:Content>

Page Name: shop_item.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class shop_item : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

protected void Page_Load(object sender, EventArgs e)

{

if (Session["id"] == null)

{

Response.Redirect("Login.aspx");

}

string prid = Request.QueryString["product_category"];

if (!IsPostBack)

{

DataTable dt = new DataTable();

string st = "select * from product where product_category='" + prid + "'";

SqlDataAdapter adp = new SqlDataAdapter(st, con);

adp.Fill(dt);

dlGallery.DataSource = dt;

dlGallery.DataBind();

}

Page Name: shoping_cart.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="shoping_cart.aspx.cs" Inherits="shoping_cart" %>

<%-- <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>--%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

.style1

{

width: 104%;

position: relative;

top: 0px;

left: 5px;

background-color: #F4F4F4;

}

.style2

{

width: 188px;

}

.style9

{

width: 10px;

font-weight: 700;

}

.style19

{

width: 266px;

}

.style25

{

text-decoration: underline;

font-weight: bold;

color: #333300;

}

.style16

{

width: 188px;

height: 24px;

background-color: #DBDBDB;

}

.style20

{

height: 24px;

width: 266px;

background-color: #A8AFA5;

}

.style18

{

}

.style7

{

width: 188px;

height: 31px;

background-color: #DBDBDB;

}

body {

margin: 0px;

padding: 0px;

background-repeat: no-repeat;

background-position: left top;

font-family:Arial, Helvetica, sans-serif;

}

.style31

{

color: #333300;

font-weight: bold;

}

.style33

{

height: 24px;

}

.style34

{

height: 31px;

}

.style35

{

color: #800000;

}

.style36

{

height: 31px;

width: 266px;

background-color: #A8AFA5;

}

.style39

{

background-color: #A09996;

}

.style40

{

background-color: #FFCCCC;

}

.style45

{

width: 266px;

background-color: #A8AFA5;

}

.style46

{

width: 10px;

height: 24px;

}

.style47

{

width: 10px;

height: 31px;

}

.style53

{

width: 188px;

background-color: #DBDBDB;

}

.style54

{

width: 229px;

}

</style>

</head>

<body>

<tr>

 </td>

 </td>

 </td>

<td>

 </td>

 </td>

<td>

 </td>

</tr>

<tr>

 </td>

</tr>

<tr>

                                                                     <span

class="style31"> </span>

<span class="style25">Enter your billing Information </span></td>

</tr>

<tr>

                                                                                                                                           </td>

</tr>

<tr>

 </td>

</tr>

<tr>

 </td>

Name</td>

<asp:TextBox ID="txtname" runat="server" Enabled="False"></asp:TextBox>

</td>

 </td>

</td>

 </td>

</tr>

<tr>

Email Id</td>

<asp:TextBox ID="txtemail" runat="server" Enabled="False"></asp:TextBox>

</td>

 </td>

<asp:TextBox ID="txtuid" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 Address </td>

<asp:TextBox ID="txtadd" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<span class="style35">Password:</span><asp:TextBox ID="txtpassword"

runat="server" TextMode="Password"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

Country</td>

<asp:TextBox ID="txtcountry" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

<asp:Button ID="Button2" runat="server"

style="position: relative; top: -4px; left: 91px; height: 27px; width: 74px; color: #800000"

Text="Login" onclick="Button2_Click" />

</td>

</tr>

<tr>

State</td>

<asp:TextBox ID="txtstate" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

<asp:Label ID="lblmsg" runat="server" style="color: #CC0000"></asp:Label>

</td>

 </td>

</tr>

<tr>

Town/city</td>

<asp:TextBox ID="txtcity" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

 </td>

</tr>

<tr>

Pin Code</td>

<asp:TextBox ID="txtpin" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

 </td>

</tr>

<tr>

Mobile Number</td>

<asp:TextBox ID="txtmobile" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</td>

</tr>

<tr>

Total Amount</td>

<asp:TextBox ID="txttotal" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

 </td>

</tr>

<tr>

<asp:Button ID="Button1" runat="server"

style="position: relative; top: -2px; left: 436px; height: 29px" Text="Submit"

Width="78px" onclick="Button1_Click1" />

</td>

</tr>

<tr>

 </td>

</tr>

</table>

</form>

</body>

</html>

Page Name: shoping_cart.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class shoping_cart : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

}

protected void Button1_Click1(object sender, EventArgs e)

{

}

protected void Button2_Click(object sender, EventArgs e)

{

string str_select = "select * from registration where user_name='" + txtuid.Text + "' and password='" + txtpassword.Text + "'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

int a = dt.Rows.Count;

if (a == 1)

{

txtname.Text=dt.Rows[0][1].ToString();

txtemail.Text=dt.Rows[0][5].ToString();

txtadd.Text = dt.Rows[0][1].ToString();

txtcountry.Text=dt.Rows[0][1].ToString();

txtstate.Text = dt.Rows[0][1].ToString();

txtcity.Text = dt.Rows[0][1].ToString();

txtpin.Text = dt.Rows[0][1].ToString();

txtmobile.Text = dt.Rows[0][1].ToString();

txttotal.Text = dt.Rows[0][1].ToString();

}

else

{

lblmsg.Text = ("Invalid User Name Or Password");

}

Page Name: ShopItem.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ShopItem.aspx.cs" Inherits="ShopItem" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

body {

background-color: #000000;

}

</style></head>

<body>

<div>

<tr>

<asp:Panel ID="Panel1" Width="100%" runat="server">

<asp:DataList ID="DataList1" runat="server" Width="100%" OnEditCommand="DataList1_EditCommand"

ForeColor="#666666" onselectedindexchanged="DataList1_SelectedIndexChanged" >

<tr>

<asp:Label ID="Label_picture" runat="server" Text='<%# Eval("Picture") %>' Visible="false"></asp:Label>

<asp:ImageButton ID="ImageButton1" runat="server" Height="250px" ImageUrl='<%# Eval("Picture") %>'

Width="200px" BorderColor="#ffcc66" BorderWidth="2px" />

</td>

<tr>

Product details

</td>

</tr>

<tr>

<td style="width:50%">Product Code:</td>

<asp:Label ID="Label_pid" runat="server" Text='<%# Eval("product_id") %>' ></asp:Label>

</td>

</tr>

<tr>

<td style="width:50%">Product Name: </td>

<asp:Label ID="Label_name" runat="server" Text='<%# Eval("Product_Name") %>' ></asp:Label>

</td>

</tr>

<tr>

<td style="width:50%">Product Cost: </td>

<asp:Label ID="Label_cost" runat="server" Text='<%# Eval("Product_cost") %>' ></asp:Label>

</td>

</tr>

<tr>

Product Discription

</td>

</tr>

<tr>

  <asp:Label ID="Label4" ForeColor="white" runat="server" Text='<%# Eval("Discription") %>' ></asp:Label>

</td>

</tr>

<tr>

<asp:ImageButton ID="ImageButton2" CommandName="Edit" Width="126px" Height="78px" runat="server" ImageUrl="~/image/add_to_shopping_cart.png" />

<br />

<asp:HyperLink id="HyperLink1" Font-Bold="True" Font-Names="verdana"

Font-Size="Smaller" ForeColor="White" runat="server" NavigateUrl="Default.aspx">Return to Shop</asp:HyperLink>

</td>

</tr>

</table>

</td>

</tr>

</table>

</ItemTemplate>

</asp:DataList>

</asp:Panel>

</td>

</tr>

<tr>

<td>

<asp:Panel ID="Panel2" Width="100%" runat="server">

<tr>

<td>

<asp:HyperLink ID="ShoppingCartLink" runat="server" Font-Bold="True" Font-Names="verdana"

Font-Size="Smaller" ForeColor="White" NavigateUrl="ShoppingCartPage.aspx">View Shopping Cart</asp:HyperLink></td>

</tr>

<tr>

<td>

 </td>

</tr>

</table>

</asp:Panel>

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

Page Name: ShopItem.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class ShopItem : System.Web.UI.Page

{

DataTable tablegrid = new DataTable();

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

protected void Page_Load(object sender, EventArgs e)

{

if (Session["uid"] == null)

{

Response.Redirect("login.aspx");

}

string prid = Request.QueryString["product_id"];

if (!IsPostBack)

{

DataTable dt = new DataTable();

string st = "select * from product where product_id='" + prid + "'";

SqlDataAdapter adp = new SqlDataAdapter(st, con);

adp.Fill(dt);

DataList1.DataSource = dt;

DataList1.DataBind();

}

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)

{

double Price = double.Parse(((Label)DataList1.Controls[0].FindControl("Label_cost")).Text);

string Name = ((Label)DataList1.Controls[0].FindControl("Label_name")).Text;

string PictureURL = ((Label)DataList1.Controls[0].FindControl("Label_picture")).Text;

string ProductID = Request.QueryString["product_id"];

if (Session["Cart"] == null)

{

DataTable dt = new DataTable();

DataColumn dc;

dc = new DataColumn("Price", typeof(double));

dt.Columns.Add(dc);

dc = new DataColumn("Name", typeof(string));

dt.Columns.Add(dc);

dc = new DataColumn("PictureURL", typeof(string));

dt.Columns.Add(dc);

dc = new DataColumn("ProductID", typeof(string));

dt.Columns.Add(dc);

dc = new DataColumn("quantity", typeof(int));

dt.Columns.Add(dc);

dc = new DataColumn("Total", typeof(double));

dt.Columns.Add(dc);

DataRow dr;

dr = dt.NewRow();

dr[0] = Price;

dr[1] = Name;

dr[2] = PictureURL;

dr[3] = ProductID;

dr[4] = "1";

dr[5] = Price;

dt.Rows.Add(dr);

Session["Cart"] = dt;

}

else

{

DataTable dt;

dt = (DataTable)Session["Cart"];

DataRow dr;

dr = dt.NewRow();

dr[0] = Price;

dr[1] = Name;

dr[2] = PictureURL;

dr[3] = ProductID;

dr[4] = "1";

dr[5] = Price;

dt.Rows.Add(dr);

}

Server.Transfer("ShoppingCartPage.aspx");

}

protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Redirect("product.aspx");

}

Page Name: ShoppingCart1.ascx

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ShoppingCart1.ascx.cs" Inherits="ShoppingCart1" %>

<asp:GridView id="CartGrid" OnRowUpdating="CartGrid_RowUpdating"

OnRowEditing="CartGrid_RowEditing" OnRowDeleting="CartGrid_RowDeleting"

OnRowCancelingEdit="CartGrid_RowCancelingEdit" EnableTheming="False"

DataKeyNames="ProductID" AutoGenerateColumns="False" runat="server" Width="90%"

BorderColor="White" ShowFooter="True"

onselectedindexchanged="CartGrid_SelectedIndexChanged">

<asp:TemplateField>

<asp:Image ID="Image1" runat="server" Height="100px" ImageUrl='<%# Eval("PictureURL") %>'

Width="100px" />

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="Name" HeaderText="Product" ReadOnly="True" ></asp:BoundField>

<asp:TemplateField HeaderText="Quantity">

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Quantity") %>'></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("Quantity") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="Price" HeaderText="Price" ReadOnly="True" ></asp:BoundField>

<asp:TemplateField HeaderText="Total">

<asp:Label id="Total" runat="server" Text='<%# Bind("total") %>' Font-Bold="True" ForeColor="White"></asp:Label>

</ItemTemplate>

<asp:Label id="Total1" runat="server" Text='<%# Bind("total") %>' Font-Bold="True" ForeColor="White"></asp:Label>

</EditItemTemplate>

<asp:Label id="Totallab" runat="server" Font-Bold="True" ForeColor="White"></asp:Label>

</FooterTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" ButtonType="Image" CancelImageUrl="~/image/cancle.jpg" DeleteImageUrl="~/image/delete.png" EditImageUrl="~/image/cut.png" UpdateImageUrl="~/image/update.jpg" ></asp:CommandField>

<asp:CommandField ShowDeleteButton="True" ButtonType="Image" DeleteImageUrl="~/image/remove_from_shopping_cart.png" ></asp:CommandField>

</Columns>

There is nothing in your Shopping cart.You can buy items from <a href="collection.aspx">

Shop</a>

</EmptyDataTemplate>

</asp:GridView>

<br />

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click"

ForeColor="Red">CheckOut</asp:LinkButton>

Page Name: ShoppingCart1.ascx.s

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class ShoppingCart1 : System.Web.UI.UserControl

{

DataTable dt = new DataTable();

DataTable gt = new DataTable();

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlDataAdapter adp = new SqlDataAdapter();

string celo, cel1, cel2, cel3, cel4,cel5;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}

void bindgrid()

{

if (Session["Cart"] == null)

{

CartGrid.DataSource = null;

CartGrid.DataBind();

}

else

{

CartGrid.DataSource = (DataTable)Session["Cart"];

CartGrid.DataBind();

DataTable dt = (DataTable)Session["Cart"];

if (dt.Rows.Count > 0)

{

((Label)CartGrid.FooterRow.Cells[4].FindControl("Totallab")).Text = dt.Compute("Sum(Total)", "").ToString();

}

protected void CartGrid_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

CartGrid.EditIndex = -1;

bindgrid();

}

protected void CartGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

string str = CartGrid.DataKeys[e.RowIndex].Value.ToString();

TextBox Quantity = (TextBox)CartGrid.Rows[e.RowIndex].Cells[2].FindControl("TextBox1");

int Quant = Convert.ToInt32(Quantity.Text);

DataTable dt = (DataTable)Session["Cart"];

foreach (DataRow dr in dt.Rows)

{

if (dr["ProductID"].ToString() == str)

{

double price = Convert.ToDouble(dr["Price"]);

double total = Quant * price;

dr["quantity"] = Quant;

dr["Total"] = total;

}

dt.AcceptChanges();

bindgrid();

CartGrid.EditIndex = -1;

bindgrid();

}

protected void CartGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string str = CartGrid.DataKeys[e.RowIndex].Value.ToString();

DataTable dt = (DataTable)Session["Cart"];

foreach (DataRow dr in dt.Rows)

{

if (dr["ProductID"].ToString() == str)

{

dr.Delete();

}

dt.AcceptChanges();

bindgrid();

}

protected void CartGrid_RowEditing(object sender, GridViewEditEventArgs e)

{

CartGrid.EditIndex = e.NewEditIndex;

bindgrid();

}

protected void LinkButton1_Click(object sender, EventArgs e)

{

for (int i = 0; i <= CartGrid.Rows.Count - 1; i++)

{

DataTable dt1 = (DataTable)Session["Cart"];

// celo =

celo = dt1.Rows[i][0].ToString();

string date = System.DateTime.Now.ToShortDateString();

cel1 = dt1.Rows[i][1].ToString();;

cel2 = dt1.Rows[i][2].ToString();

cel3 = dt1.Rows[i][3].ToString();

cel4 = dt1.Rows[i][4].ToString();

cel5 = dt1.Rows[i][5].ToString();

string str_ins = "insert into checkout values('" + cel3 + "','" + cel2 + "','" + cel1 + "','" + cel4 + "','" + celo + "','" + cel5 + "','" + date + "','" + Session["uid"].ToString() + "')";

adp.InsertCommand = new SqlCommand( str_ins,con);

con.Open();

adp.InsertCommand.ExecuteNonQuery();

con.Close();

}

Response.Redirect("shoping_cart.aspx");

}

protected void CartGrid_SelectedIndexChanged(object sender, EventArgs e)

{

}

Page Name: ShoppingCartPage.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ShoppingCartPage.aspx.cs" Inherits="ShoppingCartPage" %>

<%@ Register Src="ShoppingCart1.ascx" TagName="ShoppingCart1" TagPrefix="uc2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

<!--

body {

background-color: #000000;

}

-->

</style></head>

<body>

<div>

<tr>

</tr>

<tr>

 <uc2:ShoppingCart1 ID="ShoppingCart1_1" runat="server" /></td>

</tr>

<tr>

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/products.aspx"

Font-Bold="True" Font-Names="Verdana" Font-Size="Small" ForeColor="White">More Shopping</asp:HyperLink></td>

</tr>

<tr>

 </td>

</tr>

<tr>

</tr>

</table>

</div>

</form>

</body>

</html>

Page Name: ShoppingCartPage.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class ShoppingCartPage : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

protected void Page_Load(object sender, EventArgs e)

{

//if (Session["id"] == null)

//{

// Response.Redirect("Login.aspx");

//}

}

Page Name: userdetail.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="userdetail.aspx.cs" Inherits="userdetail" Title="Untitled Page" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Subscription Details</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Sponsor Id:

</td>

<td>

<asp:TextBox ID="txtsid" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

<td>

Sponsor Name: </td>

<td>

<asp:TextBox ID="txtsname" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Subscription Code:

</td>

<td>

<asp:TextBox ID="txtscode" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

<td>

Date of Application: </td>

<td>

<asp:TextBox ID="txtdoa" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Account Details </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

User Name:

</td>

<td>

<asp:TextBox ID="txtuname" runat="server" AutoPostBack="True"

ontextchanged="txtuname_TextChanged"></asp:TextBox>

<cc1:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server"

TargetControlID="txtuname" WatermarkText="User Name">

</cc1:TextBoxWatermarkExtender>

<asp:Label ID="lbluser" runat="server" ForeColor="#339966"></asp:Label>

</td>

<td>

 </td>

<td>

Placement: </td>

<td>

<asp:DropDownList ID="ddlplacement" runat="server">

<asp:ListItem>--Select--</asp:ListItem>

<asp:ListItem>Left</asp:ListItem>

<asp:ListItem>Right</asp:ListItem>

</asp:DropDownList>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Password:</td>

<td>

<asp:TextBox ID="txtpass" runat="server" TextMode="Password"></asp:TextBox>

</td>

<td>

 </td>

<td>

ConfConfirm Password:

</td>

<td>

<asp:TextBox ID="txtcpass" runat="server" TextMode="Password"></asp:TextBox>

<asp:CompareValidator ID="CompareValidator1" runat="server"

ControlToCompare="txtpass" ControlToValidate="txtcpass"

ErrorMessage="Mismatch Password"></asp:CompareValidator>

</td>

<td>

 </td>

</tr>

<tr>

Security Question :</td>

<asp:DropDownList ID="ddlsquestion" runat="server">

<asp:ListItem>--Select--</asp:ListItem>

<asp:ListItem>Your Favoroute Colour</asp:ListItem>

<asp:ListItem>Your fathers mid name</asp:ListItem>

<asp:ListItem>your pets name</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

</td>

</td>

Security Answer :</td>

<asp:TextBox ID="txtsans" runat="server"></asp:TextBox>

</td>

</td>

</tr>

<tr>

 </td>

 </td>

 </td>

 </td>

 </td>

 </td>

</tr>

<tr>

<td>

Personal Details </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Name:

</td>

<td>

<asp:TextBox ID="txtname" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"

PopupButtonID="Image1" TargetControlID="txtdob">

</cc1:CalendarExtender>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Date of Birth: </td>

<td>

<asp:TextBox ID="txtdob" runat="server"></asp:TextBox>

<asp:Image ID="Image1" runat="server" ImageUrl="~/image/cal.gif" Width="16px" />

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Contact Number:</td>

<td>

<asp:TextBox ID="txtcnum" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

<td>

Email:

</td>

<td>

<asp:TextBox ID="txtemail" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Country:</td>

<td>

<asp:TextBox ID="txtcountry" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

<td>

State:</td>

<td>

<asp:TextBox ID="txtstate" runat="server" Enabled="False"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

District:</td>

<td>

<asp:TextBox ID="txtdistrict" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

City:</td>

<td>

<asp:TextBox ID="txtcity" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Postal Code:</td>

<td>

<asp:TextBox ID="txtpcode" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

Address:</td>

<td>

<asp:TextBox ID="txtadd" runat="server" TextMode="MultiLine"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: userdetail.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class userdetail : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlCommand cmd;

SqlCommand cmd1;

SqlCommand cmd2;

SqlCommand cmd3;

SqlCommand cmd4;

SqlCommand cmd5;

SqlCommand cmd6;

SqlCommand cmd7;

SqlDataAdapter adp;

string status = "Unused";

int total1, child1;

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

string str_select = "select name from registration where user_name='" + Session["sid"].ToString() + "'";

adp = new SqlDataAdapter(str_select, con);

adp.Fill(dt);

txtsname.Text = dt.Rows[0][0].ToString();

txtsid.Text = Session["sid"].ToString();

txtscode.Text = Session["scode"].ToString();

txtemail.Text = Session["email"].ToString();

txtcnum.Text = Session["cnum"].ToString();

txtcountry.Text = Session["country"].ToString();

txtstate.Text = Session["state"].ToString();

txtdoa.Text = System.DateTime.Today.ToShortDateString();

}

protected void Button1_Click(object sender, EventArgs e)

{

string str_update = "update registration set sponser_name='" + txtsname.Text + "', doa='" + txtdoa.Text + "', user_name='" + txtuname.Text + "', password='" + txtpass.Text + "',squestion='" + ddlsquestion.SelectedItem.Text + "',sans='" + txtsans.Text + "',placement='" + ddlplacement.SelectedItem.Text + "',name='" + txtname.Text + "',dob='" + txtdob.Text + "',district='" + txtdistrict.Text + "',city='" + txtcity.Text + "',pin='" + txtpcode.Text + "',address='" + txtadd.Text + "' where regid='" + Session["regid"].ToString() + "'";

cmd = new SqlCommand(str_update, con);

con.Open();

cmd.ExecuteNonQuery();

Session["name"] = txtname.Text;

string total = "select total_income from tbl_totalincome where user_name='" + txtsid.Text + "'";

SqlDataAdapter adp1 = new SqlDataAdapter(total, con);

DataTable dt1 = new DataTable();

adp1.Fill(dt1);

//int co = dt1.Rows.Count;

//if (co == 1)

//{

string total_income = dt1.Rows[0][0].ToString();

//}

string child = "select child_income from commission where user_name='" + txtsname.Text + "'";

SqlDataAdapter adp2 = new SqlDataAdapter(child , con);

DataTable dt2 = new DataTable();

adp1.Fill(dt2);

string child_income = dt2.Rows[0][0].ToString();

int totali = Convert.ToInt16(total_income.ToString());

int childi = Convert.ToInt16(child_income.ToString());

totali = totali + 1000;

childi = childi + 1000;

string str1_update = "update tbl_totalincome set total_income= "+totali+" where user_name='" + txtsname.Text + "'";

cmd3 = new SqlCommand(str1_update, con);

cmd3.ExecuteNonQuery();

string str2_update = "update commission set child_income="+ childi+" where user_name='" + txtsname.Text + "'";

cmd4 = new SqlCommand(str2_update, con);

cmd4.ExecuteNonQuery();

String str1_insert = "insert into tbl_totalincome values('" + txtuname.Text + "',0)";

cmd5 = new SqlCommand(str1_insert, con);

cmd5.ExecuteNonQuery();

String str2_insert = "insert into commission values('" + txtuname.Text + "',0,0,0)";

cmd6 = new SqlCommand(str2_insert, con);

cmd6.ExecuteNonQuery();

string str3_update = "update subcode set status='Used' where scode='" + txtscode.Text + "'";

cmd7 = new SqlCommand(str3_update, con);

cmd7.ExecuteNonQuery();

con.Close();

Session["uid"] = txtuname.Text;

con.Close();

Response.Redirect("welcome.aspx");

}

protected void txtuname_TextChanged(object sender, EventArgs e)

{

string str_select = "select * from registration where user_name='" + txtuname.Text + "'";

SqlDataAdapter adp = new SqlDataAdapter(str_select, con);

DataTable dt = new DataTable();

adp.Fill(dt);

int a = dt.Rows.Count;

if (a == 1)

{

lbluser.ForeColor=System.Drawing.Color.Red ;

lbluser.Text="User Name Not Available";

}

else

{

lbluser.ForeColor = System.Drawing.Color.Green;

lbluser.Text = "User Name Available";

}

Page Name: userinfo.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="userinfo.aspx.cs" Inherits="userinfo" Title="Untitled Page" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Subscription Details</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Sponsor Id:

</td>

<td>

<asp:TextBox ID="txtsid" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

Sponsor Name:

</td>

<td>

<asp:TextBox ID="txtsname" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Subscription Code:

</td>

<td>

<asp:TextBox ID="txtscode" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

Date of Application:

</td>

<td>

<asp:TextBox ID="txtdoa" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Account Details

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

User Name:

</td>

<td>

<asp:TextBox ID="txtuname" runat="server" AutoPostBack="True"

ontextchanged="txtuname_TextChanged"></asp:TextBox>

<cc1:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server"

TargetControlID="txtuname" WatermarkText="User Name">

</cc1:TextBoxWatermarkExtender>

</td>

<td>

 </td>

<td>

Placement:

</td>

<td>

<asp:TextBox ID="txtplace" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Password:</td>

<td>

<asp:TextBox ID="txtpass" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

 </td>

 </td>

</td>

 </td>

 </td>

</td>

</tr>

<tr>

 </td>

 </td>

 </td>

 </td>

 </td>

 </td>

</tr>

<tr>

<td>

Personal Details

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Name:

</td>

<td>

<asp:TextBox ID="txtname" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Date of Birth:

</td>

<td>

<asp:TextBox ID="txtdob" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"

PopupButtonID="Image1" TargetControlID="txtdob">

</cc1:CalendarExtender>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

Contact Number:</td>

<td>

<asp:TextBox ID="txtcnum" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

Email:

</td>

<td>

<asp:TextBox ID="txtemail" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

Country:</td>

<td>

<asp:TextBox ID="txtcountry" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

State:</td>

<td>

<asp:TextBox ID="txtstate" runat="server"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

District:</td>

<td>

<asp:TextBox ID="txtdistrict" runat="server"></asp:TextBox>

</td>

<td>

</td>

<td>

City:</td>

<td>

<asp:TextBox ID="txtcity" runat="server"></asp:TextBox>

</td>

<td>

</td>

</tr>

<tr>

<td>

Postal Code:</td>

<td>

<asp:TextBox ID="txtpcode" runat="server"></asp:TextBox>

</td>

<td>

 </td>

<td>

Address:</td>

<td>

<asp:TextBox ID="txtadd" runat="server" TextMode="MultiLine"></asp:TextBox>

</td>

<td>

 </td>

</tr>

<tr>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Back" />

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: userinfo.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class userinfo : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(“Data Source=.;Initial Catalog=earnmoney;Integrated Security=True”);

SqlDataAdapter adp;

string status = "Unused";

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

string str_select = "select * from registration where user_name='" + Session["uid"].ToString() + "'";

adp = new SqlDataAdapter(str_select, con);

adp.Fill(dt);

txtsid.Text = dt.Rows[0][1].ToString();

txtsname.Text = dt.Rows[0][8].ToString();

txtscode.Text = dt.Rows[0][2].ToString();

txtdoa.Text = dt.Rows[0][9].ToString();

txtuname.Text = dt.Rows[0][10].ToString();

txtplace.Text = dt.Rows[0][14].ToString();

txtpass.Text = dt.Rows[0][11].ToString();

txtname.Text = dt.Rows[0][15].ToString();

txtcnum.Text = dt.Rows[0][5].ToString();

txtdob.Text = dt.Rows[0][16].ToString();

txtemail.Text = dt.Rows[0][4].ToString();

txtcountry.Text = dt.Rows[0][5].ToString();

txtcity.Text = dt.Rows[0][18].ToString();

txtdistrict.Text = dt.Rows[0][17].ToString();

txtstate.Text = dt.Rows[0][7].ToString();

txtpcode.Text = dt.Rows[0][19].ToString();

txtadd.Text = dt.Rows[0][20].ToString();

}

protected void txtuname_TextChanged(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

}

Page Name: welcome.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="welcome.aspx.cs" Inherits="welcome" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<span style="text-decoration: underline">Our Motto Is Your <b>Golden Future</b>

With A <b>Healthy Income</b></span>.</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

WELCOME      <asp:Label ID="Label1" runat="server" style="font-weight: 700"></asp:Label>

   In The World Of <b>Rich Peoples</b>.</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

 Now You Are <b>Registered Member</b> Of <b>EarnMoney.com</b> </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click"

Text="New Registration" />

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</asp:Content>

Page Name: welcome.aspx.s

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class welcome : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

Label1.ForeColor = System.Drawing.Color.Blue;

Label1.Text = Session["name"].ToString();

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Redirect("Registration.aspx");

}

Validation Check

Page Name : Registration.aspx

Page Name : changepass.aspx

Page Name : contactus.aspx

Page Name : feedback.aspx

Page Name : login.aspx

Page Name : userdetail.aspx

Code efficiency

Optimization of code: Optimization of code is done by applying code transformation to improve performances like execution time, code size, minimum resource utilization etc?. These transformations can be made at high level or at low level.

In computing, optimization is the process of modifying a system to improve its efficiency. The system can be a single computer program, a collection of computers or even an entire network such as the Internet. Good code optimization can make your code run faster and use fewer server resources, and can even have the effect of making code easier to debug and maintain. The main point of optimization is to improve the code. There are two aspects:

I) make the program faster (in terms of execution steps)

ii) Make the program smaller (in terms of memory)

CODE Optimization

The basic design model uses the analysis model as the framework for implementation. The analysis model captures the logic information about the system, while the design model must add details to support efficient information access.

During design optimization we must:

· Add redundant association to minimize access cost and maximize convenience.

· Rearrange the computation for greater efficiency.

· Save derived attributes to avoid re-computation of complicated expression.

· During report generation we used optimization techniques of rearranging execution order for greater efficiency.

For example we had to make the report of consumers of two areas say A and B and the numbers of customers living in area A are more so we should first find the customers of area A and eliminate the dead path as early as possible.

Redundancy of data in the table has been removed through Normalization technique. All the tables are designed in normalized form.

Implicit and Explicit locks are used wherever needed.

Implementation

Introduction: -

A crucial phase in then systems life cycle is the successful implementation of the new system design. Implementation means converting a new system design into operation. This creating computer-compatible files, training the operating staff before the system is up and running. A major factor in conversion is not disrupting the functioning of the organization.

The implementation phase of software development is also concerned with translating design specification into source code. It is necessary to write source code and internal and documentation so that conformance of the code to its specification can be easily verified, and so that debugging, testing and modification are eased. This can be achieved by making the source code as clear and straight forward as possible. The implementation team should therefore be provided with-defined set of software requirements, an architectural design specification and a detailed design description.

User training is another important area, which is responsible for minimizing resistance to change and giving the new system a chance to provide its worth. Training aids, such as user-friendly manuals, data dictionary, and jobs performance aids that communication information about the new system; help-screens provide the user with a good start on the new system.

Following conversion, it is desirable to review the performance of the system and to evaluate it against established criteria. Software maintenance follows conversion, which includes minor enhancements or corrections to problems that surface late in the system's operating.

Conversion:

The objective of conversion is to put the system into operation while holding costs, risks and personal problems to a minimum. It involves three major steps:

Creating computer-compatible files
Training the operating staff
Installing hardware/software

Procedure and documents are unique to the conversion phase. These are shown below:

§ Conversion begins with a review of the project plan, the system test documentation, and the implementation plan. The parties involved are the user, the project team, programmers, and operators.

§ The conversion portion of the implementation plan is finalized and approved.

§ Files are converted.

§ Parallel processing between the existing and the new systems is initiated.

§ Results of computer runs and operators for the new system are logged on a special form.

§ Assuming no problems, parallel processing is discounted. Implementation results are documented for reference.

§ Conversion is completed. Plans for the post-implementation review are prepared. Following the review, the new subsystem is officially operational.

File Conversion: -

File conversion involves capturing data and creating a computer file from existing files. There can be problems like staff shortage for loading data. Also, specialized training necessary tom prepares records in accordance with the new system specifications. In most cases, an outside agency performs this function for a flat rate .If a computerized system already exists, then copying existing files for the new system is a concern area. If a computerized system already exists, then copying existing files for the new system is a concern area. Program can be written to copy files intact for the new system and test programs on both systems. A file comparison program can be used for this purpose.

Many systems are prone to errors because of insufficient attention given to data entry control or protective features like audit control trails. These items must be part of the overall plan for conversion. Before a data entry operator starts working, a data entry validation program can be written to keep track of wrong data entered.

At the time installation of the software it is required that SQL server must be installed on the server of the company and it must contain the data files related to the software before implementing the developed system on all machines machine connected to the server. For this the exported data is imported to the client machine and the database is checked that all tables are properly imported to the client machine or not as the software is developed in SQL server data base and also going to be implemented in oracle there is no other conversion is required. A good audit control trail is the key to detecting fraud and errors in data entry.

User Training: -

Analysis of user training focuses on two factors-user capabilities and the nature of the system being installed. The requirements of the system also range from very simple tasks like using a pocket calculator to complex tasks like learning to program a database system. Tasks that require the user to follow a well-defined, concrete, step-by-step procedure-require limited problem solving .For this, the training level and duration is basic and brief.

Training Aids: -

The most frequently used user training aids are:

§ User manual-

Contains information about functionality of the software available to the user, what each option can do, how these are executed and how diagnostic should be handled. The manual should be organized and indexed for quick reference. Graphics, pictures and schematic diagrams enhance the readability of the manual. The software is prohibited with both offline and online help. Offline help is document (User manual), which is the prohibited with the software that also contains user form feed, which can be used by the client company to report any bugs in the software. Offline help helps the user to read the functionality and operation manuals about the software. Online help is the

§ Help, which is available to the user at his figure tips, and user can get he instant help whenever he faces any problem regarding the software operations. Online help helps the user to get the immediate support, as it is not possible to read the manual for a small problem when the user is sitting on the computer and he feels comfortable if he gets the help by pressing <f1> key.

§ Help screens-

This feature is available in every software. The user selects a help option from a menu. The system accesses the necessary description or information for user reference.

§ Data Dictionary-

Can be part of user manual, describing data element names used in the manual.

§ Job Aids-

Communicate essential information about certain jobs. Forms are used to show the relevant information. For example:

§ Color printing in forms to highlight headings.

§ Color to identify pieces of hardware, cables etc.

§ Wall charts to illustrate schematics of processing information.

§ Flowcharts to guide the user for detecting and handling errors, restarting the system etc.

Hardware/Software Installation: -

Adequate time and resources for installation of software and hardware must be allotted in the development schedule. Users can be trained on the installation procedure. The detailed instructions can be a part of the user manual.

Maintenance

Software maintenance is used to describe the software engineering activities that occur following delivery of a software vehicle to the customer
Activities involved in maintenance of a software vehicle include:

Analysis activities
Standards and guidelines
Design activities
Implementation activities
Supporting documents

§ Configuration management is concerned with tracking and controlling of the work vehicle that constitute a software vehicle

§ Configuration management tools include

· Configuration management data bases

· Version control libraries

§ Automated tools to support software maintenance include technical support tools and managerial support tools

§ Other automated tools include

· Text editor

· Debugging aids

· Linkage editor

Computer Maintenance covers a wide range of activities. Many activities performed during development of Airlines Reservation System for Global Airways to enhance the maintainability of it are as follows---

Analysis Activities

The analysis phase of software development is concerned with determining customer requirements and constraints, and establishing feasibility of the vehicle. From maintenance view point, the most important activities that occur during analysis are establishing standards and guidelines for the project and the work Brands, Models to ensure uniformity of the Brands, Models; setting of milestones to ensured that the work Brands, Models are produce on schedule; specifying quality assurance procedures to ensure development of high quality documents; identifying vehicle enhancements that will most likely occur following initial delivery of the system; and estimating the resources( personnel, equipment, floor space) required to perform the maintenance activities.

o Standards and Guidelines

various types of standards and guidelines we developed to enhance the maintainability of our software.

o Design Activities

Design is concerned with developing the functional components, conceptual data structures and interconnection in a software system. The most important activity for enhancing maintainability during the design.

Automated tools to support software maintenance include technical support tools and managerial support tools. Tolls to support the technical aspects of software maintenance span the spectrum from analysis and design tolls to implementation to debugging and testing tools. Automated tolls include text editors debugging aids, cross-reference generators, linkage editors, comparators, complexity metric calculators, and version control system and configuration management databases.

Text editor permits rapid, efficient modification of source programs, test data and supporting documents. Text editors can be used to insert and replace segments of source code, internal comments, test data and supporting documents; to systematically change all occurrences of an identifier or other textual strings to locate all references to a given identifier or other string of text; and to save both old and new versions of a routine, test file or document. A syntax-directed text editor can ensure that all cross-references in text editor can ensure that all cross-references in the supporting documents are correctly updated.

Debugging aids provide traps, dumps, and traces assertion checking and history file aid in locating the causes of known errors. System-level-cross-reference generators provide cross-reference listings for procedure calls, statements usage and data references. Cross-references directories provide the calling structures of who calls whom and from where, and procedures names and statement numbers where formal parameters local variables and global variables are defined, set and used.

As we already know maintenance of the software is an important part of using it. Thus various maintenance procedures have to be followed.

Testing Techniques & Strategies

Software testing is a critical element of software quality assurance and represents the ultimate review of specification, design and coding testing requires that the developer discard preconceived notions of the “correctness” of software just developed and overcome a conflict of interest that occurs when errors are uncovered.

Testing is a process of executing a program care is one that have a high probability of finding an as yet undiscovered error. A successful test is one that uncovers an as-yet undiscovered error.

Testing is the necessary part of the project the various methods are used for testing the software. The new look to the project is giving by the perfect testing. I prefer the black box testing method. Black - box testing , focuses on the functional requirements of the software. That is black - box testing enables the software engineer to derive sets of input conditions that will fully exercise all functional requirements for a program. Black - box testing is not an alternative to white - box techniques Rather, it is a complementary approach that is likely to uncover a different class of errors than white - box methods.

Black - box testing attempts in following categories :-

(1) In correct or missing functions.

(2) Interface errors.

(3) Errors in data structures or external data base access.

(4) Performance errors.

(5) Initialization and termination errors.

Firstly, test the incorrect or missing function in the project design, testing all modules and their dependent modules such as for new care, detail of old care, forwarding of case reminder of case and disposal of case.

Secondly, test the interface of the software. The input and output of the project also depends upon the interface use, so that all links should be display accordingly.

Thirdly, testing on the data that are use, it should be properly fitted. The connectivity should be proper.

Fourthly, the performance error, testing is also done on the performance error, checking the display time, loading time, clear picture and message.

Finally, testing on the idealization and termination error, test the proper loading of the input data easily connection of the data and display of cases.

Unlike white - box testing, which is performed early in the testing process, black- box testing tender to be applied during later stages of testing. Because black - box testing purposely disregards control structure, alteration is focused on the information domain.

By applying black box techniques, we derive a set of test cares that satisfy the following criteria

(1) Test cares that reduce, by a count that is greater that one, the number of additional test cares that must be designed to achieve reasonable testing.

(2) Test cares that tell use something about the presence or absence of classes of errors rather then errors associated only with specify test at hand.

System Security Measures:

Computer system security mechanism includes authentication access control flow control, auditing and cryptography.

Authentication:

The primary goal of authentication is to allow access to legitimate system users and to deny access to unauthorized parties. The two primary measures of authentication effectiveness are

The false acceptance rate, that is the percentage of illegitimate users erroneously admitted, and
The false rejection ratio. That is the percentage of legitimate users who are denied access due to failure of the authentication mechanism. Obviously the objective is to minimize both the false acceptance and the false rejection ratio. One way authentication is usually based on:
Possession of the secret (password)
Possession of an artifact.
Unique physiological or behavioral characteristics of the user but for my software, I have chosen the authentication based on password.

Cost Estimation Of The Project

For a given set of requirements it is desirable to know how much it will cost to develop the software to satisfy the given requirements, and how much time development will take. These estimates are needed before development is initiated. The primary reason for cost and schedule estimation is to enable the client or developer to perform a cost benefit analysis and for project monitoring and control. A more practical use of these estimates is in bidding for software projects, where the developers must give cost estimates to a potential client for the development contract.

For a software development project, detailed, and accurate cost and schedule estimates are essential prerequisites for managing the project. Otherwise, even simple question like “is the project late”, “are there cost overruns”, and “when is the project likely to complete” cannot be answered. Cost and schedule estimate are also required to determine the staffing level for a project a deferent phase. It can be safely said that cost and schedule estimates are fundamental to any form of management and are generally always required for a project .

Cost in a project is due to the requirement for software, hardware, and human resources. Hardware resources are such thing as the computer time, terminal time, and memory required for the project, whereas software resources include the tool and compilers needed during development .The bulk of the cost of software development is due to the human resources needed, and most cost estimation procedure focus on this aspect. Most cost estimates are determined in terms of person-month (PM). By properly including the “overheads” in rupees cost of a person-month, besides including the direct cost of the person month, most costs for a project can be incorporated by using PM as the basic measure. Estimates can be based on subjective opinion of some person or determined through the use of models.

The costs associated with the system are expenses, outlays or losses arising from developing and using a system. But the benefits are the advantages received from installing and using this system.

Cost and benefits can be classified as follow:

Tangible or intangible

Cost that are known to exist but their financial value cannot be exactly measured are referred to as intangible costs. The estimate is only an approximation. It is difficult to fix exact intangible costs. For example, employee movable problems because of installing new system are an intangible cost. How much moral of an employee has be affected can not be exactly measured in terms of financial value.

Fixed or variable

Some costs and benefits remain constant, regardless of how a system is used. Fixed costs are considered as sunk costs. Once encountered, they will not recur. For example, the purchase of an equipment for a computer center is called as fixed cost as it remains constant whether in equipment is being is called as fixed cost as it remains constant whether in equipment is being used extensively or not. Similarly, the insurance, purchase of software etc. Contrast, variable costs are incurred on a regular basis. They are generally proportional to work volume and continue as long as the system is in operation. For example, the cost of forms varies in proportion to the amount of processing or the length of the reports desired.

Direct or indirect-

Direct cost are those which are directly associated with a system. They are applied directly to the operator. For example, the purchase of floppy for Rs 500/- is a direct cost because we can associate the floppy box with money spent.

Direct benefits also can be specifically attributable to a given project. For example, a new system that can process 30 percent more transactions per day is a direct benefit.

Indirect cost are not directly associated with a specific activity in the system. They are often referred to as overhead expenses. For example, cost of space to install a system, maintenance of computer center, heat, light and air-conditioning are all tangible costs, but it is difficult to calculate the proportion of each attributable to a specific activity such as a report.

The estimation of cost of the project is a difficult task but we can estimate the cost of the project by various methods. I am using the COCOMO (Constructive Cost Model). The model has following hierarchy: -

Model 1: - The basic COCOMO model computed software development effort land cost as a function of program size expressed in estimated lines of code.

Model 2: - The intermediate COCOMO model computer software

development effort as a function of program size and a set of “cost drivers”

that include subjective assessments of vehicle, hardware personnel and

project attributes.

Model 3: - The advanced COCOMO model incorporates all characteristics

of the intermediate version with an assessment of the cost drivers impact on each step (analysis, design etc.) of the software engineering process.

The COCOMO model is defined for three classes of software projects are: -

1) Organic Mode:- Relatively small, simple projects in which small teams with good application experience work to a set of less than rigid requirements.

2) Semidetached Mode:- An intermediate (in size and complexity) software project in which teams with mixed experience levels must meet a mix of rigid and less than rigid requirements.

3) Embedded Mode:- A software project that must developed within a set of tight hardware, software and operational constraints.

The basis COCOMO equation takes the form.

E = a_b KLOC^b_b

D = C_b E^d_b

When E is the effort applied in person months, D is the development time in chronological months, and KLOC is the estimated number of delivered lines of code for the project. (Express in thousands). The coefficients a_b and c_b and the exponents b_b and d_b where taken as.

This project is an organic project so: -

a_b = 4

b_b = 1.05

c_b = 2.5

d^b = 0.38

LOC = 1555

KLOC = 3000/1000 = 3.0

E = 2.4 (KLOC)^1.05

= 2.4(3.0)^1.05

= 7.6

= 7 person-months

New calculate the D is the development time in chronological months

D = 2.5 E ^0.35 = 2.5 (8) ^0.35 = 5.2 months

= 5 months approximately

The computer project duration we use the effort estimated described above

N = E/D = 7/5

= 1.4 person = 1 person

When N is the recommended number of people for the project.

PLANNING AND SCHEDULING

PERT Chart

A PERT chart is a graph-based chart. It can be used to determine the activities that from the “critical path”, which if delayed will cause the overall project to delay. The PERT chart for the project is:

PERT Chart

Phases	Old Project		New Project
Phases	No. Of Days	Extra Days	No. Of Days	Extra Days
Fact finding	15	5	10	3
Analysis	20	3	15	5
Designing	25	5	20	5
Coding	20	5	20	5
Testing	10	2	10	2
Maintenance	35	10	32	10

GANTT Chart

A GANTT chart uses a calendar-oriented chart to represent the project schedule. Each activity is represented as a bar in the calendar, starting from the start date of the activity and ending at the ending date for that activity. The start and end of each activity becomes milestones for the project. The GANTT chart for this project is:

GANTT Chart

Old Project

New Project

Fact finding Analysis Designing Testing Maintenance Coding

Future Scope

If we can move the software on-line a new agent can join the company from his own city without going to the company thus a wide area of network the company can cover

FREE DOWNLOAD IGNOU BCA MCA PROJECT, SYNOPSIS AND FINAL REPORT WITH SOURCE CODE

Friday, May 15, 2020

Online Multi level Marketing

ONLINE MULTI-LEVEL MARKETING SYSTEM PROJECT REPORT | ONLINE MULTI-LEVEL MARKETING SYSTEM

Project Overview

OBJECTIVE

TOOLS & PLATFORM

ASP.NET 2008(C#)

REQUIREMENT SPECIFICATIONS

CLIENT SOFTWARE REQUIREMENTS

ENTITY DIAGRAM:-

ENTITY RELATIONSHIP DIAGRAM:-

MODULE AND THEIR DESCRIPTION

3. VARIABLE MANAGEMENT

Table: Agent_info

Field name Data type Size Key

Table: Agent_payment

Field name Data type Size Key

Table: Category_child

Table: Commission_register

Field name Data type Size Key

Field name Data type Size Key

Table: Item_info

Table: Kit_item

Table: Registration

Table: Level_percentage

Table: Security

Table: Stock_info

Table: Transaction

Table: Unit-info

Table: Employee Register

Table: Leave

Table: Designation

Table: Deduction

Table: Allowance

1. Category information: -

4. Agent information: -

5 Payment modes: -

Report:-

Utilities: -

FUTURE SCOPE

PROJECT REPORT

Objectives of Project

System Analysis

1.1 Identification Of Need

Software Requirement Specification

Software Requirement

System Design

Code efficiency

CODE Optimization

Implementation

User Training: -

Hardware/Software Installation: -

Maintenance

Black - box testing attempts in following categories :-

No comments:

Post a Comment

SQL Server Unique Constraint