public void Test_Add_QueryById_Update_Delete_CategoryProvider() { var category = new Category { Name = "category1", Description = "Hello111", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; //Add Catagory provider.Add(category); Console.WriteLine("Add OK!"); //QueryBy var categoryQueryBy = provider.QueryById(category.Id); Assert.IsNotNull(categoryQueryBy); Console.WriteLine("QueryBy OK!"); //update category.Description = "New description"; provider.Update(category); var categoryUpdate = provider.QueryById(category.Id); Assert.AreEqual("New description", categoryUpdate.Description); Console.WriteLine("Update OK!"); //Delete provider.Delete(category); var categoryDelete = provider.QueryById(category.Id); Assert.IsNull(categoryDelete); Console.WriteLine("Delete OK!"); }
public void Test_Add_QueryById_Update_Delete_ProductCategoryProvider() { var category = new Category { Name = "catagory1", Description = "Hello description!", Image = "", PageSize = 10, Published = true, Deleted = false, DisplayOrder = 1, UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; var product = new Product { Name = "Product1", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; var productCategory = new ProductCategory { IsFeaturedProduct = false, DisplayOrder = 2, Product = product, Category = category }; Mock<IEntityFileProvider> entityFileProvider = new Mock<IEntityFileProvider>(); var categoryProvider = new CategoryProvider(new NoDI_NHibernateContextFactory(), entityFileProvider.Object); //Add brand new ProductProvider(new NoDI_NHibernateContextFactory()).Add(product); categoryProvider.Add(category); provider.Add(productCategory); Console.WriteLine("Add OK!"); //QueryBy var productCategoryQueryBy = provider.QueryById(productCategory.Id); Assert.IsNotNull(productCategoryQueryBy); Console.WriteLine("QueryBy OK!"); //update productCategory.DisplayOrder = 5; provider.Update(productCategory); var productCategoryUpdate = provider.QueryById(productCategory.Id); Assert.AreEqual(5, productCategoryUpdate.DisplayOrder); Console.WriteLine("Update OK!"); //Delete provider.Delete(productCategory); var productCategoryDelete = provider.QueryById(productCategory.Id); Assert.IsNull(productCategoryDelete); Console.WriteLine("Delete OK!"); }
public void Test_Simple_Mapping_ProductCategory() { var category = new Category { Name = "catagory1", Description = "Hello description!", Image = "", PageSize = 10, Published = true, Deleted = false, DisplayOrder = 1, UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; var product = new Product { Name = "Product1", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; var productCategory = new ProductCategory { IsFeaturedProduct=false, DisplayOrder=2, Product=product, Category=category }; using (ISession session = MySessionFactory.OpenSession()) { ITransaction transaction = session.BeginTransaction(); session.Save(product); session.Save(category); session.Save(productCategory); transaction.Commit(); } var productCategory1 = MySessionFactory.OpenSession().Query<ProductCategory>() .Where(it => it.Id == productCategory.Id) .FirstOrDefault(); Assert.AreEqual(productCategory.Id, productCategory1.Id); Assert.AreEqual(product.Id, productCategory1.Product.Id); Assert.AreEqual(category.Id, productCategory1.Category.Id); Console.WriteLine(productCategory.Id); Console.WriteLine(product.Id); Console.WriteLine(category.Id); var product1 = MySessionFactory.OpenSession().Query<Product>() .Where(it => it.Id == product.Id) .FirstOrDefault(); Assert.AreEqual(1,product1.ProductCategories.Count); }
public void Test_Change_Parent() { var session = MySessionFactory.OpenSession(); var parent1 = new Category { Name = "parent1", Description = "Hello description!", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow, Parent = null }; var child1 = new Category { Name = "child", Description = "Hello description!", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow, Parent = parent1 }; var parent2 = new Category { Name = "parent2", Description = "Hello description!", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow, }; using (ITransaction transaction = session.BeginTransaction()) { session.Save(parent1); session.Save(child1); session.Save(parent2); transaction.Commit(); } session = MySessionFactory.OpenSession(); var actualChild1 = session.Query<Category>() .Where(it => it.Id == child1.Id) .First(); var actualParent2 = session.Query<Category>() .Where(it => it.Id == parent2.Id) .First(); actualChild1.Parent = actualParent2; using (ITransaction transaction = session.BeginTransaction()) { session.Save(actualChild1); transaction.Commit(); } actualChild1 = session.Query<Category>() .Where(it => it.Id == child1.Id) .FirstOrDefault(); Assert.AreEqual(actualParent2.Id, actualChild1.ParentId); using (ITransaction transaction = session.BeginTransaction()) { session.Delete(actualParent2); transaction.Commit(); } actualChild1 = session.Query<Category>() .Where(it => it.Id == child1.Id) .FirstOrDefault(); Assert.IsNull(actualChild1); }
public void Test_Simple_Mapping_Category() { var category = new Category { Name = "catagory1", Description = "Hello description!", Image = "", PageSize = 10, Published = true, Deleted = false, DisplayOrder = 1, UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow }; using (ISession session = MySessionFactory.OpenSession()) { ITransaction transaction = session.BeginTransaction(); session.Save(category); session.Flush(); transaction.Commit(); } }
public void Test_Parent_Mapping_Category() { var session = MySessionFactory.OpenSession(); var category1 = new Category { Name = "catagory1", Description = "Hello description!", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow, Parent = null }; var category2 = new Category { Name = "catagory2", Description = "Hello description!", UtcCreationDate = DateTime.UtcNow, UtcUpdateDate = DateTime.UtcNow, Parent = category1 }; using (ITransaction transaction = session.BeginTransaction()) { session.Save(category1); session.Save(category2); transaction.Commit(); } Assert.AreNotEqual(0, category2.Id); var actualCategory2 = session.Query<Category>() .Where(it => it.Id == category2.Id) .FirstOrDefault(); Assert.AreEqual(category2.Id, actualCategory2.Id); session = MySessionFactory.OpenSession(); var actualCategory1 = session.Query<Category>() .Where(it => it.Id == category1.Id) .FirstOrDefault(); using (var transaction = session.BeginTransaction()) { session.Delete(actualCategory1); transaction.Commit(); } }