/// <summary>
/// Gets the mappings for the specified entity and worksheet
/// </summary>
/// <returns></returns>
public Message GetEntityMappings()
{
Message responseMsg = null;
ImportUtilities importUtility = new ImportUtilities();
SPDataAccess spDataAccess = new SPDataAccess();
MappedColumns mappedColumns = new MappedColumns();
WorksheetUtilities worksheetUtilities = new WorksheetUtilities(spDataAccess);
MappingData mappingData = this.ValidateRequest(spDataAccess, false);
// get the columns from the supplied worksheet
mappedColumns.WSColumns = worksheetUtilities.GetWorksheetColumns(mappingData);
// checks to see if the columns pulled from sheet map to
// a predefined template e.g. Bulk Import or Goals Export
mappedColumns.TemplateType = ImportUtilities.GetImportTemplateType(mappedColumns.WSColumns);
// get the entity columns with the default values for choice columns
mappedColumns.ColumnDefinitions = importUtility.GetEntityColumnDefaultValues(spDataAccess, mappingData.ListName);
responseMsg = ctx.CreateJsonResponse <MappedColumns>(mappedColumns);
return(responseMsg);
}
/// <summary>
/// Default Ctor
/// </summary>
/// <param name="worksheetUtilities"></param>
/// <param name="spDataAccess"></param>
public SheetImport(WorksheetUtilities worksheetUtilities, SPDataAccess spDataAccess)
{
this.worksheetUtilities = worksheetUtilities;
this.spDataAccess = spDataAccess;
this.domainManager = new DomainManager();
this.domainManager.SetCurrentUser();
// sets default 'storage' library
// uploaded documents are saved here by default
this.libraryName = DOCUMENT_UPLOAD_LIBRARY;
}
/// <summary>
/// Get list of worksheets in the specified file
/// </summary>
/// <param name="fileName"></param>
public Message GetSheets(string listName, string fileName)
{
Message responseMsg = null;
SPDataAccess spDataAccess = new SPDataAccess();
WorksheetUtilities worksheetUtilities = new WorksheetUtilities(new SPDataAccess());
List <string> worksheets = worksheetUtilities.GetWorksheetNames(listName, fileName);
responseMsg = ctx.CreateJsonResponse <List <string> >(worksheets);
return(responseMsg);
}
public void Generate <T>(IEnumerable <T> records, IEnumerable <String> fieldsExcluded = null, String name = "Foglio 1")
{
File = WorksheetUtilities.CreateGenericReport <T>(records, fieldsExcluded, name);
}
