public static bool SubscribeToItem(Core core, ItemKey itemKey)
{
if (core == null)
{
throw new NullCoreException();
}
core.Db.BeginTransaction();
SelectQuery query = Subscription.GetSelectQueryStub(core, typeof(Subscription));
query.AddCondition("subscription_item_id", itemKey.Id);
query.AddCondition("subscription_item_type_id", itemKey.TypeId);
query.AddCondition("user_id", core.LoggedInMemberId);
DataTable subscriptionDataTable = core.Db.Query(query);
if (subscriptionDataTable.Rows.Count == 0)
{
InsertQuery iQuery = new InsertQuery(typeof(Subscription));
iQuery.AddField("subscription_item_id", itemKey.Id);
iQuery.AddField("subscription_item_type_id", itemKey.TypeId);
iQuery.AddField("user_id", core.LoggedInMemberId);
iQuery.AddField("subscription_time_ut", UnixTime.UnixTimeStamp());
iQuery.AddField("subscription_ip", core.Session.IPAddress.ToString());
core.Db.Query(iQuery);
ItemInfo info = new ItemInfo(core, itemKey);
info.IncrementSubscribers();
UpdateQuery uQuery = new UpdateQuery(typeof(UserInfo));
uQuery.AddField("user_subscriptions", new QueryOperation("user_subscriptions", QueryOperations.Addition, 1));
uQuery.AddCondition("user_id", core.LoggedInMemberId);
core.Db.Query(uQuery);
return true;
}
else
{
throw new AlreadySubscribedException();
}
}
