public bool DeleteMessage(long msgId)
{
ValidateInitialized();
IMQDeleteMessageParams paramsDelMsg = _mq.CreateDeleteMessageParams();
paramsDelMsg.MessageId = msgId;
var resDelMsg = _mq.DeleteMessage(paramsDelMsg);
return(resDelMsg.Success);
}
public IMQDeleteMessageResult DeleteMessage(IMQDeleteMessageParams paramsDelMessage)
{
var result = new DbMQDeleteMessageResult();
string spName = "[SP_Delete_Message]";
SqlConnection conn = OpenConnection("ConnectionString");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = schema + "." + spName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
try
{
SqlParameter paramMessageId = new SqlParameter("@IN_Message_Id",
SqlDbType.BigInt, 0,
ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current,
paramsDelMessage.MessageId);
cmd.Parameters.Add(paramMessageId);
cmd.ExecuteNonQuery();
result.Success = true;
}
catch (Exception ex)
{
result.Success = false;
result.Errors.Add(new Interfaces.Error()
{
Message = ex.Message,
Code = Interfaces.EErrorCodes.MQDbError,
Type = Interfaces.EErrorType.Error
});
}
conn.Close();
return(result);
}