Пример #1
0
 public MainPageViewModel(INavigationService navigationService, UserLibraryViewModel userLibaryViewModel, CatalogsViewModel catalogsViewModel, DataBaseInitializer dbInitialzier)
 {
     _navigationService   = navigationService;
     _dbInitialzier       = dbInitialzier;
     UserLibraryViewModel = userLibaryViewModel;
     CatalogsViewModel    = catalogsViewModel;
 }
 public ClassificacoesController()
 {
     context = new Context();
     var dataBaseInitializer = new DataBaseInitializer();
     dataBaseInitializer.InitializeDatabase(context);
     repClassificacao = new Repository<Classificacao>(context);
 }
Пример #3
0
 private void NewFile_Click(object sender, RoutedEventArgs e)
 {
     try {
         var of = new OFWindow(true)
         {
             AppendErrorDelegate   = AppBehind.Get.AppendError,
             RowHeightPlus         = AppBehind.Get.DataGridRowHeightPlus,
             OpenButtonCaption     = AppBehind.Get.OFWindowCaptions.OpenDatabaseButton,
             NewFileButtonCaption  = AppBehind.Get.OFWindowCaptions.NewDatabaseButton,
             FileNameColumnCaption = AppBehind.Get.OFWindowCaptions.FileNameColumn,
             OverwriteDialogTitle  = AppBehind.Get.OFWindowCaptions.OverwriteDialogTitle,
             OverwriteMessage      = AppBehind.Get.OFWindowCaptions.OverwriteMessage,
             Title = AppBehind.Get.OFWindowCaptions.NewDatabaseTitle
         };
         of.Init();
         of.ShowDialog();
         if (null == of.SelectedPath || @"".Equals(of.SelectedPath))
         {
             return;
         }
         AppBehind.Get.DBFilePath = of.SelectedPath;
         FilePathOutput.Content   = AppBehind.Get.DBFilePath;
         AppBehind.Get.Password   = PasswordInput.Text;
         DataBaseInitializer.Run();
         AppBehind.Get.Reload();
     }
     catch (Exception ex) {
         AppBehind.Get.AppendError(ex.Message, ex);
     }
 }
Пример #4
0
        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IHostingEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }
            else
            {
                // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
                app.UseHsts();
            }
            // Enable middleware to serve generated Swagger as a JSON endpoint.
            app.UseSwagger();
            // Enable middleware to serve swagger-ui (HTML, JS, CSS, etc.),
            // specifying the Swagger JSON endpoint.
            app.UseSwaggerUI(c =>
            {
                c.SwaggerEndpoint("/swagger/v1/swagger.json", "PlanNeuro API");
                c.RoutePrefix = string.Empty;
            });

            app.UseCors("CorsPolicy");
            app.UseSignalR(routes =>
            {
                routes.MapHub <ConversationHub>("/chat");
            });
            app.UseMiddleware <ValidationExceptionHandlingMiddleware>();
            app.UseMiddleware <ResponseCreatingMiddleware>();
            app.UseAuthentication();
            app.UseHttpsRedirection();
            app.UseMvc();
            DataBaseInitializer.InitializeAsync(app.ApplicationServices).GetAwaiter().GetResult();
        }
Пример #5
0
        public static void Main(string[] args)
        {
            var host = CreateWebHostBuilder(args).Build();

            using (var scope = host.Services.CreateScope())
            {
                var services = scope.ServiceProvider;
                try
                {
                    var context = services.GetRequiredService <WebContext>();
                    DataBaseInitializer.Initialize(context);
                    var  userManager  = services.GetRequiredService <UserManager <IdentityUser> >();
                    var  rolesManager = services.GetRequiredService <RoleManager <IdentityRole> >();
                    Task t            = RoleInitializer.InitializeAsync(userManager, rolesManager, context);
                    t.Wait();
                }
                catch (Exception ex)
                {
                    var logger = services.GetRequiredService <ILogger <Program> >();
                    logger.LogError(ex, "An error occurred while seeding the database.");
                }
            }

            host.Run();
        }
Пример #6
0
        static void Main()
        {
            bool tryCreateNewApp;

            new Mutex(true, MAppName, out tryCreateNewApp);
            var tempHandle = FindWindow(null, MAppName);

            Properties.Settings.Default.ProgrammWindowName = MAppName;

            if (tryCreateNewApp)
            {
                var baseiInitializer = new DataBaseInitializer();
                baseiInitializer.CreateDb();

                Application.EnableVisualStyles();
                Application.SetCompatibleTextRenderingDefault(false);

                LocalAppData.Instance.Categories = new CategoryRepository().GetAllCategories().ToList();
                LocalAppData.Instance.Words      = new WordRepository().GetAllWords().ToList();
                LocalAppData.Instance.Answers    = new AnswerRepository().GetAllAnswers().ToList();
                Application.Run(new MainForm());
            }
            else
            {
                ShowWindow(tempHandle, 5);
                SetForegroundWindow(tempHandle);
            }
        }
