/// <summary> /// Updates a record in the <c>NewsThread</c> table. /// </summary> /// <param name="value">The <see cref="NewsThreadRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(NewsThreadRow value) { string sqlStr = "UPDATE [dbo].[NewsThread] SET " + "[Title]=" + _db.CreateSqlParameterName("@Title") + ", " + "[Thread_isForcus]=" + _db.CreateSqlParameterName("@Thread_isForcus") + ", " + "[Thread_RT]=" + _db.CreateSqlParameterName("@Thread_RT") + ", " + "[Thread_Logo]=" + _db.CreateSqlParameterName("@Thread_Logo") + "," + "[Thread_RC]=" + _db.CreateSqlParameterName("@Thread_RC") + ", " + "[Status]=" + _db.CreateSqlParameterName("@Status") + " WHERE " + "[Thread_ID]=" + _db.CreateSqlParameterName("@Thread_ID"); IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "@Title", value.Title); AddParameter(cmd, "@Thread_isForcus", value.IsThread_isForcusNull ? DBNull.Value : (object)value.Thread_isForcus); AddParameter(cmd, "@Thread_RT", value.Thread_RT); AddParameter(cmd, "@Thread_Logo", value.Thread_Logo); AddParameter(cmd, "@Thread_ID", value.Thread_ID); AddParameter(cmd, "@Thread_RC", value.Thread_RC); AddParameter(cmd, "@Status", value.Status); return(0 != cmd.ExecuteNonQuery()); }
/// <summary> /// Deletes the specified object from the <c>NewsThread</c> table. /// </summary> /// <param name="value">The <see cref="NewsThreadRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(NewsThreadRow value) { return(DeleteByPrimaryKey(value.Thread_ID)); }