public void ShouldReturnSameInstanceOfIntParserWhenCalledTwice()
{
var parsers = new ArgumentParsers();
var parser1 = parsers.GetParser(DataType.Integer);
var parser2 = parsers.GetParser(DataType.Integer);
Assert.AreEqual(parser1, parser2);
}
public LookupArguments(IEnumerable <FunctionArgument> arguments, ArgumentParsers argumentParsers)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
RangeAddress = arguments.ElementAt(1).Value.ToString();
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(arguments.ElementAt(2).Value);
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
}
public LookupArguments(IEnumerable<FunctionArgument> arguments, ArgumentParsers argumentParsers)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
RangeAddress = arguments.ElementAt(1).Value.ToString();
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(arguments.ElementAt(2).Value);
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
}
public LookupArguments(IEnumerable <FunctionArgument> arguments, ArgumentParsers argumentParsers, ParsingContext context)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
var arg1 = arguments.ElementAt(1).Value;
var dataArray = arg1 as IEnumerable <FunctionArgument>;
if (dataArray != null)
{
DataArray = dataArray;
ArgumentDataType = LookupArgumentDataType.DataArray;
}
else
{
//if (arg1 is ExcelDataProvider.INameInfo) arg1 = ((ExcelDataProvider.INameInfo) arg1).Value;
var rangeInfo = arg1 as ExcelDataProvider.IRangeInfo;
if (rangeInfo != null)
{
RangeAddress = string.IsNullOrEmpty(rangeInfo.Address.WorkSheet) ? rangeInfo.Address.Address : "'" + rangeInfo.Address.WorkSheet + "'!" + rangeInfo.Address.Address;
RangeInfo = rangeInfo;
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
else
{
RangeAddress = arg1.ToString();
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
}
var indexVal = arguments.ElementAt(2);
if (indexVal.DataType == DataType.Enumerable)
{
var rangeInfo = indexVal.ValueAsRangeInfo;
var address = rangeInfo?.Address ?? throw new InvalidOperationException("Value does not match declared type.");
var indexObj = context.ExcelDataProvider.GetRangeValue(address.WorkSheet ?? context.Scopes.Current.Address.Worksheet, address._fromRow, address._fromCol);
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(indexObj);
}
else
{
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(indexVal.Value);
}
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
else
{
RangeLookup = true;
}
}
public LookupArguments(IEnumerable <FunctionArgument> arguments, ArgumentParsers argumentParsers, ParsingContext context)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
var arg1 = arguments.ElementAt(1).Value;
var dataArray = arg1 as IEnumerable <FunctionArgument>;
if (dataArray != null)
{
DataArray = dataArray;
ArgumentDataType = LookupArgumentDataType.DataArray;
}
else
{
//if (arg1 is ExcelDataProvider.INameInfo) arg1 = ((ExcelDataProvider.INameInfo) arg1).Value;
var rangeInfo = arg1 as ExcelDataProvider.IRangeInfo;
if (rangeInfo != null)
{
RangeAddress = string.IsNullOrEmpty(rangeInfo.Address.WorkSheetName) ? rangeInfo.Address.Address : "'" + rangeInfo.Address.WorkSheetName + "'!" + rangeInfo.Address.Address;
RangeInfo = rangeInfo;
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
else
{
RangeAddress = arg1.ToString();
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
}
var indexVal = arguments.ElementAt(2);
if (indexVal.DataType == DataType.ExcelAddress)
{
var address = new ExcelAddress(indexVal.Value.ToString());
var indexObj = context.ExcelDataProvider.GetRangeValue(address.WorkSheetName, address._fromRow, address._fromCol);
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(indexObj);
}
else
{
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(arguments.ElementAt(2).Value);
}
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
else
{
RangeLookup = true;
}
}
public LookupArguments(IEnumerable<FunctionArgument> arguments, ArgumentParsers argumentParsers, ParsingContext context)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
var arg1 = arguments.ElementAt(1).Value;
var dataArray = arg1 as IEnumerable<FunctionArgument>;
if (dataArray != null)
{
DataArray = dataArray;
ArgumentDataType = LookupArgumentDataType.DataArray;
}
else
{
//if (arg1 is ExcelDataProvider.INameInfo) arg1 = ((ExcelDataProvider.INameInfo) arg1).Value;
var rangeInfo = arg1 as ExcelDataProvider.IRangeInfo;
if (rangeInfo != null)
{
RangeAddress = string.IsNullOrEmpty(rangeInfo.Address.WorkSheet) ? rangeInfo.Address.Address : "'" + rangeInfo.Address.WorkSheet + "'!" + rangeInfo.Address.Address;
RangeInfo = rangeInfo;
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
else
{
RangeAddress = arg1.ToString();
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
}
var indexVal = arguments.ElementAt(2);
if (indexVal.DataType == DataType.ExcelAddress)
{
var address = new ExcelAddress(indexVal.Value.ToString());
var indexObj = context.ExcelDataProvider.GetRangeValue(address.WorkSheet, address._fromRow, address._fromCol);
LookupIndex = (int) _argumentParsers.GetParser(DataType.Integer).Parse(indexObj);
}
else
{
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(arguments.ElementAt(2).Value);
}
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
else
{
RangeLookup = true;
}
}
public LookupArguments(IEnumerable <FunctionArgument> arguments, ArgumentParsers argumentParsers)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
var arg1 = arguments.ElementAt(1).Value;
var dataArray = arg1 as IEnumerable <FunctionArgument>;
if (dataArray != null)
{
DataArray = dataArray;
ArgumentDataType = LookupArgumentDataType.DataArray;
}
else
{
//if (arg1 is ExcelDataProvider.INameInfo) arg1 = ((ExcelDataProvider.INameInfo) arg1).Value;
var rangeInfo = arg1 as ExcelDataProvider.IRangeInfo;
if (rangeInfo != null)
{
RangeAddress = string.IsNullOrEmpty(rangeInfo.Address.WorkSheet) ? rangeInfo.Address.Address : "'" + rangeInfo.Address.WorkSheet + "'!" + rangeInfo.Address.Address;
RangeInfo = rangeInfo;
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
else
{
RangeAddress = arg1.ToString();
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
}
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(arguments.ElementAt(2).Value);
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
else
{
RangeLookup = true;
}
}
public LookupArguments(IEnumerable<FunctionArgument> arguments, ArgumentParsers argumentParsers)
{
_argumentParsers = argumentParsers;
SearchedValue = arguments.ElementAt(0).Value;
var arg1 = arguments.ElementAt(1).Value;
var dataArray = arg1 as IEnumerable<FunctionArgument>;
if (dataArray != null)
{
DataArray = dataArray;
ArgumentDataType = LookupArgumentDataType.DataArray;
}
else
{
var rangeInfo = arg1 as ExcelDataProvider.IRangeInfo;
if (rangeInfo != null)
{
RangeAddress = string.IsNullOrEmpty(rangeInfo.Address.WorkSheet) ? rangeInfo.Address.Address : "'" + rangeInfo.Address.WorkSheet + "'!" + rangeInfo.Address.Address;
RangeInfo = rangeInfo;
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
else
{
RangeAddress = arg1.ToString();
ArgumentDataType = LookupArgumentDataType.ExcelRange;
}
}
LookupIndex = (int)_argumentParsers.GetParser(DataType.Integer).Parse(arguments.ElementAt(2).Value);
if (arguments.Count() > 3)
{
RangeLookup = (bool)_argumentParsers.GetParser(DataType.Boolean).Parse(arguments.ElementAt(3).Value);
}
else
{
RangeLookup = true;
}
}
