Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
Create login and register page in asp net example in 3 tier architecture
91011 Views
Introduction 
In this lesson i explained about how to make registation and login with logout in asp.net using 3 layer achitecture.I have done asp validation for all the fields.
BalLogin.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DAL;

namespace BAL
{
    public class balLogin
    {
        dalLogin dallogin = new dalLogin();
        public int ballog(string userid, string pass)//checking the usename and password
        {
            try
            {
                int a = dallogin.userlogin(userid, pass);
                string b = dallogin.userlog(userid, pass);
                if (a == 1 && (b == "Level1" || b == "Level2" || b == "Level3" ))
                {
                    return 1;
                }
                else if (a == 1 && b == "admin")
                {
                    return 2;
                }
                else
                {
                    return 0;
                }
            }
            catch (Exception ec)
            {
                ec.GetType();
            }
            return 0;

        }
        public string usertype(string user, string pass)//checking the userType
        {
            try
            {
               return dallogin.userlog(user, pass);
            }
            catch(Exception ex)
            {
                throw ex;
            }
        }
    }
}
DalRegister.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using BO;


namespace DAL
{
    public class dalRegister
    {
        SqlConnection conn = new SqlConnection(@"data source=LAKSHANYA\SQLEXPRESS;database=master;integrated security=true");
        public int dalreg(boRegister boregister)
        {
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand("insert into user_table values('" + boregister.userName + "','" + boregister.gender + "','" + boregister.password + "','" + boregister.cPassword + "','" + boregister.fees + "','" + boregister.userType + "','" + boregister.eMail + "')", conn);
                cmd.ExecuteNonQuery();
                return 1;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
        }
    }
}
DalLogin.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class dalLogin
    {
        SqlConnection con = new SqlConnection(@"data source=LAKSHANYA\SQLEXPRESS;database=master;integrated security=true");
        public int userlogin(string user, string passw)//checking the user name and password.If matched count 1 not 0.
        {
            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("select count(*) from user_table where userName='" + user + "'and password='" + passw + "'", con);
                int a = Convert.ToInt32(cmd.ExecuteScalar());
                return a;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }
        public string userlog(string user, string passw)//getting the userType
        {

            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("select userType from user_table where userName='" + user + "' and password='" + passw + "'", con);
                string a = cmd.ExecuteScalar().ToString();
                return a;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }

    }
}
Note 
For logout i did that in master page. so that logout option will come in all the pages.
Include this in your master page
<div class="loginDisplay">
            Welcome
                <asp:Label ID="lblUser" runat="server"></asp:Label>
            &nbsp;&nbsp;&nbsp;
                <asp:Button ID="Sign_out" runat="server" onclick="Sign_out_Click"
                    Text="Signout" />
</div>
Master.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace cdManage
{
    public partial class SiteMaster : System.Web.UI.MasterPage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblUser.Text = Session["userName"].ToString();
        }

        protected void Sign_out_Click(object sender, EventArgs e)
        {
            Session.Remove("userName");
            Response.Redirect("Home.aspx");
        }
    }
}
Look of this logout After logged in 
Conclusion 
I think my lesson helped you.Thanks for reading it.
Preview of page 
Note 
I have created seperate notes for registration page and also for login.If you get any clarification see that lessons.I have explained deeply in that notes.In this lesson i gave the codes with combination of registration and login operations.
Registration page click here For login page click here.
Solution expolrer 
Note : Dont forget to refer the class library.Because i have done this in 3 layer architecture

Inside BAL class library i have created class named balRegister.cs and balLogin.cs
Inside BO class library i have created class named boRegister.cs
Inside DAL class library i have created class named dalRegister.cs dalLogin.cs
Inside cdManage application i have created web form named Home.aspx
Below i gave code for all the classes and web form.
Create table
	create table user_table(
	userName varchar(20),
	gender varchar(20),
	password varchar(20),
	cpassword varchar(20),
	fees varchar(20),
	userType varchar(20),
	email varchar(50))
