public async Task <IEnumerable <VariableData> > GetDataFromXlsAsync()
{
variableXlsDescription = _excelImportDataService.CurrentVariableXlsDescription;
_variableDataList = new List <VariableData>();
SetCurrentWorkSheet();
GetYears();
var row = variableXlsDescription.RowBg;
do
{
try
{
if (variableXlsDescription.RegionCol > 0)
{
_currentRegionId = await GetRegionIdAsync(row);
if (_currentRegionId == 0)
{
row++;
continue;
}
}
if (variableXlsDescription.ProcessSetCol > 0)
{
_currentProcessSetId = await GetProcessSetIdAsync(row);
}
if (variableXlsDescription.CommodityCol > 0)
{
_currentCommodityId = await GetCommodityIdAsync(row);
}
if (variableXlsDescription.CommoditySetCol > 0)
{
_currentCommoditySetId = await GetCommoditySetIdAsync(row);
}
if (variableXlsDescription.AttributeCol > 0)
{
_currentAttributeId = await GetAttributeIdAsync(row);
}
if (variableXlsDescription.UserConstraintCol > 0)
{
_currentUserConstraintId = await GetUserConstraintIdAsync(row);
}
AddVariables(row);
row++;
}
catch (Exception)
{
// ToDo: log exception
continue;
}
finally {
row++;
}
} while (_currentRegionId > 0);
return(_variableDataList);
}
public void Remove(VariableXlsDescription VariableXlsDescription)
{
context.Remove(VariableXlsDescription);
}
public void Add(VariableXlsDescription VariableXlsDescription)
{
context.VariableXlsDescriptions.Add(VariableXlsDescription);
}
