public override void loadDefinedSymbolFromDB()
{
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
// equity 쪽을 죄다 로드함.
daoM.KeyColumn_ = "fx".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "fx".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedFxSymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_fxSymbolViewModel esvm = new Excel_fxSymbolViewModel();
esvm.setFromDAO(item);
this.definedFxSymbolList_.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();
// equity 쪽을 죄다 로드함.
daoM.KeyColumn_ = "fx".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "fx".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedFxSymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_fxSymbolViewModel esvm = new Excel_fxSymbolViewModel();
esvm.setFromDAO(item);
this.definedFxSymbolList_.Add(esvm);
}
}
catch (Exception)
{
//OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
}
public static Excel_marketDataSymbol CreateSymbolViewModel(string underType)
{
if (underType.ToUpper() == "STOCK" || underType.ToUpper() == "EQUITY")
{
Excel_equitySymbolViewModel e_esvm = new Excel_equitySymbolViewModel();
return(e_esvm);
}
else if (underType.ToUpper() == "IR" || underType.ToUpper() == "INTERESTRATE")
{
Excel_irSymbolViewModel e_irsvm = new Excel_irSymbolViewModel();
return(e_irsvm);
}
else if (underType.ToUpper() == "INDEX" || underType.ToUpper() == "INDEX")
{
Excel_indexSymbolViewModel e_isvm = new Excel_indexSymbolViewModel();
return(e_isvm);
}
else if (underType.ToUpper() == "FX" || underType.ToUpper() == "FXRATE")
{
Excel_fxSymbolViewModel e_fsvm = new Excel_fxSymbolViewModel();
return(e_fsvm);
}
else
{
throw new NotImplementedException();
}
}
private void resultDataGrid_MouseDoubleClick2(object sender, MouseButtonEventArgs e)
{
Excel_fxSymbolViewModel selectedItem = this.symbolDataGrid_.SelectedItem as Excel_fxSymbolViewModel;
if (selectedItem != null)
{
Excel_underlyingLoaderViewModel e_ulvm = ((Grid)this.Parent).DataContext as Excel_underlyingLoaderViewModel;
e_ulvm.SelectedUnderlyingVM_ = selectedItem.underlyingInfoVM();
}
}
public static Excel_marketDataSymbol CreateSymbolViewModel(string underType)
{
if (underType.ToUpper() == "STOCK" || underType.ToUpper() == "EQUITY")
{
Excel_equitySymbolViewModel e_esvm = new Excel_equitySymbolViewModel();
return e_esvm;
}
else if (underType.ToUpper() == "IR" || underType.ToUpper() == "INTERESTRATE")
{
Excel_irSymbolViewModel e_irsvm = new Excel_irSymbolViewModel();
return e_irsvm;
}
else if (underType.ToUpper() == "INDEX" || underType.ToUpper() == "INDEX")
{
Excel_indexSymbolViewModel e_isvm = new Excel_indexSymbolViewModel();
return e_isvm;
}
else if (underType.ToUpper() == "FX" || underType.ToUpper() == "FXRATE")
{
Excel_fxSymbolViewModel e_fsvm = new Excel_fxSymbolViewModel();
return e_fsvm;
}
else
{
throw new NotImplementedException();
}
}
