/// <summary>
/// Add New Process Request Argument
/// </summary>
public ResponseStatus Add()
{
ResponseStatus responseSuccessful = new ResponseStatus();
ResponseStatus responseError = new ResponseStatus(messageType: MessageType.Error);
// Check if request has already been added
//
if (ProcessRequestArguments.Exists(this.FKRequestUID, this.Code))
{
responseError.Message = "Request Argument already exists " + this.Code;
responseError.Contents = this;
return(responseError);
}
DateTime _now = DateTime.Today;
using (var connection = new SqlConnection(ConnString.ConnectionString))
{
var commandString =
(
"INSERT INTO [ProcessRequestArguments] " +
"( " +
FieldString() +
")" +
" VALUES " +
"( " +
" @" + FieldName.FKRequestUID +
", @" + FieldName.Code +
", @" + FieldName.ValueType +
", @" + FieldName.Value +
" )"
);
using (var command = new SqlCommand(
commandString, connection))
{
command.Parameters.Add("@FKRequestUID", SqlDbType.BigInt).Value = FKRequestUID;
command.Parameters.Add("@Code", SqlDbType.VarChar).Value = Code;
command.Parameters.Add("@ValueType", SqlDbType.VarChar).Value = ValueType;
command.Parameters.Add("@Value", SqlDbType.VarChar).Value = Value;
connection.Open();
command.ExecuteNonQuery();
}
}
return(responseSuccessful);
}
