private async Task SetCurrentSubVariableId(string subVariableName) { var subVariable = await _subVariableRepository.GetSubVariable(subVariableName); if (subVariable == null) { subVariable = new SubVariable { Name = subVariableName }; _subVariableRepository.Add(subVariable); await _unitOfWork.CompleteAsync(); } CurrentSubVariableId = subVariable.Id; }
protected async Task SetCurrentSubVariableId(int currentRow, int subVariableCol, string currentRangePref = "") { var subVariableVal = CurrentWorkSheet.Cells[currentRow, subVariableCol].Value; if (subVariableVal == null) { CurrentSubVariableId = 0; } var subVariableName = !string.IsNullOrEmpty(currentRangePref) ? $"{currentRangePref} - {subVariableVal.ToString()}" : subVariableVal.ToString(); var subVariable = await _subVariableRepository.GetSubVariable(subVariableName); if (subVariable == null) { subVariable = new SubVariable { Name = subVariableName }; _subVariableRepository.Add(subVariable); await _unitOfWork.CompleteAsync(); } CurrentSubVariableId = subVariable.Id; }