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
Post a Comment