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();
}
}
