public HttpResponseMessage DeleteSupplier(HttpRequestMessage request, Guid id) { return GetHttpResponse(request, () => { HttpResponseMessage response = null; EntityOperationResultBase deleteResult = new DeleteResult<SupplierViewModel>() { Success = false }; GetEntityResult<SupplierViewModel> entityResult = supplierRepository.FindById(id); if (!(entityResult.Success && entityResult.Entity != null)) { response = new HttpResponseMessage(HttpStatusCode.NotFound); deleteResult.ErrorMessage = "Supplier does not exist"; response.Content = new ObjectContent<EntityOperationResultBase>(deleteResult, Configuration.Formatters.JsonFormatter); return response; } deleteResult = supplierRepository.Delete(id); response = GetOperationBaseResponse(request, deleteResult); return response; }); }
public DeleteResult<ProductAttributeViewModel> Delete(Guid id) { GetEntityResult<ProductAttributeViewModel> productAttributeResult = FindById(id); DeleteResult<ProductAttributeViewModel> deleteResult = new DeleteResult<ProductAttributeViewModel>(); FindResult<SubCategoryAttributeMapViewModel> mapResult = subCategoryAttributeMapRepository.FindBy(x => x.ProductAttributeId == productAttributeResult.Entity.ProductAttributeId); if (mapResult.Success && mapResult.Entities.Count > 0) { foreach (SubCategoryAttributeMapViewModel map in mapResult.Entities) { EntityOperationResultBase deleteMapResult = subCategoryAttributeMapRepository.Delete(map.SubCategoryAttributeMapId); if (!deleteMapResult.Success) { deleteResult.ErrorMessage = string.Format("Not able to delete all mappings"); return deleteResult; } } } EntityOperationResultBase attributeDeleteResult = productAttributeRepository.Delete(id); return deleteResult; }
public HttpResponseMessage DeleteProductAttribute(HttpRequestMessage request, Guid id) { ProductAttributeViewModel productAttribute = null; return GetHttpResponse(request, () => { HttpResponseMessage response = null; DeleteResult<ProductAttributeViewModel> deleteResult = new DeleteResult<ProductAttributeViewModel>(); deleteResult = productAttributeActivity.Delete(id); deleteResult.Entity = productAttribute; if (productAttribute == null) { response = new HttpResponseMessage(HttpStatusCode.BadRequest); deleteResult.ErrorMessage = "Product Attribute is null"; deleteResult.Success = false; response.Content = new ObjectContent<DeleteResult<ProductAttributeViewModel>>(deleteResult, Configuration.Formatters.JsonFormatter); return response; } EntityOperationResultBase result = productAttributeActivity.Delete(productAttribute.ProductAttributeId); deleteResult.ErrorMessage = result.ErrorMessage; deleteResult.Success = result.Success; deleteResult.SuccessMessage = result.SuccessMessage; response = new HttpResponseMessage(HttpStatusCode.OK); if (deleteResult.Success) { deleteResult.SuccessMessage = string.Format("Product Attribute: '{0}' has been deleted", productAttribute.AttributeName); } else { deleteResult.SuccessMessage = string.Format("Error occurred while deleting Product Attribute: '{0}'", productAttribute.AttributeName); } response.Content = new ObjectContent<DeleteResult<ProductAttributeViewModel>>(deleteResult, Configuration.Formatters.JsonFormatter); return response; }); }
public async Task <bool> DeleteBalance(Balance balance) { try { DeleteResult actionResult = await _context.Addresses .DeleteOneAsync(n => n.Id.Equals(balance.Id)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { throw ex; } }
public void SuccessAndError() { var contentSize = 8; var contentHash = ContentHash.Random(); var successResult = new DeleteResult(contentHash, contentSize); var errorResult = new DeleteResult(DeleteResult.ResultCode.Error, "errorMsg"); var deleteResultMapping = new Dictionary <string, DeleteResult> { { "TEST_MACHINE_LOCATION", successResult }, { "TEST_MACHINE_LOCATION2", errorResult } }; var distributedDeleteResult = new DistributedDeleteResult(contentHash, contentSize, deleteResultMapping); distributedDeleteResult.ToString().Should().Contain(errorResult.ErrorMessage); distributedDeleteResult.ToString().Should().Contain("ContentSize"); distributedDeleteResult.ToString().Should().Contain("Status=Success"); }
public async Task <bool> RemoveEntity(Guid id) { try { DeleteResult actionResult = await _context.Datasets .DeleteOneAsync(Builders <CollectedData> .Filter.Eq("Id", id)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception e) { Console.WriteLine(e); throw; } }
public bool RemoveUser(string id) { try { ObjectId internalId = GetInternalId(id); DeleteResult actionResult = _context.Users.DeleteOne( Builders <User> .Filter.Eq("InternalId", internalId)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { throw ex; } }
public async Task <bool> Remove(string name) { try { DeleteResult actionResult = await _context.Permissions.DeleteOneAsync( Builders <Permission> .Filter.Eq("Name", name)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { _logger.Warning("Something went wrong while removing Permission with Name {@Name}.", name); throw ex; } }
public bool Delete(string set_name, Dictionary <object, object> search) { if (search.ContainsKey("_id")) { search["_id"] = new ObjectId(search["_id"].ToString()); } BsonDocument bfilter = new BsonDocument(search); BsonDocumentFilterDefinition <BsonDocument> filterDef = new BsonDocumentFilterDefinition <BsonDocument>(bfilter); DeleteResult dres = mdb.GetCollection <BsonDocument>(set_name).DeleteMany(bfilter); if (dres.DeletedCount >= 1) { return(true); } return(false); }
public async Task <bool> Remove(Coupon coupon) { try { DeleteResult actionResult = await _context.Coupons.DeleteOneAsync( Builders <Coupon> .Filter.Eq("Id", coupon.Id)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { _logger.LogError(ex.ToString()); throw ex; } }
public virtual DeleteResult <T> Delete <T>() where T : Entity { var output = new DeleteResult <T>(); CurrentValidation = Validate(); if (CurrentValidation.IsSuccess) { var repo = DepCon.Resolve <IRepository <T> >(); output = repo.Delete(this as T); } output.Validation = CurrentValidation; return(output); }
public async Task <bool> RemoveNote(string id) { try { var filter = Builders <Note> .Filter.Eq("Id", id); DeleteResult result = await _context.Notes.DeleteOneAsync(filter); return(result.IsAcknowledged && result.DeletedCount > 0); } catch (Exception ex) { //Log or manage the exception throw ex; } }
public async Task <bool> RemoveCodeFailure(string id) { try { DeleteResult actionResult = await _dbContext.CodeFailure.DeleteOneAsync( Builders <CodeFailure> .Filter.Eq("_id", ObjectId.Parse(id))); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { // log or manage the exception throw ex; } }
public IActionResult Delete(string id) { ObjectId oId = new ObjectId(id); DeleteResult result = collection.DeleteOne (l => l.Id == oId); if (result.IsAcknowledged) { TempData["Message"] = "Location deleted successfully!"; } else { TempData["Message"] = "Error while deleting Location!"; } return(RedirectToAction("Index")); }
public async Task <bool> DeleteSession(ObjectId sessionId) { try { DeleteResult actionResult = await _context.Session.DeleteOneAsync( Builders <Session> .Filter.Eq("InternalId", sessionId)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { throw ex; } }
public async Task <bool> RemoveDepartment(int id) { try { DeleteResult actionResult = await _context.Departments.DeleteOneAsync( Builders <Department> .Filter.Eq("ID", id)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { // log or manage the exception throw ex; } }
public async Task <bool> Delete(String id) { try { FilterDefinition <T> filter = Builders <T> .Filter.Eq("_id", ObjectId.Parse(id)); DeleteResult actionResult = await _db.Collection.DeleteOneAsync(filter); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { throw ex; } }
public async Task <bool> Remove(int id) { try { DeleteResult actionResult = await _context.AccessPoints.DeleteOneAsync( Builders <AccessPoint> .Filter.Eq("ID", id)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { _logger.Warning("Something went wrong while removing AccessPoint with ID {@ID}.", id); throw ex; } }
public async Task <bool> RemoveCat(string name) { try { DeleteResult actionResult = await _context.Cats.DeleteOneAsync( Builders <Cat> .Filter.Eq("Name", name)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { throw ex; } }
//Get call from Noteservice to Create Note Based on Id from Mongo DB public async Task <bool> DeleteAsync(int id) { try { FilterDefinition <Notes> filter = Builders <Notes> .Filter.Eq(m => m.Id, id); DeleteResult deleteResult = await _context.notes.DeleteOneAsync(filter); bool result = deleteResult.IsAcknowledged && deleteResult.DeletedCount > 0; return(result); } catch (Exception ex) { throw (ex); } }
public async Task <IActionResult> DeleteAsync(string _id) { DeleteResult deleteResult = null; try { deleteResult = await scoreManager.DeleteScoreAsync(new ObjectId(_id)); } catch (Exception ex) { throw ex; } var output = StatusCode((int)HttpStatusCode.OK, deleteResult); return(output); }
public async Task <IActionResult> DeleteAllAsync() { DeleteResult deleteResult = null; try { deleteResult = await scoreManager.DeleteAllScoresAsync(); } catch (Exception ex) { throw ex; } var output = StatusCode((int)HttpStatusCode.OK, deleteResult); return(output); }
public async Task <bool> RemoveAllConfigurationsAsync() { try { DeleteResult actionResult = await _context.Configurations.DeleteManyAsync(new BsonDocument()); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { _logger.LogError(ex, ""); throw ex; } }
public async Task <bool> RemoveAllAsync() { try { DeleteResult actionResult = await _context.ConnectionAttributes.DeleteManyAsync(new BsonDocument()); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { // log or manage the exception throw ex; } }
public virtual DeleteResult <T> Delete <T>() where T : Entity { var output = new DeleteResult <T>(); CurrentValidation = ValidateDel(); if (CurrentValidation.IsSuccess) { var repo = GetRepo <T>(); output = repo.Delete(this as T); } output.Validation = CurrentValidation; return(output); }
public async Task <bool> RemoveSessaoAsync(string id) { try { DeleteResult actionResult = await _context.Sessoes.DeleteOneAsync( Builders <Sessao> .Filter.Eq("Id", GetInternalId(id))); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { throw ex; } }
public override async ETTask Run() { DBComponent dbComponent = Game.Scene.GetComponent <DBComponent>(); try { // 执行保存数据库任务 DeleteResult deleteResult = await dbComponent.GetCollection(this.CollectionName).DeleteManyAsync(s => s.Id == this.Id); this.Tcs.SetResult(deleteResult.DeletedCount); } catch (Exception e) { this.Tcs.SetException(new Exception($"删除数据失败! {CollectionName} {Id}", e)); } }
public string DeleteMessage(string ID) { string response = string.Empty; DeleteResult result = _messages.DeleteOne(mes => mes.ID == ID); if (result.DeletedCount == 1) { response = "Deleted successfully"; } else { response = "Error in deleting message"; } return(response); }
public virtual async Task Delete(List <ObjectId> subscriberIds, List <int> receivePeriodSets = null) { var filter = Builders <SubscriberScheduleSettings <ObjectId> > .Filter.Where( p => subscriberIds.Contains(p.SubscriberId)); if (receivePeriodSets != null) { filter &= Builders <SubscriberScheduleSettings <ObjectId> > .Filter.Where( p => receivePeriodSets.Contains(p.Set)); } DeleteResult response = await _collectionFactory .GetCollection <SubscriberScheduleSettings <ObjectId> >() .DeleteManyAsync(filter) .ConfigureAwait(false); }
private static void DeleteTweeterIndex(ElasticConnection connection, JsonNetSerializer serializer) { /* * $ curl -XDELETE 'http://localhost:9200/twitter?pretty=true' */ string deleteCommand = Commands.Delete(index: "twitter").Pretty(); var result = connection.Delete(deleteCommand); DeleteResult deleteResult = serializer.ToDeleteResult(result); PrintDeleteCommand(deleteCommand, deleteResult, result); }
public async Task <bool> RemoveOneAsync(string id) { try { DeleteResult actionResult = await _context.ConnectionAttributes.DeleteOneAsync( Builders <ConnectionAttribute> .Filter.Eq("Id", id)); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { // log or manage the exception throw ex; } }
public async Task <bool> RemoveAllContracts() { //throw new NotImplementedException(); try { DeleteResult actionResult = await _context.ManagementContract.DeleteManyAsync(new BsonDocument()); return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0); } catch (Exception ex) { // log or manage the exception throw ex; } }
public async Task <bool> DeleteQuestionsByTopic(string topicName) { FilterDefinition <QuestionGeneration> filter = Builders <QuestionGeneration> .Filter.Eq(m => m.TopicName, topicName); DeleteResult deleteResult = await context.QuestionGenerationCollection.DeleteManyAsync(filter); if (deleteResult.IsAcknowledged && deleteResult.DeletedCount > 0) { Console.WriteLine(deleteResult.DeletedCount + " Items Deleted."); TopicBroadcaster topicBroadcaster_deleted_single = new TopicBroadcaster(); topicBroadcaster_deleted_single.PublishTopic_as_deleted(topicName); Console.WriteLine("----------------" + topicName + " deleted --------------"); return(true); } return(false); }
public HttpResponseMessage DeleteVolumeMeasure(HttpRequestMessage request, Guid id) { //Guid id = Guid.Empty; //if(!Guid.TryParse(volumeMeasureId, out id)) //{ // throw new Exception("Id is not in correct formate"); //} GetEntityResult<VolumeMeasureViewModel> volumeMeasureResult = _volumeMeasureRepository.FindById(id); VolumeMeasureViewModel volumeMeasure = null; if (volumeMeasureResult.Success && volumeMeasureResult.Entity != null) { volumeMeasure = volumeMeasureResult.Entity; } return GetHttpResponse(request, () => { HttpResponseMessage response = null; DeleteResult<VolumeMeasureViewModel> deleteResult = new DeleteResult<VolumeMeasureViewModel>(); deleteResult.Entity = volumeMeasure; if (volumeMeasure == null) { response = new HttpResponseMessage(HttpStatusCode.BadRequest); deleteResult.ErrorMessage = "VolumeMeasure is null"; deleteResult.Success = false; response.Content = new ObjectContent<DeleteResult<VolumeMeasureViewModel>>(deleteResult, Configuration.Formatters.JsonFormatter); return response; } EntityOperationResultBase result = _volumeMeasureRepository.Delete(volumeMeasure.VolumeMeasureId); deleteResult.ErrorMessage = result.ErrorMessage; deleteResult.Success = result.Success; deleteResult.SuccessMessage = result.SuccessMessage; response = new HttpResponseMessage(HttpStatusCode.OK); if (deleteResult.Success) { deleteResult.SuccessMessage = string.Format("VolumeMeasure: '{0}' has been deleted", volumeMeasure.VolumeMeasureName); } else { deleteResult.SuccessMessage = string.Format("Error occurred while deleting VolumeMeasure: '{0}'", volumeMeasure.VolumeMeasureName); } response.Content = new ObjectContent<DeleteResult<VolumeMeasureViewModel>>(deleteResult, Configuration.Formatters.JsonFormatter); return response; }); }
public static ManualDelete GetViewModel(BaseController baseController, int id, out DeleteResult deleteResult) { deleteResult = DeleteResult.Ok; Manual manual = ManualCache.GetDetail(baseController.Db, id); if (manual == null) return null; var manualDelete = new ManualDelete(manual); manualDelete.Process(baseController); if (baseController.ModelState.IsValid) { deleteResult = ManualCache.Delete(baseController.Db, manual); switch (deleteResult) { case DeleteResult.Ok: case DeleteResult.AuthorizationFailed: return manualDelete; case DeleteResult.DbFailed: baseController.ModelState.AddModelError(BaseCache.TitleField, ValidationResource.Global_DeleteRecord_ErrorMessage); break; default: throw new ArgumentOutOfRangeException(); } } return manualDelete; }
/************************************** * 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; } } }
//delete a list of objects from zuora public List<ResponseHolder> Delete(List<String> input, String type) { List<ResponseHolder> results = new List<ResponseHolder>(); bool done = false; int deleteNum = 50; while (!done) { List<String> doWork = new List<String>() { }; if (input.Count > deleteNum) { List<String> delList = input.GetRange(0, deleteNum); for (int i = 0; i < deleteNum; i++) { String temp = delList[i]; doWork.Add(temp); input.Remove(temp); } } else { done = true; doWork = input; } CheckTime(); DeleteResult[] drs = new DeleteResult[] { }; try { drs = svc.delete(sh, type, doWork.ToArray()); } catch (FaultException e) { ResponseHolder error = new ResponseHolder(); error.Message = e.Message; error.Success = false; results.Add(error); return results; } foreach (DeleteResult dr in drs) { ResponseHolder res = new ResponseHolder(); if (dr.success) { res.Success = true; res.Id = dr.id; } else { res.Success = false; res.Message = dr.errors[0].Message; } results.Add(res); } } return results; }
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 HttpResponseMessage DeleteCategory(HttpRequestMessage request, Guid id) { //Guid id = Guid.Empty; //if(!Guid.TryParse(categoryId, out id)) //{ // throw new Exception("Id is not in correct formate"); //} GetEntityResult<CategoryViewModel> categoryResult = _categoryRepository.FindById(id); CategoryViewModel category = null; if (categoryResult.Success && categoryResult.Entity != null) { category = categoryResult.Entity; } return GetHttpResponse(request, () => { HttpResponseMessage response = null; DeleteResult<CategoryViewModel> deleteResult = new DeleteResult<CategoryViewModel>(); deleteResult.Entity = category; if (category == null) { response = new HttpResponseMessage(HttpStatusCode.InternalServerError); deleteResult.ErrorMessage = "Category is null"; deleteResult.Success = false; response.Content = new ObjectContent<DeleteResult<CategoryViewModel>>(deleteResult, Configuration.Formatters.JsonFormatter); return response; } EntityOperationResultBase result = _categoryRepository.Delete(category.CategoryId); deleteResult.ErrorMessage = result.ErrorMessage; deleteResult.Success = result.Success; deleteResult.SuccessMessage = result.SuccessMessage; response = new HttpResponseMessage(HttpStatusCode.OK); if (deleteResult.Success) { deleteResult.SuccessMessage = string.Format("Category: '{0}' has been deleted", category.CategoryName); } else { deleteResult.SuccessMessage = string.Format("Error occurred while deleting Category: '{0}'", category.CategoryName); } response.Content = new ObjectContent<DeleteResult<CategoryViewModel>>(deleteResult, Configuration.Formatters.JsonFormatter); return response; }); }
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 bool DeleteImpressionRecordsForAdmin(AdminImpressionRecordFilter filter, int topCount, out int deletedCount) { deletedCount = 0; using (SqlQuery query = new SqlQuery()) { string conditions = BuildCondition(query, filter); StringBuffer sql = new StringBuffer(); sql += @" DECLARE @DeleteData table (RecordID int); INSERT INTO @DeleteData SELECT TOP (@TopCount) [RecordID] FROM [bx_ImpressionRecords] WHERE " + conditions + @"; DELETE [bx_ImpressionRecords] WHERE TypeID IN (SELECT [RecordID] FROM @DeleteData); SELECT @@ROWCOUNT;"; 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); return true; } } }
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; } } }
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 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; } } }