public void BindRecord(string searchby, int pageS)
{
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["Ad_ConnectionStringMain"].ToString());
SqlCommand cmd = new SqlCommand("GetSearchFromMasterPage", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", 1);
cmd.Parameters.AddWithValue("@PageSize", pageS);
cmd.Parameters.AddWithValue("@RecordCount", "");
cmd.Parameters.AddWithValue("@Searchby", searchby);
SqlDataAdapter daP = new SqlDataAdapter(cmd);
DataTable dtProduct = new DataTable();
daP.Fill(dtProduct);
clsAssignDataCollection getVW_Item = new clsAssignDataCollection();
uc_VwProduct1.ProductItemBind(getVW_Item.GetViewProductCommon(dtProduct.ToList<vw_OfferItem>()));
//if (dtProduct.Rows.Count > 0)
// lnkLoadmoreRecords.Visible = true;
//else
// lnkLoadmoreRecords.Visible = false;
//ViewState["NoofProduct"] = dtProduct;
}
catch (Exception ex)
{ }
}
public void BindDatasetRecordSet()
{
DataTable dtDatasetResult = (DataTable)ViewState["DatasetResult"];
ViewState["TotalPages"] = (Convert.ToInt32(dtDatasetResult.Rows.Count) / pageSize) + 1;
clsAssignDataCollection getVW_Item = new clsAssignDataCollection();
DataTable dt = objSearch.FunctionForPaging(dtDatasetResult, CurrentPage, pageSize);
uc_VwProduct1.ProductItemBind(getVW_Item.GetViewProductCommon(dt.ToList <vw_OfferItem>()));
PagingInRepeater();
}
public void BindRecord(string sortby)
{
try
{
DataTable dtprice = new DataTable();
dtprice.Columns.Add("HighPrice");
dtprice.Columns.Add("LowPrice");
if (txtPriceTo.Text != string.Empty && txtpriceFrom.Text != string.Empty)
{
DataRow drPrice = dtprice.NewRow();
drPrice["HighPrice"] = txtPriceTo.Text;
drPrice["LowPrice"] = txtpriceFrom.Text;
dtprice.Rows.Add(drPrice);
}
DataTable dtp = new DataTable();
dtp = BindAllBrand();
dtMerchant = new DataTable();
dtMerchant.Columns.Add("merchantID");
dtMerchant.Columns.Add("merchantName");
foreach (ListItem lstMerchat in chkMerchant.Items)
{
if (lstMerchat.Selected)
{
DataRow dr = dtMerchant.NewRow();
dr["merchantID"] = lstMerchat.Value;
string input = string.Empty;
int index = lstMerchat.Text.LastIndexOf("(");
if (index > 0)
{
input = lstMerchat.Text.Substring(0, index - 1);
}
dr["merchantName"] = input;
dtMerchant.Rows.Add(dr);
}
}
dtCategory = new DataTable();
dtCategory.Columns.Add("CategoryID_N");
dtCategory.Columns.Add("CategoryName_V");
foreach (ListItem lstCategory in chkCategory.Items)
{
if (lstCategory.Selected)
{
DataRow dr = dtCategory.NewRow();
dr["CategoryID_N"] = lstCategory.Value;
string input = string.Empty;
int index = lstCategory.Text.LastIndexOf("(");
if (index > 0)
{
input = lstCategory.Text.Substring(0, index - 1);
}
dr["CategoryName_V"] = input;
dtCategory.Rows.Add(dr);
}
}
SqlCommand cmd = new SqlCommand("GetOfferItemPageWiseSearchForBrand", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", 1);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
cmd.Parameters.AddWithValue("@RecordCount", "");
cmd.Parameters.AddWithValue("@categoryName_V", dtCategory);
cmd.Parameters.AddWithValue("@Brandname", dtp);
cmd.Parameters.AddWithValue("@MerchantName", dtMerchant);
cmd.Parameters.AddWithValue("@searchType", "");
cmd.Parameters.AddWithValue("@sortby", sortby);
cmd.Parameters.AddWithValue("@price", dtprice);
SqlDataAdapter daP = new SqlDataAdapter(cmd);
DataTable dtProduct = new DataTable();
daP.Fill(dtProduct);
this.lblPageInfo.Text = "Page " + (CurrentPage + 1) + " of " + ViewState["TotalPages"].ToString();
if (CurrentPage == 0 && Convert.ToInt32(ViewState["TotalPages"]) * pageSize > pageSize)
{
lbtnPrevious.Enabled = false;
lbtnNext.Enabled = true;
lbtnFirst.Enabled = false;
lbtnLast.Enabled = true;
}
else if (CurrentPage == 0 && Convert.ToInt32(ViewState["TotalPages"]) * pageSize <= pageSize)
{
lbtnPrevious.Enabled = false;
lbtnNext.Enabled = false;
lbtnFirst.Enabled = false;
lbtnLast.Enabled = false;
}
else if (Convert.ToInt32(ViewState["TotalPages"]) == CurrentPage + 1)
{
lbtnPrevious.Enabled = true;
lbtnNext.Enabled = false;
lbtnFirst.Enabled = true;
lbtnLast.Enabled = false;
}
else
{
lbtnPrevious.Enabled = true;
lbtnNext.Enabled = true;
lbtnFirst.Enabled = true;
lbtnLast.Enabled = true;
}
clsAssignDataCollection getVW_Item = new clsAssignDataCollection();
uc_VwProduct1.ProductItemBind(getVW_Item.GetViewProductCommon(dtProduct.ToList <vw_OfferItem>()));
doPaging();
}
catch (Exception ex)
{ }
}