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); }