using System;
using System.Collections.Generic;
using System.IO;
using System.Threading.Tasks;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.File;
using Microsoft.WindowsAzure.Storage.StorageException;
#File
class WriteCSVFileInAzureFileStorage
{
Dynamics.AX.Application.Exception exception;
public static void main(Args _args)
{
CommaStreamIo io = CommaStreamIo::constructForWrite();
str
fileName = 'Cust_DE.csv',
fileContent;
CustTable
custTable;
// Write header
io.writeExp(['Customer', 'Account number', 'Currency', 'DataAreaId']);
// Write line
while select custTable
where custTable.DataAreaId
== 'USMF'
{
io.writeExp([custTable.name(),
custTable.AccountNum,
custTable.Currency,
custTable.DataAreaId]);
}
// Set stream
System.IO.Stream stream =
io.getStream();
stream.Position = 0;
// Set stream reader
System.IO.StreamReader sReader = new System.IO.StreamReader(stream);
// Set file contentn
string
fileContent = sReader.ReadToEnd();
//// Save file
//File::SendStringAsFileToUser(fileContent,
fileName);
Dynamics.AX.Application.Exception exception;
infolog.add(exception::Info, "Azure Storage File Sample");
WriteCSVFileInAzureFileStorage
writeCSVFileInAzureFileStorage = new WriteCSVFileInAzureFileStorage();
WriteCSVFileInAzureFileStorage::BasicAzureFileOperations(fileContent,fileName);
}
private static void
BasicAzureFileOperations(str _fileContent,str _fileName)
{
//const str DemoShare
= "democsvfileshare";
const str DemoShare = "agreementfileshare";
//const str
DemoDirectory = "DemocsvFileDirectory";
const str DemoDirectory = "AgreementcsvFileDirectory";
//const str DemoFile =
"demofile";
// const str
ImageToUpload = @'C:\Users\Usere4627ee6be0\Desktop\VS error.PNG';
//"HelloWorld.png";
str FileContents =
_fileContent;
str fileName = _fileName;
Dynamics.AX.Application.Exception exception;
StorageException storageException = new Microsoft.WindowsAzure.Storage.StorageException();
// Retrieve storage
account information
Microsoft.WindowsAzure.Storage.Auth.StorageCredentials storageCredentials = new
Microsoft.WindowsAzure.Storage.Auth.StorageCredentials('siyedev813pu23e0d5d398f4', 'k03yWIis7PV3yIIUNxXKseUQZ7GSQMW3Ch0Ri2vAGmWVbov/dcj/7mzjpbAYrwA46LSuvKOWZKyBpA60B+zXpA==');
Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = new
Microsoft.WindowsAzure.Storage.CloudStorageAccount(storageCredentials, true);
// Create a file
client for interacting with the file service.
CloudFileClient fileClient = storageAccount.CreateCloudFileClient();
// Create a share for
organizing files and directories within the storage account.
CloudFileShare share = fileClient.GetShareReference(DemoShare);
try
{
share.CreateIfNotExistsAsync();
}
catch (storageException)
{
infolog.add(exception::Error, "Unable to connect to Azure File Storage");
throw exception::Error;
}
// Get a reference to
the root directory of the share.
CloudFileDirectory root = share.GetRootDirectoryReference();
// Create a directory
under the root directory
CloudFileDirectory dir = root.GetDirectoryReference(DemoDirectory);
dir.CreateIfNotExistsAsync();
// Creating a new file
in the directory created above and writing contents to the file
// Also delete if
exists
CloudFile file = dir.GetFileReference(fileName);
file.DeleteIfExistsAsync();
file.UploadTextAsync(FileContents);
// Uploading a local
file to the directory created above
//CloudFile file =
dir.GetFileReference(ImageToUpload);
//file.UploadFromFileAsync(ImageToUpload,
System.IO.FileMode::Open);
}
}
