public int Add(SubscriptionInfo subscription) { string strSql = "INSERT INTO " + Config.ForumTablePrefix + "SUBSCRIPTIONS " + "(MEMBER_ID,CAT_ID,TOPIC_ID,FORUM_ID) VALUES (@MemberId,@CatId,@TopicId,@ForumId)"; List<SqlParameter> parms = new List<SqlParameter> { new SqlParameter("@MemberId", SqlDbType.Int) {Value = subscription.MemberId}, new SqlParameter("@CatId", SqlDbType.Int) {Value = subscription.CategoryId}, new SqlParameter("@TopicId", SqlDbType.Int) {Value = subscription.TopicId}, new SqlParameter("@ForumId", SqlDbType.Int) {Value = subscription.ForumId} }; return SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray()); }
public static void RemoveCategorySubscription(SubscriptionInfo subscription) { ISubscription dal = Factory<ISubscription>.Create("Subscription"); dal.Delete(subscription.Id); }