Пример #7
0
        public static void Main(string[] args)
        {
            /*
             * Get a database context instance from the dependency injection container.
             * Call the seed method, passing to it the context.
             * Dispose the context when the seed method is done.
             */
            var host = BuildWebHost(args);

            using (var scope = host.Services.CreateScope())
            {
                var services = scope.ServiceProvider;
                try
                {
                    var context = services.GetRequiredService <ApplicationDbContext>();
                    DataBaseInitializer.Initialize(context);
                }
                catch (Exception ex)
                {
                    var logger = services.GetRequiredService <ILogger <Program> >();
                    logger.LogError(ex, "An error occurred while seeding the database.");
                }
            }

            host.Run();
        }
Пример #8
0
        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env, MsSqlServerClient sqlServerClient)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }
            else
            {
                app.UseExceptionHandler("/Home/Error");
                // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
                app.UseHsts();
            }
            app.UseRequestLogging();                               //используем этот компонент для логирования http запросов к серверу

            var Sqlconnection = sqlServerClient.SqlConnection;     //получаем наш connection

            DataBaseInitializer.CreateProfileTable(Sqlconnection); //создаём табличку, если её нет
            DataBaseInitializer.InitializeProfiles(Sqlconnection); //инициализируем табличку начальными данными, если данных в таблице нет


            app.UseHttpsRedirection();
            app.UseStaticFiles();

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllerRoute(
                    name: "default",
                    pattern: "{controller}/{action}/{part}",
                    defaults: new { controller = "Home", action = "Index", part = 1 });
            });
        }
Пример #9
0
        static void Main(string[] args)
        {
            var host         = CreateHostBuilder(args).Build();
            var scopeFactory = host.Services.GetService <IServiceScopeFactory>();

            using (var scope = scopeFactory.CreateScope())
            {
                var services = scope.ServiceProvider;

                try
                {
                    var userManager  = services.GetRequiredService <UserManager <StoreUser> >();
                    var rolesManager = services.GetRequiredService <RoleManager <IdentityRole> >();
                    var appDbContext = services.GetRequiredService <BooksStoreContext>();
                    DataBaseInitializer.SeedData(userManager, rolesManager, appDbContext).Wait();
                }
                catch (Exception ex)
                {
                    var logger = services.GetRequiredService <ILogger <Program> >();
                    logger.LogError(ex, "An error occurred while seeding the database.");
                }
            }

            host.Run();
        }
 public TransportadorasController()
 {
     context = new Context();
     var dataBaseInitializer = new DataBaseInitializer();
     dataBaseInitializer.InitializeDatabase(context);
     repositorioTransportadora = new Repository<Transportadora>(context);
 }
Пример #11
0
 public HomeController()
 {
     context = new Context();
     var dataBaseInitializer = new DataBaseInitializer();
     dataBaseInitializer.InitializeDatabase(context);
     repositorioTransportadora = new Repository<Transportadora>(context);
     repositorioClassificacao = new Repository<Classificacao>(context);
     repositorioAvaliacao = new Repository<Avaliacao>(context);
 }
Пример #12
0
        static void Main(string[] args)
        {
            try
            {
                DataBaseInitializer <MessageContext> .InitializedDatabase();

                using (BaseContext context = ContextFactory.Create())
                {
                    IUnitOfWork uow = new EFUnitOfWork(context);

                    IRepository <User> userRepository = uow.GetRepository <User>();
                    User user1 = new User()
                    {
                        Name = "Berkay"
                    };
                    User user2 = new User()
                    {
                        Name = "Arda"
                    };
                    userRepository.Add(user1);
                    userRepository.Add(user2);

                    uow.SaveChanges();

                    IRepository <Message> msgRepository = uow.GetRepository <Message>();
                    msgRepository.Add(new Message()
                    {
                        FromUser = user1, ToUser = user2, Text = $"Selam. Nasılsın?", CreateDate = DateTime.Now
                    });
                    msgRepository.Add(new Message()
                    {
                        FromUser = user2, ToUser = user1, Text = $"İyiyim", CreateDate = DateTime.Now
                    });
                    uow.SaveChanges();

                    Console.WriteLine("Tüm mesajlar cekiliyor...");
                    foreach (var msg in msgRepository.GetAll())
                    {
                        Console.WriteLine(msg.ToString());
                    }

                    Console.WriteLine("Berkay'ın mesajları çekiliyor");
                    foreach (var msg in msgRepository.GetAll((m) => m.FromUser.Name == "Berkay"))
                    {
                        Console.WriteLine(msg.ToString());
                    }

                    InvokeUnitySample();
                }

                Console.ReadLine();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
            }
        }
