public void DisplayOrders()
{
IRepository<Order> repo = new Repository<Order>(new RepositoryTestDataContext());
var allOrders = repo.GetAll();
foreach (var item in allOrders.Take(10))
{
Console.WriteLine("OrderId: {0} OrderDate: {1}", item.OrderID, item.OrderDate);
}
Console.WriteLine();
Console.WriteLine();
var filteredOrders = repo.Find(o => o.OrderDate <= new DateTime(1996, 7, 4));
foreach (var item in filteredOrders.Take(10))
{
Console.WriteLine("OrderId: {0} OrderDate: {1}", item.OrderID, item.OrderDate);
}
Console.WriteLine();
Console.WriteLine("Insert new order");
Order newOrder = new Order
{
OrderDate = DateTime.Now,
CustomerID = "ALFKI",
EmployeeID = null,
Freight = null,
RequiredDate = DateTime.Now.AddDays(10),
ShipAddress = "Obere Str. 57",
ShipCity = "Berlin",
ShipCountry = "Germany",
ShipName = "Alfreds Futterkiste",
ShipPostalCode = "12209",
ShipVia = 1
};
repo.Insert(newOrder);
Order updateOrder;
IRepository<Order> repo2 = new Repository<Order>(new RepositoryTestDataContext());
updateOrder = repo2.GetById(11078);
IRepository<Order> repo3 = new Repository<Order>(new RepositoryTestDataContext());
updateOrder.EmployeeID = 1;
repo3.Update(updateOrder);
}
static void work2()
{
Console.WriteLine("Start thread:{0}", Thread.CurrentThread.ManagedThreadId);
//UnitOfWork uow = new UnitOfWork();
//UnitOfWork.Begin("DBServer");
//IProductRepository prodRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository>();
//IProductRepository prodRep = new ProductRepository("DBServer");
//Console.WriteLine("ProductID : {0} ", prodRep.Single(x => string.IsNullOrEmpty( x.CUSTSN)).ProductID);
//using (UnitOfWork uow = new UnitOfWork())
//{
IRepository<Product> prodRep = new Repository<Product>("HPIMES");
//foreach (Product item in prodRep.Find(x => x.Model == "PCBE15YA837Y"))
//{
// if (string.IsNullOrEmpty(item.CUSTSN))
// {
// item.CUSTSN = "";
// }
// Thread.Sleep(20);
// Console.WriteLine("thread:{0} ProductID:{1} CustomSN:{2}", Thread.CurrentThread.ManagedThreadId, item.ProductID, item.CUSTSN);
//}
Product p1 = new Product
{
ProductID = "A35500006 ",
CUSTSN = "test1111",
Model = "PCBE15YA837Y",
PCBID = "",
Udt = DateTime.Now.AddDays(-1)
};
//prodRep.Delete(p);
prodRep.Update(p1);
//prodRep.Save();
UnitOfWork.ThreadCommit();
Console.WriteLine("Update!!");
//}
Console.WriteLine("End thread:{0}", Thread.CurrentThread.ManagedThreadId);
}
