/** Generate Payment for Single Cheque */
public string GenratePaymentHdr(Ctx ctx, int Record_Id, int paymentDocumentTypeId, Trx trxName)
{
StringBuilder _sql = new StringBuilder();
MVA027PostDatedCheck _pdc = new MVA027PostDatedCheck(ctx, Record_Id, trxName);
MPayment _payment = new MPayment(ctx, 0, trxName);
_payment.SetAD_Client_ID(_pdc.GetAD_Client_ID());
_payment.SetAD_Org_ID(_pdc.GetAD_Org_ID());
if (c_BankAccount_ID == 0)
{
_payment.SetC_BankAccount_ID(_pdc.GetC_BankAccount_ID());
}
else
{
_payment.SetC_BankAccount_ID(c_BankAccount_ID);
}
_payment.SetDateTrx(_sysDate); // Set Today date in transaction Date.
if (_pdc.IsVA027_DiscountingPDC())
{
_payment.SetDateAcct(_sysDate); // In Case of Discounting PDC set Today date in Account Date. // _pdc.GetVA027_CheckDate()
}
else
{
_payment.SetDateAcct(_pdc.GetVA027_CheckDate());
}
if (_pdc.IsVA027_DiscountingPDC())
{
_payment.SetVA027_DiscountingPDC(true);
}
_payment.SetDescription(_pdc.GetVA027_Description());
if (_pdc.GetC_BPartner_ID() > 0)
{
_payment.SetC_BPartner_ID(_pdc.GetC_BPartner_ID());
_payment.SetC_BPartner_Location_ID(_pdc.GetC_BPartner_Location_ID());
}
_payment.SetIsPrepayment(_pdc.IsVA027_IsPrepayment());
if (_pdc.GetC_Invoice_ID() > 0)
{
_payment.SetC_Invoice_ID(_pdc.GetC_Invoice_ID());
}
if (_pdc.GetC_InvoicePaySchedule_ID() > 0)
{
_payment.SetC_InvoicePaySchedule_ID(_pdc.GetC_InvoicePaySchedule_ID());
}
if (_pdc.GetC_Order_ID() > 0)
{
_payment.SetC_Order_ID(_pdc.GetC_Order_ID());
}
if (_pdc.GetVA009_OrderPaySchedule_ID() > 0)
{
_payment.SetVA009_OrderPaySchedule_ID(_pdc.GetVA009_OrderPaySchedule_ID());
}
if (_pdc.GetC_Charge_ID() > 0)
{
_payment.SetC_Charge_ID(_pdc.GetC_Charge_ID());
}
if (_pdc.GetVA027_Payee() != null)
{
_payment.SetDescription(_pdc.GetVA027_Payee());
}
_payment.SetC_Tax_ID(_pdc.GetC_Tax_ID());
_payment.SetTaxAmount(Math.Round(_pdc.GetTaxAmount(), 2));
// if Surcharge Amount field is available then set value from Post Dated Check.
if (_payment.Get_ColumnIndex("SurchargeAmt") > 0)
{
_payment.Set_Value("SurchargeAmt", Util.GetValueOfDecimal(_pdc.Get_Value("SurchargeAmt")));
}
_payment.SetPayAmt(Math.Round(_pdc.GetVA027_PayAmt(), 2));
_payment.SetC_Currency_ID(_pdc.GetC_Currency_ID());
_payment.SetDiscountAmt(Math.Round(_pdc.GetVA027_DiscountAmt(), 2));
_payment.SetWriteOffAmt(Math.Round(_pdc.GetVA027_WriteoffAmt(), 2));
_payment.SetVA009_PaymentMethod_ID(_pdc.GetVA009_PaymentMethod_ID());
_payment.SetCheckNo(_pdc.GetVA027_CheckNo());
_payment.SetCheckDate(_pdc.GetVA027_CheckDate());
_payment.SetValidMonths(_pdc.GetVA027_ValidMonth());
_payment.SetMicr(_pdc.GetVA027_MICR());
_payment.SetAccountNo(_pdc.GetVA027_AccountNo());
_payment.SetA_Name(_pdc.GetVA027_AccountName());
_payment.SetPDCType(_pdc.GetPDCType());
//_sql.Append("select docbasetype,c_doctype_id from C_doctype where c_doctype_id=" + _pdc.GetC_DocType_ID());
//_docBaseType = Util.GetValueOfString(DB.ExecuteScalar(_sql.ToString()));
_sql.Clear();
//if (_docBaseType == "PDR")
//{
// _sql.Append("SELECT C_DocType_ID FROM C_DocType WHERE DocBaseType='ARR' AND IsActive='Y' AND AD_Client_ID=" + ctx.GetAD_Client_ID());
// int _docuType = Util.GetValueOfInt(DB.ExecuteScalar(_sql.ToString()));
// _payment.SetC_DocType_ID(_docuType);
// _sql.Clear();
//}
//else
//{
// _sql.Append("SELECT C_DocType_ID FROM C_DocType WHERE DocBaseType='APP' AND AD_Client_ID=" + ctx.GetAD_Client_ID());
// int _documentType = Util.GetValueOfInt(DB.ExecuteScalar(_sql.ToString(), null, trxName));
// _payment.SetC_DocType_ID(_documentType);
//}
_payment.SetC_DocType_ID(paymentDocumentTypeId);
_exeStatus = _payment.GetVA009_ExecutionStatus();
_payment.SetVA009_ExecutionStatus(_exeStatus = "I");
if (_payment.Save(trxName))
{
_status = null;
_status = _payment.CompleteIt();
}
else
{
return("F");
}
if (_status == "CO")
{
_payment.SetDocStatus("CO");
_pdc.SetVA027_PaymentStatus("1");
_payment.Set_Value("VA027_PostDatedCheck_ID", _pdc.GetVA027_PostDatedCheck_ID());
_payment.Save(trxName);
}
_pdc.SetC_Payment_ID(_payment.GetC_Payment_ID());
_pdc.SetVA027_PaymentGenerated(true);
_pdc.SetVA027_GeneratePayment("Y");
if (!_pdc.Save(trxName))
{
return("E");
}
else
{
documentno = _payment.GetDocumentNo();
return("Success");
}
}