Пример #13
0
        public static IApplicationBuilder SeedDatabase(this IApplicationBuilder app)
        {
            IServiceProvider serviceProvider = app.ApplicationServices.CreateScope().ServiceProvider;

            try
            {
                DataBaseInitializer.Initialize(serviceProvider);
            }
            catch (Exception ex)
            {
                ILogger <Program> logger = serviceProvider.GetRequiredService <ILogger <Program> >();
                logger.LogError(ex, "An error occurred while seeding the database.");
            }

            return(app);
        }
Пример #14
0
 private static void CreateDbIfNotExists(IHost host)
 {
     using (var scope = host.Services.CreateScope())
     {
         var services = scope.ServiceProvider;
         try
         {
             var context = services.GetRequiredService <DataBaseContext>();
             DataBaseInitializer.Initialize(context);
         }
         catch (Exception ex)
         {
             var logger = services.GetRequiredService <ILogger <Program> >();
             logger.LogError(ex, "An error occurred creating the DB.");
         }
     }
 }
Пример #15
0
        static void Main(string[] args)
        {
            DataBaseInitializer <TaskContext> .InitializedDatabase();

            IContainer container = new SimpleIocContainer();

            BootStrapper.Configure(container);

            ICommandDispatcher commandDispatcher = container.Resolve <ICommandDispatcher>();

            IQueryDispatcher queryDispatcher = container.Resolve <IQueryDispatcher>();



            var createCommand = new CreateTaskCommand {
                Title = "CQRS Örneği", UserName = "******", IsCompleted = false, CreatedOn = DateTime.Now, UpdatedOn = DateTime.Now
            };

            commandDispatcher.Execute(createCommand);


            var getTasksQuery = new GetTasksQuery();

            getTasksQuery.Predicate = (t) => t.IsCompleted == false;

            IQueryable <Task> tasks = queryDispatcher.Query <GetTasksQuery, IQueryable <Task> >(getTasksQuery);


            Console.WriteLine("Bitmemiş tasklar getiriliyor.");

            foreach (var task in tasks.ToList())
            {
                Console.WriteLine(task);
            }

            var lastTask = tasks.ToList().LastOrDefault();


            var changeCommand = new ChangeTaskStatusCommand {
                TaskId = 24, IsCompleted = true, UpdatedOn = DateTime.Now.AddMinutes(5)
            };

            commandDispatcher.Execute(changeCommand);

            Console.ReadLine();
        }
Пример #16
0
        public static void Main(string[] args)
        {
            var host = BuildWebHost(args);

            using (var scope = host.Services.CreateScope())
            {
                var services = scope.ServiceProvider;
                try
                {
                    var context = services.GetRequiredService <FireContext>();
                    DataBaseInitializer.Initialize(context);
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error while seeding database.");
                }
            }

            host.Run();
        }
Пример #17
0
        public static void Main(string[] args)
        {
            var host = BuildWebHost(args);

            using (var scope = host.Services.CreateScope())
            {
                var services = scope.ServiceProvider;
                try
                {
                    var context = services.GetRequiredService <EmployeeEntity>();
                    DataBaseInitializer.Initialize(context);
                }
                catch (Exception ex)
                {
                    var logger = services.GetRequiredService <ILogger <Program> >();
                    logger.LogError(ex, "An error occured while initializing the database");
                }
            }
            host.Run();
        }
Пример #18
0
        public static void Main(string[] args)
        {
            var host = CreateHostBuilder(args).Build();

            using (var serviceScope = host.Services.CreateScope())
            {
                var services = serviceScope.ServiceProvider;

                try
                {
                    var context = services.GetRequiredService <AppCtx>();
                    DataBaseInitializer.Initialize(context);
                }
                catch (Exception ex)
                {
                    var logger = services.GetRequiredService <ILogger <Program> >();
                    logger.LogError(ex, "An error occurred while seeding the database.");
                }
            }



            host.Run();
        }
Пример #19
0
 public ItemsController(ItemDbContext dbContext)
 {
     _dbContext = dbContext;
     DataBaseInitializer.Initialize(_dbContext);
 }
