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)); }