public List <SummaryData> GetAllSelectedTrades(string pTrdSysCode, string pSeCptySn, string pCptySn, string pCdtyCode,
DateTime pBeginTradeDt, DateTime pEndTradeDt, string pTrdSysTicket, string pCptyTradeId, string pPermissionKeyInClause)
{
const string SELECT_OBJECT = "*";
var result = new List <SummaryData>();
Int32 tradeId = 0;
string sql = GetAllTradeSummarySqlCommandStr(pTrdSysCode, pSeCptySn, pCptySn, pCdtyCode,
pBeginTradeDt, pEndTradeDt, pTrdSysTicket, pCptyTradeId, SELECT_OBJECT);
if (pPermissionKeyInClause != "")
{
//Israel 11/20/2015 -- Added support for Null permission key
//sql += " and " + pPermissionKeyInClause;
sql += " and " + "( " + pPermissionKeyInClause + " or PERMISSION_KEY is null )";
}
using (SqlConnection conn = new SqlConnection(sqlConnStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.Text;
conn.Open();
using (SqlDataReader dataReader = cmd.ExecuteReader())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
result.Add(new SummaryData
{
AdditionalConfirmSent = dataReader["ADDITIONAL_CONFIRM_SENT"].ToString(),
AnalystName = dataReader["ANALYST_NAME"].ToString(),
ArchiveFlag = dataReader["ARCHIVE_FLAG"].ToString(),
BookingCoId = DBUtils.HandleInt32IfNull(dataReader["BOOKING_CO_ID"].ToString()),
BookingCoSn = dataReader["BOOKING_CO_SN"].ToString(),
//BookingCoSn = dataReader["SE_CPTY_SN"].ToString(),
BkrDbUpd = DBUtils.HandleInt32IfNull(dataReader["BKR_DB_UPD"].ToString()),
BkrMeth = dataReader["BKR_METH"].ToString(),
BkrRqmt = dataReader["BKR_RQMT"].ToString(),
BkrStatus = dataReader["BKR_STATUS"].ToString(),
Book = dataReader["BOOK"].ToString(),
BrokerId = DBUtils.HandleInt32IfNull(dataReader["BROKER_ID"].ToString()),
BrokerLegalName = dataReader["BROKER_LEGAL_NAME"].ToString(),
BrokerPrice = dataReader["BROKER_PRICE"].ToString(),
BrokerSn = dataReader["BROKER_SN"].ToString(),
BuySellInd = dataReader["BUY_SELL_IND"].ToString(),
CdtyCode = dataReader["CDTY_CODE"].ToString(),
CdtyGrpCode = dataReader["CDTY_GRP_CODE"].ToString(),
Cmt = dataReader["CMT"].ToString(),
//Comm = dataReader["COMM"].ToString(),
CptyDbUpd = DBUtils.HandleInt32IfNull(dataReader["CPTY_DB_UPD"].ToString()),
CptyId = DBUtils.HandleInt32IfNull(dataReader["CPTY_ID"].ToString()),
CptyLegalName = dataReader["CPTY_LEGAL_NAME"].ToString(),
//CptyLn = dataReader["CPTY_LN"].ToString(),
CptyMeth = dataReader["CPTY_METH"].ToString(),
CptyRqmt = dataReader["CPTY_RQMT"].ToString(),
CptySn = dataReader["CPTY_SN"].ToString(),
CptyStatus = dataReader["CPTY_STATUS"].ToString(),
CptyTradeId = dataReader["CPTY_TRADE_ID"].ToString(),
CurrentBusnDt = DBUtils.HandleDateTimeIfNull(dataReader["CURRENT_BUSN_DT"].ToString()),
//EfsCptySn = dataReader["EFS_CPTY_SN"].ToString(),
//EfsFlag = dataReader["EFS_FLAG"].ToString(),
EndDt = DBUtils.HandleDateTimeIfNull(dataReader["END_DT"].ToString()),
FinalApprovalFlag = dataReader["FINAL_APPROVAL_FLAG"].ToString(),
FinalApprovalTimestampGmt = DBUtils.HandleDateTimeIfNull(dataReader["FINAL_APPROVAL_TIMESTAMP_GMT"].ToString()),
GroupXref = dataReader["GROUP_XREF"].ToString(),
HasProblemFlag = dataReader["HAS_PROBLEM_FLAG"].ToString(),
Id = DBUtils.HandleInt32IfNull(dataReader["ID"].ToString()),
InceptionDt = DBUtils.HandleDateTimeIfNull(dataReader["INCEPTION_DT"].ToString()),
IsTestBook = dataReader["IS_TEST_BOOK"].ToString(),
LastTrdEditTimestampGmt = DBUtils.HandleDateTimeIfNull(dataReader["LAST_TRD_EDIT_TIMESTAMP_GMT"].ToString()),
LastUpdateTimestampGmt = DBUtils.HandleDateTimeIfNull(dataReader["LAST_UPDATE_TIMESTAMP_GMT"].ToString()),
LocationSn = dataReader["LOCATION_SN"].ToString(),
MigrateInd = dataReader["MIGRATE_IND"].ToString(),
NoconfDbUpd = DBUtils.HandleInt32IfNull(dataReader["NOCONF_DB_UPD"].ToString()),
NoconfMeth = dataReader["NOCONF_METH"].ToString(),
NoconfRqmt = dataReader["NOCONF_RQMT"].ToString(),
NoconfStatus = dataReader["NOCONF_STATUS"].ToString(),
OpsDetActFlag = dataReader["OPS_DET_ACT_FLAG"].ToString(),
OptnPremPrice = dataReader["OPTN_PREM_PRICE"].ToString(),
OptnPutCallInd = dataReader["OPTN_PUT_CALL_IND"].ToString(),
OptnStrikePrice = dataReader["OPTN_STRIKE_PRICE"].ToString(),
//PayPrice = dataReader["PAY_PRICE"].ToString(),
PermissionKey = dataReader["PERMISSION_KEY"].ToString(),
PlAmt = dataReader["PL_AMT"].ToString(),
PriceDesc = dataReader["PRICE_DESC"].ToString(),
Priority = dataReader["PRIORITY"].ToString(),
//Qty = DBUtils.HandleFloatIfNull(dataReader["QTY"].ToString()),
QuantityDescription = dataReader["QTY_DESC"].ToString(),
QtyTot = DBUtils.HandleFloatIfNull(dataReader["QTY_TOT"].ToString()),
ReadyForFinalApprovalFlag = dataReader["READY_FOR_FINAL_APPROVAL_FLAG"].ToString(),
//RecPrice = dataReader["REC_PRICE"].ToString(),
RecentInd = DBUtils.HandleInt32IfNull(dataReader["RECENT_IND"].ToString()),
RefSn = dataReader["REF_SN"].ToString(),
RplyRdyToSndFlag = dataReader["RPLY_RDY_TO_SND_FLAG"].ToString(),
//SeCptySn = dataReader["SE_CPTY_SN"].ToString(),
SetcDbUpd = DBUtils.HandleInt32IfNull(dataReader["SETC_DB_UPD"].ToString()),
SetcMeth = dataReader["SETC_METH"].ToString(),
SetcRqmt = dataReader["SETC_RQMT"].ToString(),
SetcStatus = dataReader["SETC_STATUS"].ToString(),
StartDt = DBUtils.HandleDateTimeIfNull(dataReader["START_DT"].ToString()),
SttlType = dataReader["STTL_TYPE"].ToString(),
TradeDesc = dataReader["TRADE_DESC"].ToString(),
TradeDt = DBUtils.HandleDateTimeIfNull(dataReader["TRADE_DT"].ToString()),
TradeId = DBUtils.HandleInt32IfNull(dataReader["TRADE_ID"].ToString()),
Trader = dataReader["TRADER"].ToString(),
TradeStatCode = dataReader["TRADE_STAT_CODE"].ToString(),
TradeTypeCode = dataReader["TRADE_TYPE_CODE"].ToString(),
TransactionSeq = DBUtils.HandleInt32IfNull(dataReader["TRANSACTION_SEQ"].ToString()),
TransportDesc = dataReader["TRANSPORT_DESC"].ToString(),
TrdSysCode = dataReader["TRD_SYS_CODE"].ToString(),
TradeSysTicket = dataReader["TRD_SYS_TICKET"].ToString(),
//UomDurCode = dataReader["UOM_DUR_CODE"].ToString(),
VerblDbUpd = DBUtils.HandleInt32IfNull(dataReader["VERBL_DB_UPD"].ToString()),
VerblMeth = dataReader["VERBL_METH"].ToString(),
VerblRqmt = dataReader["VERBL_RQMT"].ToString(),
VerblStatus = dataReader["VERBL_STATUS"].ToString(),
Version = DBUtils.HandleInt32IfNull(dataReader["VERSION"].ToString()),
Xref = dataReader["XREF"].ToString()
});
}
}
}
}
}
return(result);
}
public List <TradeDataChgDto> GetTradeDataChg(Int32 pTradeId)
{
var result = new List <TradeDataChgDto>();
string sql = "select jn_datetime, trade_id, buy_sell_ind, trade_dt, booking_co_sn, cpty_sn, " +
"broker_sn, trade_desc, price_desc, trade_stat_code, location_sn, qty_desc, " +
"qty_tot, trade_type_code, cdty_code, sttl_type, book, transport_desc, cpty_legal_name, " +
"broker_legal_name, broker_price, trader, cdty_grp_code, start_dt, end_dt, xref, " +
"ref_sn, inception_dt, optn_put_call_ind, optn_prem_price, optn_strike_price, " +
"profit_center, permission_key " +
" from " + DBUtils.SCHEMA_NAME + "trade_data_jn " +
" where trade_id = @trade_id " +
" order by jn_datetime ";
using (SqlConnection conn = new SqlConnection(sqlConnStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@trade_id", System.Data.SqlDbType.Int).Value = pTradeId;
conn.Open();
using (SqlDataReader dataReader = cmd.ExecuteReader())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
result.Add(new TradeDataChgDto
{
Book = dataReader["book"].ToString(),
BookingCoSn = dataReader["booking_co_sn"].ToString(),
BrokerLegalName = dataReader["broker_legal_name"].ToString(),
BrokerPrice = dataReader["broker_price"].ToString(),
BrokerSn = dataReader["broker_sn"].ToString(),
BuySellInd = dataReader["buy_sell_ind"].ToString(),
CdtyCode = dataReader["cdty_code"].ToString(),
CdtyGrpCode = dataReader["cdty_grp_code"].ToString(),
CptyLegalName = dataReader["cpty_legal_name"].ToString(),
CptySn = dataReader["cpty_sn"].ToString(),
EndDt = DBUtils.HandleDateTimeIfNull(dataReader["end_dt"].ToString()),
InceptionDt = DBUtils.HandleDateTimeIfNull(dataReader["inception_dt"].ToString()),
JnDatetime = DBUtils.HandleDateTimeIfNull(dataReader["jn_datetime"].ToString()),
LocationSn = dataReader["location_sn"].ToString(),
OptnPremPrice = dataReader["optn_prem_price"].ToString(),
OptnPutCallInd = dataReader["optn_put_call_ind"].ToString(),
OptnStrikePrice = dataReader["optn_strike_price"].ToString(),
PermissionKey = dataReader["permission_key"].ToString(),
PriceDesc = dataReader["price_desc"].ToString(),
ProfitCenter = dataReader["profit_center"].ToString(),
QtyDesc = dataReader["qty_desc"].ToString(),
QtyTot = DBUtils.HandleFloatIfNull(dataReader["qty_tot"].ToString()),
RefSn = dataReader["ref_sn"].ToString(),
StartDt = DBUtils.HandleDateTimeIfNull(dataReader["start_dt"].ToString()),
SttlType = dataReader["sttl_type"].ToString(),
TradeDesc = dataReader["trade_desc"].ToString(),
TradeDt = DBUtils.HandleDateTimeIfNull(dataReader["trade_dt"].ToString()),
TradeId = DBUtils.HandleInt32IfNull(dataReader["trade_id"].ToString()),
TradeStatCode = dataReader["trade_stat_code"].ToString(),
TradeTypeCode = dataReader["trade_type_code"].ToString(),
Trader = dataReader["trader"].ToString(),
TransportDesc = dataReader["transport_desc"].ToString(),
Xref = dataReader["xref"].ToString()
});
}
}
}
}
}
return(result);
}
