Exemplo n.º 1
0
        public void SaveToDatabase()
        {
            using (var ndb = new MyDbContext())
            {
                db.AddRange(RomsToAdd);
                db.UpdateRange(RomsToUpdate);

                db.AddRange(DisksToAdd);
                db.UpdateRange(DisksToUpdate);

                db.SaveChanges();

                GamesLibData.ForceUpdate();
            }
        }
Exemplo n.º 2
0
        public static void SaveToDatabase()
        {
            using (db)
            {
                db.AddRange(RomsToAdd);
                db.UpdateRange(RomsToUpdate);

                db.AddRange(DisksToAdd);
                db.UpdateRange(DisksToUpdate);

                db.SaveChanges();

                //GamesLibData.ForceUpdate();
            }
        }
        /// <summary>
        /// Adds current cart to the db. Takes orders from the cart and passes them individually to the db.
        /// </summary>
        /// <param name="currentCart"></param>
        /// <param name="_db"></param>
        public static void AddCartToDb(Cart currentCart, MyDbContext _db)
        {
            var orderList = new List <Order>();
            int currCartId;

            if (!_db.Orders.Any())//if this is the first order in the DB, set cart ID to 1
            {
                currCartId = 1;
            }
            else
            {
                var prevMaxCartId = _db.Orders.Select(x => x.CartId).ToList();//get the next available cartID
                currCartId = prevMaxCartId.Max() + 1;
            }
            for (int i = 0; i < currentCart.ProdIds.Count(); i++)
            {
                for (int j = 0; j < currentCart.OrderQuantity[i]; j++)//adds a new Order with all properties for each quantity purchased
                {
                    orderList.Add(new Order {
                        CustomerId = currentCart.CustId, LocationId = currentCart.LocIds[i], ProductId = currentCart.ProdIds[i], Price = currentCart.Costs[i], CheckoutTime = DateTime.Now, CartId = currCartId
                    });
                    var x = _db.Products.Find(currentCart.ProdIds[i]);
                    x.Quantity--;//subtracting out the quantity in inventory for each item purchased
                    _db.SaveChanges();
                }
            }

            _db.AddRange(orderList);
            _db.SaveChanges();
            return;
        }
Exemplo n.º 4
0
        public void TestDemo()
        {
            //SETUP
            var options = SqliteInMemory.CreateOptions <MyDbContext>();

            using var context = new MyDbContext(options);
            context.Database.EnsureCreated();

            var e1 = new MyEntity {
                SoftDeleted = false
            };
            var e2 = new MyEntity {
                SoftDeleted = true
            };

            context.AddRange(e1, e2);
            context.SaveChanges();

            //ATTEMPT
            var query    = RelationalQueryableExtensions.FromSqlRaw(context.MyEntities, "SELECT * FROM MyEntities");
            var entities = query.ToList();

            //VERIFY
            var sql = query.ToQueryString();

            _output.WriteLine(sql);
            entities.Count().ShouldEqual(1);
        }
        public void TestTwoQueryFilters()
        {
            //SETUP
            var options = SqliteInMemory.CreateOptions <MyDbContext>();
            var userId  = "GoodId";

            using var context = new MyDbContext(options, userId);
            context.Database.EnsureCreated();

            //ATTEMPT
            var e1 = new MyEntity {
                SoftDeleted = false, UserId = userId
            };
            var e2 = new MyEntity {
                SoftDeleted = true, UserId = userId
            };
            var e3 = new MyEntity {
                SoftDeleted = false, UserId = "BadId"
            };

            context.AddRange(e1, e2, e3);
            context.SaveChanges();

            //VERIFY
            context.ChangeTracker.Clear();
            context.MyEntities.Count().ShouldEqual(1);
            context.MyEntities.IgnoreQueryFilters().Count().ShouldEqual(3);
        }
