mercredi 26 novembre 2014

how to write code in 3 tier architecture


Vote count:

-2




Below code i write in simple example.aspx.cs file.



protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GetCustomersPageWise(1);
}
}

protected void PageSize_Changed(object sender, EventArgs e)
{
this.GetCustomersPageWise(1);
}

private void GetCustomersPageWise(int pageIndex)
{
string constring = ConfigurationManager.ConnectionStrings["constring"].ConnectionString;
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("GetCustomersPageWise", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", int.Parse(ddlPageSize.SelectedValue));
cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
con.Open();
IDataReader idr = cmd.ExecuteReader();
EmployeeList.DataSource = idr;
EmployeeList.DataBind();
idr.Close();
con.Close();
int recordCount = Convert.ToInt32(cmd.Parameters["@RecordCount"].Value);
this.PopulatePager(recordCount, pageIndex);
}
}
}

protected void Page_Changed(object sender, EventArgs e)
{
int pageIndex = int.Parse((sender as LinkButton).CommandArgument);
this.GetCustomersPageWise(pageIndex);
}

private void PopulatePager(int recordCount, int currentPage)
{
double dblPageCount = (double)((decimal)recordCount / decimal.Parse(ddlPageSize.SelectedValue));
int pageCount = (int)Math.Ceiling(dblPageCount);
List<ListItem> pages = new List<ListItem>();
if (pageCount > 0)
{
pages.Add(new ListItem("First", "1", currentPage > 1));
for (int i = 1; i <= pageCount; i++)
{
pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage));
}
pages.Add(new ListItem("Last", pageCount.ToString(), currentPage < pageCount));
}
rptPager.DataSource = pages;
rptPager.DataBind();
}




but now i want to write in Business Logic layer class. so how to write?? In BusinessLogicLayer class method like this :



#region pagination
public DataSet GetAllJobs(BussinessObj objBussiness)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Mode", "DisplayDataPaging");
param[1] = new SqlParameter("@PageIndex", objBussiness.PageIndex);
param[2] = new SqlParameter("@PageSize", objBussiness.PageSize);
param[3] = new SqlParameter("@RecordCount", SqlDbType.Int, 4);
return objDataAccess.ExecuteDataset(_spName, param);
}
#endregion


asked 2 mins ago







how to write code in 3 tier architecture

Aucun commentaire:

Enregistrer un commentaire