/// <summary>
/// Generate Payment Allocate As per ChequeDetails
/// </summary>
/// <param name="ctx">Context</param>
/// <param name="Record_Id">VA027_ChequeDetails_ID</param>
/// <param name="paymentId">C_Payment_ID</param>
/// <param name="trxName">trxName</param>
/// <returns>true/false</returns>
public bool GenratePaymentAllocate(Ctx ctx, int Record_Id, int paymentId, Trx trxName)
{
String sql = "SELECT * FROM VA027_Checkallocate WHERE VA027_ChequeDetails_ID=" + Record_Id;
DataSet ds = new DataSet();
MPaymentAllocate _paymentAllocate = null;
ds = DB.ExecuteDataset(sql.ToString(), null, trxName);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
_paymentAllocate = new MPaymentAllocate(ctx, 0, trxName);
_paymentAllocate.SetAD_Client_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_Client_ID"]));
_paymentAllocate.SetAD_Org_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_Org_ID"]));
_paymentAllocate.SetC_Payment_ID(paymentId);
_paymentAllocate.SetC_Invoice_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_Invoice_ID"]));
_paymentAllocate.SetC_InvoicePaySchedule_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_InvoicePaySchedule_ID"]));
_paymentAllocate.SetAmount(Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["Amount"]));
_paymentAllocate.SetInvoiceAmt(Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["InvoiceAmt"]));
_paymentAllocate.SetWriteOffAmt(Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["WriteOffAmt"]));
_paymentAllocate.SetDiscountAmt(Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["DiscountAmt"]));
if (!_paymentAllocate.Save(trxName))
{
trxName.Rollback();
ValueNamePair pp = VLogger.RetrieveError();
log.Info("Error Occured while generating Payment Allocate : " + pp.GetValue() + " , Error Name : " + pp.GetName());
_msg = Msg.GetMsg(ctx, "PaymentNotAllocated") + ", " + (pp != null ? pp.GetName() : "");
return(false);
}
}
}
return(true);
}
/// <summary>
/// Create actual Payment
/// </summary>
/// <param name="C_Invoice_ID">invoice</param>
/// <param name="C_BPartner_ID">partner ignored when invoice exists</param>
/// <param name="C_Currency_ID">currency</param>
/// <param name="stmtAmt">statement amount</param>
/// <param name="trxAmt">transaction amt</param>
/// <param name="C_BankAccount_ID">bank account</param>
/// <param name="dateTrx">transaction date</param>
/// <param name="dateAcct">accounting date</param>
/// <param name="description">description</param>
/// <param name="AD_Org_ID"></param>
/// <param name="C_ConversionType_ID">C_ConversionType_ID</param>
/// <param name="C_Order_ID">C_Order_ID</param>
/// <returns>payment</returns>
private MPayment CreatePayment(int C_Invoice_ID, int C_BPartner_ID,
int C_Currency_ID, Decimal stmtAmt, Decimal trxAmt,
int C_BankAccount_ID, DateTime?dateTrx, DateTime?dateAcct,
String description, int AD_Org_ID, int C_ConversionType_ID, int C_Order_ID)
{
// Trx Amount = Payment overwrites Statement Amount if defined
Decimal payAmt = trxAmt;
if (Env.ZERO.CompareTo(payAmt) == 0)
{
payAmt = stmtAmt;
}
if (C_Invoice_ID == 0 && C_Order_ID == 0 && (Env.ZERO.CompareTo(payAmt) == 0))
{
throw new Exception("@PayAmt@ = 0");
}
//if (payAmt == null)
//{
// payAmt = Env.ZERO;
//}
//
MPayment payment = new MPayment(GetCtx(), 0, Get_Trx());
payment.SetAD_Org_ID(AD_Org_ID);
payment.SetC_BankAccount_ID(C_BankAccount_ID);
//payment.SetTenderType(MPayment.TENDERTYPE_Check);//not required it will update on MPayment class
//Get the C_ConversionType_ID from BankStatementLine and Set C_ConversionType_ID for Payment
payment.SetC_ConversionType_ID(C_ConversionType_ID);
if (dateTrx != null)
{
payment.SetDateTrx(dateTrx);
}
else if (dateAcct != null)
{
payment.SetDateTrx(dateAcct);
}
if (dateAcct != null)
{
payment.SetDateAcct(dateAcct);
}
else
{
payment.SetDateAcct(payment.GetDateTrx());
}
payment.SetDescription(description);
//
if (C_Invoice_ID != 0)
{
MInvoice invoice = new MInvoice(GetCtx(), C_Invoice_ID, Get_Trx()); //Used Trx
payment.SetC_DocType_ID(invoice.IsSOTrx()); // Receipt
payment.SetC_BPartner_ID(invoice.GetC_BPartner_ID());
//set the BPartner Location from the Invoice
payment.SetC_BPartner_Location_ID(invoice.GetC_BPartner_Location_ID());
//set the PaymentMethod by the reference of Invoice
payment.SetVA009_PaymentMethod_ID(invoice.GetVA009_PaymentMethod_ID());
payment.SetC_Currency_ID(invoice.GetC_Currency_ID());
decimal _dueAmt = 0;
string _sql = "SELECT * FROM C_InvoicePaySchedule WHERE VA009_PAIDAMNT IS NULL AND VA009_IsPaid = 'N' AND IsActive = 'Y' AND C_Invoice_ID =" + invoice.GetC_Invoice_ID();
DataSet _ds = DB.ExecuteDataset(_sql, null, Get_Trx());
if (_ds != null && _ds.Tables[0].Rows.Count == 1)
{
payment.SetC_Invoice_ID(invoice.GetC_Invoice_ID());//set Invoice Reference
payment.SetC_InvoicePaySchedule_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[0]["C_INVOICEPAYSCHEDULE_ID"]));
_dueAmt = Util.GetValueOfDecimal(_ds.Tables[0].Rows[0]["DUEAMT"]);
//Set PayAmt -ve sign Incase of DocBaseType APC or ARC - IsReturnTrx is true
//Set PayAmt +ve sign Incase of DocBaseType API or ARI - IsReturnTrx is false
if (!invoice.IsReturnTrx())
{
payment.SetPayAmt(_dueAmt);
}
else // payment is likely to be negative
{
payment.SetPayAmt(Decimal.Negate(_dueAmt));
}
if (!payment.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() : "";
}
}
_message = !string.IsNullOrEmpty(error) ? error : "VA012_PaymentNotSaved";
return(null);
}
}
else if (_ds != null && _ds.Tables[0].Rows.Count > 1)
{
if (!payment.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() : "";
}
}
_message = !string.IsNullOrEmpty(error) ? error : "VA012_PaymentNotSaved";
return(null);
}
else
{
//Initialize the Object for MPaymentAllocate class
MPaymentAllocate PayAlocate = null;
for (int i = 0; _ds.Tables[0].Rows.Count > i; i++)
{
//Create the Object for MPaymentAllocate class for every Iteration
PayAlocate = new MPaymentAllocate(GetCtx(), 0, Get_Trx());
PayAlocate.SetC_Payment_ID(payment.GetC_Payment_ID());
PayAlocate.SetAD_Client_ID(payment.GetAD_Client_ID());
//set Organization with the reference of Bank Account
PayAlocate.SetAD_Org_ID(payment.GetAD_Org_ID());//set Org_ID from the Header
PayAlocate.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
PayAlocate.SetC_InvoicePaySchedule_ID(Util.GetValueOfInt(_ds.Tables[0].Rows[i]["C_INVOICEPAYSCHEDULE_ID"]));
//Set PayAmt -ve sign Incase of DocBaseType APC or ARC - IsReturnTrx is true
//Set PayAmt +ve sign Incase of DocBaseType API or ARI - IsReturnTrx is false
if (!invoice.IsReturnTrx())
{
PayAlocate.SetInvoiceAmt(Util.GetValueOfDecimal(_ds.Tables[0].Rows[i]["DUEAMT"]));
PayAlocate.SetAmount(Util.GetValueOfDecimal(_ds.Tables[0].Rows[i]["DUEAMT"]));
}
else
{
PayAlocate.SetInvoiceAmt(-1 * Util.GetValueOfDecimal(_ds.Tables[0].Rows[i]["DUEAMT"]));
PayAlocate.SetAmount(-1 * Util.GetValueOfDecimal(_ds.Tables[0].Rows[i]["DUEAMT"]));
}
if (!PayAlocate.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() : "";
}
}
_message = !string.IsNullOrEmpty(error) ? error : "VA012_PaymentNotSaved";
return(null);
}
}
}
}
}
else if (C_Order_ID > 0 && C_BPartner_ID > 0) // Create Payment for prePayOrder reference
{
MOrder order = new MOrder(GetCtx(), C_Order_ID, Get_Trx());
payment.SetC_Order_ID(C_Order_ID);
payment.SetC_DocType_ID(order.IsSOTrx()); // Receipt
payment.SetC_BPartner_ID(order.GetC_BPartner_ID());
payment.SetC_BPartner_Location_ID(order.GetC_BPartner_Location_ID());
payment.SetC_Currency_ID(order.GetC_Currency_ID());
payment.SetVA009_PaymentMethod_ID(order.GetVA009_PaymentMethod_ID());
payment.SetPayAmt(order.GetGrandTotal());
if (!payment.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() : "";
}
}
_message = !string.IsNullOrEmpty(error) ? error : "VA012_PaymentNotSaved";
return(null);
}
}
else
{
_message = "VA012_ReferenceNotfoundtoCreatePayment";
return(null);
}
//Commit the Transaction
Get_Trx().Commit();
//Call Complete Method to Complete the Record
//149 is AD_Process_ID for C_Payment_Process
_message = CompletePayment(GetCtx(), payment.GetC_Payment_ID(), 149, MPayment.DOCACTION_Complete);
if (!string.IsNullOrEmpty(_message))
{
return(null);
}
return(payment);
}