public Int32 UpdateStatus(AssociatedDocsDto pAssocDocsData)
{
//Note -- this procedure also inserts data
string updateSql = DBUtils.SCHEMA_NAME + "PKG_INBOUND$p_update_asso_status";
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_inb_id", System.Data.SqlDbType.Int).Value = pAssocDocsData.InboundDocsId;
cmd.Parameters.Add("@p_file_name", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.FileName);
cmd.Parameters.Add("@p_trade_id", System.Data.SqlDbType.Int).Value = pAssocDocsData.TradeId;
cmd.Parameters.Add("@p_status", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.DocStatusCode);
cmd.Parameters.Add("@p_cdty_grp_code", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.CdtyGroupCode);
cmd.Parameters.Add("@p_cpty_sn", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.CptySn);
cmd.Parameters.Add("@p_broker_sn", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.BrokerSn);
cmd.Parameters.Add("@p_rqmt_id", System.Data.SqlDbType.Int).Value = pAssocDocsData.TradeRqmtId;
cmd.Parameters.Add("@p_rqmt_status", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.RqmtStatus);
cmd.Parameters.Add("@p_rqmt_type", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.DocTypeCode);
cmd.Parameters.Add("@p_sec_check", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pAssocDocsData.SecValidateReqFlag);
cmd.Parameters.Add("@p_index_val", System.Data.SqlDbType.Int).Value = pAssocDocsData.IndexVal;
SqlParameter returnValue = new SqlParameter{ Direction = ParameterDirection.ReturnValue};
cmd.Parameters.Add(returnValue);
conn.Open();
cmd.ExecuteNonQuery();
return Convert.ToInt32(returnValue.Value);
}
}
return rowsUpdated;
}
