public Form1()
{
InitializeComponent();
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetCurrenciesRequestBody()
{
};
var response = mnbService.GetCurrencies(request);
var currencyresult = response.GetCurrenciesResult;
var xml = new XmlDocument();
xml.LoadXml(currencyresult);
foreach (XmlElement element in xml.DocumentElement)
{
foreach (XmlNode item in element)
{
var curr = item.InnerText;
Currencies.Add(curr);
}
}
comboBox1.DataSource = Currencies;
comboBox1.SelectedItem = "EUR";
RefreshData();
}
private async void UserControl_Loaded(object sender, RoutedEventArgs e)
{
try
{
using (MNBArfolyamServiceSoapClient client2 = new MNBArfolyamServiceSoapClient())
{
dloadpanel.Visibility = Visibility.Visible;
var response = await client2.GetCurrentExchangeRatesAsync(new GetCurrentExchangeRatesRequestBody());
var xml = response.GetCurrentExchangeRatesResponse1;
var doc = XDocument.Parse(xml.GetCurrentExchangeRatesResult);
foreach (var item in doc.Elements().Elements().Elements())
{
_rates.Add(item.Attribute("curr").Value, Convert.ToDouble(item.Value));
}
}
}
catch (Exception ex)
{
MainWindow.ErrorDialog(ex.Message);
}
finally
{
dloadpanel.Visibility = Visibility.Collapsed;
_rates.Add("HUF", 1);
var odered = _rates.Keys.OrderBy(i => i);
CbSource.ItemsSource = odered;
CbDestination.ItemsSource = odered;
CbDestination.SelectedIndex = odered.FirstIndexOf(i => i == "HUF");
}
}
public void GetCurrentExchangeRates()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetCurrentExchangeRatesRequestBody();
var response = mnbService.GetCurrentExchangeRates(request);
var result = response.GetCurrentExchangeRatesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
foreach (XmlElement element in xml.DocumentElement)
{
//DocumentElement - MNBCurrentExchangeRates
//element - Day (has only 1 attribute (current date))
// element childNodes - Rate (every Rate is a node with attributes )
foreach (XmlElement item in element.ChildNodes)
{
var rate = new RateData();
Rates.Add(rate);
rate.Currency = item.GetAttribute("curr");
var unit = decimal.Parse(item.GetAttribute("unit"));
var value = decimal.Parse(item.InnerText.ToString().Replace(',', '.')); //default separator conflict
if (unit != 0)
{
rate.Value = value / unit;
}
}
}
}
private async void UserControl_Loaded(object sender, RoutedEventArgs e)
{
try
{
using (MNBArfolyamServiceSoapClient client2 = new MNBArfolyamServiceSoapClient())
{
dloadpanel.Visibility = Visibility.Visible;
var response = await client2.GetCurrentExchangeRatesAsync(new GetCurrentExchangeRatesRequestBody());
var xml = response.GetCurrentExchangeRatesResponse1;
var doc = XDocument.Parse(xml.GetCurrentExchangeRatesResult);
foreach (var item in doc.Elements().Elements().Elements())
{
_rates.Add(item.Attribute("curr").Value, Convert.ToDouble(item.Value));
}
}
}
catch (Exception ex)
{
MainWindow.ErrorDialog(ex.Message);
}
finally
{
dloadpanel.Visibility = Visibility.Collapsed;
_rates.Add("HUF", 1);
CbSource.ItemsSource = _rates.Keys.OrderBy(i => i);
CbDestination.ItemsSource = _rates.Keys.OrderBy(i => i);
}
}
private void GetCurr()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var currRequest = new GetCurrenciesRequestBody()
{
};
var currResponse = mnbService.GetCurrencies(currRequest);
var currResult = currResponse.GetCurrenciesResult;
var currXml = new XmlDocument();
currXml.LoadXml(currResult);
foreach (XmlElement element in currXml.DocumentElement)
{
for (int i = 0; i < element.InnerText.Length / 3; i++)
{
string currency;
var currChildElement = (XmlElement)element.ChildNodes[i];
currency = currChildElement.InnerText.ToString();
CurrenciesInput.Add(currency);
CurrenciesOutput.Add(currency);
}
}
}
private void MNBRibbon_Load(object sender, RibbonUIEventArgs e)
{
_mnbService = new MNBArfolyamServiceSoapClient();
_operatorService = new OperatorService();
_logDatabaseDataSet = new LogDatabaseDataSet();
_logTableAdapter = new LogTableAdapter();
_logTableAdapter.Fill(_logDatabaseDataSet.Log);
_logBindingSource = new BindingSource();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
client = new MNBArfolyamServiceSoapClient();
string result = client.GetInfo();
ProcessInfo(result);
result = client.GetCurrentExchangeRates();
ProcessRates(result);
atvaltandoosszeg.Content = osszeg;
}
public Service(int startYear, int startMonth, int startDay, int endYear, int endMonth, int endDay)
{
client = new MNBArfolyamServiceSoapClient();
chosenCurrency = "HUF";
this.startYear = startYear.ToString();
this.startMonth = startMonth < 10 ? "0" + startMonth:startMonth.ToString();
this.startDay = startDay < 10 ? "0" + startDay : startDay.ToString();
this.endYear = endYear.ToString();
this.endMonth = endMonth < 10 ? "0" + endMonth : endMonth.ToString();
this.endDay = endDay < 10 ? "0" + endDay : endDay.ToString();
}
private void DisplayMNBServiceData() //Create client, sheet and call Fill method
{
try
{
using (MNBArfolyamServiceSoapClient soapClient = new MNBArfolyamServiceSoapClient())
{
Excel.Worksheet worksheet = Globals.ThisAddIn.Application.ActiveSheet;
FillDataToExcel(worksheet, soapClient);
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
/// <summary>
/// Aktuális árfolyam lekérdezése
/// </summary>
public static async Task <decimal> GetCurrentExchangeRate(string currency)
{
MNBArfolyamServiceSoapClient client = new MNBArfolyamServiceSoapClient();
await client.OpenAsync();
GetCurrentExchangeRatesResponse response = await client.GetCurrentExchangeRatesAsync(new GetCurrentExchangeRatesRequestBody());
await client.CloseAsync();
return(GetCurrentExchangeRateFromString(currency, response.GetCurrentExchangeRatesResponse1.GetCurrentExchangeRatesResult));
}
public string GetCurrentRates()
{
using (var client = new MNBArfolyamServiceSoapClient())
{
var result = client.GetCurrentExchangeRates(new GetCurrentExchangeRatesRequestBody());
var converter = new Converter <MNBCurrentExchangeRates>();
var subject = converter.Deserialize(result.GetCurrentExchangeRatesResult);
return(converter.Serialize(subject));
}
}
private void WebService()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetExchangeRatesRequestBody()
{
currencyNames = comboBox1.SelectedItem.ToString(),
startDate = dateTimePicker1.Value.ToString(),
endDate = dateTimePicker2.Value.ToString()
};
var response = mnbService.GetExchangeRates(request);
result = response.GetExchangeRatesResult;
}
private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
// Upon running Excel - Open a blank new Workbook
this.Application.Workbooks.Add();
// Initialize the client
var binding = new BasicHttpBinding();
binding.MaxReceivedMessageSize = Int32.MaxValue;
binding.MaxBufferSize = Int32.MaxValue;
var endpointAddress = new System.ServiceModel.EndpointAddress(MNB_ENDPOINT_ADDRESS);
client = new MNBArfolyamServiceSoapClient(binding, endpointAddress);
}
static void Main(string[] args)
{
MNBArfolyamServiceSoapClient client = new MNBArfolyamServiceSoapClient();
try
{
var resp = client.GetCurrentExchangeRates(new GetCurrentExchangeRatesRequestBody());
var respString = resp.GetCurrentExchangeRatesResult;
Console.WriteLine(resp.GetCurrentExchangeRatesResult);
XDocument xdoc = XDocument.Parse(respString);
Console.WriteLine(xdoc);
// megjeleníti a XML tag-ek nélkül
var Rates = xdoc.Descendants("Rate");
foreach (var item in Rates)
{
string[] row = new string[3];
row[0] = item.Attribute("curr").Value;
row[1] = item.Attribute("unit").Value;
row[2] = item.Value;
Console.WriteLine(row[0] + row[1] + row[2]);
}
// Nap kinyérése az XML-ből
var Day = xdoc.Descendants("Day");
foreach (var item in Day)
{
Console.WriteLine("Aktuális nap: {0}", item.Attribute("date").Value);
}
// EURÓ kinyerése az XML-ből
var euro = xdoc.Descendants("Rate");
foreach (var item in euro)
{
if (item.Attribute("curr").Value == "EUR")
{
Console.WriteLine("Euró mai árfolyama {0}", item.Value);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.ReadLine();
}
private void mnbDownload_Click(object sender, RibbonControlEventArgs e)
{
//Check MNB service
if (_mnbService.State.ToString() != "Created")
{
_mnbService = new MNBArfolyamServiceSoapClient();
_mnbService.Open();
}
//Log to the database
LogDatabaseDataSet.LogRow newLogRow = _logDatabaseDataSet.Log.NewLogRow();
newLogRow.Név = Environment.UserName;
newLogRow.TimeStamp = DateTime.Now;
_logDatabaseDataSet.Log.Rows.Add(newLogRow);
_logTableAdapter.Update(_logDatabaseDataSet.Log);
//Get currencies xml and map it to its model
GetCurrenciesResponseBody currenciesXML = _mnbService.GetCurrencies(new GetCurrenciesRequestBody());
MNBCurrencies currenciesModel = (MNBCurrencies)_operatorService.XmlToModel <MNBCurrencies>(currenciesXML.GetCurrenciesResult);
//Exchange rates query config
GetExchangeRatesRequestBody getExchangeRatesRequestBody = new GetExchangeRatesRequestBody
{
startDate = "2015.01.01.",
endDate = "2020.04.01.",
currencyNames = string.Join(",", currenciesModel.Currencies)
};
//Get exchange rates xml and map it to its model
GetExchangeRatesResponseBody exchangeRatesXML = _mnbService.GetExchangeRates(getExchangeRatesRequestBody);
MNBExchangeRates exchangeRatesModel = (MNBExchangeRates)_operatorService.XmlToModel <MNBExchangeRates>(exchangeRatesXML.GetExchangeRatesResult);
//Create datatable from model and import it to Excel then save it
DataTable dataTable = _operatorService.ModelToDataTable(exchangeRatesModel, currenciesModel);
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);
_operatorService.DataSetToExcel(dataSet);
//Format worksheet and save the workbook to the user's documents
Excel.Worksheet activeWorksheet = Globals.ThisAddIn.Application.ActiveSheet;
activeWorksheet.Range["A2:CV2"].NumberFormatLocal = "";
activeWorksheet.Range["B3:CV10000"].NumberFormatLocal = "0";
activeWorksheet.Range["A3:A10000"].NumberFormatLocal = "éééé\\.hh\\.nn\\.";
string savePath = Directory.GetCurrentDirectory() + "\\arfolyam-letoltes.xlsx";
Globals.ThisAddIn.Application.ActiveWorkbook.SaveCopyAs(savePath);
_mnbService.Close();
}
private void RefreshData()
{
Rates.Clear();
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetExchangeRatesRequestBody()
{
currencyNames = comboBox1.SelectedItem.ToString(),
startDate = dateTimeStart.Value.ToString(),
endDate = dateTimeEnd.Value.ToString()
};
var response = mnbService.GetExchangeRates(request);
var result = response.GetExchangeRatesResult;
newXml(result);
dataGridView1.DataSource = Rates;
newChart();
}
private void WebServiceCallOutput()
{
RatesOutput.Clear();
var mnbServiceOutput = new MNBArfolyamServiceSoapClient();
var requestOutput = new GetExchangeRatesRequestBody()
{
currencyNames = selectedCurrencyOutput,
//startDate = DateTime.Today.AddYears(-1).ToString(),
//endDate = DateTime.Today.ToString()
startDate = dateTimePicker1.Value.AddYears(-1).ToString(),
endDate = dateTimePicker1.Value.ToString()
};
var responseOutput = mnbServiceOutput.GetExchangeRates(requestOutput);
resultOutput = responseOutput.GetExchangeRatesResult;
}
private string WebService()
{
var MNBservice = new MNBArfolyamServiceSoapClient();
var request = new GetExchangeRatesRequestBody()
{
currencyNames = cbCurrency.SelectedItem.ToString(),
startDate = dtpFrom.Value.ToString(),
endDate = dtpTo.Value.ToString()
};
var response = MNBservice.GetExchangeRates(request);
var result = response.GetExchangeRatesResult;
return(result);
}
public void feladat3()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetExchangeRatesRequestBody()
{
currencyNames = "EUR",
startDate = "2020-01-01",
endDate = "2020-06-30"
};
var response = mnbService.GetExchangeRates(request);
var result = response.GetExchangeRatesResult;
}
private void GER()
{
var mnbService = new MNBArfolyamServiceSoapClient();
foreach (var item in cv)
{
var request = new GetExchangeRatesRequestBody()
{
currencyNames = item,
startDate = DateTime.Today.AddDays(-29).ToString("yyyy-MM-dd"),
endDate = DateTime.Today.ToString("yyyy-MM-dd")
};
var response = mnbService.GetExchangeRates(request);
var result = response.GetExchangeRatesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
foreach (XmlElement element in xml.DocumentElement)
{
var valuta = new Valuta();
Arfolyamok.Add(valuta);
valuta.Date = DateTime.Parse(element.GetAttribute("date"));
var childElement = (XmlElement)element.ChildNodes[0];
if (childElement == null)
{
continue;
}
valuta.Currency = childElement.GetAttribute("curr");
var unit = decimal.Parse(childElement.GetAttribute("unit"));
var value = decimal.Parse(childElement.InnerText);
if (unit != 0)
{
valuta.Value = value / unit;
}
}
}
}
private void CurrencyList()
{
var MNBservice = new MNBArfolyamServiceSoapClient();
var request = new GetCurrenciesRequestBody();
var response = MNBservice.GetCurrencies(request);
var result = response.GetCurrenciesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
foreach (XmlElement element in xml.DocumentElement.ChildNodes[0])
{
var currency = element.InnerText;
Currencies.Add(currency);
}
cbCurrency.DataSource = Currencies;
}
private static void Main(string[] args)
{
MNBArfolyamServiceSoapClient client = new MNBArfolyamServiceSoapClient();
String currentExchangeRates = client.GetCurrentExchangeRates();
XDocument doc = XDocument.Parse(currentExchangeRates);
// Console.WriteLine(doc.ToString());
XElement currentDay = doc.Root.Descendants("Day").First();
// Console.WriteLine(currentDay.ToString());
XElement eurEchangeRate = currentDay.Descendants("Rate").Where(x => ((String)x.Attribute("curr")).Equals("EUR") ).First();
// Console.WriteLine(eurEchangeRate.ToString());
double eur2huf = Double.Parse(eurEchangeRate.Value);
Console.WriteLine("EUR 2 HUF: " + eur2huf);
String value = doc.Root.Descendants("Rate").Where(x => ((String)x.Attribute("curr")).Equals("EUR")).First().Value;
Console.WriteLine("EUR 2 HUF: " + value);
String demo = client.GetExchangeRates("2004-07-14", "2004-07-16", "EUR,USD");
XDocument docDemo = XDocument.Parse(demo);
Console.WriteLine(docDemo.ToString());
}
private void fv()
{
BindingList <Money> moneydata = new BindingList <Money>();
moneydata.Clear();
dataGridView1.DataSource = moneydata;
var valuta = new MNBArfolyamServiceSoapClient();
var inquiry = new GetExchangeRatesRequestBody()
{
currencyNames = comboBox1.SelectedItem.ToString(),
startDate = dateTimePicker1.Value.ToString(),
endDate = dateTimePicker2.Value.ToString()
};
var feedback = valuta.GetExchangeRates(inquiry);
var end = feedback.GetExchangeRatesResult;
var xml = new XmlDocument();
xml.LoadXml(end);
foreach (XmlElement item in xml.DocumentElement)
{
var money = new Money();
moneydata.Add(money);
money.Date = DateTime.Parse(item.GetAttribute("date"));
var childElement = (XmlElement)item.ChildNodes[0];
money.Currency = childElement.GetAttribute("curr");
var unit = decimal.Parse(childElement.GetAttribute("unit"));
var value = decimal.Parse(childElement.InnerText);
if (unit != 0)
{
money.Value = value / unit;
}
}
}
private void RefreshData()
{
Rates.Clear();
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetExchangeRatesRequestBody()
{
currencyNames = (comboBox1.SelectedItem).ToString(),
startDate = (dateTimePicker1.Value).ToString(),
endDate = (dateTimePicker2.Value).ToString()
};
var response = mnbService.GetExchangeRates(request);
var result = response.GetExchangeRatesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
foreach (XmlElement element in xml.DocumentElement)
{
var rate = new RateData();
Rates.Add(rate);
rate.Date = DateTime.Parse(element.GetAttribute("date"));
var childElement = (XmlElement)element.ChildNodes[0];
rate.Currency = childElement.GetAttribute("curr");
var unit = decimal.Parse(childElement.GetAttribute("unit"));
var value = decimal.Parse(childElement.InnerText);
if (unit != 0)
{
rate.Value = value / unit;
}
}
//comboBox1.DataSource = Currencies;
dataGridView1.DataSource = Rates;
}
private void GetCurrencies()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetCurrenciesRequestBody();
var response = mnbService.GetCurrencies(request);
var result = response.GetCurrenciesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
foreach (XmlElement element in xml.DocumentElement)
{
var rate = new RateData();
Rates.Add(rate);
var childElement = (XmlElement)element.ChildNodes[0];
rate.Currency = childElement.GetAttribute("curr");
}
}
private void getExchangeRates()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetCurrenciesRequestBody()
{
};
var response = mnbService.GetCurrencies(request);
var result = response.GetCurrenciesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
int sorszam = 0; //ha ide 3-at írnék, akkor a HUF-t be se olvassa
while (sorszam + 2 < xml.DocumentElement.InnerText.Length) //data-nál alkalmazott foreach csak egy elemet számít, HUF után kiugrik a ciklusból, ez végigmegy a teljes listán, még ha nem is szép megoldás
{
string curr;
curr = (xml.DocumentElement.InnerText[sorszam]).ToString() + (xml.DocumentElement.InnerText[sorszam + 1]).ToString() + (xml.DocumentElement.InnerText[sorszam + 2]).ToString();
Currencies.Add(curr);
sorszam += 3;
}
comboBox1.DataSource = Currencies;
}
private async Task <IList <CurrencyRate> > UpdateRates()
{
using (MNBArfolyamServiceSoapClient client = new MNBArfolyamServiceSoapClient(new BasicHttpBinding(), new EndpointAddress("http://www.mnb.hu/arfolyamok.asmx")))
{
var respone = await client.GetCurrentExchangeRatesAsync(new GetCurrentExchangeRatesRequestBody());
var current = respone.GetCurrentExchangeRatesResponse1.GetCurrentExchangeRatesResult;
XDocument xml = XDocument.Parse(current);
List <CurrencyRate> result = new List <CurrencyRate>();
foreach (var rate in xml.Descendants("Rate"))
{
var parsed = new CurrencyRate
{
CurrencyCode = rate.Attribute("curr").Value,
Unit = Convert.ToDecimal(rate.Attribute("unit").Value, new CultureInfo("hu-HU")),
ValueInForint = Convert.ToDecimal(rate.Value, new CultureInfo("hu-HU")),
};
result.Add(parsed);
}
return(result);
}
}
private void CreateWebService()
{
var webService = new MNBArfolyamServiceSoapClient();
//MNBArfolyamServiceSoapClient osztály példányosítása
var beertek = new GetExchangeRatesRequestBody()
{
currencyNames = "DKK",
startDate = "2019-12-31",
endDate = "2020-12-31"
};
var visszaertek = webService.GetExchangeRates(beertek);
var vegertek = visszaertek.GetExchangeRatesResult;
//vegertek string!!!
var xml = new XmlDocument();
xml.LoadXml(vegertek);
foreach (XmlElement element in xml.DocumentElement)
{
var jelenarfolyam = new Arfolyam();
Arfolyamok.Add(jelenarfolyam);
jelenarfolyam.dátum = DateTime.Parse(element.GetAttribute("date"));
var childElement = (XmlElement)element.ChildNodes[0];
jelenarfolyam.valuta = childElement.GetAttribute("curr");
var unit = decimal.Parse(childElement.GetAttribute("unit"));
var value = decimal.Parse(childElement.InnerText);
if (unit != 0)
{
jelenarfolyam.érték = value / unit;
}
{
}
}
}
private void GetExchangeRates()
{
var mnbService = new MNBArfolyamServiceSoapClient();
var request = new GetExchangeRatesRequestBody()
{
currencyNames = comboBox1.SelectedItem.ToString(),
startDate = dateTimePicker1.Value.ToString(),
endDate = dateTimePicker2.Value.ToString()
};
var response = mnbService.GetExchangeRates(request);
var result = response.GetExchangeRatesResult;
var xml = new XmlDocument();
xml.LoadXml(result);
foreach (XmlElement element in xml.DocumentElement)
{
// Létrehozzuk az adatsort és rögtön hozzáadjuk a listához
// Mivel ez egy referencia típusú változó, megtehetjük, hogy előbb adjuk a listához és csak később töltjük fel a tulajdonságait
var rate = new RateData();
Rates.Add(rate);
// Dátum
rate.Date = DateTime.Parse(element.GetAttribute("date"));
// Valuta
var childElement = (XmlElement)element.ChildNodes[0];
if (childElement == null)
{
continue;
}
rate.Currency = childElement.GetAttribute("curr");
// Érték
var unit = decimal.Parse(childElement.GetAttribute("unit"));
var value = decimal.Parse(childElement.InnerText);
if (unit != 0)
{
rate.Value = value / unit;
}
}
var series = chartRateData.Series[0];
series.ChartType = SeriesChartType.Line;
series.XValueMember = "Date";
series.YValueMembers = "Value";
series.BorderWidth = 2;
var legend = chartRateData.Legends[0];
legend.Enabled = false;
var chartArea = chartRateData.ChartAreas[0];
chartArea.AxisX.MajorGrid.Enabled = false;
chartArea.AxisY.MajorGrid.Enabled = false;
chartArea.AxisY.IsStartedFromZero = false;
}
private void FillDataToExcel(Excel.Worksheet sheet, MNBArfolyamServiceSoapClient soapClient) //Fill excel worksheet
{
GetCurrenciesRequestBody getCurrenciesBody = new GetCurrenciesRequestBody();
GetExchangeRatesRequestBody getRatesBody = new GetExchangeRatesRequestBody();
var range = sheet.get_Range("A1", "A1");
var currencies = soapClient.GetCurrencies(getCurrenciesBody);
int DayID = 0, countRates = 0;
string xmlResult = currencies.GetCurrenciesResult;
DataTable table = XmlToDataTable(xmlResult, 1);
DataTable dataRates = new DataTable();
DataTable dataDays = new DataTable();
List <string> currenciesList = new List <string>();
((Excel.Range)range.Cells[1, 1]).Value = "Dátum/ISO";
((Excel.Range)range.Cells[2, 1]).Value = "Egység";
//Fill and get all currencies//
int columnIndex = 2;
foreach (DataRow items in table.Rows)
{
((Excel.Range)range.Cells[1, columnIndex]).Value = items[0];
currenciesList.Add(items[0].ToString());
columnIndex++;
}
//////////////////////////////
//Fill days//
var exchRates = soapClient.GetExchangeRates(getRatesBody);
xmlResult = exchRates.GetExchangeRatesResult;
table = XmlToDataTable(xmlResult, 0);
columnIndex = 3;
foreach (DataRow item in table.Rows)
{
((Excel.Range)range.Cells[columnIndex, 1]).Value2 = item[0];
columnIndex++;
}
/////////////
//Fill Rates//
getRatesBody = new GetExchangeRatesRequestBody();
dataRates = new DataTable();
dataDays = new DataTable();
for (int k = 0; k < currenciesList.Count; k++)//Loop all currencies and fill rates value
{
//if (k > 2) break; Set how many item will appaer
range.Cells[1, k + 2].Select();
DayID = 0;
countRates = 0;
columnIndex = 3;
getRatesBody.currencyNames = currenciesList[k];
exchRates = soapClient.GetExchangeRates(getRatesBody);
xmlResult = exchRates.GetExchangeRatesResult;
dataRates = XmlToDataTable(xmlResult, 1);
dataDays = XmlToDataTable(xmlResult, 0);
if (dataRates != null)
{
((Excel.Range)range.Cells[2, k + 2]).Value = dataRates.Rows[countRates][0]; //Fill unit
while (countRates < dataRates.Rows.Count)
{
if (dataRates.Rows[countRates][3].ToString() == dataDays.Rows[DayID][0].ToString()) //Date ID check
{
((Excel.Range)range.Cells[columnIndex, k + 2]).Value = dataRates.Rows[countRates][2].ToString().Replace(",", "."); //Change string format
columnIndex++;
DayID++;
countRates++;
}
else
{
columnIndex++; DayID++;
}
}
}
}
}