Home.aspx
<!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">
    <title></title>
    <link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .style1
        {
            width: 436px;
            text-align: center;
            height: 45px;
        }
        .style2
        {
            color: #0066CC;
            text-align: center;
        }
        .style7
        {
            height: 45px;
            color: #0066CC;
            text-align: left;
        }
        .style8
        {
            height: 45px;
            color: #0066CC;
            text-align: center;
        }
        .style9
        {
            height: 45px;
            color: #0066CC;
            width: 256px;
            text-align: center;
        }
        .style10
        {
            width: 237px;
            text-align: center;
            height: 26px;
        }
        .style11
        {
            width: 225px;
            text-align: center;
            height: 26px;
        }
        .style12
        {
            color: #0066CC;
            width: 256px;
            text-align: center;
        }
        .style13
        {
            color: #0066CC;
            text-align: left;
        }
        .style14
        {
            width: 436px;
            text-align: center;
            height: 30px;
        }
        .style15
        {
            height: 30px;
            color: #0066CC;
            width: 256px;
            text-align: center;
        }
        .style16
        {
            height: 30px;
            color: #0066CC;
            text-align: left;
        }
        .style17
        {
            width: 436px;
            text-align: center;
            height: 38px;
        }
    </style>
</head>
<body>
    <form id="Form1" runat="server">
    <div class="page">
        <div class="header">
            <div class="title">
                <h1>
                    GK CdS Ltd.
                </h1>
            </div>
            <div class="loginDisplay">
            </div>
            <div class="clear hideSkiplink">
            </div>
        </div>
        <script type="text/javascript" >
            function do_highlight(ele) {
                document.getElementById(ele.id).style.color = "black";

                if (ele.id.indexOf("UserName") != -1 && document.getElementById(ele.id).value == "Username") {
                    document.getElementById(ele.id).value = "";
                }
                if (ele.id.indexOf("PassLog") != -1 && document.getElementById(ele.id).value == "Password") {
                    document.getElementById(ele.id).value = "";
                }
            }

            function do_unfocus(ele) {
                if (ele.id.indexOf("UserName") != -1 && document.getElementById(ele.id).value == "") {
                    document.getElementById(ele.id).value = "Username";
                }
                if (ele.id.indexOf("PassLog") != -1 && document.getElementById(ele.id).value == "") {
                    document.getElementById(ele.id).value = "Password";
                }

                if (ele.id.indexOf("UserName") != -1 && document.getElementById(ele.id).value == "Username")
                    document.getElementById(ele.id).style.color = "rgb(70,70,70)";

                if (ele.id.indexOf("PassLog") != -1 && document.getElementById(ele.id).value == "Password")
                    document.getElementById(ele.id).style.color = "rgb(70,70,70)";
            }
        </script>
        
        <div class="clear">
            <br />
            <h2><centre>Welcome to GK CdS Ltd</centre></h2><br />
            <br />
            <br />
            <br />
            <br />
            <table style="width:100%;">
                <tr>
                    <td style="color: #0033CC" class="style1" colspan="2">
                        <h3 class="style2"><strong> Members Login Here</strong></h3></td>
                    <td  colspan="2">
                       <h3 class="style2"> <strong>New Member Sign Up Here</strong></h3></td>
                </tr>
                <tr>
                    <td class="style14" colspan="2">
                        &nbsp;&nbsp;
                        <asp:TextBox ID="UserName"  runat="server" onfocus="do_highlight(this);"
                            onblur="do_unfocus(this);" value="Username"  
                            MaxLength="20" ForeColor="#707070"></asp:TextBox>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                        <asp:TextBox ID="PassLog" runat="server"  onfocus="do_highlight(this);"
                            onblur="do_unfocus(this);" value="Password" ForeColor="#707070"
                            MaxLength="10" TextMode="Password"></asp:TextBox>
                    </td>
                    <td class="style15">
                        User Name</td>
                    <td class="style16">
                        <asp:TextBox ID="Uname" runat="server" MaxLength="15"></asp:TextBox>
                        <br />
                        <asp:RequiredFieldValidator ID="re_user" runat="server"
                            ControlToValidate="Uname" Display="Dynamic"
                            ErrorMessage="Please enter the User Name" ForeColor="Red"
                            ValidationGroup="signUp"></asp:RequiredFieldValidator>
                    </td>
                </tr>
                <tr>
                    <td class="style11">
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
                            ControlToValidate="UserName" ErrorMessage="Please Enter the User Name"
                            ForeColor="Red" InitialValue="Username" ValidationGroup="login_gr"></asp:RequiredFieldValidator>
                    </td>
                    <td class="style10">
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
                            ControlToValidate="PassLog" ErrorMessage="Please Enter the Password"
                            ForeColor="Red" InitialValue="Password" ValidationGroup="login_gr"></asp:RequiredFieldValidator>
                    </td>
                    <td class="style12" rowspan="2">
                        Gender</td>
                    <td class="style13" rowspan="2">
                        <asp:RadioButtonList ID="Gender" runat="server" RepeatDirection="Horizontal">
                            <asp:ListItem>Male</asp:ListItem>
                            <asp:ListItem>Female</asp:ListItem>
                        </asp:RadioButtonList>
                        <asp:RequiredFieldValidator ID="re_gender" runat="server"
                            ControlToValidate="Gender" Display="Dynamic"
                            ErrorMessage="Please Select the Gender" ForeColor="Red"
                            ValidationGroup="signUp"></asp:RequiredFieldValidator>
                    </td>
                </tr>
                <tr>
                    <td class="style17" colspan="2">
                        <asp:Button ID="Login" class="button_example" runat="server" Text="Login"
                            onclick="Login_Click" ValidationGroup="login_gr" Height="38px" />
                    </td>
                </tr>
                <tr>
                    <td class="style1" colspan="2">
                        <asp:Label ID="log_mess" runat="server"></asp:Label>
                    </td>
                    <td class="style9">
                        Password</td>
                    <td class="style7">
                        <asp:TextBox ID="Password" runat="server" MaxLength="8" TextMode="Password"></asp:TextBox>
                        <br />
                        <asp:RequiredFieldValidator ID="re_pass" runat="server"
                            ControlToValidate="Password" Display="Dynamic"
                            ErrorMessage="Please Enter the Password" ForeColor="Red"
                            ValidationGroup="signUp"></asp:RequiredFieldValidator>
                    </td>
                </tr>
                <tr>
                    <td class="style1" colspan="2">
                        &nbsp;</td>
                    <td class="style9">
                        Confirm Password</td>
                    <td class="style7">
                        <asp:TextBox ID="Cpassword" runat="server" MaxLength="8" TextMode="Password"></asp:TextBox>
                        <br />
                        <asp:RequiredFieldValidator ID="re_cpass" runat="server"
                            ControlToValidate="Cpassword" Display="Dynamic"
                            ErrorMessage="Please Enter the Confirm Password" ForeColor="Red"
                            ValidationGroup="signUp"></asp:RequiredFieldValidator>
                        <br />
                        <asp:CompareValidator ID="re_passCompare" runat="server"
                            ControlToCompare="Password" ControlToValidate="Cpassword" Display="Dynamic"
                            ErrorMessage="Password Mismatch" ForeColor="Red" ValidationGroup="signUp"></asp:CompareValidator>
                    </td>
                </tr>
                <tr>
                    <td class="style1" colspan="2">
                        &nbsp;</td>
                    <td class="style9">
                        Fees</td>
                    <td class="style7">
                        <asp:DropDownList ID="Fees" runat="server">
                            <asp:ListItem></asp:ListItem>
                            <asp:ListItem>299</asp:ListItem>
                            <asp:ListItem>249</asp:ListItem>
                            <asp:ListItem>Free User</asp:ListItem>
                        </asp:DropDownList>
                        <br />
                        <asp:RequiredFieldValidator ID="re_fees" runat="server"
                            ControlToValidate="Fees" ErrorMessage="Please Select the Fees" ForeColor="Red"
                            ValidationGroup="signUp"></asp:RequiredFieldValidator>
                    </td>
                </tr>
                <tr>
                    <td class="style1" colspan="2">
                        &nbsp;</td>
                    <td class="style9">
                        E-mail Id</td>
                    <td class="style7">
                        <asp:TextBox ID="eMail" runat="server"></asp:TextBox>
                        <br />
                        <asp:RequiredFieldValidator ID="re_email" runat="server"
                            ControlToValidate="eMail" Display="Dynamic"
                            ErrorMessage="Please Enter the Email" ForeColor="Red" ValidationGroup="signUp"></asp:RequiredFieldValidator>
                        <br />
                        <asp:RegularExpressionValidator ID="re_validemail" runat="server"
                            ControlToValidate="eMail" Display="Dynamic"
                            ErrorMessage="Enter the Valid Email Id" ForeColor="Red"
                            ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
                            ValidationGroup="signUp"></asp:RegularExpressionValidator>
                    </td>
                </tr>
                <tr>
                    <td class="style1" colspan="2">
                        &nbsp;</td>
                    <td class="style8" colspan="2">
                        <asp:Button ID="Button1" class="button_example" runat="server" Text="Sign Up"
                            onclick="Button1_Click" ValidationGroup="signUp"
                            />
                    </td>
                </tr>
                <tr>
                    <td class="style1" colspan="2">
                        &nbsp;</td>
                    <td class="style8" colspan="2">
            <asp:Label runat="server" ID="message"></asp:Label>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div class="footer">   
    </div>
    </form>
