private void AddRates() { DataAccess da = new DataAccess(); List<currency_rate> rates = new List<currency_rate>(); // USD currency c1 = da.GetCurrency("USD"); currency_rate r1 = new currency_rate(); r1.currency = c1; r1.rate = decimal.Parse(edtUSD.Text); r1.rate_date = DateTime.Now; // EURO currency c2 = da.GetCurrency("EUR"); currency_rate r2 = new currency_rate(); r2.currency = c2; r2.rate = decimal.Parse(edtEURO.Text); r2.rate_date = DateTime.Now; // RUR currency c3 = da.GetCurrency("RUR"); currency_rate r3 = new currency_rate(); r3.currency = c3; r3.rate = decimal.Parse(edtRUR.Text)/100; r3.rate_date = DateTime.Now; rates.Add(r1); rates.Add(r2); rates.Add(r3); da.CurrencyRatesCreate(rates); }
private void EditRates() { DataAccess da = new DataAccess(); List<currency_rate> rates = new List<currency_rate>(); // USD currency c1 = da.GetCurrency("USD"); currency_rate r1 = new currency_rate(); r1.currency = c1; r1.rate = decimal.Parse(edtUSD.Text); r1.rate_date = edtDate.SelectedDate.Value; // EURO currency c2 = da.GetCurrency("EUR"); currency_rate r2 = new currency_rate(); r2.currency = c2; r2.rate = decimal.Parse(edtEURO.Text); r2.rate_date = edtDate.SelectedDate.Value; // RUR currency c3 = da.GetCurrency("RUR"); currency_rate r3 = new currency_rate(); r3.currency = c3; r3.rate = decimal.Parse(edtRUR.Text)/100; r3.rate_date = edtDate.SelectedDate.Value; rates.Add(r1); rates.Add(r2); rates.Add(r3); da.CurrencyRatesEdit(rates); }
private void ReloadList() { DataAccess da = new DataAccess(); this.DataContext = da.GetCurrency(); }
// CUSTOM FUNCTIONS private void LoadComboboxCurrencies() { DataAccess da = new DataAccess(); List<currency> x = da.GetCurrency(); edtCurrency.Items.Clear(); foreach (currency c in x) edtCurrency.Items.Add(c.code); edtCurrency.SelectedItem = da.getBasicCurrencyCode(); }
private void LoadCurrencies() { DataAccess da = new DataAccess(); List<currency> lst = da.GetCurrency(); edtCurrentCurrency.Items.Clear(); foreach (currency i in lst) { edtCurrentCurrency.Items.Add(i.code); if (i.is_basic == 1) edtCurrentCurrency.SelectedValue = i.code; } }