Exemplo n.º 6
0
        static void Main(string[] args)
        {
            using (var db = new MyDbContext())
            {
                if (!db.Articles.Any())
                {
                    var articles = new List <Article> {
                        new Article {
                            Title = "testing is ok", Abst = "this is a test about postgre full text searching"
                        },
                        new Article {
                            Title = "tested all bugs", Abst = "there is no bug exists in this app"
                        }
                    };

                    db.AddRange(articles);
                    db.SaveChanges();
                }

                #region 英文
                var query = "test";

                var data = db.Articles
                           .Where(p => p.TitleVector.Matches(query) || p.AbstVector.Matches(query))
                           .OrderByDescending(p => p.TitleVector.Rank(EF.Functions.ToTsQuery(query)) * 2.0 + p.AbstVector.Rank(EF.Functions.ToTsQuery(query)))
                           .Select(p => new Article
                {
                    Title   = p.Title,
                    Abst    = p.Abst,
                    TitleHL = EF.Functions.ToTsQuery(query).GetResultHeadline(p.Title),
                    AbstHL  = EF.Functions.ToTsQuery(query).GetResultHeadline(p.Abst),
                });
                #endregion

                #region 中文 postgre未安装中文分词zhparser插件
                //var query = "测试";
                //var config = "chinese_zh";

                //var data = db.Articles
                //                    .Where(p => p.TitleVector.Matches(EF.Functions.ToTsQuery(config, query)) ||
                //                        p.AbstVector.Matches(EF.Functions.ToTsQuery(config, query)))
                //                    .OrderByDescending(p => p.TitleVector.Rank(EF.Functions.ToTsQuery(config, query)) * 2.0 +
                //                        p.AbstVector.Rank(EF.Functions.ToTsQuery(config, query)))
                //                    .Select(p => new Article
                //                    {
                //                        Title = p.Title,
                //                        Abst = p.Abst,
                //                        TitleHL = EF.Functions.ToTsQuery(config, query).GetResultHeadline(config, p.Title, ""),
                //                        AbstHL = EF.Functions.ToTsQuery(config, query).GetResultHeadline(config, p.Abst, ""),
                //                    });
                #endregion

                foreach (var article in data)
                {
                    Console.WriteLine($"{article.Title}\t{article.Abst}\t{article.TitleHL}\t{article.AbstHL}");
                }
            }
        }
Exemplo n.º 7
0
        public async Task SaveJsonPostsInDatabase()
        {
            var jsonData = System.IO.File.ReadAllText(@"Secret-seed-blog.json");

            JsonSerializerSettings settings = new JsonSerializerSettings
            {
                ContractResolver = new PrivateSetterContractResolver()
            };

            List <Post> posts = JsonConvert.DeserializeObject <List <Post> >(jsonData, settings);

            _dbContext.AddRange(posts);

            if (_dbContext.ChangeTracker.HasChanges())
            {
                await _dbContext.SaveChangesAsync();
            }
        }
Exemplo n.º 8
0
        public static void SeedDataContext(this MyDbContext context)
        {
            PasswordHasher passwordHasher = new PasswordHasher();
            var            user           = new User()
            {
                Username  = "******",
                FullName  = "Cinema Admin",
                Password  = passwordHasher.HashPassword("admin@123456"),
                Email     = "*****@*****.**",
                UserRoles = new List <UserRole>()
                {
                    new UserRole()
                    {
                        Role = new Role()
                        {
                            Name = "Admin",
                        }
                    },
                    new UserRole()
                    {
                        Role = new Role()
                        {
                            Name = "User",
                        }
                    },
                    new UserRole()
                    {
                        Role = new Role()
                        {
                            Name = "Staff",
                        }
                    }
                },
            };

            if (context.Users.Any(u => u.Username == "cinema-admin") == false)
            {
                context.AddRange(user);
                context.SaveChanges();
            }
        }
Exemplo n.º 9
0
        public void TestGetLocationList()
        {
            var options = new DbContextOptionsBuilder <MyDbContext>().UseInMemoryDatabase(databaseName: "TestGetCartTotal").Options;

            using (var context = new MyDbContext(options))
            {
                var stores = new List <Store>
                {
                    new Store {
                        Location = "Irving"
                    },
                    new Store {
                        Location = "Plano"
                    },
                    new Store {
                        Location = "Arlington"
                    },
                    new Store {
                        Location = "Lewisville"
                    },
                    new Store {
                        Location = "Mesquite"
                    },
                };
                context.AddRange(stores);
                context.SaveChanges();

                var numList = new List <int>();

                numList.Add(1);
                numList.Add(2);
                numList.Add(3);
                numList.Add(4);
                numList.Add(5);

                List <string> anslist = BusinessLogic.GetLocationNameList(numList, context);
                Assert.Equal(stores[0].Location, anslist[0]);
            }
        }
