Thursday, 19 December 2013

How to work with Three Tier Architecture in Asp.Net

//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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <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;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <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()" >&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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 ;">
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:TextBox ID="txtupdate" runat="server" Width="350px"></asp:TextBox>&nbsp;<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;">&nbsp;&nbsp;<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;">&nbsp;&nbsp;<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;">&nbsp;&nbsp;<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>&nbsp;&nbsp;<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" />&nbsp&nbsp<asp:LinkButton ID="profile" runat="server" Text="Profie"></asp:LinkButton>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<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" />&nbsp&nbsp<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" />&nbsp&nbsp<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"  />&nbsp&nbsp<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" />&nbsp&nbsp<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"/>&nbsp&nbsp<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"/>&nbsp&nbsp<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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;photos&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;videos<br /><asp:ImageButton ID="headscrap" runat="server" ImageUrl="~/IMAGE/p_scrap.gif" PostBackUrl="~/scrap.aspx"  OnClick="headscrap_Click" />&nbsp;<a href="scrap.aspx"><asp:Label ID="lblheadscrap" runat="server" Text="21" > </asp:Label></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:ImageButton ID="imgphotos" runat="server" ImageUrl="~/IMAGE/p_camera.gif"  PostBackUrl="~/picture.aspx"  />&nbsp<asp:Label ID="lblpicture" runat="server" Text="21"> </asp:Label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:ImageButton ID="ImageButton6" runat="server" ImageUrl="~/IMAGE/p_video.gif"  />&nbsp;<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">&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<asp:Button ID="btnaddfri" runat="server" Width="60" Text="Add" CommandName="btn_add"  CommandArgument='<%#Eval("friendid") %>' />&nbsp&nbsp&nbsp&nbsp&nbsp<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> &nbsp;&nbsp;<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());
        }

      
    }
           

}
 

 

No comments:

Post a Comment