public static Excel_marketDataSymbol getDefinedSymbol(string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code.Trim(); dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; if (underType == null) { throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_); } Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType); e_mds.setFromDAO(dao); return(e_mds); }
public static string getProvider(string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); return(dao.PROVIDER_); }
public override string dataLoad(DateTime refDate, string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); this.setFromDAO(dao); IndexMarketDataLoader indexLoader = IndexMarketDataLoader.CreateMarketDataLoader(this.provider_); string value = indexLoader.load(refDate, code); return(value); }
public override string dataLoad(DateTime refDate, string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); this.setFromDAO(dao); IndexMarketDataLoader indexLoader = IndexMarketDataLoader.CreateMarketDataLoader(this.provider_); string value = indexLoader.load(refDate, code); return value; }
public static Excel_underlyingInfoViewModel loadUnderInfo2(DateTime refDate, string nameTrans) { // nameTrans를 가지고 code를 찾음. try { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = nameTrans.Trim(); dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; if (underType == null) { throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_); } Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType); e_mds.setFromDAO(dao); Excel_underlyingInfoViewModel e_uivm = e_mds.underlyingInfoVM(); e_uivm.BasePrice_ = e_mds.dataLoad(Excel_loaderViewModel.availableMarketDataDate(refDate), e_mds.Symbol_); return(e_uivm); } catch (Exception) { throw; } }
public override string dataLoad(DateTime refDate, string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); this.setFromDAO(dao); IRCurveMarketDataLoader irLoader = IRCurveMarketDataLoader.CreateMarketDataLoader(this.provider_); ObservableCollection <Excel_irCurveDataViewModel> e_ircdvmList = new ObservableCollection <Excel_irCurveDataViewModel>(); irLoader.load(refDate, this.Linkedcurve_, e_ircdvmList); int tenorNum = e_ircdvmList[0].getTenorIndex(this.Tenor_); string value = e_ircdvmList[0].Excel_rateDataViewModelList_[tenorNum].Value_; return(value); }
public override string dataLoad(DateTime refDate, string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); this.setFromDAO(dao); IRCurveMarketDataLoader irLoader = IRCurveMarketDataLoader.CreateMarketDataLoader(this.provider_); ObservableCollection<Excel_irCurveDataViewModel> e_ircdvmList = new ObservableCollection<Excel_irCurveDataViewModel>(); irLoader.load(refDate, this.Linkedcurve_, e_ircdvmList); int tenorNum = e_ircdvmList[0].getTenorIndex(this.Tenor_); string value = e_ircdvmList[0].Excel_rateDataViewModelList_[tenorNum].Value_; return value; }
public static string underType(string underSymbol) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = underSymbol.Trim(); dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; if (underType == null) { throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_); } return(underType); }
public static string underType(string underSymbol) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = underSymbol.Trim(); dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; if (underType == null) { throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_); } return underType; }
public static Excel_marketDataSymbol getDefinedSymbol(string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code.Trim(); dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; if (underType == null) { throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_); } Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType); e_mds.setFromDAO(dao); return e_mds; }
public static string getProvider(string code) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = code; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); return dao.PROVIDER_; }
public static Excel_underlyingInfoViewModel loadUnderInfoWithoutBasePrice(string underSymbol) { // nameTrans를 가지고 code를 찾음. try { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = underSymbol.Trim(); dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; if (underType == null) { throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_); } Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType); e_mds.setFromDAO(dao); Excel_underlyingInfoViewModel e_uivm = e_mds.underlyingInfoVM(); return e_uivm; } catch (Exception) { throw; } }