/// <summary>
/// The method retrieves payment method by id
/// </summary>
/// <param name="paymentMethodId">Id of a payment method</param>
/// <returns>Returns an instant of the PaymentMethod</returns>
public PaymentMethod GetPaymentMethodById(int paymentMethodId)
{
return(_paymentMethodManager.SelectPaymentMethodById(paymentMethodId));
}
private ContractAccountingRule SelectContractAccountingRule(int pId)
{
const string sqlText = @"SELECT AccountingRules.id,
AccountingRules.debit_account_number_id,
AccountingRules.credit_account_number_id,
AccountingRules.booking_direction,
AccountingRules.event_type,
AccountingRules.event_attribute_id,
AccountingRules.[order],
AccountingRules.[description] AS rule_description,
EventAttributes.name AS attribute_name,
EventTypes.description AS event_description,
ContractAccountingRules.product_type,
ContractAccountingRules.loan_product_id,
ContractAccountingRules.savings_product_id,
ContractAccountingRules.client_type,
ContractAccountingRules.activity_id,
ContractAccountingRules.currency_id
FROM AccountingRules
INNER JOIN EventAttributes ON EventAttributes.id = AccountingRules.event_attribute_id
INNER JOIN EventTypes ON AccountingRules.event_type = EventTypes.event_type
LEFT JOIN ContractAccountingRules ON AccountingRules.id = ContractAccountingRules.id
WHERE AccountingRules.id = @id";
ContractAccountingRule rule;
using (SqlConnection conn = GetConnection())
{
using (OpenCbsCommand select = new OpenCbsCommand(sqlText, conn))
{
select.AddParam("@id", pId);
using (OpenCbsReader reader = select.ExecuteReader())
{
if (reader.Empty)
{
return(null);
}
reader.Read();
rule = GetContractAccountingRule(reader);
}
}
}
if (rule.LoanProduct != null)
{
rule.LoanProduct = _loanProductManager.Select(rule.LoanProduct.Id);
}
if (rule.Currency != null)
{
rule.Currency = _currencyManager.SelectCurrencyById(rule.Currency.Id);
}
if (rule.Currency == null)
{
rule.Currency = null;
}
if (rule.SavingProduct != null)
{
rule.SavingProduct = _savingProductManager.SelectSavingProduct(rule.SavingProduct.Id);
}
if (rule.EconomicActivity != null)
{
rule.EconomicActivity = _economicActivityManager.SelectEconomicActivity(rule.EconomicActivity.Id);
}
if (rule.PaymentMethod.Id != 0)
{
rule.PaymentMethod = _paymentMethodManager.SelectPaymentMethodById(rule.PaymentMethod.Id);
}
return(rule);
}