public override void loadDefinedSymbolFromDB()
{
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
// equity 쪽을 죄다 로드함.
daoM.KeyColumn_ = "index".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "index".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedIndexSymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_indexSymbolViewModel esvm = new Excel_indexSymbolViewModel();
esvm.setFromDAO(item);
this.definedIndexSymbolList_.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_ = "index".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "index".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedIndexSymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_indexSymbolViewModel esvm = new Excel_indexSymbolViewModel();
esvm.setFromDAO(item);
this.definedIndexSymbolList_.Add(esvm);
}
}
catch (Exception)
{
//OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
}
public static string loadMarketData(DateTime refDate, string underType, string code)
{
string load = "not loaded";
if (underType.ToUpper() == "STOCK" || underType.ToUpper() == "EQUITY" || underType.ToUpper() == "EXCEL_STOCKINDEX")
{
Excel_equitySymbolViewModel e_esvm = new Excel_equitySymbolViewModel();
load = e_esvm.dataLoad(refDate, code);
}
else if (underType.ToUpper() == "INTERESTRATE" || underType.ToUpper() == "IR" || underType.ToUpper() == "EXCEL_INTERESTRATE")
{
Excel_irCurveSymbolViewModel e_ircsvm = new Excel_irCurveSymbolViewModel();
load = e_ircsvm.dataLoad(refDate, code);
}
else if (underType.ToUpper() == "INDEX" || underType.ToUpper() == "EXCEL_INDEXTYPE")
{
Excel_indexSymbolViewModel e_isvm = new Excel_indexSymbolViewModel();
load = e_isvm.dataLoad(refDate, code);
}
else
{
}
return load;
}
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();
}
}
public static string loadMarketData(DateTime refDate, string underType, string code)
{
string load = "not loaded";
if (underType.ToUpper() == "STOCK" || underType.ToUpper() == "EQUITY" || underType.ToUpper() == "EXCEL_STOCKINDEX")
{
Excel_equitySymbolViewModel e_esvm = new Excel_equitySymbolViewModel();
load = e_esvm.dataLoad(refDate, code);
}
else if (underType.ToUpper() == "INTERESTRATE" || underType.ToUpper() == "IR" || underType.ToUpper() == "EXCEL_INTERESTRATE")
{
Excel_irCurveSymbolViewModel e_ircsvm = new Excel_irCurveSymbolViewModel();
load = e_ircsvm.dataLoad(refDate, code);
}
else if (underType.ToUpper() == "INDEX" || underType.ToUpper() == "EXCEL_INDEXTYPE")
{
Excel_indexSymbolViewModel e_isvm = new Excel_indexSymbolViewModel();
load = e_isvm.dataLoad(refDate, code);
}
else
{
}
return(load);
}
private void resultDataGrid_MouseDoubleClick2(object sender, MouseButtonEventArgs e)
{
Excel_indexSymbolViewModel selectedItem = this.symbolDataGrid_.SelectedItem as Excel_indexSymbolViewModel;
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();
}
}
