public void Run() { int imageCount = 0; CloudStorageAccount _storageAccount = CloudStorageAccountProvider.getCloudStorageAccount(); SqlConnection dbCon = WorkspaceProvider.GetWorkspaceContext(_rule); dbCon.Open(); for (int i = _assetArray.Length; i > 0; i--) { String assetType = _assetArray[i]; CloudFileDirectory assetDir = CloudStorageAccountProvider.getAssetDir(_storageAccount, _userName, assetType); SqlCommand command = GetAssetSQLQuery(dbCon, _userName, assetType); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { imageCount++; String imageId = reader.GetInt64(0).ToString(); String imageString = reader.GetString(1); if (imageString.StartsWith("data:image/png;base64,")) { imageString = imageString.Replace("data:image/png;base64,", ""); } if (imageString.StartsWith("data:image/jpeg;base64,")) { imageString = imageString.Replace("data:image/jpeg;base64,", ""); } byte[] imageBytes = Convert.FromBase64String(imageString); CloudFile assetImage = assetDir.GetFileReference(imageId + ".png"); assetImage.UploadFromByteArray(imageBytes, 0, imageBytes.Length); Console.WriteLine(assetImage.Uri.LocalPath); } } Console.WriteLine("Image Count: " + imageCount); }
public void Run() { SqlConnection dbCon = WorkspaceProvider.GetWorkspaceContext(_rule); SqlCommand sqlCommand = new SqlCommand("Delete from Workspace Where UserId = " + MangerUtils.Quotes(_userName), dbCon); Console.WriteLine("User Assets Deleted: " + sqlCommand.ExecuteNonQuery().ToString()); dbCon.Close(); if (_deleteAccount) { dbCon = MembershipProvider.GetMembershipContext(_rule); sqlCommand = new SqlCommand("Delete from AspNetUsers Where Email = " + MangerUtils.Quotes(_userName), dbCon); Console.WriteLine("Users Records Deleted: " + sqlCommand.ExecuteNonQuery().ToString()); dbCon.Close(); } }