public async Task <IActionResult> GetConsumtionList([FromQuery] PaginationInputBase input) { if (string.IsNullOrEmpty(input.SearchTerm) && string.IsNullOrEmpty(input.OrderBy)) { var waterConsumtionDtos = await waterService.GetWaterConsumptionsTotal(input); var resultPagination = mapper.Map <PaginationSet <WaterConsumtionTotalContract> >(waterConsumtionDtos); return(new OkObjectResult(new ResponseAsObject(resultPagination))); } else if (!string.IsNullOrEmpty(input.SearchTerm) && string.IsNullOrEmpty(input.OrderBy)) { var waterConsumtionDtos = await waterService.GetWaterConsumptionsTotalByDate(input); var resultPagination = mapper.Map <PaginationSet <WaterConsumtionTotalContract> >(waterConsumtionDtos); return(new OkObjectResult(new ResponseAsObject(resultPagination))); } else if (!string.IsNullOrEmpty(input.SearchTerm) && input.OrderBy == "Filter") { var waterConsumtionDtos = await waterService.GetWaterConsumptionsNotExistOnBlockchainTotalByDate(input); var resultPagination = mapper.Map <PaginationSet <WaterConsumtionTotalContract> >(waterConsumtionDtos); return(new OkObjectResult(new ResponseAsObject(resultPagination))); } else { var waterConsumtionDtos = await waterService.GetListWaterNotExistOnBlockchain(input); var resultPagination = mapper.Map <PaginationSet <WaterConsumtionTotalContract> >(waterConsumtionDtos); return(new OkObjectResult(new ResponseAsObject(resultPagination))); } }
public async Task <IActionResult> GetWaterSellingList([FromQuery] PaginationInputBase input) { if (string.IsNullOrEmpty(input.SearchTerm) && string.IsNullOrEmpty(input.OrderBy)) { var waterSellingDtos = await waterService.GetWaterSellingList(input); return(new OkObjectResult(new ResponseAsObject(mapper.Map <PaginationSet <WaterSellingContract> >(waterSellingDtos)))); } else if (!string.IsNullOrEmpty(input.SearchTerm) && string.IsNullOrEmpty(input.OrderBy)) { var waterSellingDtos = await waterService.GetWaterSellingListByDate(input); return(new OkObjectResult(new ResponseAsObject(mapper.Map <PaginationSet <WaterSellingContract> >(waterSellingDtos)))); } else if (!string.IsNullOrEmpty(input.SearchTerm) && input.OrderBy == "Filter") { var waterSellingDtos = await waterService.GetWaterSellingListNotExistOnBlockchainByDate(input); return(new OkObjectResult(new ResponseAsObject(mapper.Map <PaginationSet <WaterSellingContract> >(waterSellingDtos)))); } else { var waterSellingDtos = await waterService.GetWaterSellingListNotExistOnBlockchain(input); return(new OkObjectResult(new ResponseAsObject(mapper.Map <PaginationSet <WaterSellingContract> >(waterSellingDtos)))); } }
public async Task <IActionResult> GetListUserNotExistOnBlockchain([FromQuery] PaginationInputBase input) { var userDtos = await membershipService.GetListUserNotExistOnBlockchain(input); var resultPagination = mapper.Map <PaginationSet <UserContract> >(userDtos); return(new OkObjectResult(new ResponseAsObject(resultPagination))); }
public async Task <PaginationSet <UserDto> > GetAllUsers(PaginationInputBase input) { var users = from aspUsers in dbMemberShip.AspNetUsers join userInfo in dbMemberShip.UserInfo on aspUsers.Id equals userInfo.Id select new UserDto { Id = aspUsers.Id, FullName = aspUsers.UserInfo.FullName, UserName = aspUsers.UserName, Email = aspUsers.Email, Address = aspUsers.UserInfo.Address, Longitude = aspUsers.UserInfo.Longitude, Latitude = aspUsers.UserInfo.Latitude }; var listUser = users.ToList(); for (int i = 0; i < listUser.Count; i++) { var userBlockchain = await dbBlockchain .UserBlockChains .FirstOrDefaultAsync(u => u.Id == listUser[i].Id); if (userBlockchain != null) { listUser[i].isExistedOnNem = true; } else { listUser[i].isExistedOnNem = false; } } int totalCount = await users .CountAsync(); //var items = await users // .Skip(input.PageSize * input.PageIndex) // .Take(input.PageSize) // .ToArrayAsync(); var items = listUser .Skip(input.PageSize * input.PageIndex) .Take(input.PageSize) .ToArray(); return(new PaginationSet <UserDto>() { Items = items, PageIndex = input.PageIndex, PageSize = input.PageSize, TotalCount = totalCount }); }
public async Task <PaginationSet <WaterBuyingDto> > GetWaterBuyingListByDate(PaginationInputBase input) { string searchTerm = string.IsNullOrEmpty(input.SearchTerm) ? "" : input.SearchTerm; var param = new SqlParameter("@BuyTime", searchTerm); var waterBuyingList = dbWater .WaterBuyingViewModels .FromSql("Pro_GetWaterBuyingListByDate @BuyTime", param); var listWaterBuying = mapper.Map <List <WaterBuyingDto> >(waterBuyingList.ToList()); for (int i = 0; i < listWaterBuying.Count; i++) { var waterBuyingBlockchain = await dbBlockchain .WaterBuyingBlockChains .FirstOrDefaultAsync(w => w.Id == listWaterBuying[i].BuyerId && w.BuyTime == DateTime.Parse(listWaterBuying[i].BuyTime)); if (waterBuyingBlockchain != null) { listWaterBuying[i].isExistedOnNem = true; } else { listWaterBuying[i].isExistedOnNem = false; } } int totalCount = await waterBuyingList .CountAsync(); //var items = await waterBuyingList // .Skip(input.PageSize * input.PageIndex) // .Take(input.PageSize) // .ToArrayAsync(); var items = listWaterBuying .Skip(input.PageSize * input.PageIndex) .Take(input.PageSize) .ToArray(); return(new PaginationSet <WaterBuyingDto> { Items = items, PageIndex = input.PageIndex, PageSize = input.PageSize, TotalCount = totalCount }); }
public async Task <PaginationSet <WaterSellingDto> > GetWaterSellingList(PaginationInputBase input) { var waterSellingList = dbWater .WaterSellingViewModels .FromSql("Pro_GetWaterSellingList"); var listWaterSelling = mapper.Map <List <WaterSellingDto> >(waterSellingList.ToList()); for (int i = 0; i < listWaterSelling.Count; i++) { var waterSellingBlockchain = await dbBlockchain .WaterSellingBlockChains .FirstOrDefaultAsync(w => w.Id == listWaterSelling[i].SellerId && w.SellTime == DateTime.Parse(listWaterSelling[i].SellTime)); if (waterSellingBlockchain != null) { listWaterSelling[i].isExistedOnNem = true; } else { listWaterSelling[i].isExistedOnNem = false; } } int totalCount = await waterSellingList .CountAsync(); //var items = await waterSellingList // .Skip(input.PageSize * input.PageIndex) // .Take(input.PageSize) // .ToArrayAsync(); var items = listWaterSelling .Skip(input.PageSize * input.PageIndex) .Take(input.PageSize) .ToArray(); return(new PaginationSet <WaterSellingDto> { Items = items, PageIndex = input.PageIndex, PageSize = input.PageSize, TotalCount = totalCount }); }
public async Task <PaginationSet <WaterConsumtionTotalDto> > GetListWaterNotExistOnBlockchain(PaginationInputBase input) { var waterConsumptions = dbWater .WaterConsumtionTotalViewModels .FromSql("Pro_GetWaterConsumptionsTotal"); var listWaterConsumption = mapper.Map <List <WaterConsumtionTotalDto> >(waterConsumptions.ToList()); List <WaterConsumtionTotalDto> listWaterNotExistOnBlockchain = new List <WaterConsumtionTotalDto>(); for (int i = 0; i < listWaterConsumption.Count; i++) { var waterBlockchain = await dbBlockchain .WaterBlockChains .FirstOrDefaultAsync(w => w.Id == listWaterConsumption[i].UserId && w.LogTime == listWaterConsumption[i].LogTime); if (waterBlockchain == null) { listWaterConsumption[i].isExistedOnNem = false; listWaterNotExistOnBlockchain.Add(listWaterConsumption[i]); } } int totalCount = listWaterNotExistOnBlockchain.Count; var items = listWaterNotExistOnBlockchain .Skip(input.PageSize * input.PageIndex) .Take(input.PageSize) .ToArray(); return(new PaginationSet <WaterConsumtionTotalDto> { Items = items, PageIndex = input.PageIndex, PageSize = input.PageSize, TotalCount = totalCount }); }