Пример #20
0
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env, UserManager <User> userManager,
                              RoleManager <IdentityRole <Guid> > roleManager, ApplicationContext dbContext)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }

            app.UseCors();

            app.UseGraphQL <AuthorGraphSchema>("/api/author/graphql");
            app.UseGraphQL <PrintingEditionGraphSchema>("/api/printingEdition/graphql");
            app.UseGraphQL <UserGraphSchema>("/api/user/graphql");
            app.UseGraphQL <OrderGraphSchema>("/api/order/graphql");

            app.UseGraphQLPlayground(new GraphQLPlaygroundOptions
            {
                GraphQLEndPoint = "/api/author/graphql",
                Path            = "/api/author/playground"
            });

            app.UseGraphQLPlayground(new GraphQLPlaygroundOptions
            {
                GraphQLEndPoint = "/api/printingEdition/graphql",
                Path            = "/api/printingEdition/playground"
            });

            app.UseGraphQLPlayground(new GraphQLPlaygroundOptions
            {
                GraphQLEndPoint = "/api/user/graphql",
                Path            = "/api/user/playground"
            });

            app.UseGraphQLPlayground(new GraphQLPlaygroundOptions
            {
                GraphQLEndPoint = "/api/order/graphql",
                Path            = "/api/order/playground"
            });

            var swaggerSection = Configuration.GetSection("SwaggerSettings");

            app.UseSwagger(option =>
            {
                option.RouteTemplate = swaggerSection["JsonRoute"];
            });

            app.UseSwaggerUI(option =>
            {
                option.SwaggerEndpoint(swaggerSection["UIEndpoint"], swaggerSection["Description"]);
            });

            app.UseHttpsRedirection();
            app.UseRouting();
            app.UseAuthorization();
            app.UseAuthentication();
            app.UseMiddleware <LoggerMiddleware>();
            var dataBaseInitializer = new DataBaseInitializer(userManager, roleManager, dbContext);

            dataBaseInitializer.InitializeDb();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllers();
            });
        }
Пример #21
0
        protected override void Seed(DataAccessContext context)
        {
            var dataBaseInitializer = new DataBaseInitializer(context);

            dataBaseInitializer.Init(context);
        }
        public void InitializeDatabase(Action <IDatabaseInitializer> initFunc = null)
        {
            DataBaseInitializer initializer = _databaseProvider.GetDatabaseInitializer(_connectionString);

            initFunc?.Invoke(initializer);

            IEnumerable <Type> GetTypesOrderedCorrectly(IEnumerable <Type> types)
            {
                List <Type> typesList = types.ToList();

                while (typesList.Count > 0)
                {
                    for (int i = 0; i < typesList.Count; i++)
                    {
                        TypeMappingOptions typeMappingOptions = _mappingOptionsSet.GetTypeMappingOptions(typesList[i]);
                        if (!typeMappingOptions.MemberMappingOptions.OfType <ForeignObjectMappingOptions>()
                            .Where(x => typesList.Contains(x.ForeignObjectType))
                            .Any())
                        {
                            yield return(typesList[i]);

                            typesList.RemoveAt(i);
                        }
                    }
                }
            }

            foreach (Type type in GetTypesOrderedCorrectly(_relationalObjectProvider.Keys))
            {
                TypeMappingOptions typeMappingOptions = _mappingOptionsSet.GetTypeMappingOptions(type);
                initializer.AddTable(typeMappingOptions.TableName);
                foreach (FieldMappingOptions memberMappineOptions in typeMappingOptions.MemberMappingOptions.OfType <FieldMappingOptions>().OrderBy(x => x.IsPrimaryKey))
                {
                    if (memberMappineOptions.Type == MappingType.ReferenceListMapping)
                    {
                        continue;
                    }

                    if (memberMappineOptions is ForeignObjectMappingOptions foreignObjectMappingOptions)
                    {
                        initializer.AddField(foreignObjectMappingOptions.DatabaseFieldName, foreignObjectMappingOptions.KeyType);

                        FieldMappingOptions foreignFieldMappingOptions = foreignObjectMappingOptions.ForeignMember as FieldMappingOptions;
                        TypeMappingOptions  foreignTypeMappingOptions  = _mappingOptionsSet.GetTypeMappingOptions(foreignObjectMappingOptions.ForeignObjectType);

                        IEnumerable <ReferenceListMappingOptions> referenceListMappingOptions =
                            foreignTypeMappingOptions.MemberMappingOptions.OfType <ReferenceListMappingOptions>()
                            .Where(x => x.ForeignProperty == foreignObjectMappingOptions.Member);



                        initializer.AddForeignKey(
                            foreignTypeMappingOptions.TableName,
                            foreignFieldMappingOptions.DatabaseFieldName,
                            referenceListMappingOptions.Any(x => x.DeleteCascade));
                    }
                    else
                    {
                        initializer.AddField(memberMappineOptions.DatabaseFieldName, memberMappineOptions.Member.PropertyType);
                    }

                    if (memberMappineOptions.IsPrimaryKey)
                    {
                        initializer.SetIsKeyField(memberMappineOptions.IsReadonly);
                    }
                }
            }

            initializer.Flush();
        }
