public ICollection <TaxModel> GetTaxes()
{
_provider.ConnectToDb();
if (!_provider.Connected)
{
throw new AccessToNotConnectedDatabaseException();
}
ICollection <TaxModel> taxes;
var db = _provider.DatabaseContext;
using (var transaction = db.GetTransaction())
{
taxes = db.Query <TaxModel>("SELECT * FROM TAXES").ToList();
transaction.Complete();
}
_provider.DisconnectFromDb();
return(taxes);
}
public ICollection <CategoryModel> GetCategories()
{
_provider.ConnectToDb();
if (!_provider.Connected)
{
throw new AccessToNotConnectedDatabaseException();
}
ICollection <CategoryModel> categories;
var db = _provider.DatabaseContext;
using (var transaction = db.GetTransaction())
{
categories = _provider.DatabaseContext.Query <CategoryModel>("SELECT * FROM Categories").ToList();
transaction.Complete();
}
_provider.DisconnectFromDb();
return(categories);
}
public ICollection <ProductModel> GetProducts()
{
_provider.ConnectToDb();
if (!_provider.Connected)
{
throw new AccessToNotConnectedDatabaseException();
}
var db = _provider.DatabaseContext;
ICollection <ProductModel> products;
using (var transaction = db.GetTransaction())
{
products = _provider.DatabaseContext
.Query <ProductModel, CategoryModel>(
"SELECT * FROM Products p LEFT JOIN CATEGORIES c ON p.Category_id = c.Id").ToList();
transaction.Complete();
}
_provider.DisconnectFromDb();
return(products);
}
public ICollection <StateOfAmericaModel> GetStates()
{
_provider.ConnectToDb();
if (!_provider.Connected)
{
throw new AccessToNotConnectedDatabaseException();
}
var db = _provider.DatabaseContext;
List <StateOfAmericaModel> states;
using (var transaction = db.GetTransaction())
{
states = db.Query <StateOfAmericaModel, TaxModel, StateOfAmericaModel>(
new StateTaxRelator().MapStateAndTax,
"SELECT * FROM States s LEFT JOIN Taxes t ON s.Id = t.StateId").ToList();
transaction.Complete();
}
_provider.DisconnectFromDb();
return(states);
}
