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