Project Report On Matrimonial Site: Skncoe
Project Report On Matrimonial Site: Skncoe
Project Report On Matrimonial Site: Skncoe
on
MATRIMONIAL SITE
CLASS: TE DIV- 1
DEPARTMENT OF COMPUTER ENGINEERING
SUBMITTED BY:
PRANALI KELAPURE (34)
SKNCOE Page 1
Table of Contents
1) Introduction ……………….……………………………………………….4
SKNCOE Page 2
1. Introduction
The internet has a lot of online dating and matrimonial sites from which you can expect
to find a prospective bride or groom for yourself. Most of these sites are genuine and charge a
little from you in turn for the services they provide you with. Further, most of these sites have a
huge collection of profiles from both the sexes. So you will not have trouble in finding your soul
mate from among these profiles. Matrimonial sites require you to submit a profile for yourself. In
order to get your match online you need to make a profile and post it on the site.
1.1 Purpose
Earlier it was mostly the parents, grandparents, relatives, advisors or the local
matrimonial channels that use to search for the right match for their children. But, the search
therefore was within and limited to their areas such as religion, caste, community, location, etc.
Even if the matrimonial advertisement is given in the newspaper, the voice is still restricted to
the territory where that newspaper is circulated. Thus many problems are faced by a customer
including the time needed , due to distance factor and also the customer had to go to the local
matrimonial offices and then would also have to wait in queue.
This was very much overcomed by the online matrimonial system. The online
matrimonial site provides a platform for connecting people from worldwide. These sites provide
choices in all areas and one gets an unlimited access to different types of profiles from different
religions, cities, states and countries, Creating an online matrimonial profile plays an important
role in carving relationships and is now one of the most trustworthy sources of matrimony.
1.2 Scope
The matrimonial website is basically a platform where people can register themselves by
creating a profile and easily find their life partners. This site contains huge database of users,
through which the match lists will be provided to individual users , that means , you can select
SKNCOE Page 3
from the wide variety of matrimonial profiles and not just the people you know. You can literally
shortlist the suitable matches based on education, religion, caste, salary, location, hobbies,
personality and even looks. Similarly you can post your profile and let others contact you in the
same way. You can even include or exclude people with special circumstances like people with
disabilities, divorce or widow. As there are millions of profiles online, the biggest advantage of
finding a match online is undoubtedly "The Choice". For this, the database will be handled with
the help of various operations like insertion, deletion, modification etc.
1.3 References :
2. OVERALL DESCRIPTION:
SKNCOE Page 4
according to the changes made.
Use cases:
2.2.1 Login :
Diagram :
Login
Admin/Operator /
User
Priority Essential
Basic Path 1. User chooses the option for login from the home page.
2. When login window is displayed he should enter the valid user name
and password.
3. Access his account.
Alternative path N/A
SKNCOE Page 5
2.2.2 Registration :
Diagram :
Registration
User
Priority High
Post condition The user will get a confirmation mail and become a permanent member.
Exception 1. Incomplete information: user will have to fill all mandatory fields
specified.
SKNCOE Page 6
2.2.3 Viewing match-list:
Diagram :
User
Priority Essential
Precondition The user must be a registered member and has given priorities for the
search.
Basic Path 1. User chooses the option for viewing the match-list.
2. Priority for assembling the list is selected for example education.
2. Accordingly the match-list of members having specified education is
displayed.
3. User will choose a match from the list.
4. If interested, sends request to operator for further details.
Alternative path N/A
Post condition He will either search for another match or if interested, he will get
information requested.
Exception If the registration is not renewed.
SKNCOE Page 7
2.2.4 Renew Registration:
Diagram:
Renew Registration
User
Exception path Report invalid card details: User reenters card details.
SKNCOE Page 8
Diagram:
Operator
Priority Essential
Precondition 1. Operator must be logged in.
2. User has sent a request for registration.
Basic path 1. Operator views the Request
2. Operator sends email regarding the password and id.
Alternative N/A
path
Post condition Successful Registration
Exception path N/A
SKNCOE Page 9
Diagram:
View report
Admin
Easy to use.
Easy to navigate.
Intuitive.
SKNCOE Page 10
Efficient.
Functional.
Our Online Matrimonial Website application follows all these principle of effective user
interface design. Users quickly see the options on the portal, grasp how to use the site and
proceed accordingly. It does not concern the user with the inner workings of the system.
The user interface will be a web page, which gives user an environment and facility of
registering and finding an appropriate match from the database. The web page will provide
recharge facility according to balance status. All pages of the system are following a consistent
theme and clear structure. In order to reduce the amount of text input from user the site will use
check boxes and drop down menu.
Availability:
The system should be available 24 X 7, meaning the user can access it using a web
browser, only restricted by the down time of the server on which the system runs.
Reliability:
The reliability of the overall program depends on the reliability of the separate
components. The main pillar of reliability of this system is the backup of the database
which is continuously maintained and updated to reflect the most recent changes.
Security:
Passwords will be saved in the database in order to ensure the user's privacy.
Certain functions will be assigned to certain modules only.
Portability:
SKNCOE Page 11
The end-user part is fully portable and any system using any web browser should be able
to use the features of the application, including any hardware platform that is available or
will be available in the future.
2.5 Assumptions and Dependencies:
3. Design
3.1 Database Design:
To incorporate the Database Design 6 tables will be formed which will store all the attributes
depending on their usage. The tables are:
1) Login table :
login
ATTRIBUTES DATA TYPE DESCRIPTION
USERNAME STRING PRIMARY KEY
PASSWORD STRING
STATUS NUMBER
person_info
ATTRIBUTES DATA TYPE DESCRIPTION
UNAME STRING : VARCHAR2 PRIMARY KEY
FNAME STRING : VARCHAR2
MNAME STRING : VARCHAR2
LNAME STRING : VARCHAR2
AGE NUMBER
SEX STRING : VARCHAR2
HT NUMBER
WT NUMBER
SKNCOE Page 12
COMPX STRING : VARCHAR2
DOB STRING : VARCHAR2
POB STRING : VARCHAR2
EDU STRING : VARCHAR2
MAR_ST STRING : VARCHAR2
HOB STRING : VARCHAR2
REG STRING : VARCHAR2
prof_info
ATTRIBUTES DATATYPE DESCRIPTION
JOB_DES STRING : VARCHAR2
COMP STRING : VARCHAR2
ANN_IN NUMBER
UNAME STRING : VARCHAR2
Fam_info
ATTRIBUTES DATATYPE DESCRIPTION
FNAME STRING : VARCHAR2
FQUAL STRING : VARCHAR2
FJOB STRING : VARCHAR2
MNAME STRING : VARCHAR2
MQUAL STRING : VARCHAR2
MJOB STRING : VARCHAR2
SIB NUMBER
FAM_STR STRING : VARCHAR2
MEM NUMBER
UNAME STRING : VARCHAR2
5) Horoscope table
Horo
ATTRIBUTES DATATYPE DESCRIPTION
UNAME STRING : VARCHAR2
RASHI STRING : VARCHAR2
GOTRA STRING : VARCHAR2
NAD STRING : VARCHAR2
KUL STRING : VARCHAR2
CASTE STRING : VARCHAR2
MANGAL STRING : VARCHAR2
SKNCOE Page 13
6) Contact information table:
Contact
ATTRIBUTES DATATYPE DESCRIPTION
CURR_ADD STRING : VARCHAR2
PER_ADD STRING : VARCHAR2
PH_NO STRING : VARCHAR2
MOB_NO STRING : VARCHAR2
E_ID STRING : VARCHAR2
UNAME STRING : VARCHAR2
SKNCOE Page 14
Class Diagram
SKNCOE Page 15
State Diagram
COMPONENT DIAGRAM
SKNCOE Page 16
4) Coding and Testing
4.1) Front End and Back End
4.2) Coding:
Home.asp
<html>
<style type="text/css">
#apDiv1 {
position:absolute;
left:500px;
top:300px;
width:800px;
height:497px;
z-index:1;
</style>
SKNCOE Page 17
<body background="wb1.jpg">
<div>
<center>
</center>
</div>
<!--img src="c:/Inetpub/wwwroot/SDTL1/imgad.gif"-->
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
</table>
</div>
SKNCOE Page 18
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
<center>
</center>
<center>
</div>
</center>
</body>
</html>
Login.asp
<html>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
SKNCOE Page 19
<h1><center><b>LOGIN PAGE</b></center></h1>
<tr>
<td><b>USERNAME : </b><br><br></td>
</tr>
<tr>
<td><b>PASSWORD : </b><br><br></td>
</tr>
</table></center>
</form>
</body>
</html>
ValidateUser.asp
<%
Dim Query
SKNCOE Page 20
Dim rs
Dim rs1
Dim uname1
uname1=TRIM(Request.Form("uname"))
rs.MoveFirst
Do until rs.EOF
Con.Execute mysql1
Response.Redirect "stcheck.asp"
end if
rs.MoveNext
loop
%>
<html>
SKNCOE Page 21
<body>
</body>
</html>
Usehome.asp
<html>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
</center>
</form>
SKNCOE Page 22
<input type="submit" value="Send Request">
</center>
</form>
<center>
</center>
</form>
<center>
</center>
</form>
<center>
</center>
</form>
</body>
</html>
SKNCOE Page 23
Person_info.asp
<html>
<style type="text/css">
.BL {
color: #000;
.gr {
color: #008000;
</style>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<script>
function check()
if (Save.uname.value.length=="")
SKNCOE Page 24
return false;
if (Save.fname.value.length=="")
return false;
if (Save.mname.value.length=="")
return false;
if (Save.lname.value.length=="")
return false;
if (Save.age.value.length=="")
return false;
if (Save.sex.value.length=="")
SKNCOE Page 25
return false;
if (Save.ht.value.length=="")
return false;
if (Save.wt.value.length=="")
return false;
if (Save.mar_st.value.length=="")
return false;
if (Save.edu.value.length=="")
return false;
if (Save.comx.value.length=="")
SKNCOE Page 26
return false;
if (Save.reg.value.length=="")
return false;
if (Save.hob.value.length=="")
return false;
if (Save.dob.value.length=="")
return false;
if (Save.pob.value.length=="")
return false;
else
SKNCOE Page 27
return true;
</script>
<b>
<p align="center"> </p>
<p align="center"><br>
</p>
<div align="center">
<center>
<table width="881" style="border-collapse: collapse; color: #000; font-weight: bold; font-family: 'Times
New Roman', Times, serif;" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="190">
</tr>
SKNCOE Page 28
<tr>
<td width="190">
<p>
</p></td>
</tr>
<tr>
<td height="40"> </td>
</tr>
<tr>
<td width="190">
</tr>
<tr>
SKNCOE Page 29
<td width="150" class="BL"><b><font size="2" face="Arial, Helvetica, sans-serif"
color="white">Age</font></b></td>
</tr>
<tr>
<td width="190">
</tr>
<tr>
<td height="35"> </td>
<td><p>
</p></td>
</tr>
<tr>
<td height="40"> </td>
</tr>
SKNCOE Page 30
<tr>
<td height="40"> </td>
</tr>
<tr>
<td height="40"> </td>
</tr>
<tr>
<td height="44"> </td>
</tr>
<tr>
<td height="39"> </td>
</tr>
<tr>
<td height="33"> </td>
SKNCOE Page 31
</tr>
<tr>
<td height="29"> </td>
</tr>
<tr>
<td height="32"> </td>
</tr>
</table></center>
</div>
<center>
<p>
</p>
<p>
</p>
</center>
<br>
SKNCOE Page 32
<FONT face="Arial, Helvetica, sans-serif" size=2>
</body>
</html>
Prof_info.asp
<%
Dim uname
Dim fname
Dim mname
Dim lname
Dim age
Dim sex
Dim compx
Dim ht
Dim wt
Dim dob
Dim pob
Dim reg
Dim mar_st
Dim hob
Dim edu
uname=TRIM(Request.Form("uname"))
fname=TRIM(Request.Form("fname"))
SKNCOE Page 33
mname=TRIM(Request.Form("mname"))
lname=TRIM(Request.Form("lname"))
age=TRIM(Request.Form("age"))
sex=TRIM(Request.Form("sex"))
compx=TRIM(Request.Form("comx"))
ht=TRIM(Request.Form("ht"))
wt=TRIM(Request.Form("wt"))
reg=TRIM(Request.Form("reg"))
mar_st=TRIM(Request.Form("mar_st"))
edu=TRIM(Request.Form("edu"))
hob=TRIM(Request.Form("hob"))
dob=TRIM(Request.Form("dob"))
pob=TRIM(Request.Form("pob"))
%>
<%
Dim Con
Dim Query
Dim rs
Set Con=Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
SKNCOE Page 34
mysql="Insert into person_info
values('"&fname&"','"&mname&"','"&lname&"','"&age&"','"&sex&"','"&ht&"','"&wt&"','"&compx&"','"
&dob&"','"&pob&"','"®&"','"&mar_st&"','"&edu&"','"&hob&"','"&uname&"')"
Con.Execute mysql
Con.Execute mysql1
%>
<html>
<style type="text/css">
.BL {
color: #000;
.gr {
color: #008000;
</style>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
SKNCOE Page 35
<script>
function check()
if (Save.job_des.value.length=="")
return false;
if (Save.com.value.length=="")
return false;
if (Save.ann_in.value.length=="")
return false;
else
return true;
SKNCOE Page 36
</script>
<p align="center"> </p>
<p align="center"><br>
</p>
<div align="center">
<center>
<table width="881" style="border-collapse: collapse; color: #000; font-weight: bold; font-family: 'Times
New Roman', Times, serif;" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="190">
<p>
</p></td>
</tr>
<tr>
SKNCOE Page 37
<td width="150" class="BL"><FONT face="Arial, Helvetica, sans-serif" size=2><b>Company Name </b>
</font></td>
<td width="190">
</tr>
<tr>
</tr>
</table></center>
</div>
<center>
<p>
</p>
<p>
</p>
</center>
<br>
SKNCOE Page 38
<br><br><br>
<a href="person_info.asp">BACK</a>
</body>
</html>
Fam_info.asp
<%
Dim uname1
Dim job_des
Dim com
Dim ann_in
job_des=TRIM(Request.Form("job_des"))
com=TRIM(Request.Form("com"))
ann_in=TRIM(Request.Form("ann_in"))
%>
<%
Dim Con
Dim Query
Dim rs
Set Con=Server.CreateObject("ADODB.Connection")
SKNCOE Page 39
Set rs = Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
uname1=rs(0)
Con.Execute mysql
%>
<html>
<style type="text/css">
.BL {
color: #000;
.gr {
color: #008000;
</style>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
SKNCOE Page 40
<script>
function check()
if (Save.fname.value.length=="")
return false;
if (Save.mname.value.length=="")
return false;
if (Save.fqual.value.length=="")
return false;
if (Save.mqual.value.length=="")
return false;
SKNCOE Page 41
if (Save.sib.value.length=="")
return false;
if (Save.mem.value.length=="")
return false;
if (Save.fam_str.value.length=="")
return false;
else
return true;
</script>
SKNCOE Page 42
<form name="Save" method=post action="kundali.asp" >
<p align="center"> </p>
<p align="center"><br>
</p>
<div align="center">
<center>
<table width="881" style="border-collapse: collapse; color: #000; font-weight: bold; font-family: 'Times
New Roman', Times, serif;" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
</tr>
<tr>
<td width="190">
<p>
</p></td>
</tr>
SKNCOE Page 43
<tr>
<td width="190">
</tr>
<tr>
</tr>
<tr>
<td><center>Mothers Information</center></td>
</tr>
<tr>
<td width="190">
SKNCOE Page 44
<p>
</p></td>
</tr>
<tr>
<td width="190">
</tr>
<tr>
</tr>
<tr>
</tr>
SKNCOE Page 45
<tr>
</tr>
<tr>
</tr>
</table></center>
</div>
<center>
<p>
</p>
<p>
</p>
</center>
SKNCOE Page 46
<br>
<br><br><br>
<a href="prof_info.asp">BACK</a>
</body>
</html>
Kundali.asp
<%
Dim uname1
Dim fname
Dim fjob
Dim fqual
Dim mname
Dim mjob
Dim mqual
Dim mem
Dim sib
Dim fam_str
fname=TRIM(Request.Form("fname"))
fjob=TRIM(Request.Form("fjob"))
SKNCOE Page 47
fqual=TRIM(Request.Form("fqual"))
mname=TRIM(Request.Form("mname"))
mjob=TRIM(Request.Form("mjob"))
mqual=TRIM(Request.Form("mqual"))
mem=TRIM(Request.Form("mem"))
sib=TRIM(Request.Form("sib"))
fam_str=TRIM(Request.Form("fam_str"))
%>
<%
Dim Con
Dim Query
Dim rs
Set Con=Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
uname1=rs(0)
Con.Execute mysql
%>
SKNCOE Page 48
<html>
<style type="text/css">
.BL {
color: #000;
.gr {
color: #008000;
</style>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<script>
function check()
if (Save.rashi.value.length=="")
SKNCOE Page 49
alert ("Enter Rashi");
return false;
if (Save.caste.value.length=="")
return false;
else
return true;
</script>
<p align="center"> </p>
<p align="center"><br>
</p>
<div align="center">
<center>
SKNCOE Page 50
<table width="881" style="border-collapse: collapse; color: #000; font-weight: bold; font-family: 'Times
New Roman', Times, serif;" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="190">
<p>
</p></td>
</tr>
<tr>
<td width="190">
</tr>
<tr>
SKNCOE Page 51
<td width="190"><input type="text" name="nad" size="20" ></td>
</tr>
<tr>
<td width="190">
<p>
</p></td>
</tr>
<tr>
<td width="190">
</tr>
<tr>
SKNCOE Page 52
<td width="190"><input type="text" name="mangal" size="20" ></td>
</tr>
</table></center>
</div>
<center>
<p>
</p>
<p>
</p>
</center>
<br>
<br><br><br>
<a href="fam_info.asp">BACK</a>
</body>
</html>
Contact.asp
<%
SKNCOE Page 53
Dim uname1
Dim rashi
Dim gotra
Dim kul
Dim nad
Dim caste
Dim mangal
rashi=TRIM(Request.Form("rashi"))
gotra=TRIM(Request.Form("gotra"))
kul=TRIM(Request.Form("kul"))
nad=TRIM(Request.Form("nad"))
caste=TRIM(Request.Form("caste"))
mangal=TRIM(Request.Form("mangal"))
%>
<%
Dim Con
Dim Query
Dim rs
Set Con=Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
SKNCOE Page 54
rs.Open "Select * from uname",Con
rs.MoveFirst
uname1=rs(0)
Con.Execute mysql
%>
<html>
<style type="text/css">
.BL {
color: #000;
.gr {
color: #008000;
</style>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
SKNCOE Page 55
<script>
function check()
if (Save.cad.value.length=="")
return false;
if (Save.pad.value.length=="")
return false;
if (Save.phn.value.length=="")
return false;
if (Save.eid.value.length=="")
return false;
else
SKNCOE Page 56
return true;
</script>
<p align="center"> </p>
<p align="center"><br>
</p>
<div align="center">
<center>
<table width="881" style="border-collapse: collapse; color: #000; font-weight: bold; font-family: 'Times
New Roman', Times, serif;" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="190">
<p>
SKNCOE Page 57
</p></td>
</tr>
<tr>
<td width="190">
</tr>
<tr>
</tr>
<tr>
<td width="190">
<p>
SKNCOE Page 58
</p></td>
</tr>
<tr>
<td width="190">
</tr>
</table></center>
</div>
<center>
<p>
</p>
<p>
</p>
</center>
<br>
SKNCOE Page 59
<br><br><br>
<a href="kundali.asp">BACK</a>
</body>
</html>
Confirm.asp
<%
Dim uname1
Dim cad
Dim pad
Dim phn
Dim mno
Dim eid
cad=TRIM(Request.Form("cad"))
pad=TRIM(Request.Form("pad"))
phn=TRIM(Request.Form("phn"))
mno=TRIM(Request.Form("mno"))
eid=TRIM(Request.Form("eid"))
%>
<%
SKNCOE Page 60
Dim Con
Dim Query
Dim rs
Set Con=Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
uname1=rs(0)
Con.Execute mysql
Con.Execute mysql1
%>
<html>
<body background="wb1.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<form action="home.asp">
SKNCOE Page 61
<h1><center><b>WELCOME!</b></center></h1>
</form>
</body>
</html>
Vwmat.asp
<html>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<%
Dim uname1
Dim Con
Dim rs
Dim rs1
Dim rs2
Dim pri
Dim sex1
SKNCOE Page 62
Dim sex2
sex2="sex"
pri=TRIM(Request.Form("search"))
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs1=Server.CreateObject("ADODB.Recordset")
Set rs2=Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
uname1=rs(0)
rs1.MoveFirst
if(uname1=rs1(14)) Then
sex1=rs1(4)
end if
rs1.MoveNext
wend
rs1.MoveFirst
SKNCOE Page 63
%>
<center><table border=1>
<tr>
</tr>
<%
%>
<tr>
SKNCOE Page 64
<td> <%=rs1("mname")%> </td>
</tr>
<% end if
rs1.MoveNext
Wend
%>
</table>
<br><br><br>
<a href="userHome.asp">BACK</a>
</body>
</html>
Request.asp
SKNCOE Page 65
<html>
<body bgcolor="brown">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<%
Dim uname1
Dim uname2
Dim Con
Dim rs
Dim rs1
Dim rs2
Dim rs3
Dim rs4
Dim rs5
SKNCOE Page 66
uname1=TRIM(Request.Form("rqst"))
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs1=Server.CreateObject("ADODB.Recordset")
Set rs2=Server.CreateObject("ADODB.Recordset")
Set rs3=Server.CreateObject("ADODB.Recordset")
Set rs4=Server.CreateObject("ADODB.Recordset")
Set rs5=Server.CreateObject("ADODB.Recordset")
Set rs6=Server.CreateObject("ADODB.Recordset")
rs1.MoveFirst
%>
<center>
<b>
<tr>
SKNCOE Page 67
<%
if(rs1(14)=uname1) Then
%>
<tr>
<td> </td>
</tr>
<tr>
<td width="225"><%=rs1("fname")%> </td>
</tr>
<tr>
<td>Middle Name</td>
<td><%=rs1("mname")%> </td>
</tr>
<tr>
<td>Last Name</td>
<td><%=rs1("lname")%> </td>
</tr>
<tr>
<td>Age</td>
<td><%=rs1("age")%> </td>
</tr>
SKNCOE Page 68
<tr>
<td>Sex</td>
<td><%=rs1("sex")%> </td>
</tr>
<tr>
<td>Height</td>
<td><%=rs1("ht")%> </td>
</tr>
<tr>
<td>Weight</td>
<td><%=rs1("wt")%> </td>
</tr>
<tr>
<td>Complexion</td>
<td><%=rs1("comx")%> </td>
</tr>
<tr>
<td>Date of Birth</td>
<td><%=rs1("dob")%> </td>
</tr>
<tr>
<td>Place of Birth</td>
<td><%=rs1("pob")%> </td>
</tr>
<tr>
SKNCOE Page 69
<td>Religion</td>
<td><%=rs1("reg")%> </td>
</tr>
<tr>
<td>Education</td>
<td><%=rs1("edu")%> </td>
</tr>
<tr>
<td>Marital Status</td>
<td><%=rs1("mar_st")%> </td>
</tr>
<tr>
<td>Hobbies</td>
<td><%=rs1("hob")%> </td>
</tr>
<%
end if
rs1.MoveNext
wend
%>
</table></td>
<td width="484">
<%
SKNCOE Page 70
rs2.Open("select * from fam_info"),Con
rs2.MoveFirst
if (rs2(9)=uname1) Then
%>
<tr>
<td width="233"> </td>
</tr>
<tr>
<td><%=rs2("fname")%> </td>
</tr>
<tr>
<td><%=rs2("fqual")%> </td>
</tr>
<tr>
<td><%=rs2("fjob")%> </td>
</tr>
<tr>
SKNCOE Page 71
<td><%=rs2("mname")%> </td>
</tr>
<tr>
<td><%=rs2("mqual")%> </td>
</tr>
<tr>
<td><%=rs2("mjob")%> </td>
</tr>
<tr>
<td height="32">Sibblings</td>
<td><%=rs2("sib")%> </td>
</tr>
<tr>
<td><%=rs2("mem")%> </td>
</tr>
<tr>
<td><%=rs2("fam_str")%> </td>
</tr>
</table>
SKNCOE Page 72
<%
end if
rs2.MoveNext
wend
%>
</td>
</tr>
<tr>
<td height="37"> </td>
<td> </td>
</tr>
<tr>
<td>
<%
rs3.MoveFirst
if (rs3(0)=uname1) Then
%>
<tr>
SKNCOE Page 73
<td width="220" height="39"><font size="2" face="Arial, Helvetica, sans-serif"
color="white"><b>KUNDALI</b></td>
<td width="225"> </td>
</tr>
<tr>
<td height="31">Rashi</td>
<td><%=rs3("rashi")%> </td>
</tr>
<tr>
<td height="30">Gotra</td>
<td><%=rs3("gotra")%> </td>
</tr>
<tr>
<td height="30">Kul</td>
<td><%=rs3("kul")%> </td>
</tr>
<tr>
<td height="29">Nad</td>
<td><%=rs3("nad")%> </td>
</tr>
<tr>
<td height="33">Caste</td>
<td><%=rs3("caste")%> </td>
</tr>
<tr>
<td>Mangal</td>
SKNCOE Page 74
<td><%=rs3("mangal")%> </td>
</tr>
</table>
<%
end if
rs3.MoveNext
wend
%>
</td>
<td>
<%
rs4.MoveFirst
if (rs4(3)=uname1) Then
%>
<tr>
SKNCOE Page 75
<td width="236"><font size="2" face="Arial, Helvetica, sans-serif" color="white"><b>OTHER
INFORMATION</b></td>
<td width="234"> </td>
</tr>
<tr>
<td>Job Description</td>
<td><%=rs4("job_des")%> </td>
</tr>
<tr>
<td>Company/Bussiness Name</td>
<td><%=rs4("comp")%> </td>
</tr>
<tr>
<td>Annual Income</td>
<td><%=rs4("ann_in")%> </td>
</tr>
</table>
<%
end if
rs4.MoveNext
wend
rs5.MoveFirst
SKNCOE Page 76
if (rs5(5)=uname1) Then
%>
<tr>
<td>Current Address</td>
<td><%=rs5("curr_add")%> </td>
</tr>
<tr>
<td>Permanent Address</td>
<td><%=rs5("per_add")%> </td>
</tr>
<tr>
<td>Phone Number</td>
<td><%=rs5("ph_no")%> </td>
</tr>
<tr>
<td>Mobile Number</td>
<td><%=rs5("mob_no")%> </td>
</tr>
<tr>
<td>E-mail ID</td>
<td><%=rs5("e_id")%> </td>
</tr>
SKNCOE Page 77
</table>
<%
end if
rs5.MoveNext
wend
%>
</td>
</tr>
</table>
</form>
</center>
</font>
</b>
<br><br><br>
<a href="userHome.asp">BACK</a>
</body>
</html>
<%
rs.MoveFirst
uname2=rs(0)
SKNCOE Page 78
rs6.Open "UPDATE login SET status = status- 1 WHERE username = '" & uname2 & "'",Con
%>
Report.asp
<html>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<%
Dim uname1
Dim Con
Dim rs
Dim rs2
Dim rs3
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs2=Server.CreateObject("ADODB.Recordset")
SKNCOE Page 79
Set rs3=Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
rs3.MoveFirst
rs2.MoveFirst
%>
<center><table border=1">
<tr>
SKNCOE Page 80
<td> <b> Status </b> </td>
</tr>
<%
uname1=rs(0)
%>
<tr>
<%
rs3.MoveFirst
if(uname1=rs3(14)) Then
%>
<%
end if
rs3.MoveNext
SKNCOE Page 81
wend
%>
<%
rs2.MoveFirst
if(uname1=rs2(5)) Then
%>
</tr>
<%
end if
rs2.MoveNext
wend
rs.MoveNext
Wend
%>
</table>
SKNCOE Page 82
<br><br><br>
<a href="adHome.asp">BACK</a>
</body>
</html>
Delete.asp
<html>
<body background="wb.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<%
Dim uname1
uname1=TRIM(Request.Form("memb"))
Dim rs
Dim rs1
SKNCOE Page 83
Dim rs2
Dim rs3
Dim rs4
Dim rs5
Dim Con
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs1=Server.CreateObject("ADODB.Recordset")
Set rs2=Server.CreateObject("ADODB.Recordset")
Set rs3=Server.CreateObject("ADODB.Recordset")
Set rs4=Server.CreateObject("ADODB.Recordset")
Set rs5=Server.CreateObject("ADODB.Recordset")
rs.Open "delete from login where username='" & uname1 & "'",Con
rs1.Open "delete from person_info where uname='" & uname1 & "'",Con
rs2.Open "delete from prof_info where uname='" & uname1 & "'",Con
rs3.Open "delete from fam_info where uname='" & uname1 & "'",Con
rs4.Open "delete from horo where uname='" & uname1 & "'",Con
rs5.Open "delete from contact where uname='" & uname1 & "'",Con
%>
SKNCOE Page 84
<h2> The member has been deleted successfully! </h2>
<br><br><br>
<a href="opHome.asp">BACK</a>
</body>
</html>
Strcheck.asp
<html>
<body>
<%
Dim Con
Dim rs
Dim rs1
Dim uname
Dim st
st=11
Set Con=Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
SKNCOE Page 85
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.MoveFirst
uname=rs1(0)
rs.MoveFirst
if(uname=rs(0)) Then
st=rs(2)
end if
rs.MoveNext
wend
if(st="0") Then
%>
<form action="renew1.asp">
</form>
SKNCOE Page 86
<%
else
Response.Redirect "userHome.asp"
end if
%>
<a href="home.asp">BACK</a>>
</body>
</html>
Vwstatus.asp
<html>
<body background="wb1.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<%
Dim uname1
Dim rs
Dim rs1
SKNCOE Page 87
Dim st
Dim Con
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs1=Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
uname1=rs(0)
rs1.MoveFirst
if (rs1(0)=uname1) Then
st=rs1(2)
end if
rs1.MoveNext
wend
%>
<br><br><br>
<br><br><br>
SKNCOE Page 88
</body>
</html>
Renew.asp
<html>
<body background="wb1.jpg">
<div>
<center>
<h1 style="color:white;">JeevanSathi.Com</h1>
</center>
</div>
<%
Dim uname1
Dim rs
Dim rs1
Dim rs2
Dim st
Dim Con
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs1=Server.CreateObject("ADODB.Recordset")
SKNCOE Page 89
Set rs2=Server.CreateObject("ADODB.Recordset")
rs.MoveFirst
uname1=rs(0)
rs1.MoveFirst
if (rs1(0)=uname1) Then
rs2.Open "UPDATE login SET status = 10 WHERE username = '" & uname1 & "'",Con
end if
rs1.MoveNext
wend
%>
<br><br><br>
<br><br><br>
</body>
</html>
Logoff.asp
SKNCOE Page 90
<%
Dim rs
Dim Con
Set Con=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
Response.Redirect "home.asp"
%>
4.3) Testing:
1: USER LOGIN
Purpose Test that users can log in with the proper username and
password.
Pre-Requisites User is not already logged in.
User exists and membership is not expired.
Test Data username = {valid, invalid, empty}
password = {valid, invalid, empty}
Steps 1. Visit Login Page.
2. Enter username.
3. Enter password
4. click Login
5. see Home Page
SKNCOE Page 91
5. If the membership has been expired then information
page is displayed.
Expected Result The userx logs in to the site and the home page opens.
Purpose Test that service provider can register with desired username
and password.
SKNCOE Page 92
Pre-Requisites Service provider is not already registered on the site.
A new service provider userx opens the registration page
Service provider userx selects the provider type of
registration.
Test Data username = {userx, empty}
password = {valid, empty}
email id= {valid, empty}
Expected Result The service provider logs in to the site and the home
page opens.
SKNCOE Page 93
Steps 1 Seeker logs in
2 Provide card no
3 Provide card pin
4 Provide mobile no
5 click Submit
6 A new page specifying a successful recharge appears.
SKNCOE Page 94
5) Conclusion
Availability of services and ease of use are the key points which have been
implemented. The low cost development will further increase the effectiveness. Since the
software has been developed using jsp and html which increases the reliability of data
exchange.
All the site pages have been designed to be intuitive and easy to use predicting what to do
further. An additional functionality for displaying the ads of service provider online is given in
which the service provider can login to his home page and request to display a new ad.
The ad will be displayed on the approval of the administrator. The registration functionality of
the site also maintains the support for using the services of the site by the new users. All the
transactions are simple to perform and easy to do.
In the end it doesn’t matter whether the recharge is carried out or login is done or a new
registration every functionality has been designed for use at ease by all the users.
6) References
Object Oriented Modeling and Design by J Rambaugh
SKNCOE Page 95
SKNCOE Page 96