Three Layer Architecture Project Coding--Login & SignUp

Step-1:- Create Database.

create table tblRegister(pkUserName varchar(50) primary key,[Password] varchar(50),
EmailId varchar(50),MobileNo bigint,SecQuest varchar(250),SecurityAns varchar(250))

create procedure usp_SignUp @userName varchar(50),@password varchar(50),
@emailId varchar(50),@mobileNo bigint,@secQuest varchar(50),@secAns varchar(50)
as
begin
insert into tblRegister(pkUserName,[Password],EmailId,MobileNo,SecQuest,SecurityAns)
values(@userName,@password,@emailId,@mobileNo,@secQuest,@secAns)
end

create procedure usp_GetRegisteredUser @userName varchar(50),@password varchar(50)
as
begin
select * from tblRegister where pkUserName=@userName and [Password]=@password
end

Step-2:- Create a class file as DALUser.cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
public class DALUser
{
    public bool SignUp(Register regObj)
    {
        try
        {
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand("usp_SignUp", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;//compulsry
                    cmd.Parameters.AddWithValue("@userName", regObj.UserName);
                    cmd.Parameters.AddWithValue("@password", regObj.Password);
                    cmd.Parameters.AddWithValue("@emailId", regObj.EmailId);
                    cmd.Parameters.AddWithValue("@mobileNo", regObj.MobileNo);
                    cmd.Parameters.AddWithValue("@secQuest", regObj.SecQuest);
                    cmd.Parameters.AddWithValue("@secAns", regObj.SecAns);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    return true;
                }
            }
        }
        catch (Exception)
        {
            return false;
        }
    }
    public Register GetRegisteredUser(string userName, string password)
    {
        try
        {
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand("usp_GetRegisteredUser", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@userName", userName);
                    cmd.Parameters.AddWithValue("@password", password);
                    con.Open();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        if (sdr.HasRows)
                        {
                            Register userObj = new Register();
                            while (sdr.Read())
                            {
                                userObj.UserName = sdr[0].ToString();
                                userObj.Password = sdr[1].ToString();
                                userObj.EmailId = sdr[2].ToString();
                                userObj.MobileNo = Convert.ToInt64(sdr[3]);
                                userObj.SecQuest = sdr[4].ToString();
                                userObj.SecAns=sdr[5].ToString();
                                return userObj;
                            }
                            return null;
                        }
                        return null;
                    }
                }
            }
        }
        catch (Exception)
        {
            return null;
        }
    }
}

Step-3:- Create a class file as BLLUser.cs

using System;
using System.Collections.Generic;

public class BLLUser
{
    DALUser dalObj = null;
    public BLLUser()
    {
        dalObj = new DALUser();
    }
    public bool SignUpBLL(Register regObj)
    {
        return dalObj.SignUp(regObj);
    }
    public bool Authenticate(string userName, string password)
    {
        Register regObj = dalObj.GetRegisteredUser(userName, password);
        if (regObj != null)
        {
            //Server Side Validation
            if (userName.Equals(regObj.UserName) && password.Equals(regObj.Password))
            {
                return true;
            }
            return false;
        }
        return false;
    }
}

Step-4:- Create a class file as Register.cs

using System;
using System.Collections.Generic;

public class Register
{
    public Register()
    {
    }
    public string UserName { get; set; }
    public string Password { get; set; }
    public string EmailId { get; set; }
    public long MobileNo { get; set; }
    public string SecQuest { get; set; }
    public string SecAns { get; set; }
}

Step-5:- Create a login form.

    protected void btnSignIn_Click(object sender, EventArgs e)
    {
        BLLUser bllUserObj = new BLLUser();
        bool temp = bllUserObj.Authenticate(txtUserName.Text,txtPassword.Text);
        if (temp)
        {
            Session["username"] = txtUserName.Text;
            Server.Transfer("frmWelcome.aspx");
        }
        else {
            lblStatus.Text = "Login Failed";
            lblStatus.ForeColor = System.Drawing.Color.Red;
        }

Step-6:- Create a Register form.

   protected void btnSignUp_Click(object sender, EventArgs e)
    {
        Register regObj = new Register();
        regObj.UserName = txtUserName.Text;
        regObj.Password = txtPassword.Text;
        regObj.EmailId = txtEmail.Text;
        regObj.MobileNo = Convert.ToInt64(txtMobileNo.Text);
        regObj.SecQuest = txtSecQuest.Text;
        regObj.SecAns = txtSecAns.Text;
        BLLUser bllUserObj = new BLLUser();
        bool temp = bllUserObj.SignUpBLL(regObj);
        if (temp)
        {
            lblStatus.Text = "Congratulation!!!!Registeraiton Successfull";
            lblStatus.ForeColor = System.Drawing.Color.Green;
        }
        else
        {
            lblStatus.Text = "Sorry..!Registeraiton Unsuccessfull";
            lblStatus.ForeColor = System.Drawing.Color.Red;
        }
    }

Step-7:- Create a Welcome form.

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["username"] != null)
            {
                lblStatus.Text = "Welcome " + Session["username"].ToString();
            }
            else
            {
                Server.Transfer("frmLogin.aspx");
            }
        }
    }

Step-7:- Add connectionStrings tag on Web.config .

 <connectionStrings>
    <add name="conn" connectionString="Data Source= UTPAL;Initial Catalog=threetier_db;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>