public MainWindow() { InitializeComponent(); this.WindowStartupLocation = WindowStartupLocation.CenterScreen; // 数据库连接建立 string s = "Server =.; Database = {0}; integrated security = SSPI"; ConnectString = String.Format(s, DatabaseName); textNodeDB = new TextNodeDB(ConnectString); treeDB = new TreeDB(ConnectString); // 数据库初始化(创建数据库/表) InitDB initDB = new InitDB("Server=.;Database=master;integrated security=SSPI"); initDB.DatabaseName = DatabaseName; try { initDB.Init(); } catch (Exception e) { MessageBox.Show(e.Message); } treeView.UpdateTreeToDB += SaveTree; this.Loaded += OpenOrCreateTreeWindow; }
public Login() { InitializeComponent(); WindowStartupLocation = WindowStartupLocation.CenterScreen; FocusManager.SetFocusedElement(this, usernameBox); InitDB.InitiateDB(); }
private async Task InitializeDatabase(IApplicationBuilder app) { using (var scope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope()) { var context = scope.ServiceProvider.GetRequiredService <ApplicationDbContext>(); context.Database.Migrate(); var userManager = scope.ServiceProvider.GetRequiredService <UserManager <ApplicationUser> >(); foreach (var role in InitDB.GetRoles()) { if (!context.Roles.Where(x => x.Name == role.Name).Any()) { context.Roles.Add(role); } } await context.SaveChangesAsync(); foreach (var admin in InitDB.GetAdmins()) { if (!userManager.Users.Where(x => x.UserName == admin.UserName).Any()) { var result = await userManager.CreateAsync(admin, admin.Password); if (result.Succeeded) { await userManager.AddToRolesAsync(admin, InitDB.GetRoles().Select(x => x.Name)); } } } } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } // app.UseHttpsRedirection(); app.UseRouting(); app.UseCors(x => x.AllowAnyOrigin().AllowAnyMethod().AllowAnyHeader()); app.UseAuthentication(); app.UseAuthorization(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); InitDB.Populate(app); }
public MainWindow() { InitializeComponent(); // загружаем ресурсы пользовательских элементов //userControlHome = new UserControlHome(); userControlPassenger = new UserControlPassenger(); userControlFlight = new UserControlFlight(); userControlTicket = new UserControlTicket(); Context = new AirportContext(); InitDB.IsRebuid = true; // set it if you want to recreate database if (InitDB.IsRebuid) { Database.SetInitializer(new DropCreateDatabaseAlways <AirportContext>()); InitDB.Fill(Context); } else { Database.SetInitializer(new DropCreateDatabaseIfModelChanges <AirportContext>()); } userControlPassenger.PassengersGrid.DataContext = new PassengerTabViewModel(Context); userControlFlight.ArrivalFlightsGrid.DataContext = new FlightTabViewModel(Context); userControlFlight.DepartureFlightsGrid.DataContext = new FlightTabViewModel(Context); userControlTicket.TicketsGrid.DataContext = new TicketTabViewModel(Context); ContentGrid.Children.Add(userControlFlight); }
public void DBOperationsDown_Test() { InitDB initDB = new InitDB(); int count = initDB.DownOperations.Count; initDB.DownOperations.ToString(); Assert.IsType <int>(count); }
public void Initialize() { builder = new DbContextOptionsBuilder <ApplicationDBContext>(); builder.UseInMemoryDatabase(databaseName: "TestDB"); db = new ApplicationDBContext(builder.Options); InitDB.InitDbContext(db); }
public ActionResult Index() { InitDB.InitData(); var data = new GetDataModule(); List <Books> aa = new List <Books>(); var ListBook = data.getAllBooks(); return(View(ListBook.OrderByDescending(e => e.Score))); }
public void Initialize() { builder = new DbContextOptionsBuilder <ApplicationDBContext>(); builder.UseInMemoryDatabase(databaseName: "TestDB"); db = new ApplicationDBContext(builder.Options); InitDB.InitDbContext(db); unitOfWork = new UnitOfWork(db); userService = new UserService(unitOfWork); Mapper.Initialize(cfg => cfg.CreateMap <User, UserDTO>()); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); IDatabaseInitializer <BddContext> init = new InitDB(); Database.SetInitializer(init); init.InitializeDatabase(new BddContext()); }
public async Task <IEnumerable <Blog> > GetBlogs() { //var page = new PaginationParam(); //var (total, lis) = await InitDB.Create().FindListAsync<Blog>(page.SortColumn, page.IsASC, page.PageSize, page.CurrentPage); //return lis; var aaa = await InitDB.Create().FindObjectAsync("delete from t_sys_blog"); return((IEnumerable <Blog>)aaa); }
public static void Register(HttpConfiguration config) { // Конфигурация и службы веб-API // Маршруты веб-API config.MapHttpAttributeRoutes(); config.Routes.MapHttpRoute( name: "DefaultApi", routeTemplate: "api/{controller}/{id}", defaults: new { id = RouteParameter.Optional } ); InitDB.Load(); }
/// <summary> /// The Index. /// </summary> /// <returns>The <see cref="ActionResult"/>.</returns> public ActionResult Index() { using (ERPDBEntities db = new ERPDBEntities()) { if (!db.Product.Any()) { InitDB.InitProduct(); } if (!db.Staff.Any()) { InitDB.InitStaff(); } if (!db.schedule.Any()) { InitDB.InitSchedule(); } if (!db.WorkTime.Any()) { InitDB.InitWorkTime(); } if (!db.Sell_Record.Any()) { InitDB.InitSellRecord(); } if (!db.Inventory.Any()) { InitDB.InitInventory(); } if (!db.Staff_Auth.Any()) { InitDB.InitStaffAuth(); } } return(View()); }
public static void Main(string[] args) { var host = Host.CreateDefaultBuilder(args).ConfigureWebHostDefaults(webBuilder => { webBuilder.UseStartup <Startup>(); }).Build(); using (IServiceScope scope = host.Services.CreateScope()) { IServiceProvider services = scope.ServiceProvider; try { var context = services.GetRequiredService <StudentsDB>(); InitDB.Initialize(context); } catch (Exception ex) { var logger = services.GetRequiredService <ILogger <Program> >(); logger.LogError(ex, "An error occurred while seeding the database."); } } host.Run(); }
public static void Main(string[] args) { var ambiente = BuildWebHost(args); using (var escopo = ambiente.Services.CreateScope()) { var servico = escopo.ServiceProvider; try { var contex = servico.GetRequiredService <DataBaseContext>(); InitDB.Init(contex); //contex.Database.EnsureCreated(); // InicializarBanco.Iniciar(contex); } catch (Exception e) { var logger = servico.GetRequiredService <ILogger <Program> >(); logger.LogError(e, "Ocorreu um erro enquanto os dados foram enviados"); } } ambiente.Run(); //CreateWebHostBuilder(args).Build().Run(); }
public IDataBaseOperation GetInterface() { return(InitDB.Create("SqlServer", "Data Source=.;DataBase=MyBlog;Trusted_Connection=True;") .GetIDataBaseOperation()); }
private void Button_Click(object sender, RoutedEventArgs e) { InitDB.Init(); }
public ViewModelUpdateDB(ILoginToken token) { _token = token; t = _token as LoginToken <Administrator>; FCS = FlyingCenterSystem.GetFlyingCenterSystemInstance(); ILoggedInAdministratorFacade administratorFacade = FCS.GetFacade(token) as ILoggedInAdministratorFacade; AddDBCommand = new DelegateCommand(() => { Log.logger.Debug("Start AddDBCommand"); progressCounter = 0; LogMessage = ""; totalResources = NumOfCountries + NumOfCustomers + NumOfAirlineCompanies + NumOfFlights + NumOfAdministrators; AddToCountryList(administratorFacade, t); Task taskA = Task.Run(() => { for (int i = 0; i < NumOfAdministrators; i++) { InsertAdministratorsToDb(administratorFacade, t); } if (counterAdministrator == NumOfAdministrators) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Administrators created", counterAdministrator); } else if (counterAdministrator < NumOfAdministrators || counterAdministrator == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfCustomers} Administrators"); } for (int i = 0; i < NumOfCustomers; i++) { InsertCustomerToDb(administratorFacade, t); } if (counterCustomers == NumOfCustomers) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Customers created", counterCustomers); } else if (counterCustomers < NumOfCustomers || counterCustomers == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfCustomers} customers"); } InsertCountriesToDbByNumOfCountries(NumOfCountries, administratorFacade, t); if (counterCountries == NumOfCountries) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Countries created", NumOfCountries); } else if (counterCountries < NumOfCountries || counterCountries == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfCountries} countries"); } for (int i = 0; i < NumOfAirlineCompanies; i++) { Log.logger.Debug($"Before InsertAirlineCompanyToDb i = {i} from {NumOfAirlineCompanies}"); InsertAirlineCompanyToDb(administratorFacade, t); } if (counterAielineCompanies == NumOfAirlineCompanies) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Airline Companies created", NumOfAirlineCompanies); } else if (counterAielineCompanies < NumOfAirlineCompanies || counterAielineCompanies == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfAirlineCompanies} airline companies"); } for (int i = 0; i < NumOfFlights; i++) { InsertFlightsToDb(administratorFacade, t); } if (counterFlights == NumOfFlights) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Flights created", NumOfFlights); } else if (counterFlights == NumOfFlights || counterFlights == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfFlights} flights"); } for (int i = 0; i < NumOfTickets; i++) { InsetTicketsToDb(administratorFacade, t); } if (counterTickets == NumOfTickets) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Tickets created", NumOfTickets); } else if (counterTickets < NumOfTickets || counterTickets == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfTickets} tickets"); } }); }, () => { return(CanExecuteAddMethod()); }); ReplaceDBCommand = new DelegateCommand(() => { Log.logger.Debug("Start ReplaceDBCommand"); InitDB.InitDataBase(); progressCounter = 0; LogMessage = ""; totalResources = NumOfCountries + NumOfCustomers + NumOfAirlineCompanies + NumOfFlights + NumOfAdministrators; AddToCountryList(administratorFacade, t); Task taskA = Task.Run(() => { for (int i = 0; i < NumOfAdministrators; i++) { InsertAdministratorsToDb(administratorFacade, t); } if (counterAdministrator == NumOfAdministrators) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Administrators created", counterAdministrator); } else if (counterAdministrator < NumOfAdministrators || counterAdministrator == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfCustomers} Administrators"); } for (int i = 0; i < NumOfCustomers; i++) { InsertCustomerToDb(administratorFacade, t); } if (counterCustomers == NumOfCustomers) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Customers created", counterCustomers); } else if (counterCustomers < NumOfCustomers || counterCustomers == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfCustomers} customers"); } InsertCountriesToDbByNumOfCountries(NumOfCountries, administratorFacade, t); if (counterCountries == NumOfCountries) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Countries created", NumOfCountries); } else if (counterCountries < NumOfCountries || counterCountries == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfCountries} countries"); } for (int i = 0; i < NumOfAirlineCompanies; i++) { Log.logger.Debug($"Before InsertAirlineCompanyToDb i = {i} from {NumOfAirlineCompanies}"); InsertAirlineCompanyToDb(administratorFacade, t); } if (counterAielineCompanies == NumOfAirlineCompanies) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Airline Companies created", NumOfAirlineCompanies); } else if (counterAielineCompanies < NumOfAirlineCompanies || counterAielineCompanies == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfAirlineCompanies} airline companies"); } for (int i = 0; i < NumOfFlights; i++) { InsertFlightsToDb(administratorFacade, t); } if (counterFlights == NumOfFlights) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Flights created", NumOfFlights); } else if (counterFlights == NumOfFlights || counterFlights == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfFlights} flights"); } for (int i = 0; i < NumOfTickets; i++) { InsetTicketsToDb(administratorFacade, t); } if (counterTickets == NumOfTickets) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format("{0} Tickets created", NumOfTickets); } else if (counterTickets < NumOfTickets) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Half a failure created {counterTickets} /{NumOfTickets} tickets"); } else if (counterTickets == 0) { if (LogMessage != "") { LogMessage = LogMessage + "\n"; } LogMessage = LogMessage + string.Format($"Failed to create {NumOfTickets} tickets"); } }); }, () => { return(CanExecuteAddMethod()); }); Task.Run(() => { while (true) { AddDBCommand.RaiseCanExecuteChanged(); // go check the enable/disable ReplaceDBCommand.RaiseCanExecuteChanged(); // go check the enable/disable Thread.Sleep(250); } }); }