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 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 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;
}
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_;
}
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();
}
