public static void LoadCallLogPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, Label lbltotalrecord, int LocationID, DateTime FromDate, DateTime ToDate, String UserID, string SignUp)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlClientProvider sqlClientProvider = new SqlClientProvider();
DataSet ds = sqlClientProvider.GetCallLogPageWise(search_val, pageIndex, PageSize, out recordCount, LocationID, FromDate, ToDate, UserID, SignUp);
gv.DataSource = ds;
gv.DataBind();
string htmlStatus = "";
foreach (DataRow dr in ds.Tables[1].Rows)
{
htmlStatus += dr["TourStatusName"].ToString() + " : (<b>";
int count = 0;
foreach (DataRow drCount in ds.Tables[2].Rows)
{
if (drCount["StastusID"].ToString() == dr["TourStatusID"].ToString())
{
count = int.Parse(drCount["NoOfRecords"].ToString());
}
}
htmlStatus += count.ToString() + "</b>) ";
}
lbltotalrecord.Text = htmlStatus + " Total Record Found : (<b>" + recordCount + "</b>)";
clientsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static void LoadCallLogPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, Label lbltotalrecord, int LocationID, DateTime FromDate, DateTime ToDate, String UserID, string SignUp)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlClientProvider sqlClientProvider = new SqlClientProvider();
DataSet ds = sqlClientProvider.GetCallLogPageWise(search_val, pageIndex, PageSize, out recordCount, LocationID, FromDate, ToDate, UserID, SignUp);
gv.DataSource = ds;
gv.DataBind();
string htmlStatus = "";
foreach (DataRow dr in ds.Tables[1].Rows)
{
htmlStatus += dr["TourStatusName"].ToString() + " : (<b>";
int count = 0;
foreach (DataRow drCount in ds.Tables[2].Rows)
{
if (drCount["StastusID"].ToString() == dr["TourStatusID"].ToString())
{
count = int.Parse(drCount["NoOfRecords"].ToString());
}
}
htmlStatus += count.ToString() + "</b>) ";
}
lbltotalrecord.Text = htmlStatus + " Total Record Found : (<b>" + recordCount + "</b>)";
clientsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
