public ActionResult Index(int? page)
{
var pageNumber = page ?? 1;
const int pageSize = 20;
var unitOfWork = new UnitOfWork();
int totalCustomerCount;
var customers =
unitOfWork.Repository<Customers>()
.Query()
.Include(i => i.CustomerDemographics)
.OrderBy(q => q
.OrderBy(c => c.ContactName)
.ThenBy(c => c.CompanyName))
.Filter(q => q.ContactName != null)
.GetPage(pageNumber, pageSize, out totalCustomerCount);
ViewBag.Customers = new StaticPagedList<Customers>(customers, pageNumber, pageSize, totalCustomerCount);
unitOfWork.Save();
return View();
}
public void FindProductById()
{
using (IDbContext northwindFakeContext = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(northwindFakeContext))
{
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 1, Discontinued = false});
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 2, Discontinued = true});
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 3, Discontinued = true});
unitOfWork.Save();
var product = unitOfWork.Repository<Product>().Find(2);
Assert.IsNotNull(product);
Assert.AreEqual(2, product.ProductID);
}
}
public void DeleteProductById()
{
using (IDbContext northwindFakeContext = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(northwindFakeContext))
{
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 2, Discontinued = true, ObjectState = ObjectState.Added});
unitOfWork.Save();
unitOfWork.Repository<Product>().Delete(2);
unitOfWork.Save();
var product = unitOfWork.Repository<Product>().Find(2);
Assert.IsNull(product);
}
}
public void GetProductsExecutesQuery()
{
using (IDbContext context = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(context))
{
var products = unitOfWork.Repository<Product>().Query().Get().ToList();
Assert.IsInstanceOfType(products, typeof (List<Product>));
}
}
public async void FindProductKeyAsync()
{
using (IDbContext northwindFakeContext = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(northwindFakeContext))
{
unitOfWork.Repository<Product>().Insert(new Product { ProductID = 2, Discontinued = true });
unitOfWork.Save();
var product = await unitOfWork.Repository<Product>().FindAsync(2);
Assert.AreEqual(product.ProductID, 2);
}
}
public void UpdateProduct()
{
using (IDbContext northwindFakeContext = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(northwindFakeContext))
{
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 2, Discontinued = true});
unitOfWork.Save();
var product = unitOfWork.Repository<Product>().Find(2);
Assert.AreEqual(product.Discontinued, true, "Assert we are able to find the inserted Product.");
product.Discontinued = false;
product.ObjectState = ObjectState.Modified;
unitOfWork.Repository<Product>().Update(product);
unitOfWork.Save();
Assert.AreEqual(product.Discontinued, false, "Assert that our changes were saved.");
}
}
public void InsertRangeOfProducts()
{
using (IDbContext northwindFakeContext = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(northwindFakeContext))
{
var newProducts = new[]
{
new Product {ProductID = 1, Discontinued = false, ObjectState = ObjectState.Added},
new Product {ProductID = 2, Discontinued = true, ObjectState = ObjectState.Added},
new Product {ProductID = 3, Discontinued = true, ObjectState = ObjectState.Added}
};
unitOfWork.Repository<Product>().InsertRange(newProducts);
var savedProducts = unitOfWork.Repository<Product>().Query().Get();
Assert.AreEqual(savedProducts.Count(), newProducts.Length);
}
}
public void GetProductsThatHaveBeenDiscontinued()
{
using (IDbContext northwindFakeContext = new NorthwindFakeContext())
using (IUnitOfWork unitOfWork = new UnitOfWork(northwindFakeContext))
{
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 1, Discontinued = false, ObjectState = ObjectState.Added});
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 2, Discontinued = true, ObjectState = ObjectState.Added});
unitOfWork.Repository<Product>().Insert(new Product {ProductID = 3, Discontinued = true, ObjectState = ObjectState.Added});
unitOfWork.Save();
var discontinuedProducts = unitOfWork.Repository<Product>().Query().Filter(t => t.Discontinued).Get();
Assert.AreEqual(2, discontinuedProducts.Count());
}
}
