public async Task <bool> DeleteGroupAsync(int id)
        {
            var sData = await _Context.Settlement.Where(c => c.GroupId == id).ToListAsync();

            if (sData.Count > 0)
            {
                for (var i = 0; i < sData.Count; i++)
                {
                    _Context.Remove(sData[i]);
                }
                await _Context.SaveChangesAsync();
            }

            var billData = await _Context.Bill.Where(c => c.GroupId == id).ToListAsync();

            if (billData.Count > 0)
            {
                for (var i = 0; i < billData.Count; i++)
                {
                    _Context.Remove(billData[i]);
                }
                await _Context.SaveChangesAsync();
            }

            var transData = await _Context.Transactions.Where(c => c.GroupId == id).ToListAsync();

            if (transData.Count > 0)
            {
                for (var i = 0; i < transData.Count; i++)
                {
                    _Context.Remove(transData[i]);
                }
                await _Context.SaveChangesAsync();
            }


            var group = await _Context.Group.SingleOrDefaultAsync(c => c.GroupId == id);

            _Context.Remove(group);
            //await _Context.SaveChangesAsync();

            try
            {
                return(await _Context.SaveChangesAsync() > 0 ? true : false);
            }
            catch (System.Exception exp)
            {
                _Logger.LogError($"Error in {nameof(DeleteGroupAsync)}: " + exp.Message);
            }
            return(false);
        }
예제 #2
0
        public async Task <bool> DeleteUserAsync(int id)
        {
            var user = await _Context.User
                       .Include(c => c.BillMembers)
                       .Include(c => c.Bills)
                       .Include(c => c.Friends)
                       .Include(c => c.groupMembers)
                       .Include(c => c.Groups)
                       .Include(c => c.Payers)
                       .Include(c => c.Payersdata)
                       .Include(c => c.SharedMembers)
                       .Include(c => c.TPayers)
                       .Include(c => c.TReceivers)
                       .Include(c => c.Users)
                       .SingleOrDefaultAsync(c => c.UserId == id);

            _Context.Remove(user);

            try
            {
                return(await _Context.SaveChangesAsync() > 0 ? true : false);
            }
            catch (System.Exception exp)
            {
                _Logger.LogError($"Error in {nameof(DeleteUserAsync)}: " + exp.Message);
            }
            return(false);
        }
예제 #3
0
        public async Task <bool> DeleteGroupAsync(int id)
        {
            var group = await _Context.Group.SingleOrDefaultAsync(c => c.GroupId == id);

            _Context.Remove(group);


            try
            {
                return(await _Context.SaveChangesAsync() > 0 ? true : false);
            }
            catch (System.Exception exp)
            {
                _Logger.LogError($"Error in {nameof(DeleteGroupAsync)}: " + exp.Message);
            }
            return(false);
        }
예제 #4
0
        public async Task <int> DeleteAsync(int countryId)
        {
            var countryToDelete = await _dbContext.Country
                                  .Where(x => x.CountryId == countryId)
                                  .FirstOrDefaultAsync();

            _dbContext.Remove(countryToDelete);
            return(await _dbContext.SaveChangesAsync());
        }
예제 #5
0
        public virtual void Setup()
        {
            DbContext.DetachAllEntities();
            foreach (var administrator in DbContext.Administrators.ToList())
            {
                DbContext.Remove(administrator);
            }

            DbContext.SaveChanges();
        }
예제 #6
0
파일: TestUtils.cs 프로젝트: yuyu2you/sod
        static void TestWriteDataWarpper()
        {
            DemoDbContext remoteDbContext = new DemoDbContext(AdoHelper.CreateHelper("DemoDB"));

            //删除数据,必须通过DbContext 来处理,详细参见 解决方案说明.txt 文件的数据同步说明
            using (IWriteDataWarpper warpper = WriteDataWarpperFactory.Create(remoteDbContext))
            {
                UserEntity entity = new UserEntity();
                entity.UID = 100;
                remoteDbContext.Remove <UserEntity>(entity);
            }
        }
예제 #7
0
        static void InitData(string dbName, string prjId)
        {
            DemoDbContext context = new DemoDbContext(AdoHelper.CreateHelper(dbName));
            //分类ID

            int delId = 0;

            for (int i = 0; i < 100; i++)
            {
                TestEntity test = new TestEntity();
                test.Name           = "Name" + i;
                test.AtTime         = DateTime.Now;
                test.Classification = prjId;
                context.Add(test);

                UserEntity user = new UserEntity();
                user.Name     = "User" + i;
                user.Sex      = false;
                user.Height   = 1.6f + i / 10;
                user.Birthday = new DateTime(1990, 1, 1).AddDays(i);
                context.Add(user);

                if (i == 50)
                {
                    delId = test.ID;
                }
            }
            //删除数据,确保被删除的ID写入到ID删除记录表中
            using (IWriteDataWarpper warpper = WriteDataWarpperFactory.Create(context))
            {
                context.Remove(new TestEntity()
                {
                    ID = delId
                });
                context.Remove(new UserEntity()
                {
                    UID = delId
                });
            }
        }
        public async Task <bool> DeleteFriendAsync(int fid, int uid)
        {
            var data = _Context.FriendList.SingleOrDefault(c => c.UserId == uid && c.FriendId == fid);

            if (data == null)
            {
                var fData = _Context.FriendList.SingleOrDefault(c => c.UserId == fid && c.FriendId == uid);
                _Context.Remove(fData);
            }
            else
            {
                _Context.Remove(data);
            }
            try
            {
                return(await _Context.SaveChangesAsync() > 0 ? true : false);
            }
            catch (System.Exception exp)
            {
                _Logger.LogError($"Error in {nameof(DeleteFriendAsync)}: " + exp.Message);
            }
            return(false);
        }