private int CallInsertVaultRequest(string destination,
TransmitDestinationType type,
string userName,
Action<SqlCommand> setParametersAction)
{
var methodIndicator = GetMethodIndicator(type);
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
using (var cmd =
new SqlCommand(string.Format("{0}P_INSERT_XMIT_REQUEST", DBUtils.SCHEMA_NAME), conn))
{
setParametersAction(cmd);
cmd.Parameters.AddWithValue("@p_xmit_method_ind", methodIndicator);
cmd.Parameters.AddWithValue("@p_xmit_dest", destination);
cmd.Parameters.AddWithValue("@p_sent_by_user", userName);
cmd.CommandType = CommandType.StoredProcedure;
var ret = cmd.ExecuteScalar();
return (int) ret;
}
}
}
private int CallInsertVaultRequest(string destination,
TransmitDestinationType type,
string userName,
Action <SqlCommand> setParametersAction)
{
var methodIndicator = GetMethodIndicator(type);
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
using (var cmd =
new SqlCommand(string.Format("{0}P_INSERT_XMIT_REQUEST", DBUtils.SCHEMA_NAME), conn))
{
setParametersAction(cmd);
cmd.Parameters.AddWithValue("@p_xmit_method_ind", methodIndicator);
cmd.Parameters.AddWithValue("@p_xmit_dest", destination);
cmd.Parameters.AddWithValue("@p_sent_by_user", userName);
cmd.CommandType = CommandType.StoredProcedure;
var ret = cmd.ExecuteScalar();
return((int)ret);
}
}
}
private static string GetMethodIndicator(TransmitDestinationType type)
{
return(type.ToString().Substring(0, 1));
}
public int SaveTradeRqmtConfirmXmitRequest(int id, TransmitDestinationType destinationType, string destination,
string userName)
{
return(CallInsertVaultRequest(destination, destinationType, userName,
cmd => { cmd.Parameters.AddWithValue("@p_trade_rqmt_confirm_id", id); }));
}
public int SaveAssociatedDocumentXmitRequest(int id, TransmitDestinationType destinationType, string destination,
string userName)
{
return(CallInsertVaultRequest(destination, destinationType, userName,
cmd => { cmd.Parameters.AddWithValue("@p_associated_docs_id", id); }));
}
public TransmitDestination(TransmitDestinationType type, string value)
{
Type = type;
Value = value;
Validate();
}
private static string GetMethodIndicator(TransmitDestinationType type)
{
return type.ToString().Substring(0, 1);
}
public int SaveTradeRqmtConfirmXmitRequest(int id, TransmitDestinationType destinationType, string destination,
string userName)
{
return CallInsertVaultRequest(destination, destinationType, userName,
cmd => { cmd.Parameters.AddWithValue("@p_trade_rqmt_confirm_id", id); });
}
public int SaveAssociatedDocumentXmitRequest(int id, TransmitDestinationType destinationType, string destination,
string userName)
{
return CallInsertVaultRequest(destination, destinationType, userName,
cmd => { cmd.Parameters.AddWithValue("@p_associated_docs_id", id); });
}
public TransmitDestination(TransmitDestinationType type, string value)
{
Type = type;
Value = value;
Validate();
}