Exemplo n.º 10
0
        public void TestDemo()
        {
            //SETUP
            var options = SqliteInMemory.CreateOptions <MyDbContext>();

            using var context = new MyDbContext(options);
            context.Database.EnsureCreated();

            //ATTEMPT
            var e1 = new MyEntity {
                SoftDeleted = false
            };
            var e2 = new MyEntity {
                SoftDeleted = true
            };

            context.AddRange(e1, e2);
            context.SaveChanges();

            //VERIFY
            context.ChangeTracker.Clear();
            context.MyEntities.Count().ShouldEqual(1);
            context.MyEntities.IgnoreQueryFilters().Count().ShouldEqual(2);
        }
        public static void SeedStores(MyDbContext context)
        {
            var stores = new List <Store>
            {
                new Store {
                    Location = "Irving"
                },
                new Store {
                    Location = "Plano"
                },
                new Store {
                    Location = "Arlington"
                },
                new Store {
                    Location = "Lewisville"
                },
                new Store {
                    Location = "Mesquite"
                },
            };

            context.AddRange(stores);
            context.SaveChanges();
        }
Exemplo n.º 12
0
        public void TestSubcartFormatCount()
        {
            int numOfOrderGroups = -1;
            var options          = new DbContextOptionsBuilder <MyDbContext>().UseInMemoryDatabase(databaseName: "TestSubcartFormatCount").Options;

            using (var context = new MyDbContext(options))
            {
                var productList = new List <Product>()
                {
                    new Product {
                        Name = "Mattress Frame", Description = "This is a mattress frame to fit a king-sized mattress.", Price = 149.99, Quantity = 50, StoreId = 1
                    },
                    new Product {
                        Name = "Memory Foam Mattress", Description = "This is a king-sized memory foam mattress. The best of the best!", Price = 499.99, Quantity = 50, StoreId = 2
                    },
                    new Product {
                        Name = "Spring Mattress", Description = "This is a king-sized spring mattress. Comfort at an affordable price!", Price = 274.99, Quantity = 50, StoreId = 3
                    },
                };
                context.Products.AddRange(productList);
                context.SaveChanges();

                var stores = new List <Store>
                {
                    new Store {
                        Location = "Irving"
                    },
                    new Store {
                        Location = "Plano"
                    },
                    new Store {
                        Location = "Arlington"
                    },
                    new Store {
                        Location = "Lewisville"
                    },
                    new Store {
                        Location = "Mesquite"
                    },
                };
                context.AddRange(stores);
                context.SaveChanges();

                Cart newCart = BusinessLogic.NewCart();
                newCart.CustId = 1;
                newCart.Costs.Add(100);
                newCart.Costs.Add(200);
                newCart.Costs.Add(300);
                newCart.CustId = 1;
                newCart.LocIds.Add(1);
                newCart.LocIds.Add(2);
                newCart.LocIds.Add(3);
                newCart.OrderQuantity.Add(3);
                newCart.OrderQuantity.Add(2);
                newCart.OrderQuantity.Add(1);
                newCart.ProdIds.Add(1);
                newCart.ProdIds.Add(2);
                newCart.ProdIds.Add(3);
                newCart.ProdNames.Add("a");
                newCart.ProdNames.Add("b");
                newCart.ProdNames.Add("c");
                newCart.TotalCost = 0.00;

                BusinessLogic.AddCartToDb(newCart, context);
                BusinessLogic.AddCartToDb(newCart, context);

                List <HistorySubcart> historySubcart = BusinessLogic.FormatLocOrderHistory(1, context);
                numOfOrderGroups = historySubcart.Count();
            }
            Assert.Equal(2, numOfOrderGroups);
        }
Exemplo n.º 13
0
 public void AddMultiple(List <T> entities)
 {
     _context.AddRange(entities);
 }
Exemplo n.º 14
0
 public void AddRange(IEnumerable entities)
 {
     _context.AddRange(entities);
     //  Save();
 }
