public string GetAccountBookNameForFund(CSMAmFund fund)
{
string result = null;
int fundFolioCode = fund.GetTradingPortfolio();
string SQLQuery = "select SICOVAM ID, substr(b.name, 1,4) IDB_ACCOUNT_BOOK from FUNDS f, account_book_folio bf , account_book b where b.ID=bf.ACCOUNT_BOOK_ID and record_type=1 and f.TRADINGFOLIO=bf.FOLIO_ID AND f.FUNDTYPE=1";
using (OracleCommand myCommand = new OracleCommand(SQLQuery, DBContext.Connection))
{
using (OracleDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.Read())
{
result = myReader["IDB_ACCOUNT_BOOK"].ToString();
}
}
}
return(result);
}
public string GetAccountBookNameForFund(CSMAmFund fund)
{
string result = "";
int fundFolioCode = fund.GetTradingPortfolio();
string SQLQuery = "select substr(b.name, 1,4) IDB_ACCOUNT_BOOK from account_book_folio bf , account_book b where b.ID=bf.ACCOUNT_BOOK_ID and bf.FOLIO_ID = " + fundFolioCode + " and record_type=1";
using (OracleCommand myCommand = new OracleCommand(SQLQuery, DBContext.Connection))
{
using (OracleDataReader myReader = myCommand.ExecuteReader())
{
while (myReader.Read())
{
result = myReader["IDB_ACCOUNT_BOOK"].ToString();
break;
}
}
}
return(result);
}
public override void GetCell(CSMAccPostingData data, ref SSMCellValue value, SSMCellStyle style)
{
using (var log = LogHelper.GetLogger(GetType().Name, MethodBase.GetCurrentMethod().Name))
{
style.kind = eMDataType.M_dNullTerminatedString;
var accountData = data.GetAccPosting();
var tradeId = accountData.fTradeID;
var accountId = 0;
SSMFinalPosting _fPosting = data.GetAccPosting();
if (_fPosting != null)
{
accountId = _fPosting.fAccountNameID;
if (_fPosting.fPostingType == 11)
{
CSMPosition pos = CSMPosition.GetCSRPosition(_fPosting.fPositionID);
if (pos != null)
{
CSMPortfolio port = pos.GetPortfolio();
if (port != null)
{
CSMAmFund fund = CSMAmFund.GetFundFromFolio(port);
if (fund != null)
{
string accountBookName = GetAccountBookNameForFund(fund);
value.SetString(accountBookName);
return;
}
}
}
return;
}
}
if (tradeId == 0 || accountId == 0)
{
return;
}
CSMTransaction trade = CSMTransaction.newCSRTransaction(tradeId);
if (trade == null)
{
return;
}
//Business Event
int type = (int)trade.GetTransactionType();
//Any Posting linked to the IDB Group should have account book 1000
if (_fPosting.fAccountNameID == 33528)
{
value.SetString(GetNostroIDBAccountBook(_fPosting.fID));
return;
}
int PostingId = _fPosting.fID;
int NostroId = _fPosting.fNostroAccountID;
if (NostroId > 0)
{
int EntityId = 0;
if (fDataLoaded == false)
{
LoadAccountEntities();
}
fNostroAndEntity.TryGetValue(NostroId, out EntityId);
if (IsIDBGroupEntity(EntityId))
{
value.SetString("1000");
return;
}
}
var cacheKey = string.Format("AccountBook_{0}", accountData.fID);
var strValue = CacheManager.GetItem <string>(cacheKey);
try
{
if (!string.IsNullOrEmpty(strValue))
{
value.SetString(strValue);
return;
}
//if value is not cached already we loaded it
strValue = CSxDataFacade.GetAccountBookName(accountData.fAccountingBookID);
//Filter on the account defined in the config file
if (CSxIslamicInstrumentsHelperCLI.IsForbiddenAccountId(accountId))
{
var parentId = 0;
try
{
//parentId = CSxIslamicInstrumentsHelperCLI.GetParentTrade(tradeId);
//couponS and redemption sukuk are not taken in account in this function
parentId = CSxIdbTradeId.GetParentIDBMergingAllocatedTrade(type, tradeId);
}
catch (Exception)
{
log.WriteSystemError("Failed to check if tarde is merged");
}
// AccountExceptions.Contains(accountData.fAccountingBookID)
//FILTER on merged trades
if (parentId != 0)
{
try
{
var t = CSMTransaction.newCSRTransaction(tradeId);
if (t == null)
{
throw new Exception("Failed to open trade");
}
var fid = 0;
//if(CSxIslamicInstrumentsHelperCLI.IsInterFundCashTransferBusinessEvent(type))
//{
// var tr = CSMTransaction.newCSRTransaction(parentId);
// if (tr == null)
// throw new Exception("Failed to open trade");
// fid = CSxIslamicInstrumentsHelperCLI.GetFundForEntity(tr.GetEntity());
//}
//else
//{
fid = CSxIslamicInstrumentsHelperCLI.GetFundForEntity(t.GetEntity());
//}
CSMAmFund f = CSMInstrument.GetInstance(fid);
if (f == null)
{
throw new Exception("Failed to find fund for settlement entity");
}
strValue = CSxDataFacade.GetAccountBookIdForFolio(f.GetTradingPortfolio());
}
catch (Exception e)
{
log.WriteSystemError("Failed to get Account Book Id from Settlement Entity for merged trade {0} : {1}", tradeId, e.Message);
}
}
//if (strValue != null)
//{
// //strValue = strValue.Substring(0, Math.Min(4, strValue.Length));
// //we cache the value for next time
// CacheManager.SetItem(cacheKey, strValue);
//}
}
if (strValue != null)
{
strValue = strValue.Substring(0, Math.Min(4, strValue.Length));
value.SetString(strValue);
}
}
catch (Exception e)
{
log.WriteSystemError("Failed to get Account Book Name for trade {0} : {1}", tradeId, e.Message);
if (IDB.IslamicInstruments.CSxIslamicInstrumentsHelperCLI.IsInGUIMode())
{
MessageBox.Show("Failed to get Account Book Name for trade " + tradeId + " Error:" + e.Message);
}
}
}
}