protected void BindSupplierDetails()
{
try
{
DataSet dt = BLL_POLOG_Register.POLOG_Get_Payment_Supplier_Invoice(UDFLib.ConvertStringToNull(txtSupplierCode.Text), UDFLib.ConvertStringToNull(txtPayMode.Text), UDFLib.ConvertIntegerToNull(GetSessionUserID()));
if (dt.Tables[0].Rows.Count > 0)
{
gvPaymentDetails.DataSource = dt;
gvPaymentDetails.DataBind();
}
else
{
gvPaymentDetails.DataSource = dt;
gvPaymentDetails.DataBind();
}
gvlinkPayment.DataSource = null;
gvlinkPayment.DataBind();
gvNewPayment.DataSource = null;
gvNewPayment.DataBind();
}
catch { }
{
}
}
protected void BindSupplierDetails(string Supplier_Code)
{
string PayMode = null;
DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Supplier_Invoice(Supplier_Code, PayMode, GetSessionUserID());
//if (ds.Tables[0].Rows.Count > 0)
//{
// gvPaymentDetails.DataSource = ds.Tables[0];
// gvPaymentDetails.DataBind();
//if (ds.Tables[0].Rows[0]["PAYMENT_STATUS"].ToString() == "OPEN")
//{
// txtPaymodeID.Text = ds.Tables[0].Rows[0]["PAYMENT_ID"].ToString();
// txtPayment_Year.Text = ds.Tables[0].Rows[0]["PAYMENT_YEAR"].ToString();
// GetPaymentDetails();
//}
//}
}
protected void BindSupplierInvoice(string Supplier_Code)
{
string PayMode = null;
DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Supplier_Invoice(Supplier_Code, PayMode, GetSessionUserID());
if (ds.Tables[0].Rows.Count > 0)
{
gvPaymentDetails.DataSource = ds;
gvPaymentDetails.DataBind();
gvApprovedInvoice.DataSource = ds;
gvApprovedInvoice.DataBind();
}
if (ds.Tables[1].Rows.Count > 0)
{
txtSupplierName.Text = ds.Tables[1].Rows[0]["Supplier_Name"].ToString();
txtPaymentTerms.Text = ds.Tables[1].Rows[0]["Payment_Terms"].ToString();
txtAddress.Text = ds.Tables[1].Rows[0]["Address"].ToString();
txtPayment.Text = ds.Tables[1].Rows[0]["Payment_Instructions"].ToString();
txtCity.Text = ds.Tables[1].Rows[0]["City"].ToString();
txtpaymentnotification.Text = ds.Tables[1].Rows[0]["Payment_Notifications"].ToString();
txtEmail.Text = ds.Tables[1].Rows[0]["Email"].ToString();
txtPhone.Text = ds.Tables[1].Rows[0]["Phone"].ToString();
txtFax.Text = ds.Tables[1].Rows[0]["Fax"].ToString();
}
if (ds.Tables[2].Rows.Count > 0)
{
gvNewPayment.DataSource = ds.Tables[2];
gvNewPayment.DataBind();
if (ds.Tables[2].Rows[0]["PAYMENT_STATUS"].ToString() == "OPEN")
{
gvNewPayment.Rows[0].BackColor = System.Drawing.Color.Yellow;
txtPaymodeID.Text = ds.Tables[2].Rows[0]["PAYMENT_ID"].ToString();
txtPayment_Year.Text = ds.Tables[2].Rows[0]["PAYMENT_YEAR"].ToString();
GetPaymentDetails(txtPaymodeID.Text, txtPayment_Year.Text);
btnUpdate.Enabled = true;
btnlink.Enabled = true;
}
}
}
