//Biniding content protected void BindContents(string search = "") { this.Form.DefaultButton = imgbtnSearch.UniqueID; languageManager objlanguage = new languageManager(); DataTable dtcontents = new DataTable(); try { objlanguage.languageName = Server.HtmlEncode(txtsearch.Text.Trim()); if (pageNo == 0) { pageNo = 1; } objlanguage.pageNo = pageNo; objlanguage.pageSize = pageSize; objlanguage.SortExpression = SortExpression; querystring = "&key=" + txtsearch.Text; //querystring = "&pageSize=" + ddlpageSize.SelectedValue + "&key=" + txtsearch.Text; dtcontents = objlanguage.SearchItem(); totalrecs = objlanguage.TotalRecord; if (pageNo == 1) { objlanguage.pageNo = 1; pageNo = 1; } else if (pageNo == 0) { objlanguage.pageNo = 1; pageNo = 1; } else { objlanguage.pageNo = (pageNo - 1) * pageSize; } objlanguage.pageSize = pageSize; totalpages = totalrecs / pageSize; if ((totalrecs % pageSize) > 0 && (totalrecs > pageSize)) { totalpages += 1; } gvAdmin.DataSource = dtcontents; gvAdmin.DataBind(); if (dtcontents.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.AdminPaging(totalpages, pageNo, querystring, "viewlanguage.aspx"); ltrpaggingbottom.Text = strpaging; //Ltrup.Text = strpaging; LoadDropDownList(); } catch (Exception ex) { throw ex; } }
//Biniding content protected void BindContents(string search = "") { importjobManager objimportjob = new importjobManager(); DataTable dtcontents = new DataTable(); try { objimportjob.id = Convert.ToInt32(Request.QueryString["id"]); objimportjob.productname = ""; //objlanguage.languagename = Server.HtmlEncode(txtsearch.Text.Trim()); if (pageNo == 0) { pageNo = 1; } objimportjob.pageNo = pageNo; objimportjob.pageSize = pageSize; objimportjob.SortExpression = SortExpression; querystring = "&id=" + Request.QueryString["id"] + "&filename=" + Request.QueryString["filename"] + "&filetp=" + Request.QueryString["filetp"] + "&pageSize=" + ddlpageSize.SelectedValue; //if (Convert.ToInt32(Request.QueryString["iptp"]) == 1) //{ // dtcontents = objimportjob.SearchImportJobs(); //} //else //{ dtcontents = objimportjob.SearchImportJobs(); //} totalrecs = objimportjob.TotalRecord; if (pageNo == 1) { objimportjob.pageNo = 1; pageNo = 1; } else if (pageNo == 0) { objimportjob.pageNo = 1; pageNo = 1; } else { objimportjob.pageNo = (pageNo - 1) * pageSize; } objimportjob.pageSize = pageSize; totalpages = totalrecs / pageSize; if ((totalrecs % pageSize) > 0 && (totalrecs > pageSize)) { totalpages += 1; } gvImportjob.DataSource = dtcontents; gvImportjob.DataBind(); if (dtcontents.Rows.Count > 0) { lblinsertfilecount.Text = "Proccessed <b>" + dtcontents.Rows[0]["Proccessed"] + "</b> rows of which <b>" + dtcontents.Rows[0]["NoErrorLine"] + "</b> passed validation and <b>" + dtcontents.Rows[0]["ErrorLine"] + "</b> failed."; int startRowOnPage = (gvImportjob.PageIndex * gvImportjob.PageSize) + 1; int lastRowOnPage = startRowOnPage + gvImportjob.Rows.Count - 1; int totalRows = totalrecs; ltrcountrecord.Text = "<div class=\"countdiv\">Showing " + startRowOnPage.ToString() + " to " + lastRowOnPage + " of " + totalRows + " entries</div>"; } String strpaging = CommonFunctions.AdminPaging(totalpages, pageNo, querystring, "ViewImportJobDetails.aspx"); ltrpaggingbottom.Text = strpaging; //LoadDropDownList(); } catch (Exception ex) { throw ex; } }