private void IndexName_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Window w = new Window();
w.Width = 500;
w.Height = 200;
IndexTickerInfoEditorView itiev = new IndexTickerInfoEditorView();
// data load
IndexTickerInfo iti = this.definedIndexList_.SelectedItem as IndexTickerInfo;
itiev.ViewModel_ = this.viewModel_.loadDefinedIndex(iti.Name_);
w.Content = itiev;
if (w.ShowDialog() == true)
{
this.selectedViewModel_ = itiev.ViewModel_;
this.viewModel_.updateDefinedIndex(itiev.ViewModel_);
//this.indexSymbolTextBox_.Text = this.selectedViewModel_.Name_;
}
else
{
}
}
public IndexHistoryMarketData(IndexTickerInfo indexTicker)
{
this.Code_ = indexTicker.KrCode_;
this.Name_ = indexTicker.Name_;
this.TimeSeries_ = new Dictionary <string, string>();
}
public IndexHistoryMarketData(IndexTickerInfo indexTicker)
{
this.Code_ = indexTicker.KrCode_;
this.Name_ = indexTicker.Name_;
this.TimeSeries_ = new Dictionary<string, string>();
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
IndexTickerInfo item = this.definedIndexList_.SelectedItem as IndexTickerInfo;
this.viewModel_.deleteDefinedIndex(item.Name_);
this.viewModel_.DefinedIndexSymbolList_.Remove(item);
}
public IndexTickerInfo loadDefinedIndex(string nameStr)
{
SqlCeConnection connection = new SqlCeConnection(this.connectionStr_);
try
{
SqlCeCommand command = connection.CreateCommand();
connection.Open();
string wrapName = QueryStr.wrapComma(nameStr);
command.CommandText = "SELECT * FROM INDEX_TICKER_INFO WHERE NAME=" + wrapName;
SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
DataTable tb = new DataTable();
dataAdapter.Fill(tb);
IndexTickerInfo loadITI = new IndexTickerInfo();
foreach (DataRow row in tb.Rows)
{
string name = row["NAME"].ToString();
string krcode = row["KRCODE"].ToString();
string yahoo_ticker = row["YAHOO_TICKER"].ToString();
string bloomberg_ticker = row["BLOOMBERG_TICKER"].ToString();
string kap_ticker = row["KAP_TICKER"].ToString();
string kis_ticker = row["KIS_TICKER"].ToString();
string datasource = row["DATASOURCE"].ToString();
string time_download = row["TIME_DOWNLOAD"].ToString();
string index_type = row["INDEX_TYPE"].ToString();
loadITI = new IndexTickerInfo(name, krcode, yahoo_ticker,
bloomberg_ticker,
kap_ticker,
kis_ticker,
datasource,
time_download,
index_type
);
}
connection.Close();
return(loadITI);
}
catch (SqlCeException)
{
connection.Close();
OutputLogViewModel.addResult("DataBase Connection Error : DB Load");
throw;
}
}
public int updateDefinedIndex(IndexTickerInfo iti)
{
SqlCeConnection connection = new SqlCeConnection(this.connectionStr_);
try
{
DataTable tb = new DataTable();
SqlCeCommand command = connection.CreateCommand();
connection.Open();
//delCommand.CommandText = "DELETE FROM CORRELATION WHERE DATE ='" + ReferenceDate_.ToString("yyyy-MM-dd") + "'";
//delCommand.ExecuteNonQuery();
string name = QueryStr.wrapComma(iti.Name_);
string krcode = QueryStr.wrapComma(iti.KrCode_);
string yahoo_ticker = QueryStr.wrapComma(iti.Yahoo_ticker_);
string bloomberg_ticker = QueryStr.wrapComma(iti.Bloomberg_ticker_);
string kap_ticker = QueryStr.wrapComma(iti.Kap_ticker_);
string kis_ticker = QueryStr.wrapComma(iti.Kis_ticker_);
string datasource = QueryStr.wrapComma(iti.Datasource_);
string time_download = QueryStr.wrapComma(iti.Time_download_);
string index_type = QueryStr.wrapComma(iti.Index_type_);
command.CommandText = "DELETE FROM INDEX_TICKER_INFO WHERE NAME=" + name;
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO INDEX_TICKER_INFO (NAME,KRCODE,YAHOO_TICKER,BLOOMBERG_TICKER," +
"KAP_TICKER,KIS_TICKER,DATASOURCE,TIME_DOWNLOAD,INDEX_TYPE) " +
" VALUES (" + name + "," +
krcode + "," +
yahoo_ticker + "," +
bloomberg_ticker + "," +
kap_ticker + "," +
kis_ticker + "," +
datasource + "," +
time_download + "," +
index_type + ")";
command.ExecuteNonQuery();
connection.Close();
return(0);
}
catch (SqlCeException)
{
connection.Close();
OutputLogViewModel.addResult("DataBase Connection Error : DB Load");
return(1);
}
}
private void loadButton_Click(object sender, RoutedEventArgs e)
{
IndexTickerInfo item = this.definedIndexList_.SelectedItem as IndexTickerInfo;
IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item);
DateTime sd = new DateTime(2014, 1, 1);
DateTime ed = DateTime.Now;
QLNet.TimeSeries <string> series = ihmd.historySeries(sd, ed);
this.historyDataGrid_.ItemsSource = series;
}
public int historyDataDownload(IndexTickerInfo iti)
{
YahooMarketDataLoader ymdl = new YahooMarketDataLoader();
DateTime sDate = new DateTime(2014, 1, 1);
DateTime eDate = DateTime.Now;
ymdl.indexYahooTickerList_.Add(iti);
ymdl.loadHistoryData(sDate, eDate);
ymdl.dbInsertHistory();
return(0);
}
private void redownloadButton_Click(object sender, RoutedEventArgs e)
{
IndexTickerInfo selected_ITI = this.definedIndexList_.SelectedItem as IndexTickerInfo;
int result = this.viewModel_.historyDataDownload(selected_ITI);
if (result == 0)
{
MessageBoxResult msgBox = MessageBox.Show("redownload success!");
this.loadButton_Click(sender, e);
}
else
{
MessageBoxResult msgBox = MessageBox.Show("fail!");
}
}
private void editButton_Click(object sender, RoutedEventArgs e)
{
Window w = new Window();
w.Width = 500;
w.Height = 200;
IndexTickerInfoEditorView itiev = new IndexTickerInfoEditorView();
w.Content = itiev;
if (w.ShowDialog() == true)
{
this.selectedViewModel_ = itiev.ViewModel_;
this.indexSymbolTextBox_.Text = this.selectedViewModel_.Name_;
}
else
{
}
}
private void resultDataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
DataGridRow dgr = sender as DataGridRow;
if (dgr != null)
{
IndexTickerInfo iti = dgr.Item as IndexTickerInfo;
Excel_referenceInformationViewModel e_rivm = new Excel_referenceInformationViewModel();
//e_rivm.KrCode_ = iti.KrCode_;
//e_rivm.Name_ = iti.Name_;
e_rivm.EntityId_ = "testEntiti_id";
e_rivm.EntityName_ = "testEntiti_name";
//e_sivm.BasePrice_ = "testBasePrice";
this.selectedReferenceVM_ = e_rivm;
((Window)this.Parent).DialogResult = true;
((Window)this.Parent).Close();
}
}
private void ViewModelChanged(object sender, DependencyPropertyChangedEventArgs e)
{
this.viewModel_ = this.DataContext as IndexTickerInfo;
this.bindingPanel_.DataContext = this.viewModel_;
}
public IndexTickerInfoEditorView()
{
InitializeComponent();
this.DataContextChanged += new DependencyPropertyChangedEventHandler(ViewModelChanged);
this.viewModel_ = new IndexTickerInfo();
}
public int historyDataDownload(IndexTickerInfo iti)
{
YahooMarketDataLoader ymdl = new YahooMarketDataLoader();
DateTime sDate = new DateTime(2014, 1, 1);
DateTime eDate = DateTime.Now;
ymdl.indexYahooTickerList_.Add(iti);
ymdl.loadHistoryData(sDate, eDate);
ymdl.dbInsertHistory();
return 0;
}
public IndexTickerInfo loadDefinedIndex(string nameStr)
{
SqlCeConnection connection = new SqlCeConnection(this.connectionStr_);
try
{
SqlCeCommand command = connection.CreateCommand();
connection.Open();
string wrapName = QueryStr.wrapComma(nameStr);
command.CommandText = "SELECT * FROM INDEX_TICKER_INFO WHERE NAME=" + wrapName;
SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
DataTable tb = new DataTable();
dataAdapter.Fill(tb);
IndexTickerInfo loadITI = new IndexTickerInfo();
foreach (DataRow row in tb.Rows)
{
string name = row["NAME"].ToString();
string krcode = row["KRCODE"].ToString();
string yahoo_ticker = row["YAHOO_TICKER"].ToString();
string bloomberg_ticker = row["BLOOMBERG_TICKER"].ToString();
string kap_ticker = row["KAP_TICKER"].ToString();
string kis_ticker = row["KIS_TICKER"].ToString();
string datasource = row["DATASOURCE"].ToString();
string time_download = row["TIME_DOWNLOAD"].ToString();
string index_type = row["INDEX_TYPE"].ToString();
loadITI = new IndexTickerInfo(name, krcode, yahoo_ticker,
bloomberg_ticker,
kap_ticker,
kis_ticker,
datasource,
time_download,
index_type
);
}
connection.Close();
return loadITI;
}
catch (SqlCeException )
{
connection.Close();
OutputLogViewModel.addResult("DataBase Connection Error : DB Load");
throw;
}
}
public IndexTickerInfoEditorView()
{
InitializeComponent();
this.DataContextChanged += new DependencyPropertyChangedEventHandler(ViewModelChanged);
this.viewModel_ = new IndexTickerInfo();
}
private void IndexName_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Window w = new Window();
w.Width = 500;
w.Height = 200;
IndexTickerInfoEditorView itiev = new IndexTickerInfoEditorView();
// data load
IndexTickerInfo iti = this.definedIndexList_.SelectedItem as IndexTickerInfo;
itiev.ViewModel_ = this.viewModel_.loadDefinedIndex(iti.Name_);
w.Content = itiev;
if (w.ShowDialog() == true)
{
this.selectedViewModel_ = itiev.ViewModel_;
this.viewModel_.updateDefinedIndex(itiev.ViewModel_);
//this.indexSymbolTextBox_.Text = this.selectedViewModel_.Name_;
}
else
{
}
}
private void ViewModelChanged(object sender, DependencyPropertyChangedEventArgs e)
{
this.viewModel_ = this.DataContext as IndexTickerInfo;
this.bindingPanel_.DataContext = this.viewModel_;
}
private void editButton_Click(object sender, RoutedEventArgs e)
{
Window w = new Window();
w.Width = 500;
w.Height = 200;
IndexTickerInfoEditorView itiev = new IndexTickerInfoEditorView();
w.Content = itiev;
if (w.ShowDialog() == true)
{
this.selectedViewModel_ = itiev.ViewModel_;
this.indexSymbolTextBox_.Text = this.selectedViewModel_.Name_;
}
else
{
}
}
public int updateDefinedIndex(IndexTickerInfo iti)
{
SqlCeConnection connection = new SqlCeConnection(this.connectionStr_);
try
{
DataTable tb = new DataTable();
SqlCeCommand command = connection.CreateCommand();
connection.Open();
//delCommand.CommandText = "DELETE FROM CORRELATION WHERE DATE ='" + ReferenceDate_.ToString("yyyy-MM-dd") + "'";
//delCommand.ExecuteNonQuery();
string name = QueryStr.wrapComma(iti.Name_);
string krcode = QueryStr.wrapComma(iti.KrCode_);
string yahoo_ticker = QueryStr.wrapComma(iti.Yahoo_ticker_);
string bloomberg_ticker = QueryStr.wrapComma(iti.Bloomberg_ticker_);
string kap_ticker = QueryStr.wrapComma(iti.Kap_ticker_);
string kis_ticker = QueryStr.wrapComma(iti.Kis_ticker_);
string datasource = QueryStr.wrapComma(iti.Datasource_);
string time_download = QueryStr.wrapComma(iti.Time_download_);
string index_type = QueryStr.wrapComma(iti.Index_type_);
command.CommandText = "DELETE FROM INDEX_TICKER_INFO WHERE NAME=" + name;
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO INDEX_TICKER_INFO (NAME,KRCODE,YAHOO_TICKER,BLOOMBERG_TICKER," +
"KAP_TICKER,KIS_TICKER,DATASOURCE,TIME_DOWNLOAD,INDEX_TYPE) " +
" VALUES (" + name + "," +
krcode + "," +
yahoo_ticker + "," +
bloomberg_ticker + "," +
kap_ticker + "," +
kis_ticker + "," +
datasource + "," +
time_download + "," +
index_type + ")";
command.ExecuteNonQuery();
connection.Close();
return 0;
}
catch (SqlCeException )
{
connection.Close();
OutputLogViewModel.addResult("DataBase Connection Error : DB Load");
return 1;
}
}
