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;
}
}
}
