Three Tier Architecture

  1.    In  WEB.config do the connection

<connectionStrings>
<add name="company"connectionString="Datasource=MDSWIN48;uid=sa;pwd=Admin2011;
Initial Catalog=Company;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>

</connectionStrings> 
2.  Create the Common classlibrary
a.       Rename the Class1.cs as CustomerInfo.cs
b.      Create get/set method for the data
c.       Then save and Build it.
Code:

namespace COMMON
{
    public class CustomerInfo
    {
        private string username;
        private string password;
        private string id;

        public string Username
        {
            get
            {
                return this.username;
            }
            set
            {
                try
                {
                    this.username = value;
                    if (this.username == string.Empty)
                    {
                        throw new Exception("Enter the username");
                    }
                }
                catch (Exception e)
                {
                    throw new Exception(e.Message.ToString());

                }
            }
        }
        public string Password
        {
            get
            {
                return this.password;
            }
            set
            {
                try
                {
                this.password = value;
                if (this.password == string.Empty)
                {
                    throw new Exception("Enter the password");
                }
                }
                catch (Exception e)
                {
                    throw new Exception(e.Message.ToString());

                }
            }
        }
        public string Id
        {
            get
            {
                return this.id;
            }
            set
            {
               
                try
                {
                    this.id = value;
                    if (this.id  == string.Empty)
                    {
                        throw new Exception("Enter the Id");
                    }
                }
                catch (Exception e)
                {
                    throw new Exception(e.Message.ToString());

                }
            }
        }
    }
}
3.       Create the Data Access Layer Class Library
·         Rename the Class1.cs as DAL.cs
·         Create reference for common
·         Include using COMMON in code
·         Create the connection to the database
·          Then save and Build it.

Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using COMMON;

namespace DAL
{
    public class DACustomer
    {
        public DACustomer()
        { }

        public void Add(CustomerInfo customer)
        {
        
            SqlConnection con = new SqlConnection();

            con.ConnectionString = ConfigurationManager.ConnectionStrings["company"].ConnectionString;
            con.Open();

             SqlCommand command = new SqlCommand("Storelog", con);
             command.CommandType = CommandType.StoredProcedure;

             try
            {
                command.Parameters.AddWithValue("@UserName", customer.Username);
                command.Parameters.AddWithValue("@Password", customer.Password);
                command.Parameters.AddWithValue("@Id", customer.Id);
                command.ExecuteNonQuery();

            }

             catch
             {
                 throw;
             }
             finally
             {
                 command.Dispose();
                 con.Close();
                 con.Dispose();
             }
       
        }
    }
}

4       Create the Business  Access Layer Class Library
·         Rename the Class1.cs as BOCustomer.cs
·         Create reference for common, DAL
·         Include using COMMON and DAL in code
·         Then save and Build it.

Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using COMMON;
using DAL;

namespace BAL
{
    public class BOCustomer
    {
        public void AddCust(CustomerInfo customer)
        {
            DACustomer DACust = new DACustomer();
            DACust.Add(customer);
        }
    }
}
5.       In Default.UI
·         Create reference for common, BAL
·         Include using COMMON and BAL in code
·         Then save and Build it.
Code:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using COMMON;
using BAL;

namespace WebApplication1
{
    public partial class _Default : System.Web.UI.Page
    {
        BOCustomer BCUST = new BOCustomer();
        CustomerInfo CUST = new CustomerInfo();

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                CUST.Username = txtUserName.Text.Trim();
                CUST.Password = txtPassword.Text.Trim();
                CUST.Id = txtId.Text.Trim();
                BCUST.AddCust(CUST);
            }
            catch
            {
                throw;
            }
        }
    }
}



Comments

Post a Comment

Popular posts from this blog

How to retain the data annotations or class during modify a table in the database

Image
In database-first approach since there is an existing database., The entity classes are automatically created by edmx model.: If we use [MetadataType(typeof(ConceptMetadataSource))] to attach a MetadataSource file which contains all the data annotations like [HiddenInput(DisplayValue = false)] or [Display(Name = "Title")]. The data annotations will be wiped out each time the entity classes are regenerated as the code will be regenerated once we modify a table in the database Solution: All you have to do is create another partial class and use Metadatatype attribute Create a metadata class in models as below…   Create a Partial class for the metadata in models as below… The new partial class can be created in a different folder
Read more

Interview Questions

Difference between GET and POST. Which one is more secure? GET and POST methods are used for the data transfer between the web pages. GET mainly used for small data which is not secure because in case of GET method, the data which we are passing will be visible in the url so we can't keep the secure data which will be visible in the url. There is also limited data which can be passed in case of GET method (max 255 character). POST is used for transferring the huge data between the pages where we can keep the secure data and can transfer it. In case of using the POST method, the data which is transferring between the pages will not be visible so it is more secure than the GET method. Also there is no limit for POST method to post the data to the next page. POST is more secure What are Razor engines? How is it diff from ASP Engines? A. RAZOR engine is the new concept in the MVC 3 which is mainly used to create the views in the MVC applications. It created the cshtml pages for...
Read more

AJAX CONTROL

Image
1.        Goto  web confiq add following controls        < controls >   < add tagPrefix = " ccl " namespace = " AjaxContolToolkit " assembly   = " AjaxContolToolkit " />      </ controls > 2.        Go to  bin folder  ->  include project -> add ajax.dll file from AjaxControl Toolkit 3.        Add  toolsciptmanager  to default.aspx            < asp : ToolkitScriptManager ID ="ToolkitScriptManager1" runat ="server">         </ asp : ToolkitScriptManager > 4.        Create a function < script type = "text/javascript" >     function panelclick()     {    alert( "click" );  ...
Read more