public void Can_generate_schema()
{
Database.SetInitializer<NopObjectContext>(null);
var ctx = new NopObjectContext("Test");
string result = ctx.CreateDatabaseScript();
result.ShouldNotBeNull();
}
public static void Build()
{
var ctx = new NopObjectContext("Data Source=JASON-THINK;Initial Catalog=Brigita;Integrated Security=True;Persist Security Info=False");
var products = ctx.Set<Product>();
var cats = ctx.Set<Category>().ToArray();
var pic = ctx.Set<Picture>().OrderByDescending(p => p.ID).First();
foreach(var cat in cats) {
for(int i = 0; i < 100; i++) {
var p = new Product() {
Name = "Product" + i,
CreatedOnUtc = DateTime.UtcNow,
UpdatedOnUtc = DateTime.UtcNow,
ShortDescription = "Short desc blah blah blah blah blah.",
FullDescription = "Full desc blah blah blah blah blah blah blah blah blah blah blah blah blah..."
//...
};
p.ProductCategories.Add(new ProductCategory() {
Category = cat
});
p.ProductPictures.Add(new ProductPicture() {
Picture = pic
});
products.Add(p);
}
}
try {
ctx.SaveChanges();
}
catch(Exception ex) {
//...
}
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public CampaignService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public OnlineUserService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopStaticCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public ShippingByWeightAndCountryService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public StateProvinceService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
public void Can_get_customer_content_by_type()
{
var customer = SaveAndLoadEntity <Customer>(GetTestCustomer(), false);
var product = SaveAndLoadEntity <Product>(GetTestProduct(), false);
var productReview = new ProductReview
{
Customer = customer,
Product = product,
Title = "Test",
ReviewText = "A review",
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02),
};
var productReviewHelpfulness = new ProductReviewHelpfulness
{
Customer = customer,
ProductReview = productReview,
WasHelpful = true,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04)
};
var blogComment = new BlogComment
{
Customer = customer,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04),
BlogPost = new BlogPost()
{
Title = "Title 1",
Body = "Body 1",
AllowComments = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
Language = new Language()
{
Name = "English",
LanguageCulture = "en-Us",
}
}
};
context.Set <CustomerContent>().Add(productReview);
context.Set <CustomerContent>().Add(productReviewHelpfulness);
context.Set <CustomerContent>().Add(blogComment);
context.SaveChanges();
context.Dispose();
context = new NopObjectContext(GetTestDbName());
var query = context.Set <CustomerContent>();
query.ToList().Count.ShouldEqual(3);
var dbReviews = query.OfType <ProductReview>().ToList();
dbReviews.Count().ShouldEqual(1);
dbReviews.First().ReviewText.ShouldEqual("A review");
var dbHelpfulnessRecords = query.OfType <ProductReviewHelpfulness>().ToList();
dbHelpfulnessRecords.Count().ShouldEqual(1);
dbHelpfulnessRecords.First().WasHelpful.ShouldEqual(true);
var dbBlogCommentRecords = query.OfType <BlogComment>().ToList();
dbBlogCommentRecords.Count().ShouldEqual(1);
}
public void Can_get_customer_content_by_type()
{
var customer = SaveAndLoadEntity<Customer>(GetTestCustomer(), false);
var product = SaveAndLoadEntity<Product>(GetTestProduct(), false);
var productReview = new ProductReview
{
Customer = customer,
Product = product,
Title = "Test",
ReviewText = "A review",
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02),
};
var productReviewHelpfulness = new ProductReviewHelpfulness
{
Customer = customer,
ProductReview = productReview,
WasHelpful = true,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04)
};
var blogComment = new BlogComment
{
Customer = customer,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04),
BlogPost = new BlogPost()
{
Title = "Title 1",
Body = "Body 1",
AllowComments = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
Language = new Language()
{
Name = "English",
LanguageCulture = "en-Us",
}
}
};
context.Set<CustomerContent>().Add(productReview);
context.Set<CustomerContent>().Add(productReviewHelpfulness);
context.Set<CustomerContent>().Add(blogComment);
context.SaveChanges();
context.Dispose();
context = new NopObjectContext(GetTestDbName());
var query = context.Set<CustomerContent>();
query.ToList().Count.ShouldEqual(3);
var dbReviews = query.OfType<ProductReview>().ToList();
dbReviews.Count().ShouldEqual(1);
dbReviews.First().ReviewText.ShouldEqual("A review");
var dbHelpfulnessRecords = query.OfType<ProductReviewHelpfulness>().ToList();
dbHelpfulnessRecords.Count().ShouldEqual(1);
dbHelpfulnessRecords.First().WasHelpful.ShouldEqual(true);
var dbBlogCommentRecords = query.OfType<BlogComment>().ToList();
dbBlogCommentRecords.Count().ShouldEqual(1);
}
/// <summary>
/// Filter query results by ACL per object
/// </summary>
/// <param name="query">Source query</param>
/// <param name="context">context</param>
/// <returns>Result</returns>
public static IQueryable <Category> WhereAclPerObjectNotDenied(this IQueryable <Category> query, NopObjectContext context)
{
if (NopContext.Current.User != null)
{
//customer roles
var crQuery = from cr in NopContext.Current.User.CustomerRoles
orderby cr.CustomerRoleId
select cr.CustomerRoleId;
//ACL query
query = query.Where(c => (from acl in context.ACLPerObject
where acl.ObjectId == c.CategoryId &&
acl.ObjectTypeId == (int)ObjectTypeEnum.Category &&
acl.Deny == true &&
//crQuery.Count > 0 &&
crQuery.Contains(acl.CustomerRoleId)
select acl.CustomerRoleId).Count() == 0);
}
return(query);
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public DownloadService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public SearchLogService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public SpecificationAttributeService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public BlacklistService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public MaintenanceService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public ManufacturerService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public SettingManager(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopStaticCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public LocalizationManager(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopStaticCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public AffiliateService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public ProductAttributeService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public CustomerActivityService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public WarehouseService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public ShippingByTotalService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public TaxCategoryService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
/// <summary>
/// Ctor
/// </summary>
/// <param name="context">Object context</param>
public TaxProviderService(NopObjectContext context)
{
this._context = context;
this._cacheManager = new NopRequestCache();
}
