//Bind product
private void BindProduct(string search = "")
{
productManager objproduct = new productManager();
DataTable dtadmin = new DataTable();
try
{
if (txtsearch.Text != "")
{
string strg = txtsearch.Text.Trim();
string[] arystr = strg.Split('\n');
//string[] arystr = strg.Split(',');
string orgstr = string.Empty;
if (arystr.Length > 0)
{
for (int k = 0; k < arystr.Length; k++)
{
if (k == 0)
{
orgstr += "('" + Convert.ToString(arystr[k]) + "'";
}
else
{
orgstr += ",'" + Convert.ToString(arystr[k]) + "'";
}
}
orgstr += ")";
}
//objproduct.sku = txtsearch.Text.Trim();
objproduct.sku = orgstr.ToString();
}
else
{
objproduct.sku = txtsearch.Text.Trim();
}
//less than greter than equal to
if (txtfilter.Text != "")
{
objproduct.InventoryFilter = txtfilter.Text.Trim();
}
else
{
objproduct.InventoryFilter = txtfilter.Text.Trim();
}
if (ddlfilter.SelectedValue != "0")
{
objproduct.filter = ddlfilter.SelectedValue;
}
else
{
objproduct.filter = ddlfilter.SelectedValue;
}
if (pageNo == 0)
{
pageNo = 1;
}
objproduct.pageNo = pageNo;
objproduct.pageSize = pageSize;
objproduct.SortExpression = SortExpression;
querystring = "&pageSize=" + ddlpageSize.SelectedValue + "&key=" + txtsearch.Text;
//querystring = "&key=" + txtsearch.Text;
dtadmin = objproduct.SearchProductInventoryItem();
totalrecs = objproduct.TotalRecord;
if (pageNo == 1)
{
objproduct.pageNo = 1;
pageNo = 1;
}
else if (pageNo == 0)
{
objproduct.pageNo = 1;
pageNo = 1;
}
else
{
objproduct.pageNo = (pageNo - 1) * pageSize;
}
objproduct.pageSize = pageSize;
totalpages = totalrecs / pageSize;
if ((totalrecs % pageSize) > 0 && (totalrecs > pageSize))
{
totalpages += 1;
}
gvAdmin.DataSource = dtadmin;
gvAdmin.DataBind();
if (dtadmin.Rows.Count > 0)
{
int startRowOnPage = (gvAdmin.PageIndex * gvAdmin.PageSize) + 1;
int lastRowOnPage = startRowOnPage + gvAdmin.Rows.Count - 1;
int totalRows = totalrecs;
ltrcountrecord.Text = "<div class=\"countdiv\">Showing " + startRowOnPage.ToString() + " to " + lastRowOnPage + " of " + totalRows + " entries</div>";
}
String strpaging = CommonFunctions.AdminPagingv2(totalpages, pageNo, querystring, "viewinventory.aspx");
ltrpaggingbottom.Text = strpaging;
//Ltrup.Text = strpaging;
}
catch (Exception ex) { throw ex; }
finally { dtadmin.Dispose(); objproduct = null; }
}