private List<DdeKursAdvisor> GetAllAdvisors()
{
var advisors = new List<DdeKursAdvisor>();
Range excelRange = _xlWorkSheet.UsedRange;
var valueArray = (object[,])excelRange.get_Value(
XlRangeValueDataType.xlRangeValueDefault);
int usdLength = KursProviderConfig.BASE_USD_ROW_END - KursProviderConfig.BASE_USD_ROW_START + 1;
for (int i = 0; i < usdLength; i++)
{
var kurs = new Kurs
{
currency = valueArray[22 + i, 1].ToString().TrimEnd('='),
bid = ConvertToDoubleTwoDecimal(valueArray[22 + i, 2]),
ask = ConvertToDoubleTwoDecimal(valueArray[22 + i, 3])
};
var bidCell = string.Format("R{0}C2", KursProviderConfig.BASE_USD_ROW_START + i);
var askCell = string.Format("R{0}C3", KursProviderConfig.BASE_USD_ROW_START + i);
advisors.Add(new DdeKursAdvisor(kurs, bidCell, askCell));
}
int idrLength = KursProviderConfig.BASE_IDR_ROW_END - KursProviderConfig.BASE_IDR_ROW_START + 1 ;
for (int i = 0; i < idrLength; i++)
{
var kurs = new Kurs
{
currency = valueArray[44 + i, 1].ToString().TrimEnd('='),
bid = ConvertToDoubleTwoDecimal(valueArray[44 + i, 2]),
ask = ConvertToDoubleTwoDecimal(valueArray[44 + i, 3])
};
var bidCell = string.Format("R{0}C2", KursProviderConfig.BASE_IDR_ROW_START + i);
var askCell = string.Format("R{0}C3", KursProviderConfig.BASE_IDR_ROW_START + i);
advisors.Add(new DdeKursAdvisor(kurs, bidCell, askCell));
}
return advisors;
}
public DdeKursAdvisor(Kurs kurs, string bidCell, string askCell)
{
_kurs = kurs;
_bidCell = bidCell;
_askCell = askCell;
}
public DdeKursAdvisor(string currency, string bidCell, string askCell)
{
_bidCell = bidCell;
_askCell = askCell;
_kurs = new Kurs {currency = currency};
}