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