/// <summary> /// Adds the user subscription. /// </summary> /// <param name="userId">The user id.</param> /// <param name="placeTagId">The place tag id.</param> /// <returns>True if it was OK, false otherwise</returns> public bool AddUserSubscription(long userId, long placeTagId) { place_tag_users_subscription subscription = new place_tag_users_subscription(); try { subscription.user_id = userId; subscription.place_tag_id = placeTagId; data.place_tag_users_subscriptions.InsertOnSubmit(subscription); data.SubmitChanges(); return(true); } catch { return(false); } }
/// <summary> /// Deletes the user subscription. /// </summary> /// <param name="userId">The user id.</param> /// <param name="placeTagId">The place tag id.</param> /// <returns>True if it was OK, false otherwise</returns> public bool DeleteUserSubscription(long userId, long placeTagId) { var query = from subscriptions in data.place_tag_users_subscriptions where subscriptions.user_id == userId where subscriptions.place_tag_id == placeTagId select subscriptions; try { place_tag_users_subscription subscriptionToDelete = query.First <place_tag_users_subscription>(); data.place_tag_users_subscriptions.DeleteOnSubmit(subscriptionToDelete); data.SubmitChanges(); return(true); } catch { return(false); } }