public static Excel_underlyingInfoViewModel loadUnderInfo(DateTime refDate, string nameTrans) { // nameTrans를 가지고 code를 찾음. MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.NAME_KOR_ = (nameTrans.Trim()).ToUpper(); dao.selectNAME_KOR(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; 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); }
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 void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); this.DAOList_ = new List <MARKETDATA_SYMBOL_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = MARKETDATA_SYMBOL_INFO_Table_DAOManager.SelectQuery_; selectQuery = selectQuery.Replace("@SYMBOL_TYPEKeyColumnValue@", this.KeyColumn_SYMBOL_TYPE_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = item[0].ToString(); dao.NAME_ENG_ = item[1].ToString(); dao.NAME_KOR_ = item[2].ToString(); dao.SYMBOL_TYPE_ = item[3].ToString(); dao.PROVIDER_ = item[4].ToString(); dao.DESCRIPTION_ = item[5].ToString(); dao.TENOR_ = item[6].ToString(); dao.SUB_TYPE_ = item[7].ToString(); dao.LINKEDCURVE_ = item[8].ToString(); dao.RATE_TYPE_ = item[9].ToString(); dao.LEG_TENOR_ = item[10].ToString(); dao.CURRENCY_ = item[11].ToString(); this.DAOList_.Add(dao); } conn.Close(); } catch (Exception) { conn.Close(); } }
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_); }
private void AddSymbolButton_Click(object sender, RoutedEventArgs e) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.DESCRIPTION_ = descriptionTb_.Text; dao.NAME_ENG_ = name_engTb_.Text; dao.NAME_KOR_ = name_korTb_.Text; dao.PROVIDER_ = providerTb_.Text; dao.SYMBOL_TYPE_ = symbol_typeTb_.Text; dao.SYMBOL_ = symbolTb_.Text; dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); this.viewModel_.loadMarketDataSymbolFromDB(); }
public void copy(MARKETDATA_SYMBOL_INFO_Table_DAO clone) { this.DESCRIPTION_ = clone.DESCRIPTION_; this.SYMBOL_ = clone.SYMBOL_; this.SYMBOL_TYPE_ = clone.SYMBOL_TYPE_; this.NAME_ENG_ = clone.NAME_ENG_; this.NAME_KOR_ = clone.NAME_KOR_; this.PROVIDER_ = clone.PROVIDER_; this.TENOR_ = clone.TENOR_; this.SUB_TYPE_ = clone.SUB_TYPE_; this.LINKEDCURVE_ = clone.LINKEDCURVE_; this.RATE_TYPE_ = clone.RATE_TYPE_; this.LEG_TENOR_ = clone.LEG_TENOR_; this.CURRENCY_ = clone.CURRENCY_; }
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 void setFromDAO(MARKETDATA_SYMBOL_INFO_Table_DAO dao) { // bussiness logic here this.symbol_ = dao.SYMBOL_; this.name_eng_ = dao.NAME_ENG_; this.name_kor_ = dao.NAME_KOR_; this.symbol_type_ = dao.SYMBOL_TYPE_; this.provider_ = dao.PROVIDER_; this.description_ = dao.DESCRIPTION_; this.tenor_ = dao.TENOR_; this.sub_type_ = dao.SUB_TYPE_; this.linkedcurve_ = dao.LINKEDCURVE_; this.rate_type_ = dao.RATE_TYPE_; this.leg_tenor_ = dao.LEG_TENOR_; this.currency_ = dao.CURRENCY_; }
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); }
private void symbolDataListView__SelectionChanged(object sender, SelectionChangedEventArgs e) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = this.symbolDataListView_.SelectedItem as MARKETDATA_SYMBOL_INFO_Table_DAO; if (dao != null) { this.SelectedSymbol_.setFromDAO(dao); descriptionTb_.Text = dao.DESCRIPTION_; name_engTb_.Text = dao.NAME_ENG_; name_korTb_.Text = dao.NAME_KOR_; providerTb_.Text = dao.PROVIDER_; symbol_typeTb_.Text = dao.SYMBOL_TYPE_; symbolTb_.Text = dao.SYMBOL_; } //this.bindingPanel_.DataContext = this.SelectedSymbol_; //this.bindingPanel_.Text = this.SelectedSymbol_.Symbol_; }
public MARKETDATA_SYMBOL_INFO_Table_DAO clone() { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.DESCRIPTION_ = this.DESCRIPTION_; dao.SYMBOL_ = this.SYMBOL_; dao.SYMBOL_TYPE_ = this.SYMBOL_TYPE_; dao.NAME_ENG_ = this.NAME_ENG_; dao.NAME_KOR_ = this.NAME_KOR_; dao.PROVIDER_ = this.PROVIDER_; dao.TENOR_ = this.TENOR_; dao.SUB_TYPE_ = this.SUB_TYPE_; dao.LINKEDCURVE_ = this.LINKEDCURVE_; dao.RATE_TYPE_ = this.RATE_TYPE_; dao.LEG_TENOR_ = this.LEG_TENOR_; dao.CURRENCY_ = this.CURRENCY_; return(dao); }
public MARKETDATA_SYMBOL_INFO_Table_DAO buildDAO() { // bussiness logic here MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = this.Symbol_; dao.NAME_ENG_ = this.Name_eng_; dao.NAME_KOR_ = this.Name_kor_; dao.SYMBOL_TYPE_ = this.Symbol_type_; dao.PROVIDER_ = this.Provider_; dao.DESCRIPTION_ = this.Description_; dao.TENOR_ = this.Tenor_; dao.SUB_TYPE_ = this.sub_type_; dao.LINKEDCURVE_ = this.linkedcurve_; dao.RATE_TYPE_ = this.Rate_type_; dao.LEG_TENOR_ = this.Leg_tenor_; dao.CURRENCY_ = this.Currency_; return(dao); }
private void deleteSymbolButton_Click(object sender, RoutedEventArgs e) { // symbol 같은거 수정되면 delete 비활성화 MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.DESCRIPTION_ = descriptionTb_.Text; dao.NAME_ENG_ = name_engTb_.Text; dao.NAME_KOR_ = name_korTb_.Text; dao.PROVIDER_ = providerTb_.Text; dao.SYMBOL_TYPE_ = symbol_typeTb_.Text; dao.SYMBOL_ = symbolTb_.Text; dao.delete(DataBaseConnectManager.ConnectionFactory("myDB")); this.viewModel_.loadMarketDataSymbolFromDB(); //MARKETDATA_SYMBOL_INFO_Table_DAO dao = this.symbolDataListView_.SelectedItem as MARKETDATA_SYMBOL_INFO_Table_DAO; //this.viewModel_.deleteDao(this.SelectedSymbol_); //this.viewModel_.loadMarketDataSymbolFromDB(); }
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 MARKETDATA_SYMBOL_INFO_Table_DAO buildDAO() { // bussiness logic here MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = this.Symbol_; dao.NAME_ENG_ = this.Name_eng_; dao.NAME_KOR_ = this.Name_kor_; dao.SYMBOL_TYPE_ = this.Symbol_type_; dao.PROVIDER_ = this.Provider_; dao.DESCRIPTION_ = this.Description_; dao.TENOR_ = this.Tenor_; dao.SUB_TYPE_ = this.sub_type_; dao.LINKEDCURVE_ = this.linkedcurve_; dao.RATE_TYPE_ = this.Rate_type_; dao.LEG_TENOR_ = this.Leg_tenor_; dao.CURRENCY_ = this.Currency_; return dao; }
public Excel_marketDataSymbolViewModel() { this.symbolDAOList_ = new ObservableCollection <MARKETDATA_SYMBOL_INFO_Table_DAO>(); this.addedDao_ = new MARKETDATA_SYMBOL_INFO_Table_DAO(); }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) conn.Open(); try { DataTable tb = new DataTable(); this.DAOList_ = new List<MARKETDATA_SYMBOL_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = MARKETDATA_SYMBOL_INFO_Table_DAOManager.SelectQuery_; selectQuery = selectQuery.Replace("@SYMBOL_TYPEKeyColumnValue@", this.KeyColumn_SYMBOL_TYPE_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = item[0].ToString(); dao.NAME_ENG_ = item[1].ToString(); dao.NAME_KOR_ = item[2].ToString(); dao.SYMBOL_TYPE_ = item[3].ToString(); dao.PROVIDER_ = item[4].ToString(); dao.DESCRIPTION_ = item[5].ToString(); dao.TENOR_ = item[6].ToString(); dao.SUB_TYPE_ = item[7].ToString(); dao.LINKEDCURVE_ = item[8].ToString(); dao.RATE_TYPE_ = item[9].ToString(); dao.LEG_TENOR_ = item[10].ToString(); dao.CURRENCY_ = item[11].ToString(); this.DAOList_.Add(dao); } conn.Close(); } catch (Exception) { conn.Close(); } }
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; } }
public static Excel_underlyingInfoViewModel loadUnderInfo(DateTime refDate, string nameTrans) { // nameTrans를 가지고 code를 찾음. MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.NAME_KOR_ = (nameTrans.Trim()).ToUpper(); dao.selectNAME_KOR(DataBaseConnectManager.ConnectionFactory("myDB")); // 코드를 찾아서 symbol을 로드함. // symbol을 통해서 type을 로드함 // type을 통해서 symbolVM을 만들음 string underType = dao.SYMBOL_TYPE_; 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; }
public Excel_marketDataSymbolViewModel() { this.symbolDAOList_ = new ObservableCollection<MARKETDATA_SYMBOL_INFO_Table_DAO>(); this.addedDao_ = new MARKETDATA_SYMBOL_INFO_Table_DAO(); }
public MARKETDATA_SYMBOL_INFO_Table_DAO clone() { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.DESCRIPTION_ = this.DESCRIPTION_; dao.SYMBOL_ = this.SYMBOL_; dao.SYMBOL_TYPE_ = this.SYMBOL_TYPE_; dao.NAME_ENG_ = this.NAME_ENG_; dao.NAME_KOR_ = this.NAME_KOR_; dao.PROVIDER_ = this.PROVIDER_; dao.TENOR_ = this.TENOR_; dao.SUB_TYPE_ = this.SUB_TYPE_; dao.LINKEDCURVE_ = this.LINKEDCURVE_; dao.RATE_TYPE_ = this.RATE_TYPE_; dao.LEG_TENOR_ = this.LEG_TENOR_; dao.CURRENCY_ = this.CURRENCY_; return dao; }