public async Task <IEnumerable <SubVariableData> > GetDataFromXlsAsync()
{
_agrigationXlsDescription = _excelImportDataService.CurrentAgrigationXlsDescription;
_currentRegionAgrigationTypeId = _excelImportDataService.CurrentAgrigationXlsDescription.RegionAgrigationTypeId;
_subVariableDataList = new List <SubVariableData>();
SetCurrentWorkSheet();
GetYears();
for (var row = _agrigationXlsDescription.RowBg; row <= _agrigationXlsDescription.RowEnd; row++)
{
try
{
await SetCurrentAttributes(row);
AddSubVariables(row);
}
catch (Exception)
{
// ToDo: log exception
continue;
}
}
return(_subVariableDataList);
}
public void Remove(AgrigationXlsDescription AgrigationXlsDescription)
{
context.Remove(AgrigationXlsDescription);
}
public void Add(AgrigationXlsDescription AgrigationXlsDescription)
{
context.AgrigationXlsDescriptions.Add(AgrigationXlsDescription);
}
