public List <Currency> FindAllCurrencies() { using (SqlConnection conn = _currencyManager.GetConnection()) { SqlTransaction t = conn.BeginTransaction(); try { List <Currency> _currencies = FindAllCurrencies(t); t.Commit(); return(_currencies); } catch { t.Rollback(); return(null); } } }
public void SelectAllCurrency() { CurrencyManager currencyManager = (CurrencyManager)container["CurrencyManager"]; using (SqlConnection conn = currencyManager.GetConnection()) { SqlTransaction t = conn.BeginTransaction(); List <Currency> list = currencyManager.SelectAllCurrencies(t); Assert.AreEqual(2, list.Count); _AssertCurrency(list[0], 1, "KGS", "KGS", true); _AssertCurrency(list[1], 2, "USD", "USD", false); } }
public void Add_Currency() { CurrencyManager currencyManager = (CurrencyManager)container["CurrencyManager"]; using (SqlConnection conn = currencyManager.GetConnection()) { Currency currency = new Currency { Code = "US Dollar", IsPivot = false, Name = "USD" }; SqlTransaction t = conn.BeginTransaction(); currency.Id = currencyManager.Add(currency, t); Assert.AreNotEqual(0, currency.Id); } }