protected void GetPaymentDetails()
{
//string Payment_ID = null;
//int Payment_Year = 0;
//string Supplier_Code = null;
DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Details(txtPaymodeID.Text.ToString(), txtSupplierCode.Text.ToString(), UDFLib.ConvertIntegerToNull(txtPayment_Year.Text), GetSessionUserID());
if (ds.Tables[0].Rows.Count > 0)
{
txtPaymentAmount.Text = ds.Tables[0].Rows[0]["PAYMENT_AMOUNT"].ToString();
txtBankRef.Text = ds.Tables[0].Rows[0]["BANK_REFERENCE"].ToString();
txtPayDate.Text = ds.Tables[0].Rows[0]["PAYMENT_DATE"].ToString();
ddlPayMode.SelectedValue = ds.Tables[0].Rows[0]["PAYMENT_MODE"].ToString();
rdbPaymode.SelectedValue = ds.Tables[0].Rows[0]["Payment_Status"].ToString();
ddlAccount.Text = ds.Tables[0].Rows[0]["Bank_Account_ID"].ToString();
txtBankAmt.Text = ds.Tables[0].Rows[0]["Bank_Amount"].ToString();
txtBankCharge.Text = ds.Tables[0].Rows[0]["Bank_Charges"].ToString();
txtRemarks.Text = ds.Tables[0].Rows[0]["PAYMENT_REMARKS"].ToString();
txtJournal.Text = ds.Tables[0].Rows[0]["Journal_ID"].ToString();
txtPaymodeID.Text = ds.Tables[0].Rows[0]["PAYMENT_ID"].ToString();
txtPayment_Year.Text = ds.Tables[0].Rows[0]["PAYMENT_YEAR"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
gvNewPayment.DataSource = ds.Tables[1];
gvNewPayment.DataBind();
}
BindLinkInvoice(txtPaymodeID.Text, UDFLib.ConvertToInteger(txtPayment_Year.Text));
}
protected void GetPaymentDetails(string Payment_ID, string Payment_Year)
{
DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Details(Payment_ID, txtSupplierCode.Text.ToString(), UDFLib.ConvertIntegerToNull(Payment_Year), GetSessionUserID());
if (ds.Tables[0].Rows.Count > 0)
{
btnUpdate.Enabled = true;
txtPaymentAmount.Text = ds.Tables[0].Rows[0]["PAYMENT_AMOUNT"].ToString();
txtBankRef.Text = ds.Tables[0].Rows[0]["BANK_REFERENCE"].ToString();
txtPayDate.Text = ds.Tables[0].Rows[0]["PAYMENT_DATE"].ToString();
ddlPayMode.SelectedValue = ds.Tables[0].Rows[0]["PAYMENT_MODE"].ToString();
rdbPaymode.SelectedValue = ds.Tables[0].Rows[0]["Payment_Status"].ToString();
ddlAccount.Text = ds.Tables[0].Rows[0]["Bank_Account_ID"].ToString();
txtBankAmt.Text = ds.Tables[0].Rows[0]["Bank_Amount"].ToString();
txtBankCharge.Text = ds.Tables[0].Rows[0]["Bank_Charges"].ToString();
txtRemarks.Text = ds.Tables[0].Rows[0]["PAYMENT_REMARKS"].ToString();
txtJournal.Text = ds.Tables[0].Rows[0]["Journal_ID"].ToString();
txtPaymodeID.Text = ds.Tables[0].Rows[0]["PAYMENT_ID"].ToString();
txtPayment_Year.Text = ds.Tables[0].Rows[0]["PAYMENT_YEAR"].ToString();
lblTotalAmount.Text = ds.Tables[0].Rows[0]["PAYMENT_AMOUNT"].ToString();
lblCurrency.Text = ds.Tables[0].Rows[0]["PAYMENT_CURRENCY"].ToString();
lblPaymentID.Text = ds.Tables[0].Rows[0]["PAYMENT_ID"].ToString();
lblSupplierName.Text = ds.Tables[0].Rows[0]["Supplier_Name"].ToString();
if (rdbPaymode.SelectedValue == "PAID")
{
gvInvoice.Columns[4].Visible = false;
}
}
if (ds.Tables[2].Rows.Count > 0)
{
gvInvoice.DataSource = ds.Tables[2];
gvInvoice.DataBind();
}
}
protected void BindLinkInvoice(string Payment_ID, int Payment_Year)
{
DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Details(Payment_ID, txtSupplierCode.Text.ToString(), UDFLib.ConvertIntegerToNull(Payment_Year), GetSessionUserID());
if (ds.Tables[2].Rows.Count > 0)
{
gvInvoice.DataSource = ds.Tables[2];
gvInvoice.DataBind();
}
}
protected void PaymentDet()
{
DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Details(txtPaymodeID.Text.ToString(), txtSupplierCode.Text.ToString(), UDFLib.ConvertIntegerToNull(txtPayment_Year.Text), GetSessionUserID());
if (ds.Tables[0].Rows.Count > 0)
{
txtPaymentAmount.Text = ds.Tables[0].Rows[0]["PAYMENT_AMOUNT"].ToString();
txtBankRef.Text = ds.Tables[0].Rows[0]["BANK_REFERENCE"].ToString();
txtPayDate.Text = ds.Tables[0].Rows[0]["PAYMENT_DATE"].ToString();
ddlPayMode.SelectedValue = ds.Tables[0].Rows[0]["PAYMENT_MODE"].ToString();
rdbPaymode.SelectedValue = ds.Tables[0].Rows[0]["Payment_Status"].ToString();
ddlAccount.Text = ds.Tables[0].Rows[0]["Bank_Account_ID"].ToString();
txtBankAmt.Text = ds.Tables[0].Rows[0]["Bank_Amount"].ToString();
txtBankCharge.Text = ds.Tables[0].Rows[0]["Bank_Charges"].ToString();
txtRemarks.Text = ds.Tables[0].Rows[0]["PAYMENT_REMARKS"].ToString();
txtJournal.Text = ds.Tables[0].Rows[0]["Journal_ID"].ToString();
txtPaymodeID.Text = ds.Tables[0].Rows[0]["PAYMENT_ID"].ToString();
txtPayment_Year.Text = ds.Tables[0].Rows[0]["PAYMENT_YEAR"].ToString();
}
}
