protected void BindPaymentApprovedGrid() { try { int rowcount = ucCustomPager2.isCountRecord; objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center"); //objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6 }, "Total Invoice Value & Count", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Payment Approved", "HeaderStyle-center"); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } string InvoiceAmt = (ViewState["InvoiceAmt"] == null) ? null : (ViewState["InvoiceAmt"].ToString()); string InvoiceStatus = (ViewState["InvoiceStatus"] == null) ? null : (ViewState["InvoiceStatus"].ToString()); string PaymentStatus = (ViewState["PaymentStatus"] == null) ? null : (ViewState["PaymentStatus"].ToString()); DataTable dt = BLL_POLOG_Register.POLOG_Get_Approved_Payment_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, InvoiceStatus, PaymentStatus, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPager2.CurrentPageIndex, ucCustomPager2.PageSize, ref rowcount); if (ucCustomPager2.isCountRecord == 1) { ucCustomPager2.CountTotalRec = rowcount.ToString(); ucCustomPager2.BuildPager(); } if (dt.Rows.Count > 0) { btnUnApprove.Visible = true; divApprovedPayment.Visible = true; gvApprovedPayment.DataSource = dt; gvApprovedPayment.DataBind(); } else { divApprovedPayment.Visible = false; btnUnApprove.Visible = false; gvApprovedPayment.DataSource = dt; gvApprovedPayment.DataBind(); } } catch { } { } }