Exemplo n.º 15
0
 public virtual void InserirLote(List <T> lista)
 {
     _Db.AddRange(lista);
     _Db.SaveChanges();
 }
        public static void SeedProducts(MyDbContext context)
        {
            var prod = new List <Product>
            {
                new Product {
                    Name = "Mattress Frame", Description = "This is a mattress frame to fit a king-sized mattress.", Price = 149.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Memory Foam Mattress", Description = "This is a king-sized memory foam mattress. The best of the best!", Price = 499.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Spring Mattress", Description = "This is a king-sized spring mattress. Comfort at an affordable price!", Price = 274.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Box Spring", Description = "This is a must for all king-sized beds!", Price = 89.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Pillow (Feather)", Description = "This is an extremely comfortable feather pillow!", Price = 24.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Pillow (Microbead)", Description = "This is a modern form-fitting pillow!", Price = 22.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Pillow (Memory Foam)", Description = "This memory foam pillow will give you the ultimate support!", Price = 32.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Comforter", Description = "This comforter will fit a king size mattress.", Price = 28.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Sheets", Description = "This set of sheets will fit a king-sized bed.", Price = 42.99, Quantity = 50, StoreId = 1
                },
                new Product {
                    Name = "Mattress Frame", Description = "This is a mattress frame to fit a king-sized mattress.", Price = 149.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Memory Foam Mattress", Description = "This is a king-sized memory foam mattress. The best of the best!", Price = 499.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Spring Mattress", Description = "This is a king-sized spring mattress. Comfort at an affordable price!", Price = 274.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Box Spring", Description = "This is a must for all king-sized beds!", Price = 89.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Pillow (Feather)", Description = "This is an extremely comfortable feather pillow!", Price = 24.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Pillow (Microbead)", Description = "This is a modern form-fitting pillow!", Price = 22.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Pillow (Memory Foam)", Description = "This memory foam pillow will give you the ultimate support!", Price = 32.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Comforter", Description = "This comforter will fit a king size mattress.", Price = 28.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Sheets", Description = "This set of sheets will fit a king-sized bed.", Price = 42.99, Quantity = 50, StoreId = 2
                },
                new Product {
                    Name = "Mattress Frame", Description = "This is a mattress frame to fit a king-sized mattress.", Price = 149.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Memory Foam Mattress", Description = "This is a king-sized memory foam mattress. The best of the best!", Price = 499.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Spring Mattress", Description = "This is a king-sized spring mattress. Comfort at an affordable price!", Price = 274.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Box Spring", Description = "This is a must for all king-sized beds!", Price = 89.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Pillow (Feather)", Description = "This is an extremely comfortable feather pillow!", Price = 24.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Pillow (Microbead)", Description = "This is a modern form-fitting pillow!", Price = 22.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Pillow (Memory Foam)", Description = "This memory foam pillow will give you the ultimate support!", Price = 32.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Comforter", Description = "This comforter will fit a king size mattress.", Price = 28.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Sheets", Description = "This set of sheets will fit a king-sized bed.", Price = 42.99, Quantity = 50, StoreId = 3
                },
                new Product {
                    Name = "Mattress Frame", Description = "This is a mattress frame to fit a king-sized mattress.", Price = 149.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Memory Foam Mattress", Description = "This is a king-sized memory foam mattress. The best of the best!", Price = 499.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Spring Mattress", Description = "This is a king-sized spring mattress. Comfort at an affordable price!", Price = 274.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Box Spring", Description = "This is a must for all king-sized beds!", Price = 89.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Pillow (Feather)", Description = "This is an extremely comfortable feather pillow!", Price = 24.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Pillow (Microbead)", Description = "This is a modern form-fitting pillow!", Price = 22.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Pillow (Memory Foam)", Description = "This memory foam pillow will give you the ultimate support!", Price = 32.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Comforter", Description = "This comforter will fit a king size mattress.", Price = 28.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Sheets", Description = "This set of sheets will fit a king-sized bed.", Price = 42.99, Quantity = 50, StoreId = 4
                },
                new Product {
                    Name = "Mattress Frame", Description = "This is a mattress frame to fit a king-sized mattress.", Price = 149.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Memory Foam Mattress", Description = "This is a king-sized memory foam mattress. The best of the best!", Price = 499.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Spring Mattress", Description = "This is a king-sized spring mattress. Comfort at an affordable price!", Price = 274.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Box Spring", Description = "This is a must for all king-sized beds!", Price = 89.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Pillow (Feather)", Description = "This is an extremely comfortable feather pillow!", Price = 24.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Pillow (Microbead)", Description = "This is a modern form-fitting pillow!", Price = 22.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Pillow (Memory Foam)", Description = "This memory foam pillow will give you the ultimate support!", Price = 32.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Comforter", Description = "This comforter will fit a king size mattress.", Price = 28.99, Quantity = 50, StoreId = 5
                },
                new Product {
                    Name = "Sheets", Description = "This set of sheets will fit a king-sized bed.", Price = 42.99, Quantity = 50, StoreId = 5
                },
            };

            context.AddRange(prod);
            context.SaveChanges();
        }