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