public static DataSet GetTradeableInstruments(
SecCategoryFilterOptions secCategoryFilter, string isin, string instrumentName,
SecCategories secCategoryId, int exchangeId, int currencyNominalId,
ActivityReturnFilter activityFilter, string propertyList)
{
return GetTradeableInstruments(
secCategoryFilter, isin, instrumentName, secCategoryId,
exchangeId, currencyNominalId, activityFilter, true, null, propertyList);
}
/// <summary>
/// Get all system categories
/// </summary>
/// <param name="session">Data access object</param>
/// <param name="secCategoryFilter">Type of sec category to return</param>
/// <param name="includeNotSupported">include Not Supported sec categories</param>
/// <returns>Collection of categories</returns>
public static IList<ISecCategory> GetSecCategories(IDalSession session, SecCategoryFilterOptions secCategoryFilter, bool? includeNotSupported)
{
Hashtable parameters = new Hashtable();
if (secCategoryFilter != SecCategoryFilterOptions.All)
parameters.Add("secCategoryFilter", (int)secCategoryFilter);
if (includeNotSupported.HasValue && !includeNotSupported.Value)
parameters.Add("isSupported", true);
IList<ISecCategory> list = session.GetTypedListByNamedQuery<ISecCategory>(
"B4F.TotalGiro.Instruments.SecCategories",
parameters);
return list.ToList();
//
}
public static DataSet GetSecCategories(SecCategoryFilterOptions secCategoryFilter, bool includeNotSupported)
{
using (IDalSession session = NHSessionFactory.CreateSession())
{
DataSet ds = SecCategoryMapper.GetSecCategories(session, secCategoryFilter, includeNotSupported)
.Select(c => new
{
c.Key,
c.Description
})
.ToDataSet();
Utility.AddEmptyFirstRow(ds);
return ds;
}
}
public static DataSet GetTradeableInstruments(
SecCategoryFilterOptions secCategoryFilter, string isin, string instrumentName,
SecCategories secCategoryId, int exchangeId, int currencyNominalId,
ActivityReturnFilter activityFilter, bool assetManagerMappedOnly,
string hqlWhere, string propertyList)
{
using (IDalSession session = NHSessionFactory.CreateSession())
{
return InstrumentMapper.GetTradeableInstruments(
session, secCategoryFilter, isin, instrumentName,
secCategoryId, exchangeId, currencyNominalId,
assetManagerMappedOnly, activityFilter, hqlWhere)
.ToDataSet(propertyList);
}
}
public static DataSet GetSecCategories(SecCategoryFilterOptions secCategoryFilter)
{
return GetSecCategories(secCategoryFilter, false);
}
public static DataSet GetTradeableInstrumentsDDL(
SecCategoryFilterOptions secCategoryFilter, string isin, string instrumentName,
SecCategories secCategoryId, int exchangeId, int currencyNominalId,
ActivityReturnFilter activityFilter)
{
DataSet ds = InstrumentFinderAdapter.GetTradeableInstruments(
secCategoryFilter, isin, instrumentName,
secCategoryId, exchangeId, currencyNominalId,
activityFilter, true, null, "Key, Isin, DisplayIsinWithName");
Utility.AddEmptyFirstRow(ds.Tables[0]);
return ds;
}
/// <summary>
/// Get all system categories
/// </summary>
/// <param name="session">Data access object</param>
/// <param name="secCategoryFilter">Type of sec category to return</param>
/// <returns>Collection of categories</returns>
public static IList<ISecCategory> GetSecCategories(IDalSession session, SecCategoryFilterOptions secCategoryFilter)
{
return GetSecCategories(session, secCategoryFilter, false);
}
public static List<KeyValuePair<int, string>> GetTradeableInstrumentsForDropDownList(IDalSession session, SecCategoryFilterOptions secCategoryFilter)
{
return GetTradeableInstruments(session, secCategoryFilter, null, null, SecCategories.Undefined, 0, 0, true, ActivityReturnFilter.Active, null)
.Select(i => new KeyValuePair<int, string>(i.Key, (i.Name + " - " + i.Isin)))
.ToList()
.OrderBy(o => o.Value)
.ToList();
}
public static IList<ITradeableInstrument> GetTradeableInstruments(IDalSession session,
SecCategoryFilterOptions secCategoryFilter,
string isin, string instrumentName, SecCategories secCategoryId,
int exchangeId, int currencyNominalId, bool assetManagerMappedOnly,
ActivityReturnFilter activityFilter, string hqlWhere)
{
Hashtable parameters = new Hashtable();
if (secCategoryFilter != SecCategoryFilterOptions.All)
parameters.Add("secCategoryType", (int)secCategoryFilter);
if (!string.IsNullOrEmpty(isin))
parameters.Add("isin", Util.PrepareNamedParameterWithWildcard(isin, MatchModes.Anywhere));
if (!string.IsNullOrEmpty(instrumentName))
parameters.Add("instrumentName", Util.PrepareNamedParameterWithWildcard(instrumentName, MatchModes.Anywhere));
if (secCategoryId != SecCategories.Undefined)
parameters.Add("secCategoryId", secCategoryId);
if (exchangeId > 0)
parameters.Add("exchangeId", exchangeId);
if (currencyNominalId > 0)
parameters.Add("currencyNominalId", currencyNominalId);
if (activityFilter != ActivityReturnFilter.All)
parameters.Add("isActive", activityFilter == ActivityReturnFilter.Active);
if (assetManagerMappedOnly)
{
IManagementCompany comp = LoginMapper.GetCurrentManagmentCompany(session);
if (comp != null && !comp.IsStichting)
parameters.Add("managementCompanyID", comp.Key);
}
IList<ITradeableInstrument> list = session.GetTypedListByNamedQuery<ITradeableInstrument>(
"B4F.TotalGiro.Instruments.Instrument.GetTradeableInstruments",
hqlWhere, parameters);
if (secCategoryFilter != SecCategoryFilterOptions.CorporateAction)
list = list.Where(x => x.SecCategory.SecCategoryType != SecCategoryTypes.CorporateAction).ToList();
return list;
}
public static DataSet GetDerivativeMasters(
SecCategoryFilterOptions secCategoryFilter, string isin, string instrumentName,
SecCategories secCategoryId, int exchangeId, int currencyNominalId)
{
using (IDalSession session = NHSessionFactory.CreateSession())
{
Hashtable parameters = new Hashtable();
if (secCategoryFilter != SecCategoryFilterOptions.All)
parameters.Add("secCategoryType", (int)secCategoryFilter);
if (!string.IsNullOrEmpty(isin))
parameters.Add("isin", Util.PrepareNamedParameterWithWildcard(isin, MatchModes.Anywhere));
if (!string.IsNullOrEmpty(instrumentName))
parameters.Add("instrumentName", Util.PrepareNamedParameterWithWildcard(instrumentName, MatchModes.Anywhere));
if (secCategoryId != SecCategories.Undefined)
parameters.Add("secCategoryId", secCategoryId);
if (exchangeId > 0)
parameters.Add("exchangeId", exchangeId);
if (currencyNominalId > 0)
parameters.Add("currencyNominalId", currencyNominalId);
IList<IDerivativeMaster> list = session.GetTypedListByNamedQuery<IDerivativeMaster>(
"B4F.TotalGiro.Instruments.Instrument.DerivativeMasters",
parameters);
return list.Select(l => new
{
l.Key,
UnderlyingName = l.Underlying.Name,
UnderlyingIsin = l.Underlying.Isin,
l.Name,
l.SecCategory,
ExchangeName = l.Exchange.ExchangeName,
NominalCurrency = l.CurrencyNominal.DisplayName,
Symbol = l.DerivativeSymbol
}).ToDataSet();
};
}
