private void ViewModelChanged(object sender, DependencyPropertyChangedEventArgs e) { this.InstExViewModel_ = this.DataContext as ExplorerBookInstViewModel; //ExplorerListView_.DataContext = InstExViewModel_; ExplorerListView_.ItemsSource = InstExViewModel_.InstHierarchyList_; OutputLogViewModel.addResult(new MessageOutput("ExplorerBookInstView : DataContext Changed")); }
public OutputLogView() { InitializeComponent(); OutputLogViewModel.initialize(); //밖에서 initialize함. // 미리 에러가 날수 있으므로.. //OutputLogViewModel.registerLogView(OutputAddTextBlock); //this.outputLogList_ = OutputLogViewModel.OutputList_; //this.OutputListView_.ItemsSource = this.OutputLogList_; this.OutputListView_.ItemsSource = OutputLogViewModel.OutputList_; //OutputLogViewModel.addResult("testError"); }
public ExplorerBookInstView(MainWindow mainWindow, BookInfoViewModel bookInfoVM) { InitializeComponent(); this.mainWindow_ = mainWindow; //InstExViewModel_ = new InstrumentExplorerViewModel(mainWindow,bookInfoVM); this.DataContextChanged += new DependencyPropertyChangedEventHandler(ViewModelChanged); //ExplorerListView_.Height = mainWindow.DocumentPane_.DockHeight.Value; OutputLogViewModel.addResult(new MessageOutput("Explore Load Complete")); }
public InstrumentExplorerViewCtrl(MainWindow mainWindow, BookInfoViewModel bookInfoVM) { InitializeComponent(); this.mainWindow_ = mainWindow; InstExViewModel_ = new InstrumentExplorerViewModel(mainWindow, bookInfoVM); ExplorerListView_.DataContext = InstExViewModel_; ExplorerListView_.ItemsSource = InstExViewModel_.InstHierarchyList_; //ExplorerListView_.Height = mainWindow.DocumentPane_.DockHeight.Value; OutputLogViewModel.addResult(new MessageOutput("Explore Load Complete")); }
public void setFromXml(System.Xml.XmlNode InstNode) { //DateTime referenceDate = CustomFunction.StrToDate(resultparaXml.SelectSingleNode("pricing/evaluationTime").InnerText); //string itemCode = resultparaXml.SelectSingleNode("pricing/itemCode").InnerText; //this.Result_.ReferenceDate_ = referenceDate; //this.Result_.ItemCode_ = itemCode; //XmlNode pricingNode = resultparaXml.SelectSingleNode("pricing"); //XmlNode resultparaNode = pricingNode.SelectSingleNode("pricingResult"); OutputLogViewModel.addResult(new ErrorOutput("", ItemCode_, "Result Calulation Not yet")); }
//load parameter & result public void loadParaResult() { XmlDocument instXml = new XmlDocument(); try { ParaResultXml_.Load(this.paraResultPath(this.ReferenceDate_)); this.loadParaResultFromXml(this.ParaResultXml_); } catch (Exception e) { string errStr = "Source : " + e.Source + "\n" + "Message : " + e.Message + "\n" + "Location : " + e.StackTrace; //MessageBoxResult result = MessageBox.Show( , "Exception"); OutputLogViewModel.addResult(errStr); throw; } }
private void ListView_MouseDoubleClick(object sender, MouseButtonEventArgs e) { //InstrumentHierarchyViewModel item = sender as InstrumentHierarchyViewModel; ExploreHirachyInstrumentVMWrapper item = ExplorerListView_.SelectedItem as ExploreHirachyInstrumentVMWrapper; if (item != null) { LayoutDocument layoutDoc = new LayoutDocument(); //int count = this.Parent.ChildrenCount; //LayoutDocumentPane pane = new LayoutDocumentPane(); Grid grid = new Grid(); grid.Children.Add(item.view()); layoutDoc.Content = grid; layoutDoc.Title = item.ItemCode_; mainWindow_.DocumentPane_.Children.Add(layoutDoc); OutputLogViewModel.addResult(new MessageOutput(item.ItemCode_ + " is loaded")); } //MainWindow.AddCtrlOnMainWindow(item.View_); }
public void loadData() { OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = DBConnSetting_.ConnectionStr; //DateTime referenceDate = Settings.evaluationDate(); DateTime referenceDate = ReferenceDate_; try { OdbcCommand sqlCommand = new OdbcCommand(); conn.Open(); // ------------------------------------------ Vol & Dividend -------------------------------------------- sqlCommand.CommandText = "select STD_DATE,STOCK_ID,OTHER_ID,CORR " + "from otc_td_mrelsstockcorr " + "where STD_DATE='" + referenceDate.ToString("yyyyMMdd") + "'"; OdbcDataAdapter dataAdapter = new OdbcDataAdapter(sqlCommand.CommandText, conn); DataTable tb = new DataTable(); dataAdapter.Fill(tb); using (SqlCeConnection connection = new SqlCeConnection("Data Source=D:\\Project File\\OTCDerivativesCalculatorModule\\Project_CSharp\\RiskMonitor\\Data\\MarketDataBase.sdf")) using (SqlCeCommand command = connection.CreateCommand()) { //command.CommandText = "INSERT INTO CORRELATION (DATE, CODE_A, NAME_A, CODE_B, NAME_B, CORR, TYPE, VENDOR, DESCRIPTION) " + // " VALUES (@pdate, @pcode_a, @pname_a ,@pcode_b, @pname_b, @pcorr, @ptype, @pvendor, @pdescription)" + // " WHERE DATE not in ( select DATE from CORRELATION where DATE='" + ReferenceDate_.ToString("yyyyMMdd") + "')"; connection.Open(); SqlCeCommand delCommand = connection.CreateCommand(); delCommand.CommandText = "DELETE FROM CORRELATION WHERE DATE ='" + ReferenceDate_.ToString("yyyyMMdd") + "'"; delCommand.ExecuteNonQuery(); command.CommandText = "INSERT INTO CORRELATION (DATE, CODE_A, NAME_A, CODE_B, NAME_B, CORR, TYPE, VENDOR, DESCRIPTION) " + " VALUES (@pdate, @pcode_a, @pname_a ,@pcode_b, @pname_b, @pcorr, @ptype, @pvendor, @pdescription)"; command.Parameters.Add("@pdate", SqlDbType.NVarChar); command.Parameters.Add("@pcode_a", SqlDbType.NVarChar); command.Parameters.Add("@pname_a", SqlDbType.NVarChar); command.Parameters.Add("@pcode_b", SqlDbType.NVarChar); command.Parameters.Add("@pname_b", SqlDbType.NVarChar); command.Parameters.Add("@pcorr", SqlDbType.NVarChar); command.Parameters.Add("@ptype", SqlDbType.NVarChar); command.Parameters.Add("@pvendor", SqlDbType.NVarChar); command.Parameters.Add("@pdescription", SqlDbType.NVarChar); //command.ExecuteNonQuery(); foreach (DataRow item in tb.Rows) { string code_a = item["STOCK_ID"].ToString(); string code_b = item["OTHER_ID"].ToString(); if (code_a != code_b) { command.Parameters["@pdate"].Value = item["STD_DATE"].ToString(); command.Parameters["@pcode_a"].Value = code_a; command.Parameters["@pname_a"].Value = "null"; command.Parameters["@pcode_b"].Value = code_b; command.Parameters["@pname_b"].Value = "null"; command.Parameters["@pcorr"].Value = item["CORR"].ToString(); command.Parameters["@ptype"].Value = "History"; command.Parameters["@pvendor"].Value = "MRO"; command.Parameters["@pdescription"].Value = "This is test"; command.ExecuteNonQuery(); } } } conn.Close(); } catch (OdbcException e) { conn.Close(); OutputLogViewModel.addResult("DataBase Connection Error : MRO DB Load"); throw; } }
private void ClearButton_Click(object sender, RoutedEventArgs e) { OutputLogViewModel.clear(); }
public void addInstDB(InstPositionWrapperVM wrapperVM) { SqlCeConnection connection = new SqlCeConnection("Data Source=D:\\Project File\\OTCDerivativesCalculatorModule\\Project_CSharp\\RiskMonitor\\Data\\Data_Interface\\MarketDataBase.sdf"); try { DataTable tb = new DataTable(); SqlCeCommand command = connection.CreateCommand(); connection.Open(); SqlCeCommand delCommand = connection.CreateCommand(); //delCommand.CommandText = "DELETE FROM CORRELATION WHERE DATE ='" + ReferenceDate_.ToString("yyyyMMdd") + "'"; //delCommand.ExecuteNonQuery(); string KR_CODE = QueryStr.wrapComma(wrapperVM.KRCode_); string INST_NAME = QueryStr.wrapComma(wrapperVM.InstName_); string INST_CODE = QueryStr.wrapComma(wrapperVM.InstCode_); string BOOKED_DATE = QueryStr.wrapComma(wrapperVM.BookedDate_); string UNBOOKED_DATE = QueryStr.wrapComma(wrapperVM.UnBookedDate_); string MATURITY_DATE = QueryStr.wrapComma(wrapperVM.MaturityDate_); string INST_TYPE = QueryStr.wrapComma(wrapperVM.InstType_); string FILE_NAME = QueryStr.wrapComma(wrapperVM.FileName_); string POSITION_NAME = QueryStr.wrapComma(wrapperVM.PositionName_); string COUNTERPARTY = QueryStr.wrapComma(wrapperVM.CounterParty_); string NOTIONAL = QueryStr.wrapComma(wrapperVM.Notional_); string CURRENCY = QueryStr.wrapComma(wrapperVM.Currency_); string FUND_CODE = QueryStr.wrapComma(wrapperVM.FundCode_); string FUND_NAME = QueryStr.wrapComma(wrapperVM.FundName_); command.CommandText = "INSERT INTO POSITIONMASTER (KR_CODE,INST_NAME,INST_CODE,BOOKED_DATE,UNBOOKED_DATE," + " MATURITY_DATE,INST_TYPE,FILE_NAME,POSITION_NAME,COUNTERPARTY," + " NOTIONAL,CURRENCY,FUND_CODE,FUND_NAME) " + " VALUES (" + KR_CODE + "," + INST_NAME + "," + INST_CODE + "," + BOOKED_DATE + "," + UNBOOKED_DATE + "," + MATURITY_DATE + "," + INST_TYPE + "," + FILE_NAME + "," + POSITION_NAME + "," + COUNTERPARTY + "," + NOTIONAL + "," + CURRENCY + "," + FUND_CODE + "," + FUND_NAME + ")"; //command.ExecuteNonQuery(); //command.Parameters.Add("@pdate", SqlDbType.NVarChar); //command.Parameters.Add("@pcode_a", SqlDbType.NVarChar); //command.Parameters.Add("@pname_a", SqlDbType.NVarChar); //command.Parameters.Add("@pcode_b", SqlDbType.NVarChar); //command.Parameters.Add("@pname_b", SqlDbType.NVarChar); //command.Parameters.Add("@pcorr", SqlDbType.NVarChar); //command.Parameters.Add("@ptype", SqlDbType.NVarChar); //command.Parameters.Add("@pvendor", SqlDbType.NVarChar); //command.Parameters.Add("@pdescription", SqlDbType.NVarChar); //foreach (DataRow item in tb.Rows) //{ // string code_a = item["STOCK_ID"].ToString(); // string code_b = item["OTHER_ID"].ToString(); // if (code_a != code_b) // { // command.Parameters["@pdate"].Value = item["STD_DATE"].ToString(); // command.Parameters["@pcode_a"].Value = code_a; // command.Parameters["@pname_a"].Value = "null"; // command.Parameters["@pcode_b"].Value = code_b; // command.Parameters["@pname_b"].Value = "null"; // command.Parameters["@pcorr"].Value = item["CORR"].ToString(); // command.Parameters["@ptype"].Value = "History"; // command.Parameters["@pvendor"].Value = "MRO"; // command.Parameters["@pdescription"].Value = "This is test"; // command.ExecuteNonQuery(); // } //} command.ExecuteNonQuery(); connection.Close(); } catch (SqlCeException e) { connection.Close(); OutputLogViewModel.addResult("DataBase Connection Error : MRO DB Load"); throw; } }
public void addInstDB(string tableName, List <string> fieldName, List <string> fieldValue) { // error fieldName Count != fieldValue; // table의 columnNum 와 filedNameCount 는 같아야함 int fieldNameNum = fieldName.Count; SqlCeConnection connection = new SqlCeConnection(@"Data Source=D:\Project File\OTCDerivativesCalculatorModule\ExcelOTCManagerAddIn\PositionMasterInformationDB.sdf"); List <string> wrappingFieldValue = new List <string>(); foreach (var item in fieldValue) { wrappingFieldValue.Add(QueryStr.wrapComma(item)); } try { StringBuilder sb = new StringBuilder(); DataTable tb = new DataTable(); SqlCeCommand command = connection.CreateCommand(); connection.Open(); SqlCeCommand delCommand = connection.CreateCommand(); sb.Append("INSERT INTO " + tableName + " ( "); for (int i = 0; i < fieldNameNum; i++) { sb.Append(fieldName[i]); if (i != fieldNameNum - 1) { sb.Append(", "); } } sb.Append(") "); sb.Append("VALUES ("); for (int i = 0; i < fieldNameNum; i++) { sb.Append(wrappingFieldValue[i]); if (i != fieldNameNum - 1) { sb.Append(", "); } } sb.Append(") "); command.CommandText = sb.ToString(); command.ExecuteNonQuery(); connection.Close(); } catch (SqlCeException e) { connection.Close(); OutputLogViewModel.addResult("DataBase Connection Error : MRO DB Load"); throw; } }