Пример #23
0
        public SimpleMembershipInitializer()
        {
            Database.SetInitializer <LmPlatformModelsContext>(null);

            try
            {
                bool firstLoad;

                using (var context = new LmPlatformModelsContext())
                {
                    firstLoad = DataBaseInitializer.InitializeDatabase(context);
                }

                WebSecurity.InitializeDatabaseConnection("DefaultConnection", "Users", "UserId", "UserName", autoCreateTables: false);

                if (firstLoad)
                {
                    WebSecurity.CreateUserAndAccount("admin", "123456");
                    Roles.AddUserToRole("admin", "admin");
                    WebSecurity.CreateUserAndAccount("popova", "123456");
                    Roles.AddUserToRole("popova", "lector");
                    WebSecurity.CreateUserAndAccount("hawk_1", "123456");
                    Roles.AddUserToRole("hawk_1", "student");
                    WebSecurity.CreateUserAndAccount("hawk_2", "123456");
                    Roles.AddUserToRole("hawk_2", "student");
                    WebSecurity.CreateUserAndAccount("hawk_3", "123456");
                    Roles.AddUserToRole("hawk_3", "student");
                    WebSecurity.CreateUserAndAccount("hawk_4", "123456");
                    Roles.AddUserToRole("hawk_4", "student");
                    WebSecurity.CreateUserAndAccount("hawk_5", "123456");
                    Roles.AddUserToRole("hawk_5", "student");
                    WebSecurity.CreateUserAndAccount("hawk_6", "123456");
                    Roles.AddUserToRole("hawk_6", "student");
                    WebSecurity.CreateUserAndAccount("hawk_7", "123456");
                    Roles.AddUserToRole("hawk_7", "student");
                    WebSecurity.CreateUserAndAccount("hawk_8", "123456");
                    Roles.AddUserToRole("hawk_8", "student");
                    WebSecurity.CreateUserAndAccount("hawk_9", "123456");
                    Roles.AddUserToRole("hawk_9", "student");
                    WebSecurity.CreateUserAndAccount("hawk_10", "123456");
                    Roles.AddUserToRole("hawk_10", "student");
                    using (var context = new LmPlatformModelsContext())
                    {
                        context.Lecturers.Add(new Lecturer
                        {
                            Id         = 2,
                            FirstName  = "Юлия",
                            MiddleName = "Борисовна",
                            LastName   = "Попова"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 3,
                            GroupId    = 2,
                            FirstName  = "Сергей",
                            MiddleName = "Викторович",
                            LastName   = "Яцынович"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 4,
                            GroupId    = 2,
                            FirstName  = "Киррил",
                            MiddleName = "Викторович",
                            LastName   = "Андреевич"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 5,
                            GroupId    = 2,
                            FirstName  = "Петр",
                            MiddleName = "Викторович",
                            LastName   = "Петров"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 6,
                            GroupId    = 2,
                            FirstName  = "Иван",
                            MiddleName = "Иванович",
                            LastName   = "Иванов"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 7,
                            GroupId    = 2,
                            FirstName  = "Виктор",
                            MiddleName = "Викторович",
                            LastName   = "Иванченко"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 8,
                            GroupId    = 2,
                            FirstName  = "Виктор",
                            MiddleName = "Васильевич",
                            LastName   = "Шеремет"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 9,
                            GroupId    = 2,
                            FirstName  = "Андрей",
                            MiddleName = "Петрович",
                            LastName   = "Беляк"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 10,
                            GroupId    = 2,
                            FirstName  = "Екатерина",
                            MiddleName = "Ивановна",
                            LastName   = "Крузернштейн"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 11,
                            GroupId    = 2,
                            FirstName  = "Анатолий",
                            MiddleName = "Васильевич",
                            LastName   = "Шибека"
                        });

                        context.Students.Add(new Student
                        {
                            Id         = 12,
                            GroupId    = 2,
                            FirstName  = "Николай",
                            MiddleName = "Николаевич",
                            LastName   = "Гурский"
                        });

                        context.SaveChanges();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new InvalidOperationException("Ошибка", ex);
            }
        }