Search code examples
asp.netvb.netsessioncontentplaceholder

Sessions & ContentPlaceHolders

Is it possible to set a Container(ContentPlaceHolder) in the MasterPage, and hide it whenever wished ?

For example, I want to put a 2 textboxes and a button for a user to login, but if the session is still running (i.e. user already logged in) I want the change those 2 textboxes and button to a welcome message (for example: "Welcome, Username").

enter image description here

MasterPage (Note: Not everything is coded)

<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<script runat="server">

    Protected Sub Button1_Click(sender As Object, e As EventArgs)

        Dim loginSQL As New SqlCommand
        Dim loginComm As String

        Dim CommonFunctions As New CommonFunctions()
        Dim dec_pass As String = CommonFunctions.EncryptPassword(txtLoginPass.Text.Trim)

        Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True")


        loginComm = "SELECT userid FROM users WHERE username=@username and password=@password"

        conn.Open()


        loginSQL = New SqlCommand(loginComm, conn)
        loginSQL.Parameters.AddWithValue("@username", txtLoginUser.Text.ToString)
        loginSQL.Parameters.AddWithValue("@password", dec_pass)
        Dim dr As SqlDataReader = loginSQL.ExecuteReader()

        If dr.HasRows Then
            Session("userid") = dr("userid")
        ElseIf dr.HasRows = False Then
            lblRegister.ForeColor = Drawing.Color.Red
            lblRegister.Text = "Incorrect Username/Password."
        End If

    End Sub

    Protected Sub Page_Load(sender As Object, e As EventArgs)

        If Session("userid") <> "" Then
            txtLoginUser.Visible = False
            txtLoginPass.Visible = False
        Else

            Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True")

            Dim useridComm As String = "SELECT name, surname FROM users WHERE userid=@userid"
            Dim sqlUserID As New SqlCommand

            conn.Open()

            Dim userid As String = Session("userid")

            sqlUserID = New SqlCommand(useridComm, conn)
            sqlUserID.Parameters.AddWithValue("@userid", userid)
            Dim datareader As SqlDataReader = sqlUserID.ExecuteReader()

            lblLoggedIn.Text = "Welcome," + txtLoginUser.Text
        End If
    End Sub

</script>



<head>
    <meta charset="utf-8" />
    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    <title></title>
    <meta name="keywords" content="" />
    <meta name="description" content="" />
    <link rel="stylesheet" href="style.css" type="text/css" media="screen, projection" />
</head>

<body>

    <form id="form1" runat="server">

<div id="wrapper">

    <header id="header">
        <strong>Header:</strong> Mobile CMS

        </header>


<section id="login">

    <div id="login-form">



            <asp:ContentPlaceHolder id="ContentPlaceHolder2" runat="server">

                <p>

                    <asp:Label ID="lblUsername" runat="server" Font-Bold="True" Text="U:"></asp:Label>
&nbsp;<asp:TextBox ID="txtLoginUser" runat="server" BorderStyle="None" BorderWidth="0px" Wrap="False"></asp:TextBox>
&nbsp;
                    <asp:Label ID="lblUsername0" runat="server" Font-Bold="True" Text="P:"></asp:Label>
                    <asp:TextBox ID="txtLoginPass" runat="server" BorderStyle="None" BorderWidth="0px" TextMode="Password" Wrap="False"></asp:TextBox>
&nbsp;
                    <asp:Button ID="btnLogin" runat="server" BorderStyle="None" OnClick="Button1_Click" Text="Login" />

                </p>

                <p>

                    <asp:Label ID="lblRegister" runat="server" Font-Bold="True" Font-Underline="True" ForeColor="#0000CC" Text="Register"></asp:Label>

                    <asp:ContentPlaceHolder ID="ContentPlaceHolder3" runat="server">
                        <asp:Label ID="lblLoggedIn" runat="server" Text=""></asp:Label>
                    </asp:ContentPlaceHolder>

                </p>


                </asp:ContentPlaceHolder>



    </div>

</section>

<div class="navigation-bar">
       <ul class="navigation-menu">

            <li><a href="#" class="home">Home</a></li>
            <li><a href="#" class="mainsettings">Settings</a></li>
            <li><a href="#" class="profile">Profile</a>

                <ul>
                    <li><a href="#" class="messages">Messages</a></li>
                    <li><a href="#" class="settings">Profile Settings</a></li>
                </ul>

            </li>
            <li><a href="#" class="uploads">Uploads</a></li>
            <li><a href="#" class="documents">Media</a>


                <ul>
                    <li><a href="#" class="docs">Documents</a></li>
                    <li><a href="#" class="others">Others</a></li>
                </ul>

            </li>

            <li><a href="#" class="projects">Projects</a>


                <ul>
                    <li><a href="#" class="yprojects">Your Projects</a></li>
                    <li><a href="#" class="otherprojects">Other Projects</a></li>
                </ul>

            </li>

        </ul>

    </div>


    <section id="middle">

        <div id="container">
            <div id="content">
                <div>
                    <asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">

                    </asp:ContentPlaceHolder>
                </div>
        </div>
        </div>



    </section>

    <footer id="footer">
        <strong>Footer:</strong> adsfdsgfds
    </footer>

</div>

    </form>

</body>
</html>
Solution

  • Firstly, you have a ContentPlaceHolder inside another ContentPlaceHolder and I can't see any reason for this.

    <asp:ContentPlaceHolder ID="ContentPlaceHolder3" runat="server">
   <asp:ContentPlaceHolder id="ContentPlaceHolder2" runat="server">

    To the matter in hand, I would hide the controls contained within the ContentPlaceHolder depending on whether the user is logged in or not, rather than hiding the placeholder, however this is up to you. I would also add the userid column to your SQL query.

    The follwing should get you started, note this is untested off the top of my head:

    SELECT userid, username, password FROM users ....

    If dr.HasRows Then
  Session("userid") = dr("userid")
ElseIf dr.HasRows = False Then
   lblRegister.ForeColor = Drawing.Color.Red
   lblRegister.Text = "Incorrect Username/Password."
End If

    Now that you have this, you can check the Session variable on Page_Load to see if the user is logged in.

    Protected Sub Page_Load(sender As Object, e As EventArgs)
  If Session("userid") <> "" Then
    txtLoginUser.Visible = False
    txtLoginPass.Visible = False
  Else
    'Set your label text here, query the database to get the First and Second name of the user using the `userid`
  End If
End Sub

    EDIT You need to close your readers after you have finished reading:

    dr.Close() and datareader.Close()

    Also this line lblLoggedIn.Text = "Welcome," + txtLoginUser.Text needs to be: 

    lblLoggedIn.Text = datareader("name").ToString() & " " &
datareader("surname").ToString()