//Inline Model
//// **************************************************////
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="main.aspx.cs" Inherits="main" EnableEventValidation="true" %>
<%@ Register Src="~/Usercontrol/cybocommunity.ascx" TagName="head2" TagPrefix="ctl" %>
<%@ Register Src="~/Usercontrol/usr_ctl_footer.ascx" TagName="foot" TagPrefix="ctl" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<link href="STYLE/styleh.css" type="text/css" rel="stylesheet" />
<title>Untitled Page</title>
<meta http-equiv="refresh" content="600">
<script type="text/javascript" language="javascript">
function showdiv()
{
if(document.getElementById("div1").style.display=="none")
{
document.getElementById("div1").style.display="block";
return false;
}
else
{
document.getElementById("div1").style.display="none";
return false;
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div >
<%-- main table--%>
<table border="1" width="980px" align="center" style="background-image:url(image/ms1.gif);background-repeat:repeat-x;">
<tr> <td style="width:980;"s ><ctl:head2 ID="head" runat="server" /></td> </tr>
<%-- ------------------------body part------new design--------------------%>
<tr><td>
<table>
<tr>
<td style="background-image:url(image/profile.jpg); width:980px; height:248px;" >
<table>
<tr><td valign="top">
<asp:ImageButton ID="imguser" runat="server" Height="220px" width="184px" ImageUrl="~/IMAGE/user.bmp"/>
<br /></td><td>
<table style="height:220px; width:700px;">
<tr><td style="height:20px;">
<asp:Label ID="welcom" runat="server" Font-Size="35px" Text="Welcom," ForeColor="yellow"></asp:Label><asp:Label ID="lbluser" ForeColor="yellow" runat="server" Font-Size="35px" Text="SANYOG LUCKY"></asp:Label></td></tr>
<tr><td >
<div id="div2" onclick="showdiv()" > <asp:Label ID="lbledit" runat="server" Width="520px" Text="dssd dsdfsd dssd" ForeColor="Red" Font-Size="15"></asp:Label> Edit</div>
<div id="div1" style="display:none ;">
<asp:TextBox ID="txtupdate" runat="server" Width="350px"></asp:TextBox> <asp:Button ID="btnupdate" runat="server" Text="update" OnClick="btnupdate_Click1" />
</div>
</td></tr>
<tr><td>
<table style="width:600px;">
<tr>
<td style="width:100px;">Sex </td><td style="width:100px;"> <asp:Label ID="lblmale" runat="server" ForeColor="white" Font-Size="11" Font-Bold="true" Text="Male" ></asp:Label></td>
<td style="width:100px;">City </td><td style="width:100px;"> <asp:Label ID="lblcity" runat="server" ForeColor="white" Font-Size="11" Font-Bold="true" Text="Patna City"></asp:Label></td>
<td style="width:100px;"> State </td><td style="width:190px;" ><asp:Label ID="lblstate" runat="server" ForeColor="white" Width="190" Font-Size="11" Font-Bold="true" Text="state"> </asp:Label></td>
<td style="width:100px;">Country </td><td style="width:100px;"> <asp:Label ID="lblcountry" runat="server" ForeColor="white" Font-Size="11" Text="country" ></asp:Label></td></tr>
</table>
</td></tr>
<tr><td align="right"><asp:Label ID="email" runat="server" ForeColor="yellow" Font-Size="15px" text="Sanyog_cooldud@yahoo.com"></asp:Label></td></tr>
</table>
</td></tr>
</table>
</td></tr></table>
</td></tr>
<%---------------------------------new design---------------------------------------------------------%>
<%--for search--%>
<asp:PlaceHolder ID="pl1" runat="server" >
<tr><td colspan="3">
<table><tr><td><asp:ImageButton ID="imgfriend" runat="server" Width="100px" ImageUrl="~/IMAGE/user.bmp" Height="100px" OnClick="imgfriend_Click" /></td><td><asp:LinkButton ID="username" runat="server" Text="sanyog" PostBackUrl="~/addfriend.aspx"></asp:LinkButton><br />
<asp:Label ID="lblmail" runat="server" ></asp:Label><br /><asp:Label ID="lblsex" runat="server"></asp:Label><br /><asp:Label ID="lblcit" runat="server"></asp:Label><br /><asp:Label ID="lblstat" runat="server"><br /><asp:Label ID="lblc" runat="server"></asp:Label></asp:Label></td></tr>
</table></td></tr>
</asp:PlaceHolder>
<asp:PlaceHolder ID="pl2" runat="server" ><tr><td colspan="3">
<table>
<tr><td>Email id is not found.......</td></tr>
</table></td></tr>
</asp:PlaceHolder>
<%-- ------------------------------------------------------------%>
<tr>
<td valign="top" >
<%--left td table--%>
<table >
<tr> <td style="height: 194px" valign="top" ><table >
<tr><td style="width: 200px"><asp:LinkButton ID="lnlusername" runat="server" Text="Sanyog keshri"></asp:LinkButton> <img id="imgshow" runat="server" style="width: 20px; height: 20px" /></td></tr>
<tr><td><hr /></td></tr>
<tr><td><asp:DropDownList ID="ddlon" runat="server" Width="170px" AutoPostBack="true" OnSelectedIndexChanged="ddl_change">
<asp:ListItem >Select</asp:ListItem>
<asp:ListItem Value="busy.jpg">Busy</asp:ListItem>
<asp:ListItem Value="on.png">Online</asp:ListItem>
<asp:ListItem Value="off.jpg">Offline</asp:ListItem>
</asp:DropDownList></td></tr>
<tr><td><asp:ImageButton ID="pic" runat="server" ImageUrl="~/IMAGE/p_profile.gif" />  <asp:LinkButton ID="profile" runat="server" Text="Profie"></asp:LinkButton>              <asp:LinkButton ID="edit" runat="server" PostBackUrl="~/edit.aspx" Text="Edit"></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/IMAGE/events_ico.png" />  <asp:LinkButton ID="home" runat="server" Text="Home" PostBackUrl="~/main.aspx" OnClick="home_Click" ></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/IMAGE/p_scrap.gif" />  <asp:LinkButton ID="scrap" runat="server" Text="Scrapbook" PostBackUrl="~/scrap.aspx" OnClick="scrap_Click"></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="~/IMAGE/p_camera.gif" />  <asp:LinkButton ID="photo" runat="server" Text="Photo" PostBackUrl="~/picture.aspx" OnClick="photo_Click"></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:ImageButton ID="ImageButton4" runat="server" ImageUrl="~/IMAGE/p_video.gif" />  <asp:LinkButton ID="vedios" runat="server" Text="Vedios" PostBackUrl="~/video.aspx"></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:ImageButton ID="ImageButton5" runat="server" ImageUrl="~/IMAGE/p_app.gif"/>  <asp:LinkButton ID="chat" runat="server" Text="Chat" PostBackUrl="~/chat.aspx" ></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:ImageButton ID="ImageButton7" runat="server" ImageUrl="~/IMAGE/p_app.gif"/>  <asp:LinkButton ID="lnkonline" runat="server" Text="Online Friends" OnClick="lnkonline_Click" PostBackUrl="~/showonlinefriend.aspx"></asp:LinkButton><br /><br /></td></tr>
<tr><td><asp:TextBox ID="txtsearch" runat="server" width="160px" ></asp:TextBox><br /><asp:Button ID="btnsearch" runat ="server" Text="Search" OnClick="btnsearch_Click" /></td></tr>
</table>
</td>
<td <%--style=" background-image: url(IMAGE/bk.gif);"--%> style="width: 468px" valign="top">
<%-- for middle td table--%>
<table>
<tr>
<td>scrap photos videos<br /><asp:ImageButton ID="headscrap" runat="server" ImageUrl="~/IMAGE/p_scrap.gif" PostBackUrl="~/scrap.aspx" OnClick="headscrap_Click" /> <a href="scrap.aspx"><asp:Label ID="lblheadscrap" runat="server" Text="21" > </asp:Label></a> <asp:ImageButton ID="imgphotos" runat="server" ImageUrl="~/IMAGE/p_camera.gif" PostBackUrl="~/picture.aspx" /> <asp:Label ID="lblpicture" runat="server" Text="21"> </asp:Label> <asp:ImageButton ID="ImageButton6" runat="server" ImageUrl="~/IMAGE/p_video.gif" /> <asp:Label ID="lblvedio" runat="server" Text="21"> </asp:Label></td>
</tr>
<tr><td style="height: 24px"><asp:Label ID="profiless" runat="server" Font-Size="20px" Text="Profile View:"></asp:Label><label id="profileview" runat="server" ></label></td></tr>
<tr><td><asp:Label ID="recent" runat="server" Font-Size="20px" Text="Recent Visiters:"></asp:Label>
<asp:DataList ID="dlrecent" runat="server" RepeatColumns="8" RepeatDirection="Horizontal" OnItemCommand="datalist1_click" OnSelectedIndexChanged="dlrecent_SelectedIndexChanged">
<ItemTemplate>
<a class="thumbnail" href="#thumb"><asp:ImageButton ID="imgrecent" runat="server" ImageUrl='<%#Eval("imgurl") %>' ToolTip='<%#Eval("firstname") %>' Height="30px" Width="30px" CommandArgument='<%#Eval("friendid") %>' /><span><img src='<%#Eval("imgurl") %>' alt="" width="110px" height="110px" /><br /></span></a>
<br />
<%-- <asp:LinkButton ID="lnk1" runat="server" Text='<%#Eval("firstname") %>' ></asp:LinkButton></td>--%>
</ItemTemplate>
</asp:DataList>
</td></tr><br />
<tr><td><br />
<asp:Repeater ID="rptfrnd" runat="server" OnItemCommand="rptfrnd_ItemCommand">
<ItemTemplate>
<table ><tr><td style="border-top-style: ridge; border-right-style: ridge; border-left-style: ridge;
height: 140px; border-bottom-style: ridge; width: 300px;">
<table >
<tr><td colspan="2" style="background-color:Blue"><center > <font size="4"> Friend Request</font></center></td></tr>
<tr><td><asp:ImageButton ID="imgfri" runat="server" Height="100" Width="100" ImageUrl='<%#Eval("imgurl") %>' /></td>
<td><asp:LinkButton ID="lnkfriend" runat="server" Text='<%#Eval("firstname") %>'></asp:LinkButton><br />
<asp:Label ID="lblemailid" runat="server" Width="300px" Text='<%#Eval("emailid") %>' ></asp:Label></td></tr>
<tr><td colspan="2">Message:-<asp:Label ID="lblmsg" runat="server" Text='<%#Eval("message") %>'></asp:Label></td></tr>
<tr><td colspan="2">       <asp:Button ID="btnaddfri" runat="server" Width="60" Text="Add" CommandName="btn_add" CommandArgument='<%#Eval("friendid") %>' />     <asp:Button ID="btncancel" runat="server" Width="60" Text="Cancel" /></td></tr>
</table>
</td></tr></table>
</ItemTemplate>
</asp:Repeater>
</td></tr>
</table>
</td>
<td valign="top" style="width: 309px">
<center>
<%-- --------------------------for right table------------%>
<table>
<tr><td><asp:Label ID="advertisement" runat="server" Font-Size="20px" Text="Advertisement"></asp:Label></td></tr>
<tr><td><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="260" height="260" id="add" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="image\add.swf" /><param name="quality" value="high" /><param name="bgcolor" value="#ffffff" />
</object></td></tr>
<tr><td>My Friend (<asp:Label ID="lblfriend" runat="server" Text="0"></asp:Label>)</td></tr>
<tr><td><asp:TextBox ID="txtsearcfriend" runat="server" Width="250px" Text="search friend" OnTextChanged="txtsearcfriend_TextChanged"></asp:TextBox></td></tr>
<tr><td>
<table border="1">
<asp:DataList ID="dfrnd" runat="server" RepeatColumns="3" RepeatDirection="Horizontal" OnItemCommand="datalist_click">
<ItemTemplate>
<td>
<%--<a href='addfriend.aspx?uid=<%#Eval("friendid") %>'><img src='<%#Eval("imgurl") %>' alt="" height="100px" width="100px" /></a>--%>
<asp:ImageButton ID="imgbtn" runat="server" ImageUrl='<%#Eval("imgurl") %>' Height="100px" Width="100px" CommandName="imgbtn" CommandArgument='<%#Eval("friendid") %>' />
<br />
<asp:LinkButton ID="lnk1" runat="server" Text='<%#Eval("firstname") %>' CommandName="lnkbtn" CommandArgument='<%#Eval("friendid") %>' ></asp:LinkButton> <img src='<%#Eval("show") %>' alt="" Height="10px" Width="10px"/></td>
</ItemTemplate>
</asp:DataList><br />
<a href="showallfriend.aspx">view all</a>
</table>
</td></tr>
</table>
</center>
</td>
</tr>
<tr><td colspan="3"> <center><table><tr><td><ctl:foot ID="foot1" runat="server" /></td></tr></table></center></td></tr>
</table>
</div>
</form>
</body>
</html> //// **************************************************////
//Code Behind ( First tier) That is Front End ..............
//// **************************************************////
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class main : System.Web.UI.Page
{
//bllupdatefriend bllu;
bllrequestadd bllra;
bllrequest bllr;
bllshowfriend bllshow;
bllsearch bllse;
blleditprofile blle;
bllshowprofile blls;
bllcount bllc;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["id"] == null)
{
Response.Redirect("default.aspx");
}
else
{
pl1.Visible = false;
pl2.Visible = false;
show();
if (!IsPostBack)
{
showupdate();
friendrequestshow();
friend();
showfriend();
countscrap();
countpic();
countfriend();
showrecentvisitor();
countvedio();
}
}
}
//for count friend.......................................................................
private void countfriend()
{
bllc = new bllcount();
bllc.Userid = Session["id"].ToString();
DataSet ds = new DataSet();
ds = bllc.friendcount(bllc);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblfriend.Text = ds.Tables[0].Rows[0]["friendid"].ToString();
}
}
}
//for count picture.......................................................................
private void countpic()
{
bllc = new bllcount();
bllc.Userid = Session["id"].ToString();
DataSet ds = new DataSet();
ds = bllc.picturecount(bllc);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblpicture.Text = ds.Tables[0].Rows[0]["image"].ToString();
}
}
}
//for count picture.......................................................................
private void countvedio()
{
bllc = new bllcount();
bllc.Userid = Session["id"].ToString();
DataSet ds = new DataSet();
ds = bllc.vediocount(bllc);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblvedio.Text = ds.Tables[0].Rows[0]["vedio"].ToString();
}
}
}
//for count scrap..........................................................................
private void countscrap()
{
bllc = new bllcount();
bllc.Friendid = Session["id"].ToString();
DataSet ds = new DataSet();
ds = bllc.scrapcount(bllc);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblheadscrap.Text = ds.Tables[0].Rows[0]["friendid"].ToString();
}
}
}
// for friend request .....................................................................
private void friendrequestshow()
{
bllr = new bllrequest();
DataSet ds = new DataSet();
bllr.UserId = Session["id"].ToString();
//bllr.Friendid = Session["userid"].ToString();
ds = bllr.request(bllr);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
rptfrnd.DataSource = ds;
rptfrnd.DataBind();
rptfrnd.Visible = true;
// imgfri.ImageUrl = ("./upload/") + ds.Tables[0].Rows[0]["image"].ToString();
// lnkfriend.Text = ds.Tables[0].Rows[0]["firstname"].ToString() + " " + ds.Tables[0].Rows[0]["lastname"].ToString();
// lblemailid.Text = ds.Tables[0].Rows[0]["emailid"].ToString();
// lblmsg.Text = ds.Tables[0].Rows[0]["message"].ToString();
}
}
else
{
rptfrnd.Visible = false;
}
}
// retriving friend id ..........................................................................
private void friend()
{
bllshow = new bllshowfriend();
DataSet ds = new DataSet();
bllshow.UserId = Session["id"].ToString();
ds = bllshow.friend(bllshow);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
//return friend id here
Session["friendid"] = ds.Tables[0].Rows[0]["friendid"].ToString();
//Response.Write(Session["friendid"]);
}
}
}
// for showing friend in right side list.................................................................
private void showfriend()
{
bllshow = new bllshowfriend();
DataSet ds = new DataSet();
bllshow.UserId = Session["id"].ToString();
ds = bllshow.showfriend(bllshow);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Session["stat"] = ds.Tables[0].Rows[0]["status"].ToString();
dfrnd.DataSource = ds;
dfrnd.DataBind();
dfrnd.Visible = true;
}
}
else
{
dfrnd.Visible = false;
}
}
private void showrecentvisitor()
{
bllshow = new bllshowfriend();
DataSet ds = new DataSet();
bllshow.UserId = Session["id"].ToString();
ds = bllshow.showrecent(bllshow);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
dlrecent.DataSource = ds;
dlrecent.DataBind();
dlrecent.Visible = true;
}
}
else
{
dlrecent.Visible = false;
}
}
// for showing user profile................................................................................
private void show()
{
blls = new bllshowprofile();
DataSet ds = new DataSet();
blls.UserId = Session["id"].ToString();
ds = blls.Showprofiles(blls);
if (ds.Tables[0].Rows.Count > 0)
{
imguser.ImageUrl = ("./upload/") + ds.Tables[0].Rows[0]["image"].ToString();
lbluser.Text = ds.Tables[0].Rows[0]["firstname"].ToString() + " " + ds.Tables[0].Rows[0]["lastname"].ToString();
lnlusername.Text = ds.Tables[0].Rows[0]["firstname"].ToString() + " " + ds.Tables[0].Rows[0]["lastname"].ToString();
lblcity.Text = ds.Tables[0].Rows[0]["city"].ToString();
lblstate.Text = ds.Tables[0].Rows[0]["state"].ToString();
lblmale.Text = ds.Tables[0].Rows[0]["sex"].ToString();
lblcountry.Text = ds.Tables[0].Rows[0]["country"].ToString();
email.Text = ds.Tables[0].Rows[0]["emailid"].ToString();
//imgshow.ImageUrl = ("./upload/") + ds.Tables[0].Rows[0]["show"].ToString();
//imgshow.ToolTip = ds.Tables[0].Rows[0]["show"].ToString();
imgshow.Src = ("./upload/") + ds.Tables[0].Rows[0]["show"].ToString();
//lbldob.Text = ds.Tables[0].Rows[0]["dob"].ToString();
//lblquestion.Text = ds.Tables[0].Rows[0]["question"].ToString();
//lblanswer.Text = ds.Tables[0].Rows[0]["answer"].ToString();
//lastlogin.Text = ds.Tables[0].Rows[0]["lastlogin"].ToString();
}
}
//for searching friend ................................................................................
protected void btnsearch_Click(object sender, EventArgs e)
{
bllse = new bllsearch();
DataSet ds = new DataSet();
bllse.Search = txtsearch.Text;
ds = bllse.searchprofile(bllse);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Session["addfri"] = ds.Tables[0].Rows[0]["userid"].ToString();
Session["stat"] = ds.Tables[0].Rows[0]["status"].ToString();
imgfriend.ImageUrl = ("./upload/") + ds.Tables[0].Rows[0]["image"].ToString();
username.Text = ds.Tables[0].Rows[0]["firstname"].ToString();
lblstat.Text = ds.Tables[0].Rows[0]["state"].ToString();
lblc.Text = ds.Tables[0].Rows[0]["country"].ToString();
lblsex.Text = ds.Tables[0].Rows[0]["sex"].ToString();
lblcit.Text = ds.Tables[0].Rows[0]["city"].ToString();
lblmail.Text = ds.Tables[0].Rows[0]["emailid"].ToString();
pl1.Visible = true;
}
}
else
{
pl2.Visible = true;
}
}
protected void imgfriend_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("addfriend.aspx?uid=" + Session["addfri"].ToString());
}
protected void btnaddfri_Click(object sender, EventArgs e)
{
}
// for adding friend in friend list..........................................................................
protected void rptfrnd_ItemCommand(object source, RepeaterCommandEventArgs a)
{
string p = a.CommandName;
if (p =="btn_add")
{
bllra = new bllrequestadd();
bllra.UserID = Session["id"].ToString();
bllra.FriendId = a.CommandArgument.ToString();
String s = bllra.requestadd(bllra);
Response.Redirect("main.aspx");
}
}
//for open friend profile from my friend list............................................................
protected void reptfriend_ItemCommand(object source, RepeaterCommandEventArgs e)
{
bllshow = new bllshowfriend();
DataSet ds = new DataSet();
bllshow.UserId = Session["id"].ToString();
ds = bllshow.rfriendid(bllshow);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Session["uid"] = ds.Tables[0].Rows[0]["friendid"].ToString();
//Response.Write(Session["uid"]);
}
}
Response.Redirect("showfriendprofile.aspx");
}
protected void btnupdate_Click1(object sender, EventArgs e)
{
blle = new blleditprofile();
blle.Userid = Session["id"].ToString();
blle.Msg = txtupdate.Text;
blle.editupper(blle);
}
private void showupdate()
{
bllscrap bllu = new bllscrap();
bllu = new bllscrap();
bllu.Userid = Session["id"].ToString();
DataSet ds = new DataSet();
ds = bllu.editu(bllu);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
lbledit.Text = ds.Tables[0].Rows[0]["edit"].ToString();
//lblheadscrap.Text = ds.Tables[0].Rows[0]["friendid"].ToString();
}
}
}
protected void photo_Click(object sender, EventArgs e)
{
}
protected void headscrap_Click(object sender, ImageClickEventArgs e)
{
}
protected void datalist_click(object source, CommandEventArgs e)
{
string s = e.CommandName;
if (s == "imgbtn")
{
string uid = e.CommandArgument.ToString();
Session["addfri"] = uid;
bllshow = new bllshowfriend();
bllshow.Friendid = Session["addfri"].ToString();
bllshow.UserId = Session["id"].ToString();
bllshow.recentid(bllshow);
Response.Redirect("addfriend.aspx?uid=" + uid);
}
if (s == "lnkbtn")
{
string uid = e.CommandArgument.ToString();
Session["addfri"] = uid;
bllshow = new bllshowfriend();
bllshow.Friendid = Session["addfri"].ToString();
bllshow.UserId = Session["id"].ToString();
bllshow.recentid(bllshow);
Response.Redirect("addfriend.aspx?uid=" + uid);
}
}
protected void datalist1_click(object source, CommandEventArgs e)
{
string uid = e.CommandArgument.ToString();
Session["addfri"] = uid;
Response.Redirect("addfriend.aspx?uid=" + uid);
}
protected void scrap_Click(object sender, EventArgs e)
{
}
protected void txtsearcfriend_TextChanged(object sender, EventArgs e)
{
}
protected void home_Click(object sender, EventArgs e)
{
}
protected void dlrecent_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ddl_change(object sender, EventArgs e)
{
bllshowprofile blls = new bllshowprofile();
blls.Show = ddlon.SelectedValue;
blls.UserId = Session["id"].ToString();
blls.upshow(blls);
Response.Redirect("main.aspx");
}
protected void lnkonline_Click(object sender, EventArgs e)
{
}
}
//// **************************************************////
//Second Tier(Bussines Logic layer(BLL)..............
//// **************************************************////
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// Summary description for bllRegistration
/// </summary>
public class bllRegistration
{
dalRegistraion dr;
public bllRegistration()
{
//
// TODO: Add constructor logic here
//
}
#region Private
private string _fileupload;
private string _firstname;
private string _lastname;
private int _date;
private int _month;
private int _year;
private DateTime _dob;
private string _emailid;
private string _sex;
private string _secid;
private string _password;
private string _conformpassword;
private int _question;
private string _answer;
private string _tc;
private string _state;
private string _city;
private string _location;
#endregion
#region public
public string City
{
get { return _city; }
set { _city = value; }
}
public string Sex
{
get { return _sex; }
set { _sex = value; }
}
public string location
{
get { return _location; }
set { _location = value; }
}
public string SecId
{
get { return _secid; }
set { _secid = value; }
}
public string State
{
get { return _state; }
set { _state = value; }
}
public string fileupload
{
get { return _fileupload; }
set { _fileupload = value; }
}
public String firstname
{
get { return _firstname; }
set { _firstname = value; }
}
public String lastname
{
get { return _lastname; }
set { _lastname = value; }
}
public int Date
{
get { return _date ; }
set { _date = value; }
}
public int Month
{
get { return _month ; }
set { _month= value ; }
}
public int year
{
get { return _year ; }
set { _year = value ; }
}
public DateTime DOB
{
get { return _dob; }
set { _dob = value; }
}
public String emailid
{
get { return _emailid ; }
set { _emailid = value ; }
}
public String password
{
get { return _password ; }
set { _password = value ; }
}
public String conformpassword
{
get { return _conformpassword ; }
set { _conformpassword = value ; }
}
public int question
{
get { return _question ; }
set { _question = value ; }
}
public String Answer
{
get { return _answer; }
set { _answer = value; }
}
public String TC
{
get { return _tc; }
set { _tc = value; }
}
#endregion
public void Registration(bllRegistration br)
{
dr = new dalRegistraion();
//to logic
dr.newRegistration(br);
}
public String checkemail(bllRegistration br)
{
dr = new dalRegistraion();
String msg = dr.newcheckemail(br);
return msg;
}
public String forgetpassword(bllRegistration br)
{
dr = new dalRegistraion();
String msg = dr.newforgetpassword(br);
return msg;
}
public String login(bllRegistration br)
{
dr = new dalRegistraion();
String msg = dr.newlogin(br);
return msg;
}
public DataSet searchfriend(bllRegistration br)
{
dalRegistraion dr = new dalRegistraion();
DataSet ds = new DataSet();
ds = dr.searchfriend(br);
return ds;
}
}
//// **************************************************////
//Third Tier(Data Access layer(DAL)..............
//// **************************************************////
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// Summary description for dalRegistraion
/// </summary>
public class dalRegistraion
{
SqlConnection con;
public dalRegistraion()
{
con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dreamprojectConnectionString"].ConnectionString);
//con = new SqlConnection("Data Source=STUDENT-4730FA6;Initial Catalog=dreamproject;Integrated Security=True");
}
public void newRegistration(bllRegistration br)
{
String strsql = "insert into tbluser(image,firstname,lastname,dd,mm,year,dob,emailid,password,questionno,answer,tc,status,sex,state) values(@image,@firstname, @lastname, @dd, @mm, @year, @dob, @emailid, @password, @questionno, @answer, @tc,0,@sex,@location)";
con.Open();
SqlCommand cmd = new SqlCommand(strsql,con);
SqlParameter param = new SqlParameter();
param = new SqlParameter();
param.ParameterName = "@image";
param.Value =br.fileupload;
cmd.Parameters.Add(param);
/* param = new SqlParameter();
param.ParameterName = "@secid";
param.Value = br.SecId;
cmd.Parameters.Add(param); */
param = new SqlParameter();
param.ParameterName = "@sex";
param.Value = br.Sex;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@location";
param.Value = br.location;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName ="@firstname";
param.Value = br.firstname;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@lastname";
param.Value = br.lastname;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@dd";
param.Value = br.Date ;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@mm";
param.Value = br.Month ;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@year";
param.Value = br.year ;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@dob";
param.Value = br.DOB;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@emailid";
param.Value = br.emailid ;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@password";
param.Value = br.password ;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@questionno";
param.Value = br.question;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@answer";
param.Value = br.Answer ;
cmd.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@tc";
param.Value = br.TC ;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
}
public String newcheckemail(bllRegistration br)
{
string msg = "";
try {
string selsql = "select emailid from tbluser where emailid='" + br.emailid+ "' ";
SqlDataAdapter adp = new SqlDataAdapter(selsql, con);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count>0)
{
msg = "Already exist!";
}
else
msg = "Available!";
}
catch (Exception e)
{
}
return msg;
}
public String newforgetpassword(bllRegistration br)
{
string msg = "";
try
{
string selsql = "select userid,emailid,password from tbluser where emailid='"+br.emailid+"' and questionno="+br.question+" and answer='"+br.Answer+"'";
SqlDataAdapter adp = new SqlDataAdapter(selsql, con);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
msg = "right";
}
else
msg = "wrong";
}
catch (Exception s)
{
}
return msg;
}
public String newlogin(bllRegistration br)
{
string msg = "";
try
{
string selsql = "select emailid,password from tbluser where emailid='" + br.emailid + "' and password='" + br.password + "'";
SqlDataAdapter adp = new SqlDataAdapter(selsql, con);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
msg = "Successful login";
}
else
msg = "Wrong password!";
}
catch (Exception s)
{
}
return msg;
}
public DataSet searchfriend(bllRegistration br)
{
DataSet ds = new DataSet();
try
{
string selsql = "select ('./upload/'+image)imgurl,edit,(firstname + lastname)name,userid,emailid,state,city from tbluser where firstname like '"+br.firstname +"%'";
SqlDataAdapter adp = new SqlDataAdapter(selsql, con);
adp.Fill(ds);
}
catch (Exception s)
{
}
if (ds.Tables[0].Rows.Count > 0)
{
return ds;
}
else
{
return (new DataSet());
}
}
}