コード例 #1
0
        private static async Task <string> RemovePitstopImagesFromBlob(PitstopTableEntity pitstop, CloudBlobContainer container)
        {
            string smallImageName  = pitstop.PhotoSmallUrl;
            string mediumImageName = pitstop.PhotoMediumUrl;
            string largeImageName  = pitstop.PhotoLargeUrl;

            CloudBlockBlob smallImage  = container.GetBlockBlobReference(smallImageName);
            CloudBlockBlob mediumImage = container.GetBlockBlobReference(mediumImageName);
            CloudBlockBlob largeImage  = container.GetBlockBlobReference(largeImageName);

            using (var deleteStream = await smallImage.OpenReadAsync()) { }
            await smallImage.DeleteIfExistsAsync();

            using (var deleteStream = await mediumImage.OpenReadAsync()) { }
            await mediumImage.DeleteIfExistsAsync();

            using (var deleteStream = await largeImage.OpenReadAsync()) { }
            await largeImage.DeleteIfExistsAsync();

            return($"Deleted images {smallImageName}, {mediumImageName} and {largeImageName}");
        }
コード例 #2
0
        public async Task <ActionResult <string> > PostPitstop(NewPitstop newPitstop)
        {
            string UserID = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.NameIdentifier).Value;
            //string UserID = "666";

            List <Pitstop> pitstopList = new List <Pitstop>();

            var tripList = new List <TripTableEntity>();

            //TripEntity from trip table
            var tripQuery = new TableQuery <TripTableEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, UserID));
            TableContinuationToken tokenTrip = null;

            do
            {
                TableQuerySegment <TripTableEntity> resultSegment = await _tableTrip.ExecuteQuerySegmentedAsync(tripQuery, tokenTrip);

                tokenTrip = resultSegment.ContinuationToken;

                foreach (TripTableEntity entity in resultSegment.Results)
                {
                    tripList.Add(entity);
                }
            } while (tokenTrip != null);

            //Get pitstops
            List <PitstopTableEntity> pitstopList2 = new List <PitstopTableEntity>();

            TableQuery <PitstopTableEntity> pitstopQuery = new TableQuery <PitstopTableEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, newPitstop.TripId.ToString() + ";" + UserID));

            TableContinuationToken tokenPitstop = null;

            do
            {
                TableQuerySegment <PitstopTableEntity> resultSegment = await _tablePitstop.ExecuteQuerySegmentedAsync(pitstopQuery, tokenPitstop);

                tokenPitstop = resultSegment.ContinuationToken;

                foreach (PitstopTableEntity entity in resultSegment.Results)
                {
                    pitstopList2.Add(entity);
                }
            } while (tokenPitstop != null);

            //Check if trip exists in trip table (if not return not found)
            if (tripList.Where(a => a.TripId == newPitstop.TripId).Count() != 0)
            {
                var nextPitsop = 1;

                if (pitstopList2.Count != 0)
                {
                    nextPitsop = pitstopList2.Select(a => a.PitstopId).Max() + 1;
                }

                string photoName = await StorePicture(newPitstop.picture);

                Pitstop pitstop = new Pitstop();

                pitstop.PersonId    = UserID;
                pitstop.PitstopId   = nextPitsop;
                pitstop.Title       = newPitstop.Title;
                pitstop.Note        = newPitstop.Note;
                pitstop.PitstopDate = newPitstop.PitstopDate;
                if (pitstop.PitstopDate.Year.Equals(0001))
                {
                    pitstop.PitstopDate = DateTime.Now;
                }
                pitstop.PhotoLargeUrl   = photoName;    // will be replaced with the url to the resized image.
                pitstop.PhotoMediumUrl  = string.Empty; // will be updated when the image has been resized.
                pitstop.PhotoSmallUrl   = string.Empty; // will be updated when the image has been resized.
                pitstop.TripId          = newPitstop.TripId;
                pitstop.pitstopPosition = newPitstop.pitstopPosition;
                pitstop.Address         = newPitstop.Address;

                PitstopTableEntity pitstopTable = new PitstopTableEntity(pitstop);

                TableOperation insertOperation = TableOperation.Insert(pitstopTable);

                await _tablePitstop.ExecuteAsync(insertOperation);

                await AddQueueItem(new QueueParam { PartitionKey = pitstopTable.PartitionKey, RowKey = pitstopTable.RowKey, PictureUri = photoName });

                return(Ok($"Pitstop created under trip {pitstop.TripId}, id: {pitstop.PitstopId}"));
            }
            return(NotFound());
        }