public static SubscriptionModel[] GetSubscriptions(TicketModel ticket)
{
//query = $"SELECT Subscriptions.userid FROM Subscriptions WITH (NOLOCK) " +
// $"JOIN Users WITH (NOLOCK) on users.userid = Subscriptions.userid " +
// $"WHERE Reftype = 17 and Refid = {ticket.TicketID} and MarkDeleted = 0";
int[] subscriptionUserIDs = IDReader.Read(TicketChild.Subscriptions, ticket);
SubscriptionModel[] subscriptions = new SubscriptionModel[subscriptionUserIDs.Length];
for (int i = 0; i < subscriptionUserIDs.Length; ++i)
{
subscriptions[i] = new SubscriptionModel(ticket, new UserModel(ticket.Connection, subscriptionUserIDs[i]), false);
}
return(subscriptions);
}
public SubscriptionModel[] Subscriptions()
{
return(SubscriptionModel.GetSubscriptions(this));
}
