public async Task DeleteAsync(PropertyCompanyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("物业公司Id信息不正确!"); } var propertyCompany = await db.PropertyCompanies.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (propertyCompany == null) { throw new NotImplementedException("该物业公司不存在!"); } if (await OnDelete(db, dto, token)) { throw new NotImplementedException("该物业公司存存在关联数据"); } propertyCompany.LastOperationTime = dto.OperationTime; propertyCompany.LastOperationUserId = dto.OperationUserId; propertyCompany.DeletedTime = dto.OperationTime; propertyCompany.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task <PropertyCompany> AddAsync(PropertyCompanyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if ((await db.PropertyCompanies.Where(x => x.Name == dto.Name && x.IsDeleted == false).FirstOrDefaultAsync(token)) != null) { throw new NotImplementedException("该物业公司名称已存在!"); } var entity = db.PropertyCompanies.Add(new PropertyCompany { Name = dto.Name, LogoImageUrl = dto.LogoImageUrl, Phone = dto.Phone, Address = dto.Address, Description = dto.Description, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task UpdateAsync(PropertyCompanyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("物业公司Id信息不正确!"); } var propertyCompany = await db.PropertyCompanies.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (propertyCompany == null) { throw new NotImplementedException("该物业公司不存在!"); } if ((await db.PropertyCompanies.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.Id != uid).FirstOrDefaultAsync(token)) != null) { throw new NotImplementedException("该物业公司名称已存在!"); } propertyCompany.Name = dto.Name; propertyCompany.Phone = dto.Phone; propertyCompany.Address = dto.Address; propertyCompany.Description = dto.Description; propertyCompany.LogoImageUrl = dto.LogoImageUrl; propertyCompany.LastOperationTime = dto.OperationTime; propertyCompany.LastOperationUserId = dto.OperationUserId; if (await db.SaveChangesAsync(token) <= 0) { throw new NotImplementedException("数据执行失败。"); } } }
public async Task <List <PropertyCompany> > GetListAsync(PropertyCompanyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var list = db.PropertyCompanies.Where(item => item.IsDeleted == false); return(await list.ToListAsync(token)); } }
private async Task <bool> OnDelete(GuoGuoCommunityContext db, PropertyCompanyDto dto, CancellationToken token = default) { //小区信息 if (await db.SmallDistricts.Where(x => x.PropertyCompanyId.ToString() == dto.Id && x.IsDeleted == false).FirstOrDefaultAsync(token) != null) { return(true); } return(false); }
public async Task <PropertyCompanyForPageDto> GetListForPageAsync(PropertyCompanyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var list = db.PropertyCompanies.Where(item => item.IsDeleted == false); if (!string.IsNullOrEmpty(dto.Name)) { list = list.Where(item => item.Name.Contains(dto.Name)); } if (!string.IsNullOrEmpty(dto.Phone)) { list = list.Where(item => item.Phone.Contains(dto.Phone)); } list = list.OrderByDescending(item => item.CreateOperationTime); List <PropertyCompany> resultList = await list.Skip((dto.PageIndex - 1) *dto.PageSize).Take(dto.PageSize).ToListAsync(token); PropertyCompanyForPageDto pagelist = new PropertyCompanyForPageDto { List = resultList, Count = list.Count() }; return(pagelist); } }
public Task <List <PropertyCompany> > GetAllAsync(PropertyCompanyDto dto, CancellationToken token = default) { throw new NotImplementedException(); }