| public CreateFile ( long datasetId, long datasetVersionOrderNr, long dataStructureId, string title, string extention ) : string | ||
| datasetId | long | |
| datasetVersionOrderNr | long | |
| dataStructureId | long | |
| title | string | |
| extention | string | |
| Результат | string | |
/// <summary>
/// create a new file of given extension
/// ns will be used to seperate from other files created of individual datasets
/// </summary>
/// <param name="ns">namespace</param>
/// <param name="title"></param>
/// <param name="ext"></param>
/// <param name="writer"></param>
/// <returns></returns>
private string createDownloadFile(string ns, long datastructureId, string title, string ext, DataWriter writer, string[] columns = null)
{
ExcelWriter excelwriter = null;
switch (ext)
{
// text based files
case ".csv":
case ".txt":
case ".tsv":
AsciiWriter asciiwriter = (AsciiWriter)writer;
return(asciiwriter.CreateFile(ns, title, ext));
// excel files
case ".xlsx":
excelwriter = (ExcelWriter)writer;
return(excelwriter.CreateFile(ns, datastructureId, title, ext));
case ".xlsm":
excelwriter = (ExcelWriter)writer;
excelwriter.VisibleColumns = columns;
return(excelwriter.CreateFile(ns, datastructureId, title, ext));
// no valid extension given
default:
return("");
}
}
private string createDownloadFile(long id, long datasetVersionOrderNo, long dataStructureId, string title, string ext, DataWriter writer, string[] columns = null, bool withUnits = false)
{
string addtionalFileNameExt = "";
if (withUnits)
{
addtionalFileNameExt = "_withunits";
}
string filename = "data" + addtionalFileNameExt;
if (ext.Equals(".csv") || ext.Equals(".txt") || ext.Equals(".tsv"))
{
AsciiWriter asciiwriter = (AsciiWriter)writer;
return(asciiwriter.CreateFile(id, datasetVersionOrderNo, dataStructureId, filename, ext));
}
else
if (ext.Equals(".xlsm"))
{
ExcelWriter excelwriter = (ExcelWriter)writer;
excelwriter.VisibleColumns = columns;
return(excelwriter.CreateFile(id, datasetVersionOrderNo, dataStructureId, filename, ext));
}
else
if (ext.Equals(".xlsx"))
{
ExcelWriter excelwriter = (ExcelWriter)writer;
return(excelwriter.CreateFile(id, datasetVersionOrderNo, dataStructureId, filename, ext));
}
return("");
}
private string generateDownloadFile(long id, long datasetVersionOrderNo, long dataStructureId, string title, string ext, DataWriter writer)
{
if (ext.Equals(".csv") || ext.Equals(".txt"))
{
AsciiWriter asciiwriter = (AsciiWriter)writer;
return(asciiwriter.CreateFile(id, datasetVersionOrderNo, dataStructureId, "data", ext));
}
else
if (ext.Equals(".xlsm"))
{
ExcelWriter excelwriter = (ExcelWriter)writer;
return(excelwriter.CreateFile(id, datasetVersionOrderNo, dataStructureId, "data", ext));
}
return("");
}
/// <summary>
/// create a new file of given extension
/// ns will be used to seperate from other files created of individual datasets
/// </summary>
/// <param name="ns">namespace</param>
/// <param name="title"></param>
/// <param name="ext"></param>
/// <param name="writer"></param>
/// <returns></returns>
private string generateDownloadFile(string ns, long datastructureId, string title, string ext, DataWriter writer)
{
switch (ext)
{
// text based files
case ".csv":
case ".txt":
AsciiWriter asciiwriter = (AsciiWriter)writer;
return(asciiwriter.CreateFile(ns, title, ext));
// excel files
case ".xlsx":
case ".xlsm":
ExcelWriter excelwriter = (ExcelWriter)writer;
return(excelwriter.CreateFile(ns, datastructureId, title, ext));
// no valid extension given
default:
return("");
}
}
private string GenerateDownloadFile(DatasetVersion datasetVersion)
{
TaskManager TaskManager = (TaskManager)Session["TaskManager"];
//dataset id and data structure id are available via datasetVersion properties,why you are passing them via the BUS? Javad
long datasetId = Convert.ToInt64(TaskManager.Bus[TaskManager.DATASET_ID]);
long dataStructureId = Convert.ToInt64(TaskManager.Bus[TaskManager.DATASTRUCTURE_ID]);
DatasetManager datasetManager = new DatasetManager();
string title = TaskManager.Bus[TaskManager.DATASET_TITLE].ToString();
string ext = ".xlsm";// TaskManager.Bus[TaskManager.EXTENTION].ToString();
ExcelWriter excelWriter = new ExcelWriter();
// create the generated file and determine its location
string path = excelWriter.CreateFile(datasetId, datasetVersion.VersionNo, dataStructureId, title, ext);
string dynamicPath = excelWriter.GetDynamicStorePath(datasetId, datasetVersion.VersionNo, title, ext);
//Register the generated data file as a resource of the current dataset version
ContentDescriptor generatedDescriptor = new ContentDescriptor()
{
OrderNo = 1,
Name = "generated",
MimeType = "application/xlsm",
URI = dynamicPath,
DatasetVersion = datasetVersion,
};
if (datasetVersion.ContentDescriptors.Count(p => p.Name.Equals(generatedDescriptor.Name)) > 0)
{ // remove the one contentdesciptor
foreach (ContentDescriptor cd in datasetVersion.ContentDescriptors)
{
if (cd.Name == generatedDescriptor.Name)
{
cd.URI = generatedDescriptor.URI;
}
}
}
else
{
// add current contentdesciptor to list
datasetVersion.ContentDescriptors.Add(generatedDescriptor);
}
// note: the descriptors are not persisted yet, they will be persisted if the caller of this method persists the datasetVersion object.
return path;
}
