VDCA

Major Operations

The following are the major operations of this application.

• User logs into site with username and password
• Adding details of new team
• Adding details of new player
• Adding details of a match
• Adding batting details of a match
• Adding bowling details of a match
• Modifying the details of teams
• Modifying the details of players of a team
• Allowing user to change password
• Displaying all matches
• Displaying the Scoreboard of a match
• Displaying the details of players of a team.
• Search for matches
• Providing Webservice

Technologies and Products used

• ASP.NET
• .Net Framework 1.1
• Visual Studio.Net 2003
• SQL Server 2000

The following table lists operations and associated objects and files.

Operation	Files
Login	login.aspx
Home Page	home.aspx
Adding Team	addteam.aspx
Adding Player	addplayer.aspx
Adding Match	addmatch.aspx, AddMatch Stored Procedure
Adding Batting Details	addbatting.aspx
Adding Bowling Details	addbowling.aspx
Searching For matches	search.aspx
Displaying all matches	allmatches.aspx, GetFirstTeam and GetSecondTeam stored functions
Change Password	changepassword.aspx
Logout	logout.aspx
Default Page	default.aspx
Modify Teams	modifyteam.aspx
Players of a team	teamplayers.aspx
Modifying details of a players of a team	modifyplayers.aspx (not included)
Scoreboard of a Match	scoreboard.aspx, batting.aspx, bowling.aspx
Creating required Tables	tables.txt
Creating ADDMATCH stored procedure	addmatch.sql
Creating GETFIRSTTEAM stored function	getfirstteam.sql
Creating GETSECONDTEAM stored function	getsecondteam.sql
Configuration Details	web.config
Pictures related to players	JPG files in IMAGES directory.
Web Service	all\WSVdca.asmx
Configuration of Web Service	all\web.config

The following are the steps to related to be taken to run the existing part of the application :

1. Download vdca.zip and unzip it into C:\INETPUB\WWWROOT directory (assuming Windows is installed in C drive) li>Connect to SQL Server and create VDCA database as follows:
   CREATE DATABASE VDCA
2. Make VDCA the current database by giving the following command
   USE VDCA
3. Create required tables using TABLES.TXT file and also insert some data into USERS table.
4. Start IIS and create a virtual directory with the name VDCA and make it refer to physical directory C:\INETPUB\WWWROOT\VDCA
5. Open Visual Studio.Net 2003 and open the project from C:\INETPUB\WWWROOT\VDCA.
6. Build the project.
7. Invoke IE and give the following URL:
   http://localhost/vdca
   It should display Login Page. Login in with user name and password that inserted into USERS table.