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