public override DeleteResult DeleteCommentsByFilter(AdminCommentFilter filter, int operatorUserID, IEnumerable <Guid> excludeRoleIDs, bool getDeleteResult) { using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, true, operatorUserID, excludeRoleIDs); string sql = string.Empty; if (getDeleteResult) { sql = @"SELECT [UserID],COUNT(*) AS [Count] FROM [bx_Comments] {0} GROUP BY [UserID];"; } sql += "DELETE FROM bx_Comments {0};"; query.CommandText = string.Format(sql, conditions); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get <int>("UserID"), reader.Get <int>("Count")); } return(deleteResult); } } }
public DeleteResult Check(TKey id) { var result = new DeleteResult(); foreach (var reference in _references) { var count = reference.Count(id, _context); if (count > 0) { result.Add(count, reference.Type); } } return(result); }
public override DeleteResult DeleteDoingsBySearch(AdminDoingFilter filter, IEnumerable <Guid> excludeRoleIDs, int deleteTopCount, out int deletedCount) { deletedCount = 0; using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, excludeRoleIDs, true); StringBuffer sql = new StringBuffer(); sql += @" DECLARE @DeleteData table (UserID int, DoingID int); INSERT INTO @DeleteData SELECT TOP (@TopCount) [UserID],[DoingID] FROM [bx_Doings] " + conditions + @"; DELETE [bx_Doings] WHERE DoingID IN (SELECT [DoingID] FROM @DeleteData); SELECT @@ROWCOUNT; SELECT [UserID],COUNT(*) AS [Count] FROM @DeleteData GROUP BY [UserID];"; query.CreateTopParameter("@TopCount", deleteTopCount); query.CommandText = sql.ToString(); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); if (reader.Read()) { deletedCount = reader.Get <int>(0); } if (reader.NextResult()) { while (reader.Read()) { deleteResult.Add(reader.Get <int>("UserID"), reader.Get <int>("Count")); } } return(deleteResult); } } }
public override DeleteResult DeleteDoings(int operatorID, IEnumerable <int> doingIDs, IEnumerable <Guid> excludeRoleIDs) { using (SqlQuery query = new SqlQuery()) { string excludeRolesSql = DaoUtil.GetExcludeRoleSQL("[UserID]", excludeRoleIDs, query); if (string.IsNullOrEmpty(excludeRolesSql) == false) { excludeRolesSql = " AND ([UserID] = @UserID OR " + excludeRolesSql + ")"; } string sql = @" DECLARE @DeleteData table (UserID int, DoingID int); INSERT INTO @DeleteData SELECT [UserID],[DoingID] FROM [bx_Doings] WHERE [DoingID] IN (@DoingIDs)" + excludeRolesSql + @"; DELETE [bx_Doings] WHERE DoingID IN (SELECT [DoingID] FROM @DeleteData); SELECT [UserID],COUNT(*) AS [Count] FROM @DeleteData GROUP BY [UserID];"; query.CommandText = sql; query.CreateInParameter <int>("@DoingIDs", doingIDs); query.CreateParameter <int>("@UserID", operatorID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get <int>("UserID"), reader.Get <int>("Count")); } return(deleteResult); } } }
/************************************** * Delete开头的函数删除数据 * **************************************/ public override DeleteResult DeleteBlogCategories(IEnumerable<int> categoryIDs, bool deleteArticle, int operatorID, IEnumerable<Guid> excludeRoleIDs) { using (SqlQuery query = new SqlQuery()) { string excludeRolesSql = DaoUtil.GetExcludeRoleSQL("[UserID]", excludeRoleIDs, query); if (string.IsNullOrEmpty(excludeRolesSql) == false) excludeRolesSql = " AND ([UserID] = @UserID OR " + excludeRolesSql + ")"; StringBuffer sql = new StringBuffer(); sql += @" DECLARE @DeleteData table (UserID int, [CategoryID] int, [ArticleCount] int); INSERT INTO @DeleteData SELECT [A].[UserID],[A].[CategoryID],(SELECT COUNT(*) FROM [bx_BlogArticles] AS [B] WHERE [B].[CategoryID]=[A].[CategoryID]) FROM [bx_BlogCategories] AS [A] WHERE [A].[CategoryID] IN (@CategoryIDs)" + excludeRolesSql + ";"; if (deleteArticle) { sql += @" DELETE [bx_BlogCategories] WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);"; } else { sql += @" UPDATE [bx_BlogArticles] SET [CategoryID] = 0 WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);"; } sql += @" DELETE [bx_BlogCategories] WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData); SELECT [UserID],SUM([ArticleCount]) AS [Count] FROM @DeleteData GROUP BY [UserID];"; query.CreateInParameter("@CategoryIDs", categoryIDs); query.CreateParameter<int>("@UserID", operatorID, SqlDbType.Int); query.CommandText = sql.ToString(); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } return deleteResult; } } }
public override DeleteResult DeleteBlogArticlesBySearch(AdminBlogArticleFilter filter, int operatorUserID, IEnumerable<Guid> excludeRoleIDs, int topCount, out int deletedCount) { deletedCount = 0; using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, operatorUserID, excludeRoleIDs, true); StringBuffer sql = new StringBuffer(); sql += @" DECLARE @DeleteData table (UserID int, ArticleID int); INSERT INTO @DeleteData SELECT TOP (@TopCount) [UserID],[ArticleID] FROM [bx_BlogArticles] " + conditions + @"; DELETE [bx_BlogArticles] WHERE ArticleID IN (SELECT [ArticleID] FROM @DeleteData); SELECT @@ROWCOUNT; SELECT [UserID],COUNT(*) AS [Count] FROM @DeleteData GROUP BY [UserID];"; query.CreateTopParameter("@TopCount", topCount); query.CommandText = sql.ToString(); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); if (reader.Read()) deletedCount = reader.Get<int>(0); if (reader.NextResult()) { while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } } return deleteResult; } } }
/************************************** * Delete开头的函数删除数据 * **************************************/ public override DeleteResult DeleteBlogArticles(IEnumerable<int> articleIDs, int operatorID, IEnumerable<Guid> excludeRoleIDs) { using (SqlQuery query = new SqlQuery()) { string excludeRolesSql = DaoUtil.GetExcludeRoleSQL("[UserID]", "[LastEditUserID]", operatorID, excludeRoleIDs, query); if (string.IsNullOrEmpty(excludeRolesSql) == false) excludeRolesSql = " AND ([UserID] = @UserID OR " + excludeRolesSql + ")"; string sql = @" DECLARE @DeleteData table (UserID int, ArticleID int); INSERT INTO @DeleteData SELECT [UserID],[ArticleID] FROM [bx_BlogArticles] WHERE [ArticleID] IN (@ArticleIDs)" + excludeRolesSql + @"; DELETE [bx_BlogArticles] WHERE ArticleID IN (SELECT [ArticleID] FROM @DeleteData); SELECT [UserID],COUNT(*) AS [Count] FROM @DeleteData GROUP BY [UserID];"; query.CommandText = sql; query.CreateInParameter<int>("@ArticleIDs", articleIDs); query.CreateParameter<int>("@UserID", operatorID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } return deleteResult; } } }
public override DeleteResult DeleteBlogCategoriesBySearch(AdminBlogCategoryFilter filter, bool deleteArticle, int operatorUserID, IEnumerable<Guid> excludeRoleIDs, int topCount, out int deletedCount) { deletedCount = 0; using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, excludeRoleIDs, true); StringBuffer sql = new StringBuffer(); sql += @" DECLARE @DeleteData table (UserID int, [CategoryID] int, [ArticleCount] int); INSERT INTO @DeleteData SELECT TOP (@TopCount) [A].[UserID],[A].[CategoryID],(SELECT COUNT(*) FROM [bx_BlogArticles] AS [B] WHERE [B].[CategoryID]=[A].[CategoryID]) FROM [bx_BlogCategories] AS [A] " + conditions + ";"; if (deleteArticle) { sql += @" DELETE [bx_BlogArticles] WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);"; } else { sql += @" UPDATE [bx_BlogArticles] SET [CategoryID] = 0 WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);"; } sql += @" DELETE [bx_BlogCategories] WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData); SELECT @@ROWCOUNT; SELECT [UserID],SUM([ArticleCount]) AS [Count] FROM @DeleteData GROUP BY [UserID];"; query.CreateTopParameter("@TopCount", topCount); query.CommandText = sql.ToString(); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); if (reader.Read()) deletedCount = reader.Get<int>(0); if (reader.NextResult()) { while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } } return deleteResult; } } }
public override DeleteResult DeleteCommentsByFilter(AdminCommentFilter filter, int operatorUserID, IEnumerable<Guid> excludeRoleIDs, bool getDeleteResult) { using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, true, operatorUserID, excludeRoleIDs); string sql = string.Empty; if (getDeleteResult) { sql = @"SELECT [UserID],COUNT(*) AS [Count] FROM [bx_Comments] {0} GROUP BY [UserID];"; } sql += "DELETE FROM bx_Comments {0};"; query.CommandText = string.Format(sql, conditions); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } return deleteResult; } } }
public override DeleteResult DeleteAlbumsBySearch(AdminAlbumFilter filter, int operatorID, IEnumerable<Guid> excludeRoleIDs, int topCount, out int deletedCount, out int[] deletedPhotoIDs) { deletedCount = 0; using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, operatorID, excludeRoleIDs, true); StringBuffer sql = new StringBuffer(); sql += @" DECLARE @DeleteData table (UserID int, AlbumID int, PhotoCount int); INSERT INTO @DeleteData SELECT TOP (@TopCount) [UserID],[A].[AlbumID],(SELECT COUNT(*) FROM [bx_Photos] AS [B] WHERE [B].[AlbumID]=[A].[AlbumID]) FROM [bx_Albums] AS [A] " + conditions + @"; DECLARE @DeletePhotos table (PhotoID int); INSERT INTO @DeletePhotos SELECT PhotoID from bx_Photos WHERE AlbumID IN (SELECT [AlbumID] FROM @DeleteData); DELETE [bx_Albums] WHERE [AlbumID] IN (SELECT [AlbumID] FROM @DeleteData); SELECT @@ROWCOUNT; SELECT [UserID],SUM([PhotoCount]) AS [Count] FROM @DeleteData GROUP BY [UserID]; SELECT [PhotoID] FROM @DeletePhotos;"; query.CreateTopParameter("@TopCount", topCount); query.CommandText = sql.ToString(); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); if (reader.Read()) deletedCount = reader.Get<int>(0); reader.NextResult(); while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } reader.NextResult(); List<int> deletePhotos = new List<int>(); while (reader.Read()) { deletePhotos.Add(reader.Get<int>(0)); } deletedPhotoIDs = deletePhotos.ToArray(); return deleteResult; } } }
/************************************** * Delete开头的函数删除数据 * **************************************/ public override DeleteResult DeleteAlbums(IEnumerable<int> albumIDs, int operatorID, IEnumerable<Guid> excludeRoleIDs, out int[] deletePhotoIDs) { using (SqlQuery query = new SqlQuery()) { string excludeRolesSql = DaoUtil.GetExcludeRoleSQL("[UserID]", "[LastEditUserID]", operatorID, excludeRoleIDs, query); if (string.IsNullOrEmpty(excludeRolesSql) == false) excludeRolesSql = " AND ([UserID] = @UserID OR " + excludeRolesSql + ")"; string sql = @" DECLARE @DeleteData table (UserID int, AlbumID int, PhotoCount int); INSERT INTO @DeleteData SELECT [A].[UserID],[A].[AlbumID],(SELECT COUNT(*) FROM [bx_Photos] AS [B] WHERE [B].[AlbumID]=[A].[AlbumID]) FROM [bx_Albums] AS [A] WHERE [A].[AlbumID] IN (@AlbumIDs)" + excludeRolesSql + @"; DECLARE @DeletePhotos table (PhotoID int); INSERT INTO @DeletePhotos SELECT PhotoID from bx_Photos WHERE AlbumID IN (SELECT [AlbumID] FROM @DeleteData); DELETE [bx_Albums] WHERE [AlbumID] IN (SELECT [AlbumID] FROM @DeleteData); SELECT [UserID],SUM([PhotoCount]) AS [Count] FROM @DeleteData GROUP BY [UserID]; SELECT [PhotoID] FROM @DeletePhotos;"; query.CommandText = sql; query.CreateInParameter<int>("@AlbumIDs", albumIDs); query.CreateParameter<int>("@UserID", operatorID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); //List<string> deletedFileIDList = new List<string>(); //while (reader.Read()) //{ // deletedFileIDList.Add(reader.Get<string>(0)); //} //deletedFileIDs = deletedFileIDList.ToArray(); //if (reader.NextResult()) //{ while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } reader.NextResult(); List<int> deletePhotos = new List<int>(); while (reader.Read()) { deletePhotos.Add(reader.Get<int>(0)); } deletePhotoIDs = deletePhotos.ToArray(); //} return deleteResult; } } }
/************************************** * Delete开头的函数删除数据 * **************************************/ public override DeleteResult DeletePhotos(IEnumerable<int> deleteIDs, int operatorID, IEnumerable<Guid> excludeRoleIDs, out int[] deletedPhotoIDs) { using (SqlQuery query = new SqlQuery()) { string excludeRolesSql = DaoUtil.GetExcludeRoleSQL("[UserID]", "[LastEditUserID]", operatorID, excludeRoleIDs, query); if (string.IsNullOrEmpty(excludeRolesSql) == false) excludeRolesSql = " AND ([UserID] = @UserID OR " + excludeRolesSql + ")"; string sql = @" DECLARE @DeleteData table (UserID int, PhotoID int); INSERT INTO @DeleteData SELECT [UserID],[PhotoID] FROM [bx_Photos] WHERE [PhotoID] IN (@PhotoIDs)" + excludeRolesSql + @"; UPDATE [bx_Albums] SET [CoverPhotoID] = NULL, [Cover] = '' WHERE CoverPhotoID IN (SELECT [PhotoID] FROM @DeleteData); DELETE [bx_Photos] WHERE PhotoID IN (SELECT [PhotoID] FROM @DeleteData); SELECT [UserID],COUNT(*) AS [Count] FROM @DeleteData GROUP BY [UserID]; SELECT [PhotoID] FROM @DeleteData"; query.CommandText = sql; query.CreateInParameter<int>("@PhotoIDs", deleteIDs); query.CreateParameter<int>("@UserID", operatorID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } reader.NextResult(); List<int> deletedPhotos = new List<int>(); while (reader.Read()) { deletedPhotos.Add(reader.Get<int>(0)); } deletedPhotoIDs = deletedPhotos.ToArray(); return deleteResult; } } }
public override DeleteResult DeleteSearchPosts(PostFilter filter, IEnumerable<Guid> excludeRoleIDs, bool getDeleteResult, int topCount, out int deletedCount, out List<int> threadIDs) { using (SqlQuery query = new SqlQuery()) { string conditon = BuilderSearchPostCondition(filter, excludeRoleIDs, query, false); query.CommandText = @" DECLARE @Table table(TempPostID int,TempTopicID int,TempUserID int,TempForumID int,TempThreadStatus tinyint); INSERT INTO @Table SELECT TOP (@TopCount) [PostID],[ThreadID],[UserID],[ForumID],[ThreadStatus] FROM [bx_Posts] WHERE " + conditon + @"; SELECT DISTINCT TempTopicID FROM @Table; "; if (getDeleteResult) { query.CommandText += @" SELECT [TempUserID],[TempForumID],COUNT(*) AS [Count] FROM @Table WHERE TempThreadStatus<4 GROUP BY [TempUserID],[TempForumID];"; } query.CommandText = query.CommandText + @" DELETE [bx_Posts] WHERE PostID IN(SELECT TempPostID FROM @Table); SELECT @@ROWCOUNT; "; query.CreateTopParameter("@TopCount", topCount); threadIDs = new List<int>(); deletedCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { int threadID = reader.Get<int>("TempTopicID"); if (threadIDs.Contains(threadID) == false) threadIDs.Add(threadID); } if (getDeleteResult) { if (reader.NextResult()) { while (reader.Read()) { deleteResult.Add(reader.Get<int>("TempUserID"), reader.Get<int>("Count"), reader.Get<int>("TempForumID")); } } } if (reader.NextResult()) { while (reader.Read()) { deletedCount = reader.Get<int>(0); } } return deleteResult; } } }
public override DeleteResult DeleteSearchTopics(TopicFilter filter, IEnumerable<Guid> excludeRoleIDs, bool getDeleteResult, int topCount, out int deletedCount, out List<int> threadIDs) { using (SqlQuery query = new SqlQuery()) { string conditon = BuilderSearchThreadCondition(filter, excludeRoleIDs, query, false); query.CommandText = @" DECLARE @Table table(TempTopicID int,TempUserID int,TempForumID int,TempThreadStatus tinyint); INSERT INTO @Table SELECT TOP (@TopCount) [ThreadID],[PostUserID],[ForumID],[ThreadStatus] FROM [bx_TopicsWithContents] WITH (NOLOCK) WHERE " + conditon + @"; SELECT TempTopicID FROM @Table; --SELECT FileID FROM [bx_Attachments] WHERE PostID IN(SELECT PostID FROM [bx_Posts] WHERE ThreadID IN(SELECT TempTopicID FROM @Table)) -- AND FileID NOT IN(SELECT FileID FROM [bx_Attachments] WHERE PostID NOT IN(SELECT PostID FROM [bx_Posts] WHERE ThreadID IN(SELECT TempTopicID FROM @Table))); "; if (getDeleteResult) { query.CommandText += @" SELECT [TempUserID],[TempForumID],COUNT(*) AS [Count] FROM @Table WHERE TempThreadStatus<4 GROUP BY [TempUserID],[TempForumID];"; } query.CommandText = query.CommandText + @" DELETE [bx_Threads] WHERE ThreadID IN(SELECT TempTopicID FROM @Table); SELECT @@ROWCOUNT; "; query.CreateTopParameter("@TopCount", topCount); threadIDs = new List<int>(); // fileIDs = new List<string>(); deletedCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { threadIDs.Add(reader.Get<int>("TempTopicID")); } //if (reader.NextResult()) //{ // while (reader.Read()) // { // fileIDs.Add(reader.Get<string>("FileID")); // } //} if (getDeleteResult) { if (reader.NextResult()) { while (reader.Read()) { deleteResult.Add(reader.Get<int>("TempUserID"), reader.Get<int>("Count"), reader.Get<int>("TempForumID")); } } } if (reader.NextResult()) { while (reader.Read()) { deletedCount = reader.Get<int>(0); } } return deleteResult; } } }
public override DeleteResult DeleteSearchShares(ShareFilter filter, IEnumerable<Guid> excludeRoleIDs, bool getDeleteResult) { using (SqlQuery query = new SqlQuery()) { //string condition = @" 1 = 1 " // + (filter.UserID == null ? "" : ("AND [UserID] = @UserID ")) // + (filter.ShareID == null ? "" : ("AND [ShareID] = @ShareID ")) // + (filter.ShareCatagory == ShareCatagory.All ? "" : ("AND [Type] = @Type ")) // + (filter.PrivacyType == null ? "" : ("AND [PrivacyType] = @PrivacyType ")) // + (filter.BeginDate == null ? "" : ("AND [CreateDate] > @BeginDate ")) // + (filter.EndDate == null ? "" : ("AND [CreateDate] < @EndDate ")) // + "AND " + DaoUtil.GetExcludeRoleSQL("[UserID]", excludeRoleIDs, query); SqlConditionBuilder condition = new SqlConditionBuilder(SqlConditionStart.Where); condition += (filter.UserID == null ? "" : ("AND [UserID] = @UserID ")); condition += (filter.ShareID == null ? "" : ("AND [ShareID] = @ShareID ")); condition += (filter.ShareType == ShareType.All ? "" : ("AND [Type] = @Type ")); condition += (filter.PrivacyType == null ? "" : ("AND [PrivacyType] = @PrivacyType ")); condition += (filter.BeginDate == null ? "" : ("AND [CreateDate] > @BeginDate ")); condition += (filter.EndDate == null ? "" : ("AND [CreateDate] < @EndDate ")); condition.AppendAnd(DaoUtil.GetExcludeRoleSQL("[UserID]", excludeRoleIDs, query)); if (getDeleteResult) { query.CommandText = @" SELECT [UserID],COUNT(*) AS [Count] FROM [bx_SharesView] " + condition.ToString() + " GROUP BY [UserID];"; } else query.CommandText = string.Empty; query.CommandText = query.CommandText + @" DELETE [bx_SharesView] " + condition.ToString(); query.CreateParameter<int?>("@UserID", filter.UserID, SqlDbType.Int); query.CreateParameter<int?>("@ShareID", filter.ShareID, SqlDbType.Int); query.CreateParameter<int>("@Type", (int)filter.ShareType, SqlDbType.Int); query.CreateParameter<int?>("@PrivacyType", filter.PrivacyType == null ? 0 : (int)filter.PrivacyType, SqlDbType.Int); query.CreateParameter<DateTime?>("@BeginDate", filter.BeginDate, SqlDbType.DateTime); query.CreateParameter<DateTime?>("@EndDate", filter.EndDate, SqlDbType.DateTime); using (XSqlDataReader reader = query.ExecuteReader()) { DeleteResult deleteResult = new DeleteResult(); while (reader.Read()) { deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count")); } return deleteResult; } } }