public string save(string curveCode, DateTime refDate, string venderName = "local")
{
try
{
//Excel_irCurveLoaderViewModel e_irCurveLoader = new Excel_irCurveLoaderViewModel();
//e_irCurveLoader.loadDefinedSymbolFromDB();
//e_irCurveLoader.
CURVE_DATA_Table_DAO dao = new CURVE_DATA_Table_DAO();
dao.CURVE_DATE_ = StringConverter.dbDateTimeToDateString(refDate);
dao.CURVE_CODE_ = curveCode;
foreach (var item in this.Excel_yieldCurveViewModel_.Excel_rateDataViewModel_)
{
dao.TENOR_ = item.Tenor_;
dao.VALUE_ = item.Value_;
dao.CURVE_TYPE_ = item.RateType_;
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
return("save complete");
}
catch (Exception e)
{
return("save fail : " + e.Message + " , " + e.Source);
}
}
public string remove_Curve(string curveCode, string venderName = "local")
{
try
{
CURVE_DATA_Table_DAO dao = new CURVE_DATA_Table_DAO();
dao.CURVE_CODE_ = curveCode;
dao.deleteCode(DataBaseConnectManager.ConnectionFactory("myDB"));
return("delete complete");
}
catch (Exception e)
{
return("delete fail : " + e.Message + " , " + e.Source);
}
}
private void treeViewTestBtn_Click(object sender, RoutedEventArgs e)
{
//System.GC.Collect();
DataBaseConnectManager.DBConnection_
= DataBaseConnectManager.ConnectionFactory(EnvironmentVariable.MarketDataDBFile_);
//EVENT_INFO_Table_DAOManager d = new EVENT_INFO_Table_DAOManager();
//d.delete(DataBaseConnectManager.DBConnection_);
ProgramVariable.initialize_CurrencyStringList();
RootBookViewModel.setRootBookReferenceDate(DateTime.Now);
BookFolderView bfv = new BookFolderView();
bfv.ReferenceDate_ = this.loadLastPositionDate();
bfv.positionXmlReload();
//RootBookViewModel root_bvm = new RootBookViewModel();
//root_bvm.loadPosition();
//RootFavoriteViewModel root_fvm = new RootFavoriteViewModel();
//root_fvm.loadPosition();
//bfv.RootBookViewModel_ = root_bvm;
//bfv.RootFavoriteViewModel_ = root_fvm;
Window w = new Window();
w.Width = 600;
w.Height = 400;
w.Content = bfv;
w.Visibility = 0;
}
