public override void loadDefinedSymbolFromDB()
{
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
// equity 쪽을 죄다 로드함.
daoM.KeyColumn_ = "equity".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "equity".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedEquitySymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_equitySymbolViewModel esvm = new Excel_equitySymbolViewModel();
esvm.setFromDAO(item);
this.definedEquitySymbolList_.Add(esvm);
}
}
catch (Exception)
{
//OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
}
public override void loadDefinedSymbolFromDB()
{
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
// ir 쪽을 죄다 로드함.
daoM.KeyColumn_ = "ircurve".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "ircurve".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedIRCurveSymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_irCurveSymbolViewModel eicvm = new Excel_irCurveSymbolViewModel();
eicvm.setFromDAO(item);
this.definedIRCurveSymbolList_.Add(eicvm);
}
}
catch (Exception)
{
//OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
}
public void loadMarketDataSymbolFromDB()
{
this.symbolDAOList_.Clear();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));
foreach (var item in daoM.DAOList_)
{
this.symbolDAOList_.Add(item);
}
}
public void loadMarketDataSymbolFromDB()
{
this.symbolDAOList_.Clear();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));
foreach (var item in daoM.DAOList_)
{
this.symbolDAOList_.Add(item);
}
}
public static List <Excel_marketDataSymbol> getDefinedSymbolFiltering(string filter)
{
List <Excel_marketDataSymbol> symbols = new List <Excel_marketDataSymbol>();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectFiltering(DataBaseConnectManager.ConnectionFactory("myDB"), filter);
foreach (var item in daoM.DAOList_)
{
Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol();
e_mds.setFromDAO(item);
symbols.Add(e_mds);
}
return(symbols);
}
public static List <Excel_marketDataSymbol> getDefinedSymbolALL()
{
List <Excel_marketDataSymbol> symbols = new List <Excel_marketDataSymbol>();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));
foreach (var item in daoM.DAOList_)
{
string underType = item.SYMBOL_TYPE_;
//Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType);
Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol();
e_mds.setFromDAO(item);
symbols.Add(e_mds);
}
return(symbols);
}
public static List<Excel_marketDataSymbol> getDefinedSymbolFiltering(string filter)
{
List<Excel_marketDataSymbol> symbols = new List<Excel_marketDataSymbol>();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectFiltering(DataBaseConnectManager.ConnectionFactory("myDB"), filter);
foreach (var item in daoM.DAOList_)
{
Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol();
e_mds.setFromDAO(item);
symbols.Add(e_mds);
}
return symbols;
}
public static List<Excel_marketDataSymbol> getDefinedSymbolALL()
{
List<Excel_marketDataSymbol> symbols = new List<Excel_marketDataSymbol>();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));
foreach (var item in daoM.DAOList_)
{
string underType = item.SYMBOL_TYPE_;
//Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType);
Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol();
e_mds.setFromDAO(item);
symbols.Add(e_mds);
}
return symbols;
}
