private string GetItemNo(int categoryId) { //1:获取分类 var category = _categoryRepository.Get(categoryId); //2:获取当前分类下产品的数量 var productCount = _productRepository.Count(u => u.CategoryId.Equals(categoryId)); //3:生成编号 01001 return($"{category.CategoryNo}{(productCount + 1).ToString().PadLeft(4, '0')}"); }
public Task <HomeStatsModel> GetHomeStats() { var developerCount = _userRepository.Count(x => x.RoleId != SetLocaleRole.Developer.Value); var translatorCount = _userRepository.Count(x => x.RoleId == SetLocaleRole.Translator.Value); var keyCount = _wordRepository.Count(); var appCount = _appRepository.Count(); var translationCount = _wordRepository.FindAll().Sum(x => x.TranslationCount); var model = new HomeStatsModel { ApplicationCount = appCount, DeveloperCount = developerCount, TranslatorCount = translatorCount, KeyCount = keyCount, TranslationCount = translationCount }; return(Task.FromResult(model)); }
public static IQueryable <TEntity> Pagination <TEntity>(this IRepository <TEntity> source, int currentPage, int limit, out int rowCount) where TEntity : class { rowCount = source.Count(); return(source.Entity .Skip((currentPage - 1) * limit) .Take(limit) .AsQueryable()); }
public virtual int GetUnreadMessageCount(UserIdentifier sender, UserIdentifier receiver) { using (CurrentUnitOfWork.SetTenantId(receiver.TenantId)) { return(_chatMessageRepository.Count(cm => cm.UserId == receiver.UserId && cm.TargetUserId == sender.UserId && cm.TargetTenantId == sender.TenantId && cm.ReadState == ChatMessageReadState.Unread)); } }
public async Task <List <OrganizationUnitDto> > GetOrganizationUnits() { var units = ObjectMapper.Map <List <OrganizationUnitDto> >(await _organizationUnitManager.FindChildrenAsync(null, true)); foreach (var organizationUnitDto in units) { organizationUnitDto.MemberCount = _userOrgRepository.Count(uou => uou.OrganizationUnitId == organizationUnitDto.Id); } return(units); }
public void Crud_NewObject_Success() { int originalCount = repository.Count(); output.WriteLine($"Total number of sessions before executing CRUD operations is {originalCount}."); // Create. Session original = DataFactory.CreateSession(); Session created = repository.Create(original); output.WriteLine($"Created new session:\n{JsonConvert.SerializeObject(created)}"); Assert.Equal(original.Id, created.Id); // Retrieve single. Session retrieved = repository.Retrieve(created.Id); output.WriteLine($"Retrieved newly created session:\n{JsonConvert.SerializeObject(retrieved)}"); Assert.Equal(created.Id, retrieved.Id); // Update. const string updatedSolutionId = "Sif3Framework2"; retrieved.SolutionId = updatedSolutionId; repository.Update(retrieved); Session updated = repository.Retrieve(retrieved.Id); output.WriteLine( $"Updated the SolutionId of the newly created session to {updatedSolutionId}:\n{JsonConvert.SerializeObject(updated)}"); Assert.Equal(retrieved.Id, updated.Id); Assert.Equal(updatedSolutionId, updated.SolutionId); // Delete. repository.Delete(created); Session deleted = repository.Retrieve(created.Id); output.WriteLine($"Successfully deleted session {created.Id} - {deleted == null}."); Assert.Null(deleted); int currentCount = repository.Count(); output.WriteLine($"Total number of sessions after executing CRUD operation is {currentCount}."); Assert.Equal(originalCount, currentCount); }
public int GetLoginFailedTimes(string userName, DateTime?currentDate) { if (!currentDate.HasValue) { currentDate = DateTime.Now; } var loginSucceedLog = _userlogRepository.Table.Where(x => x.UserName == userName && x.ActivityType == "LOGIN_SUCCEED" && x.DateCreated.Value.Date == currentDate.Value.Date).OrderByDescending(x => x.DateCreated).FirstOrDefault(); return(_userlogRepository.Count(c => c.DateCreated >= loginSucceedLog.DateCreated && c.ActivityType == "LOGIN_FAILED")); }
public RuimapPageResultDto <DeviceOutput> GetPageDevice(int pageIndex = 1, int pageSize = 10) { var count = _deviceInfoTbRepo.Count(); var result = _deviceInfoTbRepo.GetAll().OrderBy(d => d.DeviceCode).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); int currPage = pageIndex; int totalPage = (int)Math.Ceiling(count / (pageSize * 1.0)); return(new RuimapPageResultDto <DeviceOutput>(count, currPage, totalPage, result.MapTo <List <DeviceOutput> >())); }
/// <summary> /// 自动生成订单 /// </summary> /// <returns></returns> private string GenerateOrderNo() { //取消 using (CurrentUnitOfWork.DisableFilter(AbpDataFilters.SoftDelete)) { int curYear = DateTime.Now.Year, curMonth = DateTime.Now.Month; var counts = _orderRepository.Count(u => u.CreationTime.Year.Equals(curYear) && u.CreationTime.Month.Equals(curMonth)); //1:通过日期来 return($"MO{DateTime.Now.ToString("yyyyMM")}{(counts + 1).ToString().PadLeft(5, '0')}"); } }
public void Count_getCountRecord_Integer() { //Arrange _repo = new DataAccessRepository(_context); //Act int data = _repo.Count("DenemeD"); //Assert Assert.IsInstanceOfType(data, typeof(int)); }
public async Task GetOrUpdateTag_TestAsync() { var allTags = _tagRep.GetAllList(); var allTagStrs = allTags.Select(o => o.Name).ToList(); allTagStrs.Add("新标签"); (await _tagService.GetOrCreateTagsAsync(allTagStrs)).Count.ShouldBe(allTagStrs.Count); _tagRep.Count().ShouldBe(allTags.Count + 1); }
public PagedResultDto <PoemDto> GetPagedPoems(PagedResultRequestDto dto) { var count = _poemRepository.Count(); var lst = _poemRepository.GetAllIncluding(c => c.Author).OrderBy(o => o.Id).PageBy(dto).ToList(); return(new PagedResultDto <PoemDto> { TotalCount = count, Items = ObjectMapper.Map <List <PoemDto> >(lst) //lst.MapTo<List<PoemDto>>() }); }
public bool IsSubscribed(UserIdentifier user, string notificationName, string entityTypeName, string entityId) { //关闭多租户查询 using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.MayHaveTenant)) { return(_notificationSubscriptionsRepository.Count(s => s.UserId == user.UserId && s.NotificationName == notificationName ) > 0); } }
public async System.Threading.Tasks.Task <ActionResult> Index(int?pageNumber, int?pageSize, bool?descending) { return(await System.Threading.Tasks.Task.Factory.StartNew <ActionResult>(() => { try { int _pageNumber = 1; int _pageSize = 10; bool _descending = true; if (pageNumber.HasValue) { _pageNumber = pageNumber.Value; } if (pageSize.HasValue) { _pageSize = pageSize.Value; } if (descending.HasValue) { _descending = descending.Value; } int eventsCount = _eventsRepository.Count(); EventsGetAllViewModel vm = new EventsGetAllViewModel { PageCount = (int)Math.Ceiling((double)(eventsCount / _pageSize)), CurrentPage = _pageNumber, Events = new List <EventModel>(), TopNews = _newsRepository.GetAll(5, 1, true) }; IEnumerable <Event> events = _eventsRepository.GetAll(_pageSize, _pageNumber, _descending); foreach (var e in events) { EventModel em = new EventModel(); em.Event = e; em.Game = _gamesRepository.Read(e.GameId); em.Company = _companiesRepository.Read(em.Game.CompanyId); vm.Events.Add(em); } return View(vm); } catch (Exception ex) { _loggingService.Log(ex); return RedirectToRoute(ErrorControllerRoute.GetNotFound); } })); }
public PagedResultDto <AuditInfo> GetAuditLogs(GetAuditLogsInput input) { var query = _auditLogRepository.GetAll(); query = !string.IsNullOrEmpty(input.Sorting) ? query.OrderBy(input.Sorting) : query.OrderByDescending(t => t.ExecutionTime); var count = _auditLogRepository.Count(); var audityLogs = query.PageBy(input).ToList(); return(new PagedResultDto <AuditInfo>(count, audityLogs.MapTo <List <AuditInfo> >())); }
public void UpdateOutgoing(int userId, Outgoing outgoing) { var exist = _outgoingsRepository.Count(o => o.Id == outgoing.Id && o.UserId == userId) == 1 ? true : false; if (!exist) { throw new AppException("Вам нельзя обновить расход!"); } outgoing.UserId = userId; _outgoingsRepository.Update(outgoing); //_outgoingsRepository.Save(); }
/// <summary> /// 获取分页 /// </summary> /// <param name="dto">111</param> /// <returns></returns> public PagedResultDto <PoetDto> GetPagedPoets(PagedResultRequestDto dto) { var count = _poetRepository.Count(); var list = _poetRepository.GetAll().OrderBy(o => o.Id).PageBy(dto).ToList(); return(new PagedResultDto <PoetDto>() { //新版本 AutoMapper直接注入使用 Items = ObjectMapper.Map <List <PoetDto> >(list), TotalCount = count, }); }
/// <summary> /// Gets the total count of the items that can be exported. /// </summary> /// <returns></returns> public override int TotalExportable() { // Check for overriden handler. if (_totalHandler != null) { return(_totalHandler()); } IRepository <T> repo = EntityRegistration.GetRepository <T>(); return(repo.Count()); }
public IActionResult Index() { var usercount = _userRepository.Count(); var topiccount = _topicRepository.Count(); var replycount = _topicReplyRepository.Count(); var allstatistics = new Tuple <int, int, int>(usercount, topiccount, replycount); ViewBag.Statistics = allstatistics; var topics = _topicRepository.GetAll().OrderByDescending(r => r.CreateOn).Take(10).ToList(); return(View(topics)); }
public bool InsertLookUp(LookUp entity) { if (_lookUpRepository.Count( m => m.LookUpType.Equals(entity.LookUpType) && m.LookUpValue.Equals(entity.LookUpValue)) != 0) { return(false); } _lookUpRepository.Add(entity); _unitOfWork.CommitChanges(); return(true); }
public virtual bool IsSubscribed(UserIdentifier user, string notificationName, string entityTypeName, string entityId) { using (_unitOfWorkManager.Current.SetTenantId(user.TenantId)) { return(_notificationSubscriptionRepository.Count(s => s.UserId == user.UserId && s.NotificationName == notificationName && s.EntityTypeName == entityTypeName && s.EntityId == entityId ) > 0); } }
public PagedResultDto <PoetDto> GetPagedPoets(PagedResultRequestDto dto) { var count = _poetRepository.Count(); var lst = _poetRepository.OrderBy(o => o.Id).PageBy(dto).ToList(); var items = new List <PoetDto>(); return(new PagedResultDto <PoetDto> { TotalCount = count, Items = ObjectMapper.Map <List <Poet>, List <PoetDto> >(lst) }); }
public RuimapPageResultDto <MessageNoteOutput> GetPageMessageNote(string title = "", int flag = 9, string reporterId = "", int pageIndex = 1, int pageSize = 9999) { int count = 0; List <MessageNoteTb> result = new List <MessageNoteTb>(); if (flag == 9) { count = _messageNoteRepo.Count(m => m.Title.Contains(title) && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId))); result = _messageNoteRepo.GetAll().Where(m => m.Title.Contains(title) && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId))).OrderByDescending(m => m.Date).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); } else { count = _messageNoteRepo.Count(m => m.Title.Contains(title) && m.Flag == flag && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId))); result = _messageNoteRepo.GetAll().Where(m => m.Title.Contains(title) && m.Flag == flag && m.ToReporter.Any(r => r.Id.ToString().Contains(reporterId))).OrderByDescending(m => m.Date).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); } int currPage = pageIndex; int totalPage = (int)Math.Ceiling(count / (pageSize * 1.0)); return(new RuimapPageResultDto <MessageNoteOutput>(count, currPage, totalPage, result.MapTo <List <MessageNoteOutput> >())); }
public async Task <string> Index() { var student = await _studentRepository.GetAll().FirstOrDefaultAsync(); var oop = await _studentRepository.SingleAsync(a => a.Id == 2009); var longCount = await _studentRepository.LongCountAsync(); var count = _studentRepository.Count(); return($"{oop.Name}+{student.Name}+{longCount}+{count}"); }
public void TestSaveId() { IRepository <Apple> repository = Injector.Resolve <IRepository <Apple> >(); repository.Save(new Apple { Id = 12, Type = "Elstar" }); Assert.AreEqual(2, repository.Count()); Assert.AreEqual(12, repository.FindAll()[1].Id); Assert.AreEqual("Elstar", repository.FindAll()[1].Type); }
public void GetTest() { Assert.Equal(3, repository.Count()); var allWords = repository.GetAll(); Assert.Contains(allWords, w => w.Name == "school"); Assert.DoesNotContain(allWords, w => w.Name == "school2"); Assert.Equal(2, repository.GetPagedAll(0, 2).Count); Assert.Equal(1, repository.GetPagedAll(1, 2).Count); }
/// <summary> /// 按时间分类数据 /// </summary> /// <returns></returns> public List <ReportFormsDto> GetReportFormsByTime(string StartTime, string EndTime, string AnomalyGrade, string AnomalyType, string MonitorRoom) { dVRCameraRepairlist(); List <ReportFormsDto> listreportForms = new List <ReportFormsDto>(); List <DateTime> timelist = new List <DateTime>(); DateTime dateTimeStart = DateTime.Parse(StartTime); DateTime dateTimeEnd = DateTime.Parse(EndTime); for (int i = 0; dateTimeStart.Day + i < dateTimeEnd.Day; i++) { timelist.Add(dateTimeStart.AddDays(i)); } if (!string.IsNullOrEmpty(AnomalyGrade)) { listDVRCameraRepair = listDVRCameraRepair.Where(u => u.AnomalyGrade.Contains(AnomalyGrade)); } if (!string.IsNullOrEmpty(AnomalyType)) { listDVRCameraRepair = listDVRCameraRepair.Where(u => u.AnomalyType.Contains(AnomalyType)); } if (!string.IsNullOrEmpty(MonitorRoom)) { listDVRCameraRepair = listDVRCameraRepair.Where(r => r.DVR_Room != null).Where(u => u.DVR_Room.Contains(MonitorRoom)); } foreach (var item in timelist) { ReportFormsDto formsDto = new ReportFormsDto(); formsDto.install_time = item.ToString("yyyy-MM-dd"); //加载异常数量 formsDto.CameraAnomaly = listDVRCameraRepair.Where(u => u.CollectTime.Contains(item.ToString("yyyy-MM-dd"))).Count(); //加载维修数据 formsDto.RepairTotal = listDVRCameraRepair.Where(u => u.RepairedTime.Contains(item.ToString("yyyy-MM-dd"))).Count(); //异常+维修总数 formsDto.CameraAnomalyRepair = formsDto.CameraAnomaly + formsDto.RepairTotal; formsDto.CameraTotal = _camerarepository.Count(); listreportForms.Add(formsDto); } return(listreportForms); }
public async Task <Machine> CreateMachine(Machine machine) { //load any default configuration that will be retrieved from the machine. await LoadConfiguration(machine); //The new machine will be added to the end of the list machine.SortIndex = _machines.Count() + 1; //if the configuration is updated with data from the machine then store the configuration. _machines.Create(machine); return(machine); }
public void Sweep() { var peddingTaskCount = _repository.Count(x => x.ScheduledUtc > _clock.UtcNow && x.TaskType == "ResetSite" || x.ScheduledUtc > _clock.UtcNow && x.TaskType == "SwitchTheme"); if (peddingTaskCount == 0) { _themeService.EnableThemeFeatures("Mooncake"); _siteThemeService.SetSiteTheme("Mooncake"); _scheduledTaskManager.CreateTask("SwitchTheme", _clock.UtcNow.AddMinutes(29), null); _scheduledTaskManager.CreateTask("ResetSite", _clock.UtcNow.AddMinutes(30), null); } }
public int GetUserNotificationCount(UserIdentifier user, UserNotificationState?state = null, DateTime?startDate = null, DateTime?endDate = null) { //关闭多租户查询 using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.MayHaveTenant)) { return(_userNotificationInfoRepository.Count(un => un.UserId == user.UserId && (state == null || un.State == state.Value) && (startDate == null || un.CreationTime >= startDate.Value) && (endDate == null || un.CreationTime <= endDate.Value) )); } }
public void Count_With_Predicate_Should_Return_Count(IRepository<Contact, string> repository) { for (var i = 1; i <= 3; i++) { var contact = new Contact { Name = "Test User " + i, ContactTypeId =1}; repository.Add(contact); } for (var i = 4; i <= 7; i++) { var contact = new Contact { Name = "Test User " + i, ContactTypeId = 2}; repository.Add(contact); } repository.Count(x => x.ContactTypeId == 2).ShouldEqual(4); }
public void Count_Should_Return_All_Count(IRepository<Contact, string> repository) { for (var i = 1; i <= 3; i++) { var contact = new Contact { Name = "Test User " + i, ContactTypeId =1}; repository.Add(contact); } for (var i = 4; i <= 7; i++) { var contact = new Contact { Name = "Test User " + i, ContactTypeId = 2}; repository.Add(contact); } repository.Count().ShouldEqual(7); }