public void ListarOrdenPaginadas(int currentPage = 1)
{
using (var connection = new FesaDataSourceDataContext()) {
GVOrder.DataSource = null;
GVOrder.DataBind();
int pageSize = 10;
int?totalRowCount = 0;
//ANTONIO
List <ORDERTEMP> orders = connection.SP_GET_ALL_ORDER_PAGINATE_P(currentPage, pageSize, ref totalRowCount).ToList();
//List<OrderNew> Orders = connection.SP_GET_ORDER_PAGINATE(TxtBuscar.Text,CostCenterList.SelectedIndex,OfficeList.SelectedIndex, currentPage, pageSize, ref _TotalRowCount).ToList();
totalRowCount = Convert.ToInt32(totalRowCount.Value);
GVOrder.DataSource = orders;
GVOrder.DataBind();
//GeneratePager(totalRowCount, pageSize, currentPage);
this.PopulatePager(totalRowCount, currentPage);
}
}
//Bind product
private void BindProduct(string search = "")
{
//this.Form.DefaultButton = imgbtnSearch.UniqueID;
pageSize = Convert.ToInt32(2000);
productManager objproduct = new productManager();
DataSet dtadmin = new DataSet();
try
{
if (txtSearchProduct.Text != "")
{
objproduct.productName = Server.HtmlEncode(txtSearchProduct.Text.Trim());
}
else
{
objproduct.productName = Server.HtmlEncode(txtSearchProduct.Text.Trim());
}
if (pageNo == 0)
{
pageNo = 1;
}
objproduct.pageNo = pageNo;
objproduct.pageSize = pageSize;
objproduct.SortExpression = SortExpression;
dtadmin = objproduct.SearchOrder();
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;
}
GVOrder.DataSource = dtadmin;
GVOrder.DataBind();
if (dtadmin.Tables[0].Rows.Count > 0)
{
int startRowOnPage = (GVOrder.PageIndex * GVOrder.PageSize) + 1;
int lastRowOnPage = startRowOnPage + GVOrder.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, "add_order.aspx");
//ltrpaggingbottom.Text = strpaging;
}
catch (Exception ex) { throw ex; }
finally { dtadmin.Dispose(); objproduct = null; }
}
