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;
}
}