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