/
MemberQueue.cs
80 lines (65 loc) · 2.8 KB
/
MemberQueue.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Umbraco.Core.Events;
using Umbraco.Core.Models;
using Umbraco.Core.Services;
namespace ServiceBroker
{
public class MemberQueue
{
private SqlConnection connection;
public MemberQueue(SqlConnection queueConnection)
{
this.connection = queueConnection;
}
/// <summary>
/// Invoke dbo.[SendMemberWelcomePack]
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void MemberService_Created(IMemberService sender, NewEventArgs<IMember> e)
{
string Name = e.Entity.Name;
string Email = e.Entity.Email;
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
SqlTransaction tran = connection.BeginTransaction();
var command = new SqlCommand("dbo.[SendMemberWelcomePack]", connection, tran);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@name", SqlDbType.NVarChar, 256);
command.Parameters["@name"].Value = Name;
command.Parameters.Add("@email", SqlDbType.NVarChar, 256);
command.Parameters["@email"].Value = Email;
command.Parameters.Add("@ConversationHandle", SqlDbType.UniqueIdentifier);
command.Parameters["@ConversationHandle"].Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
tran.Commit();
}
/// <summary>
/// Creates a command to invoke dbo.[ReadFromMemberQueue].
/// </summary>
/// <param name="tran"></param>
/// <returns></returns>
public SqlCommand CreateReadCommand(SqlTransaction tran)
{
var command = new SqlCommand("dbo.[ReadFromMemberQueue]", connection, tran);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@message_type", SqlDbType.NVarChar, 256);
command.Parameters["@message_type"].Direction = ParameterDirection.Output;
command.Parameters.Add("@message_body", SqlDbType.Xml);
command.Parameters["@message_body"].Direction = ParameterDirection.Output;
command.Parameters.Add("@conversation_handle", SqlDbType.UniqueIdentifier);
command.Parameters["@conversation_handle"].Direction = ParameterDirection.Output;
command.Parameters.Add("@conversation_group_id", SqlDbType.UniqueIdentifier);
command.Parameters["@conversation_group_id"].Direction = ParameterDirection.Output;
return command;
}
}
}