/// <summary>
/// Create Payment for BankStatement
/// </summary>
/// <param name="bsl">bank statement Line</param>
/// <returns>Message</returns>
private String CreatePayment(MBankStatementLine bsl)
{
if (bsl == null || bsl.GetC_Payment_ID() != 0)
{
return("--");
}
log.Fine(bsl.ToString());
if (bsl.GetC_Invoice_ID() == 0 && bsl.GetC_BPartner_ID() == 0)
{
throw new Exception("@NotFound@ @C_Invoice_ID@ / @C_BPartner_ID@");
}
//
MBankStatement bs = new MBankStatement(GetCtx(), bsl.GetC_BankStatement_ID(), Get_Trx());
//
MPayment payment = CreatePayment(bsl.GetC_Invoice_ID(), bsl.GetC_BPartner_ID(),
bsl.GetC_Currency_ID(), bsl.GetStmtAmt(), bsl.GetTrxAmt(),
bs.GetC_BankAccount_ID(), bsl.GetStatementLineDate(), bsl.GetDateAcct(),
bsl.GetDescription(), bsl.GetAD_Org_ID());
if (payment == null)
{
throw new SystemException("Could not create Payment");
}
// update statement
bsl.SetPayment(payment);
bsl.Save();
//
String retString = "@C_Payment_ID@ = " + payment.GetDocumentNo();
if (Env.Signum(payment.GetOverUnderAmt()) != 0)
{
retString += " - @OverUnderAmt@=" + payment.GetOverUnderAmt();
}
return(retString);
}
/// <summary>
/// Load Specific Document Details
/// </summary>
/// <returns>error message or null</returns>
public override String LoadDocumentDetails()
{
MBankStatement bs = (MBankStatement)GetPO();
SetDateDoc(bs.GetStatementDate());
SetDateAcct(bs.GetStatementDate()); // Overwritten on Line Level
_C_BankAccount_ID = bs.GetC_BankAccount_ID();
// Amounts
SetAmount(AMTTYPE_Gross, bs.GetStatementDifference());
// Set Bank Account Info (Currency)
MBankAccount ba = MBankAccount.Get(GetCtx(), _C_BankAccount_ID);
SetC_Currency_ID(ba.GetC_Currency_ID());
// Contained Objects
_lines = LoadLines(bs);
log.Fine("Lines=" + _lines.Length);
return(null);
}
/// <summary>
/// Create Payment for BankStatement
/// </summary>
/// <param name="bsl">bank statement Line</param>
/// <returns>Message</returns>
private String CreatePayment(MBankStatementLine bsl)
{
if (bsl == null || bsl.GetC_Payment_ID() != 0)
{
return("--");
}
log.Fine(bsl.ToString());
if (bsl.GetC_Invoice_ID() == 0 && bsl.GetC_BPartner_ID() == 0)
{
throw new Exception("@NotFound@ @C_Invoice_ID@ / @C_BPartner_ID@");
}
//
MBankStatement bs = new MBankStatement(GetCtx(), bsl.GetC_BankStatement_ID(), Get_Trx());
//
//Check the Column Exists or not then Pass the Colums as parameters for CreatePayment method
int conversionType = bsl.Get_ColumnIndex("C_ConversionType_ID") > 0 ? bsl.Get_ValueAsInt("C_ConversionType_ID") : 0;
int _order_Id = bsl.Get_ColumnIndex("C_Order_ID") > 0 ? bsl.Get_ValueAsInt("C_Order_ID") : 0;
MPayment payment = CreatePayment(bsl.GetC_Invoice_ID(), bsl.GetC_BPartner_ID(),
bsl.GetC_Currency_ID(), bsl.GetStmtAmt(), bsl.GetTrxAmt(),
bs.GetC_BankAccount_ID(), bsl.GetStatementLineDate(), bsl.GetDateAcct(),
bsl.GetDescription(), bsl.GetAD_Org_ID(), conversionType, _order_Id);
if (payment == null && !string.IsNullOrEmpty(_message))
{
return(_message);
}
//Update Bank StatementLine
//Created new Object for Payment to get Updated Payment Record
MPayment mPayment = new MPayment(GetCtx(), payment.GetC_Payment_ID(), payment.Get_Trx());
_message = bsl.SetPayments(mPayment);
if (string.IsNullOrEmpty(_message))
{
if (!bsl.Save(Get_Trx()))
{
Get_Trx().Rollback();
ValueNamePair pp = VLogger.RetrieveError();
//to get Exact Error Message first get Value from GetName() else GetValue()
string error = pp != null?pp.GetName() : "";
if (string.IsNullOrEmpty(error))
{
error = pp != null?pp.GetValue() : "";
if (string.IsNullOrEmpty(error))
{
error = pp != null?pp.ToString() : "";
}
}
return(!string.IsNullOrEmpty(error) ? error : "DatanotSaved");
}
else
{
String retString = "@C_Payment_ID@ = " + mPayment.GetDocumentNo();
if (Env.Signum(payment.GetOverUnderAmt()) != 0)
{
retString += " - @OverUnderAmt@=" + mPayment.GetOverUnderAmt();
}
Get_Trx().Commit();
return(retString);
}
}
else
{
Get_Trx().Rollback();
return(_message);
}
}
