public Int32 Update(TradeRqmtConfirm pData) { string updateSql = DBUtils.SCHEMA_NAME + "PKG_RQMT_CONFIRM$p_update_rqmt_confirm"; Int32 rowsUpdated = 0; using (SqlConnection conn = new SqlConnection(sqlConnStr)) { using (SqlCommand cmd = new SqlCommand(updateSql, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@p_id", System.Data.SqlDbType.Int).Value = pData.Id; cmd.Parameters.Add("@p_rqmt_id", System.Data.SqlDbType.Int).Value = pData.RqmtId; cmd.Parameters.Add("@p_trade_id", System.Data.SqlDbType.Int).Value = pData.TradeId; cmd.Parameters.Add("@p_template_name", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.TemplateName); cmd.Parameters.Add("@p_confirm_cmt", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmCmt); cmd.Parameters.Add("@p_fax_telex_ind", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexInd); cmd.Parameters.Add("@p_fax_telex_number", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexNumber); cmd.Parameters.Add("@p_confirm_label", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmLabel); cmd.Parameters.Add("@p_next_status_code", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.NextStatusCode); cmd.Parameters.Add("@p_active_flag", System.Data.SqlDbType.VarChar).Value = pData.ActiveFlag; conn.Open(); rowsUpdated = cmd.ExecuteNonQuery(); } } return(rowsUpdated); }
public void OnMessage(IMessage message) { object data = CreateDataObject(message); bool isPermKeyOk = false; //Israel 11/20/2015 -- Added support for permission keys. if (message.NMSType.ToUpper() == "SUMMARY") { SummaryData summaryData = data as SummaryData; isPermKeyOk = (String.IsNullOrEmpty(summaryData.PermissionKey)) || (v_PermKeyList.IndexOf(summaryData.PermissionKey) > -1); if (isPermKeyOk || v_IsSuperUser) { callback.Invoke(this, data); } } //Israel 12/16/2015 -- Message publisher was escaping the : character-- this removes it. else if (message.NMSType.ToUpper() == "CONFIRM") { TradeRqmtConfirm confirmData = data as TradeRqmtConfirm; if (!String.IsNullOrEmpty(confirmData.XmitAddr)) { confirmData.XmitAddr = confirmData.XmitAddr.Replace(@"\", ""); } callback.Invoke(this, data); } else { callback.Invoke(this, data); } message.Acknowledge(); //string testMessage = DateTime.Now.ToShortDateString() + ":" + DateTime.Now.ToLongTimeString() + ": " + message.ToString(); //File.AppendAllText(@"_MessageDump.txt", testMessage + Environment.NewLine); }
private void CopyDataToBeUpdated() { sumDataCacheCopy.Clear(); rqmtDataCacheCopy.Clear(); assDocDataCacheCopy.Clear(); inbDocViewCacheCopy.Clear(); tradeRqmtConfirmCacheCopy.Clear(); foreach (SummaryData data in sumDataCache) { SummaryData copyData = new SummaryData(); copyData = data; sumDataCacheCopy.Add(copyData); } foreach (RqmtData data in rqmtDataCache) { RqmtData copyData = new RqmtData(); copyData = data; rqmtDataCacheCopy.Add(copyData); } foreach (AssociatedDoc data in assDocDataCache) { AssociatedDoc copyData = new AssociatedDoc(); copyData = data; assDocDataCacheCopy.Add(copyData); } foreach (InboundDocsView data in inbDocViewCache) { InboundDocsView copyData = new InboundDocsView(); copyData = data; inbDocViewCacheCopy.Add(copyData); } foreach (TradeRqmtConfirm data in tradeRqmtConfirmCache) { TradeRqmtConfirm copyData = new TradeRqmtConfirm(); copyData = data; tradeRqmtConfirmCacheCopy.Add(copyData); } }
public Int32 Insert(TradeRqmtConfirm pData) { string updateSql = DBUtils.SCHEMA_NAME + "PKG_RQMT_CONFIRM$p_insert_rqmt_confirm"; Int32 rowsInserted = 0; Int32 seqNo = 0; string seqName = "SEQ_TRADE_RQMT_CONFIRM"; seqNo = DBUtils.GetNextSequence(sqlConnStr, seqName); using (SqlConnection conn = new SqlConnection(sqlConnStr)) { using (SqlCommand cmd = new SqlCommand(updateSql, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@p_id", System.Data.SqlDbType.Int).Value = seqNo; cmd.Parameters.Add("@p_rqmt_id", System.Data.SqlDbType.Int).Value = pData.RqmtId; cmd.Parameters.Add("@p_trade_id", System.Data.SqlDbType.Int).Value = pData.TradeId; cmd.Parameters.Add("@p_template_name", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.TemplateName); cmd.Parameters.Add("@p_confirm_cmt", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmCmt); cmd.Parameters.Add("@p_fax_telex_ind", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexInd); cmd.Parameters.Add("@p_fax_telex_number", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexNumber); cmd.Parameters.Add("@p_confirm_label", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmLabel); cmd.Parameters.Add("@p_next_status_code", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.NextStatusCode); conn.Open(); rowsInserted = cmd.ExecuteNonQuery(); } } if (rowsInserted == 0) { return(rowsInserted); } else { return(seqNo); } }