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_;
}
