示例#1
0
        public static void InitData(EFDBContext context)
        {
            if (!context.Directories.Any())
            {
                context.Directories.Add(new Directory()
                {
                    Title = "First chapter",
                    Html  = "<h4>Placeholder1<h4>"
                });

                context.Directories.Add(new Directory()
                {
                    Title = "Second chapter",
                    Html  = "<h4>Placeholder2<h4>"
                });

                context.Directories.Add(new Directory()
                {
                    Title = "Third chapter",
                    Html  = "<h4>Placeholder3<h4>"
                });

                context.SaveChanges();

                if (!context.Materials.Any())
                {
                    context.Materials.Add(new Material()
                    {
                        Title       = "Paragraph11",
                        Html        = "About11",
                        DirectoryId = 1
                    });
                    context.Materials.Add(new Material()
                    {
                        Title       = "Paragraph12",
                        Html        = "About12",
                        DirectoryId = 1
                    });

                    context.Materials.Add(new Material()
                    {
                        Title       = "Paragraph21",
                        Html        = "About21",
                        DirectoryId = 2
                    });
                    context.Materials.Add(new Material()
                    {
                        Title       = "Paragraph22",
                        Html        = "About22",
                        DirectoryId = 2
                    });

                    context.Materials.Add(new Material()
                    {
                        Title       = "Paragraph31",
                        Html        = "About31",
                        DirectoryId = 3
                    });
                    context.Materials.Add(new Material()
                    {
                        Title       = "Paragraph32",
                        Html        = "About32",
                        DirectoryId = 3
                    });

                    context.SaveChanges();
                }
            }
        }
示例#2
0
        public static void InitData(EFDBContext context)
        {
            if (!context.Directories.Any())
            {
                context.Directories.Add(new Directory()
                {
                    Title = "Первый раздел", Html = "<h4>Введение в технологию ASP.NET</h4>"
                });
                context.Directories.Add(new Directory()
                {
                    Title = "Второй раздел",
                    Html  = "<h4>Особенности ASP.NET WebForms</h4>"
                });
                context.Directories.Add(new Directory()
                {
                    Title = "Третий раздел",
                    Html  = "<h4>Преимущества ASP.NET Core</h4>"
                });

                context.SaveChanges(); // обязательно - иначе не создастся директория и не добавятся материялы

                if (!context.Materials.Any())
                {
                    context.Materials.Add(new Material()
                    {
                        Title       = "Параграф-1",
                        Html        = "Аннотация-1",
                        DirectoryId = 1
                    });
                    context.Materials.Add(new Material()
                    {
                        Title       = "Параграф-2",
                        Html        = "Аннотация-2",
                        DirectoryId = 1
                    });

                    context.Materials.Add(new Material()
                    {
                        Title       = "Параграф-3",
                        Html        = "Аннотация-3",
                        DirectoryId = 2
                    });
                    context.Materials.Add(new Material()
                    {
                        Title       = "Параграф-4",
                        Html        = "Аннотация-4",
                        DirectoryId = 2
                    });

                    context.Materials.Add(new Material()
                    {
                        Title       = "Параграф-5",
                        Html        = "Аннотация-5",
                        DirectoryId = 3
                    });
                    context.Materials.Add(new Material()
                    {
                        Title       = "Параграф-6",
                        Html        = "Аннотация-6",
                        DirectoryId = 3
                    });

                    context.SaveChanges();
                }
            }
        }
示例#3
0
        public static void InitData(EFDBContext context)
        {
            if (!context.Users.Any())
            {
                //ADD USEERS

                context.Users.Add(new Entities.Users()
                {
                    Fio = "Vasya Pupkin"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Seva Dvijkov"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Seka Aubakirov"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Mishanaya Malinin"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Sanya Krasnov"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Emin Eminemovich"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Karim Asterkin"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Siden Snouden"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Water Price Cooper"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Serjan Marjan"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Ivan Ivanov"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Dedushka Kalinin"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Masya Zakin"
                });
                context.Users.Add(new Entities.Users()
                {
                    Fio = "Ivan Poddubniy"
                });
                context.SaveChanges();

                ///ADD GOODS

                context.Goods.Add(new Entities.Goods()
                {
                    Name = "IMAC", Price = 950000, UsersId = context.Users.First().Id
                });
                context.Goods.Add(new Entities.Goods()
                {
                    Name = "LENOVO NoTebook G500", Price = 275000, UsersId = context.Users.First().Id
                });
                context.Goods.Add(new Entities.Goods()
                {
                    Name = "Iphone X", Price = 265000, UsersId = context.Users.Last().Id
                });
                context.Goods.Add(new Entities.Goods()
                {
                    Name = "Macintosh Lel", Price = 330000, UsersId = context.Users.Last().Id
                });
                context.Goods.Add(new Entities.Goods()
                {
                    Name = "Rowenta shower", Price = 220000, UsersId = context.Users.Last().Id
                });
                context.SaveChanges();
            }
        }
