public List<InstPositionInfo> loadPositionData() { DataTable tb = new DataTable(); using (SqlCeConnection connection = new SqlCeConnection("Data Source=D:\\Project File\\OTCDerivativesCalculatorModule\\Project_CSharp\\RiskMonitor\\Data\\Data_Interface\\MarketDataBase.sdf")) using (SqlCeCommand command = connection.CreateCommand()) { command.CommandText = "SELECT KR_CODE , INST_NAME , INST_CODE , INST_TYPE , " + " BOOKED_DATE , UNBOOKED_DATE , MATURITY_DATE , " + " FILE_NAME , POSITION_NAME , COUNTERPARTY , " + " NOTIONAL , CURRENCY , FUND_CODE , FUND_NAME FROM POSITIONMASTER"; connection.Open(); SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection); dataAdapter.Fill(tb); } List<InstPositionInfo> positionList = new List<InstPositionInfo>(); DataLoader loader = new DataLoader(); DataRow[] resultRows = tb.Select(); foreach (DataRow item in resultRows) { InstPositionInfo instData = new InstPositionInfo(item["KR_CODE"].ToString(), item["INST_NAME"].ToString(), item["INST_CODE"].ToString(), item["INST_TYPE"].ToString(), item["BOOKED_DATE"].ToString(), item["UNBOOKED_DATE"].ToString(), item["MATURITY_DATE"].ToString(), item["FILE_NAME"].ToString(), item["POSITION_NAME"].ToString(), item["COUNTERPARTY"].ToString(), item["NOTIONAL"].ToString(), item["CURRENCY"].ToString(), item["FUND_CODE"].ToString(), item["FUND_NAME"].ToString() ); positionList.Add(instData); } return positionList; }
public List <InstPositionInfo> loadPositionData() { DataTable tb = new DataTable(); using (SqlCeConnection connection = new SqlCeConnection("Data Source=D:\\Project File\\OTCDerivativesCalculatorModule\\Project_CSharp\\RiskMonitor\\Data\\Data_Interface\\MarketDataBase.sdf")) using (SqlCeCommand command = connection.CreateCommand()) { command.CommandText = "SELECT KR_CODE , INST_NAME , INST_CODE , INST_TYPE , " + " BOOKED_DATE , UNBOOKED_DATE , MATURITY_DATE , " + " FILE_NAME , POSITION_NAME , COUNTERPARTY , " + " NOTIONAL , CURRENCY , FUND_CODE , FUND_NAME FROM POSITIONMASTER"; connection.Open(); SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection); dataAdapter.Fill(tb); } List <InstPositionInfo> positionList = new List <InstPositionInfo>(); DataLoader loader = new DataLoader(); DataRow[] resultRows = tb.Select(); foreach (DataRow item in resultRows) { InstPositionInfo instData = new InstPositionInfo(item["KR_CODE"].ToString(), item["INST_NAME"].ToString(), item["INST_CODE"].ToString(), item["INST_TYPE"].ToString(), item["BOOKED_DATE"].ToString(), item["UNBOOKED_DATE"].ToString(), item["MATURITY_DATE"].ToString(), item["FILE_NAME"].ToString(), item["POSITION_NAME"].ToString(), item["COUNTERPARTY"].ToString(), item["NOTIONAL"].ToString(), item["CURRENCY"].ToString(), item["FUND_CODE"].ToString(), item["FUND_NAME"].ToString() ); positionList.Add(instData); } return(positionList); }
public InstPositionWrapperVM(InstPositionInfo instData,InstrumentBaseViewModel instBaseVM) { this.InstBaseVM_ = instBaseVM; this.InstUri_ = instBaseVM.InstUri_; this.ResultUri_ = instBaseVM.ResultUri_; this.KRCode_= instData.KRCode_ ; this.InstName_ = instData.InstName_; this.InstCode_ = instData.InstCode_ ; this.InstType_ = instData.InstType_ ; this.CounterParty_ = instData.CounterParty_; this.BookedDate_ = instData.BookedDate_ ; this.UnBookedDate_ = instData.UnBookedDate_; this.MaturityDate_ = instData.MaturityDate_; this.Notional_ = instData.Notional_; }