public void loadDBPosition(string position) { this.instPositionWrapperVMList_ = new ObservableCollection <InstPositionWrapperVM>(); RiskMonitor.PositionSingletonManger.setReferenceDate(this.ReferenceDate_); //db 만들어서 관리 해야함? ㅇㅇ 그래야함 ㅡ.ㅡㅋ instPositionWrapperVMList_.Clear(); DataBaseManager loader = new DataBaseManager(); loader.PositionHostInfo_ = new PositionHostInfo(position); List <InstPositionInfo> instDataList = loader.loadPositionData(); foreach (InstPositionInfo item in instDataList) { InstUriInfo instUri = PositionSingletonManger.CreateInstUriInfo(item.InstCode_, item.InstType_); //ResultUriInfo resultUri = CreateResultUriInfo(item.InstCode_, item.InstType_); //InstrumentBaseViewModel instBaseVM = InstrumentBaseViewModel.CreateInstBaseVM(instUri, resultUri); InstrumentBaseViewModel instBaseVM = InstrumentBaseViewModel.CreateInstBaseVM(instUri); instBaseVM.ReferenceDate_ = PositionSingletonManger.referenceDate(); InstPositionWrapperVM viewModel = new InstPositionWrapperVM(item, instBaseVM); instPositionWrapperVMList_.Add(viewModel); } }
public void loadDBPosition(string position) { this.instPositionWrapperVMList_ = new ObservableCollection<InstPositionWrapperVM>(); RiskMonitor.PositionSingletonManger.setReferenceDate(this.ReferenceDate_); //db 만들어서 관리 해야함? ㅇㅇ 그래야함 ㅡ.ㅡㅋ instPositionWrapperVMList_.Clear(); DataBaseManager loader = new DataBaseManager(); loader.PositionHostInfo_ = new PositionHostInfo(position); List<InstPositionInfo> instDataList = loader.loadPositionData(); foreach (InstPositionInfo item in instDataList) { InstUriInfo instUri = PositionSingletonManger.CreateInstUriInfo(item.InstCode_, item.InstType_); //ResultUriInfo resultUri = CreateResultUriInfo(item.InstCode_, item.InstType_); //InstrumentBaseViewModel instBaseVM = InstrumentBaseViewModel.CreateInstBaseVM(instUri, resultUri); InstrumentBaseViewModel instBaseVM = InstrumentBaseViewModel.CreateInstBaseVM(instUri); instBaseVM.ReferenceDate_ = PositionSingletonManger.referenceDate(); InstPositionWrapperVM viewModel = new InstPositionWrapperVM(item, instBaseVM); instPositionWrapperVMList_.Add(viewModel); } }
public bool addInstrument(InstrumentBaseViewModel instBaseVM) { if (!Loader_.hasInstDB(instBaseVM.ItemCode_)) { InstPositionWrapperVM wrapperVM = new InstPositionWrapperVM(instBaseVM); this.instPositionWrapperVMList_.Add(wrapperVM); // 중복 체크 Loader_.addInstDB(wrapperVM); return(true); } else { return(false); } }
private void addUnderFromPosition(InstPositionWrapperVM instPositionWrapperVM) { StandardInstBaseViewModel stand = instPositionWrapperVM.InstBaseVM_ as StandardInstBaseViewModel; UnderlyingViewModel underlyingVM = stand.InstrumentViewModel_.getUnderlying(); // inst에서 하던under 로 하던 나중에 결정하자으 bool pickFlag = this.underlyingPickerViewModel_.pickUnderlying(underlyingVM); if (pickFlag) { GreekUnderlyingResultWrapperViewModel greekWrapperVM = new GreekUnderlyingResultWrapperViewModel(underlyingVM); this.greekWrapperVMList_.Add(greekWrapperVM); } }
public bool addInstrument(InstrumentBaseViewModel instBaseVM) { if (!Loader_.hasInstDB(instBaseVM.ItemCode_)) { InstPositionWrapperVM wrapperVM = new InstPositionWrapperVM(instBaseVM); this.instPositionWrapperVMList_.Add(wrapperVM); // 중복 체크 Loader_.addInstDB(wrapperVM); return true; } else { return false; } }
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; } }