/// <summary>
/// Get Currency Detail
/// </summary>
/// <param name="ctx"></param>
/// <param name="fields"></param>
/// <returns></returns>
public Dictionary <string, string> GetCurrency(Ctx ctx, string fields)
{
string[] paramValue = fields.Split(',');
//Assign parameter value
int C_Currency_ID = Util.GetValueOfInt(paramValue[0].ToString());
//End Assign parameter
MCurrency currency = MCurrency.Get(ctx, C_Currency_ID);
Dictionary <string, string> result = new Dictionary <string, string>();
result["StdPrecision"] = currency.GetStdPrecision().ToString();
return(result);
}
/**
* Before Save
* @param newRecord new
* @return true
*/
protected override bool BeforeSave(bool newRecord)
{
if (Is_ValueChanged("DueAmt"))
{
log.Fine("beforeSave");
SetIsValid(false);
}
oldDueAmt = Util.GetValueOfDecimal(Get_ValueOld("DueAmt"));
if (Env.IsModuleInstalled("VA009_"))
{
// get invoice currency for rounding
MCurrency currency = MCurrency.Get(GetCtx(), GetC_Currency_ID());
SetDueAmt(Decimal.Round(GetDueAmt(), currency.GetStdPrecision()));
SetVA009_PaidAmntInvce(Decimal.Round(GetVA009_PaidAmntInvce(), currency.GetStdPrecision()));
// when invoice schedule have payment reference then need to check payment mode on payment window & update here
if (GetC_Payment_ID() > 0)
{
#region for payment
MPayment payment = new MPayment(GetCtx(), GetC_Payment_ID(), Get_Trx());
SetVA009_PaymentMethod_ID(payment.GetVA009_PaymentMethod_ID());
// get payment method detail -- update to here
DataSet dsPaymentMethod = DB.ExecuteDataset(@"SELECT VA009_PaymentMode, VA009_PaymentType, VA009_PaymentTrigger FROM VA009_PaymentMethod
WHERE VA009_PaymentMethod_ID = " + payment.GetVA009_PaymentMethod_ID(), null, Get_Trx());
if (dsPaymentMethod != null && dsPaymentMethod.Tables.Count > 0 && dsPaymentMethod.Tables[0].Rows.Count > 0)
{
if (!String.IsNullOrEmpty(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentMode"])))
{
SetVA009_PaymentMode(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentMode"]));
}
if (!String.IsNullOrEmpty(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentType"])))
{
SetVA009_PaymentType(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentType"]));
}
SetVA009_PaymentTrigger(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentTrigger"]));
}
#endregion
}
else if (GetC_CashLine_ID() > 0)
{
#region For Cash
// when invoice schedule have cashline reference then need to check
// payment mode of "Cash" type having currency is null on "Payment Method" window & update here
DataSet dsPaymentMethod = (DB.ExecuteDataset(@"SELECT VA009_PaymentMethod_ID, VA009_PaymentMode, VA009_PaymentType, VA009_PaymentTrigger
FROM VA009_PaymentMethod WHERE IsActive = 'Y'
AND AD_Client_ID = " + GetAD_Client_ID() + @" AND VA009_PaymentBaseType = 'B' AND NVL(C_Currency_ID , 0) = 0", null, Get_Trx()));
if (dsPaymentMethod != null && dsPaymentMethod.Tables.Count > 0 && dsPaymentMethod.Tables[0].Rows.Count > 0)
{
SetVA009_PaymentMethod_ID(Util.GetValueOfInt(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentMethod_ID"]));
if (!String.IsNullOrEmpty(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentMode"])))
{
SetVA009_PaymentMode(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentMode"]));
}
if (!String.IsNullOrEmpty(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentType"])))
{
SetVA009_PaymentType(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentType"]));
}
SetVA009_PaymentTrigger(Util.GetValueOfString(dsPaymentMethod.Tables[0].Rows[0]["VA009_PaymentTrigger"]));
}
else
{
#region when we not found record of "Cash" then we will create a new rcord on Payment Method for Cash
string sql = @"SELECT AD_TABLE_ID FROM AD_TABLE WHERE tablename LIKE 'VA009_PaymentMethod' AND IsActive = 'Y'";
int tableId = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
MTable tbl = new MTable(GetCtx(), tableId, Get_Trx());
PO po = tbl.GetPO(GetCtx(), 0, Get_Trx());
po.SetAD_Client_ID(GetAD_Client_ID());
po.SetAD_Org_ID(0); // Recod will be created in (*) Organization
po.Set_Value("Value", "By Cash");
po.Set_Value("VA009_Name", "By Cash");
po.Set_Value("IsActive", true);
po.Set_Value("VA009_PaymentBaseType", "B");
po.Set_Value("VA009_PaymentRule", "M");
po.Set_Value("VA009_PaymentMode", "C");
po.Set_Value("VA009_PaymentType", "S");
po.Set_Value("VA009_PaymentTrigger", "S");
po.Set_Value("C_Currency_ID", null);
po.Set_Value("VA009_InitiatePay", false);
if (!po.Save(Get_Trx()))
{
ValueNamePair pp = VLogger.RetrieveError();
log.Info("Error Occured when try to save record on Payment Method for Cash. Error Type : " + pp.GetValue());
}
else
{
SetVA009_PaymentMethod_ID(Util.GetValueOfInt(po.Get_Value("VA009_PaymentMethod_ID")));
SetVA009_PaymentMode("C");
SetVA009_PaymentType("S");
SetVA009_PaymentTrigger("S");
}
#endregion
}
#endregion
}
}
return(true);
}