示例#4
0
        public static void InitData(EFDBContext context)
        {
            Random rand = new Random();

            if (!context.author.Any())
            {
                context.author.Add(new Author {
                    Name = "Стивен", Surname = "Кинг"
                });
                context.author.Add(new Author {
                    Name = "Роберт", Surname = "Гэлбрейт"
                });
                context.author.Add(new Author {
                    Name = "Коллин", Surname = "Маккалоу"
                });
                context.author.Add(new Author {
                    Name = "Джеймс", Surname = "Боуэн"
                });
                context.author.Add(new Author {
                    Name = "Джордж", Surname = "Оруэлл"
                });
                context.author.Add(new Author {
                    Name = "Джордан", Surname = "Белфорт"
                });
                context.author.Add(new Author {
                    Name = "Кассанда", Surname = "Клэр"
                });
                context.SaveChanges();
            }
            if (!context.book.Any())
            {
                context.book.Add(new Book {
                    Name = "Город потеряных душ", Price = 200, Author = context.author.Find(7)
                });
                context.book.Add(new Book {
                    Name = "Волк с Уолл-стритт", Price = 150, Author = context.author.Find(6)
                });
                context.book.Add(new Book {
                    Name = "Страна радости", Price = 400, Author = context.author.Find(1)
                });
                context.book.Add(new Book {
                    Name = "Мир глазами кота Боба", Price = 200, Author = context.author.Find(4)
                });
                context.book.Add(new Book {
                    Name = "Зов кукушки", Price = 150, Author = context.author.Find(2)
                });
                context.book.Add(new Book {
                    Name = "Поющие в терновнике", Price = 100, Author = context.author.Find(3)
                });
                context.book.Add(new Book {
                    Name = "1984", Price = 200, Author = context.author.Find(5)
                });
                context.book.Add(new Book {
                    Name = "Оно", Price = 300, Author = context.author.Find(1)
                });
                context.SaveChanges();
            }
            if (!context.reader.Any())
            {
                context.reader.Add(new Reader {
                    Name = "Валентина", Surname = "Кравчук", Patronymic = "Анатолійович", Region = "Львівська", District = "Львів", Telephone = "0502019324", TicketNumber = 33146
                });
                context.reader.Add(new Reader {
                    Name = "Алла", Surname = "Мірошниченко", Patronymic = "Янович", Region = "Донецька", District = "Донецьк", Telephone = "0938543557", TicketNumber = 29275
                });
                context.reader.Add(new Reader {
                    Name = "Олег", Surname = "Пономаренко", Patronymic = "Миколайович", Region = "Київська", District = "Київ", Telephone = "0503099380", TicketNumber = 64181
                });
                context.reader.Add(new Reader {
                    Name = "Олексій", Surname = "Іванченко", Patronymic = "Олександрович", Region = "Луганська", District = "Луганськ", Telephone = "0505083359", TicketNumber = 76851
                });
                context.reader.Add(new Reader {
                    Name = "Олексій", Surname = "Таращук", Patronymic = "Іванович", Region = "Миколаївська", District = "Миколаїв", Telephone = "0506489765", TicketNumber = 75678
                });
                context.reader.Add(new Reader {
                    Name = "Іван", Surname = "Кравчук", Patronymic = "Валентинович", Region = "Дніпропетровська", District = "Дніпропетровськ", Telephone = "0637827497", TicketNumber = 48074
                });
                context.reader.Add(new Reader {
                    Name = "Василь", Surname = "Шинкаренко", Patronymic = "Євгенович", Region = "Закарпатська", District = "Ужгород", Telephone = "0671756456", TicketNumber = 76558
                });
                context.SaveChanges();
            }
            if (!context.log.Any())
            {
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.log.Add(new Log {
                    Reader = context.reader.Find(rand.Next(1, 8)), Book = context.book.Find(rand.Next(1, 8)), DateOfIssue = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30)), DateOfReturn = new DateTime(rand.Next(2011, 2020), rand.Next(1, 12), rand.Next(1, 30))
                });
                context.SaveChanges();
            }
        }
示例#5
0
 public DatabaseInit(EFDBContext context, UserManager <ApplicationUsers> userManager, RoleManager <ApplicationRole> roleManager)
 {
     _context     = context;
     _userManager = userManager;
     _roleManager = roleManager;
 }