public async Task <HttpResponseMessage> GetSpreadsheet([FromBody] RequestModel request)
{
Guid testOutput;
if (string.IsNullOrWhiteSpace(request.guid) || !Guid.TryParse(request.guid.TrimStart('t'), out testOutput))
{
throw new System.Exception("Invalid GUID");
}
// authenticate with Forge
dynamic oauth = await Get2LeggedTokenAsync(new Scope[] { Scope.DataRead });
// get object on the bucket, should be just 1
ObjectsApi objects = new ObjectsApi();
objects.Configuration.AccessToken = oauth.access_token;
dynamic objectsInBucket = await objects.GetObjectsAsync(request.guid);
string objectId = string.Empty;
string objectKey = string.Empty;
foreach (KeyValuePair <string, dynamic> objInfo in new DynamicDictionaryItems(objectsInBucket.items))
{
objectId = objInfo.Value.objectId;
objectKey = objInfo.Value.objectKey;
}
string xlsFileName = objectKey.Replace(".rvt", ".xls");
var xlsPath = Path.Combine(HttpContext.Current.Server.MapPath("~/App_Data"), request.guid, xlsFileName);
if (File.Exists(xlsPath))
{
return(SendFile(xlsPath));// if the Excel file was already generated
}
DerivativesApi derivative = new DerivativesApi();
derivative.Configuration.AccessToken = oauth.access_token;
// get the derivative metadata
dynamic metadata = await derivative.GetMetadataAsync(objectId.Base64Encode());
foreach (KeyValuePair <string, dynamic> metadataItem in new DynamicDictionaryItems(metadata.data.metadata))
{
dynamic hierarchy = await derivative.GetModelviewMetadataAsync(objectId.Base64Encode(), metadataItem.Value.guid);
dynamic properties = await derivative.GetModelviewPropertiesAsync(objectId.Base64Encode(), metadataItem.Value.guid);
Workbook xls = new Workbook();
foreach (KeyValuePair <string, dynamic> categoryOfElements in new DynamicDictionaryItems(hierarchy.data.objects[0].objects))
{
string name = categoryOfElements.Value.name;
Worksheet sheet = new Worksheet(name);
for (int i = 0; i < 100; i++)
{
sheet.Cells[i, 0] = new Cell(""); // unless we have at least 100 cells filled, Excel understand this file as corrupted
}
List <long> ids = GetAllElements(categoryOfElements.Value.objects);
int row = 1;
foreach (long id in ids)
{
Dictionary <string, object> props = GetProperties(id, properties);
int collumn = 0;
foreach (KeyValuePair <string, object> prop in props)
{
sheet.Cells[0, collumn] = new Cell(prop.Key.ToString());
sheet.Cells[row, collumn] = new Cell(prop.Value.ToString());
collumn++;
}
row++;
}
xls.Worksheets.Add(sheet);
}
xls.Save(xlsPath);
}
return(SendFile(xlsPath));
}
public async Task ExcelObject([FromBody] ObjectModel objModel)
{
// authenticate with Forge Must have data read scope
dynamic oauth = await OAuthController.GetInternalAsync();
// get the user selected object
ObjectsApi objects = new ObjectsApi();
objects.Configuration.AccessToken = oauth.access_token;
dynamic selectedObject = await objects.GetObjectDetailsAsync(objModel.bucketKey, objModel.objectName);
string objectId = selectedObject.objectId;
string objectKey = selectedObject.objectKey;
string xlsFileName = objectKey.Replace(".rvt", ".xls");
var xlsPath = Path.Combine(HttpContext.Current.Server.MapPath("~/App_Data"), objModel.bucketKey, xlsFileName);//.guid, xlsFileName);
///////////if (File.Exists(xlsPath))
/////////// return SendFile(xlsPath);// if the Excel file was already generated
DerivativesApi derivative = new DerivativesApi();
derivative.Configuration.AccessToken = oauth.access_token;
// get the derivative metadata
dynamic metadata = await derivative.GetMetadataAsync(objectId.Base64Encode());
foreach (KeyValuePair <string, dynamic> metadataItem in new DynamicDictionaryItems(metadata.data.metadata))
{
dynamic hierarchy = await derivative.GetModelviewMetadataAsync(objectId.Base64Encode(), metadataItem.Value.guid);
dynamic properties = await derivative.GetModelviewPropertiesAsync(objectId.Base64Encode(), metadataItem.Value.guid);
Workbook xls = new Workbook();
foreach (KeyValuePair <string, dynamic> categoryOfElements in new DynamicDictionaryItems(hierarchy.data.objects[0].objects))
{
string name = categoryOfElements.Value.name;
Worksheet sheet = new Worksheet(name);
for (int i = 0; i < 100; i++)
{
sheet.Cells[i, 0] = new Cell(""); // unless we have at least 100 cells filled, Excel understand this file as corrupted
}
List <long> ids = GetAllElements(categoryOfElements.Value.objects);
int row = 1;
foreach (long id in ids)
{
Dictionary <string, object> props = GetProperties(id, properties);
int collumn = 0;
foreach (KeyValuePair <string, object> prop in props)
{
sheet.Cells[0, collumn] = new Cell(prop.Key.ToString());
sheet.Cells[row, collumn] = new Cell(prop.Value.ToString());
collumn++;
}
row++;
}
xls.Worksheets.Add(sheet);
}
//Where to save the excel file
string pathUser = Environment.GetFolderPath(Environment.SpecialFolder.UserProfile);
string pathDownload = Path.Combine(pathUser, "Downloads", xlsFileName);
//try catch save the file to the relevant place
try
{
var fstream = new System.IO.FileStream(pathDownload, FileMode.CreateNew);
xls.SaveToStream(fstream);
}
catch (Exception e)
{
Debug.Print("Exception when calling ObjectsApi.DownloadObject: " + e.Message);
}
}
//No need to return anything
//return SendFile(xlsPath);
}
