public void UpdateCurrency() { try { var md = new GetJsonCurrency().GetMBCurrency(); var nbu = new GetJsonCurrency().GetNBUCurrency(); if (md == null && nbu == null) { log.AddLog("Second attempt"); md = new GetJsonCurrency().GetMBCurrency(); nbu = new GetJsonCurrency().GetNBUCurrency(); if (md == null && nbu == null) { log.AddLog("Bad Second attempt"); return; } } DateTime date = Convert.ToDateTime(DateTime.Now.ToString("dd.MM.yyyy 11:00:00")); double USDmd, EURmd, RUBmd, USDnbu, EURnbu, RUBnbu; USDmd = 0; EURmd = 0; RUBmd = 0; USDnbu = 0; EURnbu = 0; RUBnbu = 0; foreach (var item in md) { switch (item.currency) { case "usd": USDmd = Convert.ToDouble(item.ask.Replace('.', ',')); break; case "eur": EURmd = Convert.ToDouble(item.ask.Replace('.', ',')); break; case "rub": RUBmd = Convert.ToDouble(item.ask.Replace('.', ',')); break; } } foreach (var item in nbu) { switch (item.currency) { case "usd": USDnbu = Convert.ToDouble(item.bid.Replace('.', ',')); break; case "eur": EURnbu = Convert.ToDouble(item.bid.Replace('.', ',')); break; case "rub": RUBnbu = Convert.ToDouble(item.bid.Replace('.', ',')); break; } } if (FindAndDeactivateEntity(date)) { var newRateUSD = new new_exchangerates() { new_name = "USD", new_date = date, TransactionCurrencyId = ToTransactionCurrency("USD"), new_megbank = 1, new_nbu = 1, }; service.Create(newRateUSD); var newRateEUR = new new_exchangerates() { new_name = "EUR", new_date = date, TransactionCurrencyId = ToTransactionCurrency("EUR"), //new_nbu = EURnbu / USDnbu, //new_megbank = EURmd / USDmd new_nbu = EURnbu, new_megbank = EURmd }; service.Create(newRateEUR); var newRateRUB = new new_exchangerates() { new_name = "RUB", new_date = date, TransactionCurrencyId = ToTransactionCurrency("RUB"), //new_nbu = RUBnbu / USDnbu, //new_megbank = RUBmd / USDmd new_nbu = RUBnbu, new_megbank = RUBmd }; service.Create(newRateRUB); var newRateUAH = new new_exchangerates() { new_name = "UAH", new_date = date, TransactionCurrencyId = ToTransactionCurrency("UAH"), //new_nbu = 1 / USDnbu, //new_megbank = 1 / USDmd new_nbu = USDnbu, new_megbank = USDmd }; service.Create(newRateUAH); } else { log.AddLog("All Currency is correct"); } } catch (Exception ex) { log.AddLog(string.Format("Somethink is wrong in WorkClass: {0}", ex.Message)); } }