public void UpdateItem(SharedSnippetItemData data) { if (data == null) { throw new NullParameterException("Item data is null!"); } if (ConnParams == null) { throw new NullPropertyException("Connection parameters is null!"); } using (SqlConnection conn = new SqlConnection(_connParams.ConnectionString)) { string cmdText = "exec spPragmaSQL_CodeSnippet_Update @SnippetID, @ParentID, @Name, @Snippet, @Description, @UpdatedBy"; SqlCommand cmd = new SqlCommand(cmdText, conn); cmd.CommandTimeout = 0; AddParam(cmd, "@SnippetID", SqlDbType.Int, data.ID); AddParam(cmd, "@ParentID", SqlDbType.Int, data.ParentID); AddParam(cmd, "@Name", SqlDbType.VarChar, data.Name); AddParam(cmd, "@Snippet", SqlDbType.Text, data.Snippet); AddParam(cmd, "@Description", SqlDbType.Text, data.Description); AddParam(cmd, "@UpdatedBy", SqlDbType.VarChar, _connParams.CurrentUsername); conn.Open(); cmd.ExecuteNonQuery(); if (_canSynchronize) { SharedSnippetProvider.SynchronizationActionUpdate(data); } } }
public void AddItem(SharedSnippetItemData data) { if (ConnParams == null) { throw new NullPropertyException("Connection parameters is null!"); } if (data == null) { throw new NullParameterException("Item data is null!"); } using (SqlConnection conn = new SqlConnection(_connParams.ConnectionString)) { string cmdText = "exec spPragmaSQL_CodeSnippet_Insert @Type, @ParentID, @Name, @Snippet, @Description, @CreatedBy, @SnippetID out"; SqlCommand cmd = new SqlCommand(cmdText, conn); cmd.CommandTimeout = 0; AddParam(cmd, "@Type", SqlDbType.Int, data.Type); AddParam(cmd, "@ParentID", SqlDbType.Int, data.ParentID); AddParam(cmd, "@Name", SqlDbType.VarChar, data.Name); AddParam(cmd, "@Snippet", SqlDbType.Text, data.Snippet); AddParam(cmd, "@Description", SqlDbType.Text, data.Description); AddParam(cmd, "@CreatedBy", SqlDbType.VarChar, _connParams.CurrentUsername); SqlParameter param = cmd.Parameters.Add("@SnippetID", System.Data.SqlDbType.Int); param.Direction = System.Data.ParameterDirection.Output; conn.Open(); cmd.ExecuteNonQuery(); data.ID = (int?)param.Value; if (_canSynchronize) { SharedSnippetProvider.SynchronizationActionAdd(data); } } }
public void DeleteItem(int?id) { if (ConnParams == null) { throw new NullPropertyException("Connection parameters is null!"); } using (SqlConnection conn = new SqlConnection(_connParams.ConnectionString)) { string cmdText = "exec spPragmaSQL_CodeSnippet_Delete @SnippetID"; SqlCommand cmd = new SqlCommand(cmdText, conn); cmd.CommandTimeout = 0; AddParam(cmd, "@SnippetID", SqlDbType.Int, id); conn.Open(); cmd.ExecuteNonQuery(); if (_canSynchronize) { SharedSnippetProvider.SynchronizationActionDelete(id); } } }