3 tier

 NEW FOLDER (newtier)

userBO

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

 

namespace BussinessObject

{

      public class UserBO

      {

        private int _Roll;

        private string _Name;

 

        public int Roll

        {

            get

            {

                return _Roll;

 

            }

            set

            {

                _Roll = value;

            }

        }

        public string Name

        {

            get

            {

                return _Name;

            }

            set

            {

                _Name = value;

            }

        }

      }

 

    

 

 

}

UserDA

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SqlClient;

using BussinessObject;

 

namespace DataAccess

{

     public class UserDA

    {

        SqlConnection con = new SqlConnection(@"pth");

        public int adduserdetail(UserBO objBO)

        {

            string k = "INSERT INTO DEMO (ROLL,NAME) VALUES (@roll1,@name1)";

 

            SqlCommand com  = new SqlCommand(k, con);

 

            com.Parameters.AddWithValue("roll1", objBO);

            com.Parameters.AddWithValue("name1", objBO);

 

            con.Open();

 

            int result = com.ExecuteNonQuery();

 

            return result;

 

 

        }

    }

}

 

userBL

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using DataAccess;

using BussinessObject;

 

namespace BussinessLogic

{

     public class UserBL

    {

 

        public int saveuserdetail(UserBO objBO1)

        {

            UserDA objDA = new UserDA();

 

            return  objDA.adduserdetail(objBO1);

        }

    }

}

 

Comments

Popular posts from this blog

ViewState for state management

Database joining

INTRODUCTION OF C#