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 { }
{
}
}
