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