</body>
</html>
Home.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BO;
using BAL;

namespace cdManage
{
    public partial class Home : System.Web.UI.Page
    {
        boRegister register = new boRegister();
        balRegister balregister = new balRegister();
        balLogin ballogin = new balLogin();
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            register.userName = Uname.Text;
            register.gender = Gender.SelectedValue;
            register.password = Password.Text;
            register.cPassword = Cpassword.Text;
            register.fees = Fees.SelectedValue;
            register.eMail = eMail.Text;
            if (Fees.SelectedIndex ==1)
                register.userType = "Level1";
            if (Fees.SelectedIndex == 2)
                register.userType = "Level2";
            else if(Fees.SelectedIndex == 3)
                register.userType = "Level3";
            int value= balregister.balreg(register);
            Uname.Text = "";
            Gender.ClearSelection();
            Fees.SelectedIndex = 0;
            eMail.Text = "";
            if (value == 1)
            {
                message.Text = "Registered Successfully";
            }
            else
            {
                message.Text = "User Name Not Available.Try With Different User Name";
            }
        }

        protected void Login_Click(object sender, EventArgs e)
        {
            string userName = UserName.Text;
            string password = PassLog.Text;
            int a = ballogin.ballog(userName, password);
            UserName.Text = "";
            PassLog.Text = "";
            if (a == 1)
            {
                Session["userName"] = userName;
                string type = ballogin.usertype(userName, password);
                Session["usertype"] = type;
                Response.Redirect("userHome.aspx");
            }
            else if (a == 2)
            {
                Session["userName"] = userName;
                Response.Redirect("adminHome.aspx");
            }
            else
            {
                log_mess.Text = "Enter the valid id";
            }        
        }
    }
}
BoRegister.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BO
{
    public class boRegister
    {
        private string _userName;
        public string userName
        {
            get { return _userName; }
            set { _userName = value; }
        }
        private string _gender;
        public string gender
        {
            get { return _gender; }
            set { _gender = value; }
        }
        private string _fees;
        public string fees
        {
            get { return _fees; }
            set { _fees = value; }
        }
        private string _password;
        public string password
        {
            get { return _password; }
            set { _password = value; }
        }

        private string _cPassword;
        public string cPassword
        {
            get { return _cPassword; }
            set { _cPassword = value; }
        }

        private string _eMail;
        public string eMail
        {
            get { return _eMail; }
            set { _eMail = value; }
        }

        private string _usertype;
        public string userType
        {
            get { return _usertype; }
            set { _usertype = value; }
        }
    }
}
BalRegister.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BO;
using DAL;

namespace BAL
{
    public class balRegister
    {
        dalRegister dalregister = new dalRegister();
        public int balreg(boRegister boregister)
        {
            try
            {
                return dalregister.dalreg(boregister);
            }
            catch (Exception ex)
            {
                ex.GetType();
            }
            return 0;
        }
    }
}
Best Lessons of "Asp.net/Ado.net/C#.net(Dotnet)"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details