/// <summary>
/// Select record of underlying in DB with korea name and name type(FM1, FM2 or Drop)
/// </summary>
/// <param name="koreaName"></param>
/// <returns></returns>
public static KoreaUnderlyingInfo SelectUnderlying(string koreaName, KoreaNameType type)
{
string condition = "";
if (type.Equals(KoreaNameType.KoreaName))
{
condition = "where KoreaName =N'" + koreaName + "'";
}
else if (type.Equals(KoreaNameType.KoreaNameForFM2))
{
condition = "where KoreaNameFM2 =N'" + koreaName + "'or KoreaNameDrop =N'" + koreaName + "' or UnderlyingName =N'" + koreaName + "'";
}
else if (type.Equals(KoreaNameType.KoreaNameForDrop))
{
condition = "where KoreaNameFM2 =N'" + koreaName + "'or KoreaNameDrop =N'" + koreaName + "' or UnderlyingName =N'" + koreaName + "'";
}
else
{
condition = "where KoreaNameFM2 =N'" + koreaName + "'or KoreaNameDrop =N'" + koreaName + "' or UnderlyingName =N'" + koreaName + "'";
}
DataTable dt = ManagerBase.Select(ETI_KOREA_UNDERLYING_TABLE_NAME, new string[] { "*" }, condition);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
KoreaUnderlyingInfo underlying = new KoreaUnderlyingInfo();
DataRow dr = dt.Rows[0];
underlying.BNDUnderlying = Convert.ToString(dr["BNDUnderlying"]);
underlying.BodyGroupCommonName = Convert.ToString(dr["BodyGroupCommonName"]);
underlying.IDNDisplayNamePart = Convert.ToString(dr["IDNDisplayNamePart"]);
underlying.KoreaName = Convert.ToString(dr["KoreaName"]);
underlying.KoreaNameDrop = Convert.ToString(dr["KoreaNameDrop"]);
underlying.KoreaNameFM2 = Convert.ToString(dr["KoreaNameFM2"]);
underlying.NDATCUnderlyingTitle = Convert.ToString(dr["NDATCUnderlyingTitle"]);
underlying.QACommonNamePart = Convert.ToString(dr["QACommonNamePart"]);
underlying.UnderlyingName = Convert.ToString(dr["UnderlyingName"]);
underlying.UnderlyingRIC = Convert.ToString(dr["UnderlyingRIC"]);
underlying.ISIN = Convert.ToString(dr["ISIN"]);
return(underlying);
}
/// <summary>
/// Select a record of Korea Issuer with Korea issuer code2
/// </summary>
/// <param name="issuerCode2">Korea oissuer code2</param>
/// <returns></returns>
public static KoreaIssuerInfo SelectIssuerByIssuerCode2(string issuerCode2)
{
string condition = "where IssuerCode2 =N'" + issuerCode2 + "'";
DataTable dt = ManagerBase.Select(ETI_KOREA_ISSUER_TABLE_NAME, new string[] { "*" }, condition);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
KoreaIssuerInfo issuer = new KoreaIssuerInfo();
DataRow dr = dt.Rows[0];
issuer.KoreaIssuerName = Convert.ToString(dr["KoreaIssuerName"]);
issuer.BodyGroupCommonName = Convert.ToString(dr["BodyGroupCommonName"]);
issuer.IssuerCode2 = Convert.ToString(dr["IssuerCode2"]);
issuer.IssuerCode4 = Convert.ToString(dr["IssuerCode4"]);
issuer.IssuerCompanyName = Convert.ToString(dr["IssuerCompanyName"]);
issuer.IssuerName5 = Convert.ToString(dr["IssuerName5"]);
issuer.NDAIssuerOrgid = Convert.ToString(dr["NDAIssuerOrgid"]);
issuer.NDATCIssuerTitle = Convert.ToString(dr["NDATCIssuerTitle"]);
return(issuer);
}
public static KoreaUnderlyingInfo SelectUnderlyingByISIN(string isin)
{
string condition = "where ISIN ='" + isin + "'";
DataTable dt = ManagerBase.Select(ETI_KOREA_UNDERLYING_TABLE_NAME, new string[] { "*" }, condition);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
KoreaUnderlyingInfo underlying = new KoreaUnderlyingInfo();
DataRow dr = dt.Rows[0];
underlying.BNDUnderlying = Convert.ToString(dr["BNDUnderlying"]);
underlying.BodyGroupCommonName = Convert.ToString(dr["BodyGroupCommonName"]);
underlying.IDNDisplayNamePart = Convert.ToString(dr["IDNDisplayNamePart"]);
underlying.KoreaName = Convert.ToString(dr["KoreaName"]);
underlying.KoreaNameDrop = Convert.ToString(dr["KoreaNameDrop"]);
underlying.KoreaNameFM2 = Convert.ToString(dr["KoreaNameFM2"]);
underlying.NDATCUnderlyingTitle = Convert.ToString(dr["NDATCUnderlyingTitle"]);
underlying.QACommonNamePart = Convert.ToString(dr["QACommonNamePart"]);
underlying.UnderlyingName = Convert.ToString(dr["UnderlyingName"]);
underlying.UnderlyingRIC = Convert.ToString(dr["UnderlyingRIC"]);
return(underlying);
}
public static HKUnderlyingInfo SelectUnderlyingInfoByUnderlying(string underlying)
{
try
{
if ((underlying + string.Empty).Trim().Length == 0)
{
return(null);
}
string where = string.Format("where Underlying = '{0}'", underlying);
DataTable dt = ManagerBase.Select(ETI_UNDERLYING_TABLE_NAME, new string[] { "*" }, where);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
DataRow dr = dt.Rows[0];
HKUnderlyingInfo hkUnderlying = new HKUnderlyingInfo();
hkUnderlying.ID = Convert.ToString(dr["ID"]);
hkUnderlying.Underlying = Convert.ToString(dr["Underlying"]);
hkUnderlying.BCAST_REF = Convert.ToString(dr["BCAST_REF"]);
hkUnderlying.INSTMOD_GN_TX20_6 = Convert.ToString(dr["INSTMOD_GN_TX20_6"]);
hkUnderlying.INSTMOD_GN_TX20_7 = Convert.ToString(dr["INSTMOD_GN_TX20_7"]);
hkUnderlying.INSTMOD_GN_TX20_12 = Convert.ToString(dr["INSTMOD_GN_TX20_12"]);
hkUnderlying.INSTMOD_LONGLINK2 = Convert.ToString(dr["INSTMOD_LONGLINK2"]);
hkUnderlying.INSTMOD_LONGLINK6 = Convert.ToString(dr["INSTMOD_LONGLINK6"]);
hkUnderlying.INSTMOD_UNDERLYING = Convert.ToString(dr["INSTMOD_UNDERLYING"]);
return(hkUnderlying);
}
catch (Exception)
{
return(null);
}
}
