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