private async Task InitializeDatabase() { var createDatabase = new InitializeDatabase(pageService); await createDatabase.PopulateDatabase(); RefreshTransactions(); }
public MainPage() { var themeLoader = new ThemeLoader(); themeLoader.LoadTheme(); InitializeComponent(); repository = new Repository(); period = new Period(); pageService = new PageService(); initializeDatabase = new InitializeDatabase(pageService); period.Init(DateTime.Now, PeriodType.Month); trans = repository.GetTransactions(period); navigationBarViewModel = new NavigationBarViewModel(trans, pageService, repository, period); charts = new ChartsViewModel(navigationBarViewModel, pageService, repository); transactionsViewModel = new TransactionsViewModel(navigationBarViewModel, pageService, repository, period); MainVM = new MainPageViewModel(pageService, repository, initializeDatabase); this.BindingContext = MainVM; overview.BindingContext = charts; transactions.BindingContext = transactionsViewModel; MessagingCenter.Subscribe <NavigationBarViewModel>(this, MessagingString.UpdatePeriod, RefreshTransactions); MessagingCenter.Subscribe <SettingsPage>(this, MessagingString.UpdateTransactionsAfterSettingsChange, RefreshTransactions); MessagingCenter.Subscribe <SettingsViewModel>(this, MessagingString.UpdateTransactionsAfterReset, RefreshTransactions); MessagingCenter.Subscribe <TransactionsDetailsViewModel>(this, MessagingString.UpdateTransactions, RefreshTransactions); MessagingCenter.Subscribe <TransactionsViewModel>(this, MessagingString.DeleteTransactions, RefreshTransactions); MessagingCenter.Subscribe <TransactionsViewModel>(this, MessagingString.RefreshTransactions, RefreshTransactions); }
public void Configure(IApplicationBuilder app, IHostingEnvironment env, PandaDbContext context, UserManager <ApplicationUser> userManager) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); } else { app.UseExceptionHandler("/Home/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseCookiePolicy(); app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "identity", template: "{area:exists}/{controller=Home}/{action=Index}/{id?}"); routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); InitializeDatabase.SeedData(context, userManager); }
public void Configure(IApplicationBuilder app, IHostingEnvironment env) { Kernel = InitializeNinject.Initialize(app, Configuration, RequestScope); InitializeDatabase.Initialize(Kernel, Configuration, RequestScope); InitializeServices.Initialize(Kernel); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseHsts(); } app.UseHttpsRedirection(); app.UseCors("DefaultCors"); app.UseMvc(); app.UseSwagger(); app.UseSwaggerUI(c => { c.SwaggerEndpoint("/swagger/v1/swagger.json", "Magic"); }); }
public SqlException Create(PatientAppointment PA) { //insert string insert = "INSERT INTO PatientAppointment (AppointmentNumber, DateOfAppointment, AppointmentRoom, PatientNumber)" + " VALUES(@AppointmentNumber, @DateOfAppointment, @AppointmentRoom, @PatientNumber)"; //create sql command, insert query, preparing quries, create parameterized quieries, // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(insert); // 2. define parameters used in command object List<SqlParameter> prm = new List<SqlParameter>() { new SqlParameter("@AppointmentNumber", SqlDbType.Int) {Value = PA.AppointmentNumber}, new SqlParameter("@DateOfAppointment", SqlDbType.DateTime) {Value = PA.DateOfAppointment}, new SqlParameter("@AppointmentRoom", SqlDbType.NVarChar) {Value = PA.AppointmentRoom}, new SqlParameter("@PatientNumber", SqlDbType.Int) {Value = PA.PatientNumber}, }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return res; }
public SqlException Read(int wardNumber) { string select = "SELECT Patient.FirstName, Patient.LastName, Ward.Number FROM Patient " + "JOIN InPatient ON Patient.PatientNumber=InPatient.PatientNumber JOIN Ward ON Ward.Number=InPatient.WardNumber " + "WHERE Ward.Number = @WardNumber"; // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(select); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@WardNumber", SqlDbType.Int) { Value = wardNumber } }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public static void Main(string[] args) { var host = CreateHostBuilder(args).Build(); using (var scope = host.Services.CreateScope()) { var services = scope.ServiceProvider; var applicationContext = services.GetRequiredService <ApplicationContext>(); var dbCreated = applicationContext.Database.EnsureCreated(); if (!dbCreated) { try { InitializeDatabase.InitializeApplication(services).Wait(); } catch (Exception ex) { var logger = services.GetRequiredService <ILogger <Program> >(); logger.LogError(ex, "An error occurred while initializing the Database"); throw; } } } host.Run(); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory) { loggerFactory.AddConsole(Configuration.GetSection("Logging")); loggerFactory.AddDebug(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseBrowserLink(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseStaticFiles(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); InitializeDatabase.SeedData(app); }
protected override async void OnAppearing() { //override back button if (OnBackButtonPressed()) { await Navigation.PushAsync(new MainPage { BindingContext = new MainPage() }); } base.OnAppearing(); try { InitializeDatabase ini = new InitializeDatabase(); //use script to fill database if previous database has been deleted List <TuitionFees> tuitionFees = await App.Database.GetTuittionFeesListAsync(); if (tuitionFees.Count() == 0) { ini.populateDatabase(); } } catch (Exception) { Console.WriteLine(">>> The database can't be read try to import a database in .db3 format (SQLite)"); } }
public SqlException Update(IsIn isin, int wardNumber) { string update = "UPDATE IsIn " + "SET Shift = @Shift, StaffNumber = @StaffNumber" + "WHERE Number = @wardNumber;"; // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(update); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@Shift", SqlDbType.Int) { Value = isin.Shift }, new SqlParameter("@StaffNumber", SqlDbType.NVarChar) { Value = isin.StaffNumber }, new SqlParameter("@Number", SqlDbType.Int) { Value = isin.WardNumber } }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public MainPageViewModel(PageService pageService, Repository repository, InitializeDatabase initializeDatabase) { this.pageService = pageService; this.repository = repository; this.initializeDatabase = initializeDatabase; GoToSettingsPageCommand = new Command(async vm => await GoToSettingsPage()); GoToAboutPageCommand = new Command(async vm => await GoToAboutPage()); }
public static IApplicationBuilder BuildIdentityServer(this IApplicationBuilder app) { InitializeDatabase.Up(app); return(app.UseAuthentication() .UseIdentityServer() .UseAuthorization()); }
public RegisterJob() { _scope = ContainerConfig.Configure().BeginLifetimeScope(); _cs = _scope.Resolve <CopySource>(); _idb = _scope.Resolve <InitializeDatabase>(); _iwh = _scope.Resolve <InitializeWebHost>(); _iws = _scope.Resolve <InitializeWindowService>(); _us = _scope.Resolve <UninstallJob>(); }
public SqlException Create(Patient p) { //insert string insert = "INSERT INTO Patient (PatientNumber, FirstName, LastName, Address, MaritalStatus, Gender, Telephone, DateOfBirth)" + " VALUES(@PatientNumber, @FirstName, @LastName, @Address, @MaritalStatus, @Gender, @Telephone, @DateOfBirth)"; //create sql command, insert query, preparing quries, create parameterized quieries, // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(insert); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@PatientNumber", SqlDbType.Int) { Value = p.PatientNumber }, new SqlParameter("@FirstName", SqlDbType.NVarChar) { Value = p.FirstName }, new SqlParameter("@LastName", SqlDbType.NVarChar) { Value = p.LastName }, new SqlParameter("@Address", SqlDbType.NVarChar) { Value = p.Address }, new SqlParameter("@MaritalStatus", SqlDbType.NVarChar) { Value = p.MartialStatus }, new SqlParameter("@Gender", SqlDbType.NVarChar) { Value = p.Gender }, new SqlParameter("@Telephone", SqlDbType.NVarChar) { Value = p.Telephone }, new SqlParameter("@DateOfBirth", SqlDbType.DateTime) { Value = p.DateOfBirth }, }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public SettingsPage(PageService pageService, Repository repository, InitializeDatabase initializeDatabase) { InitializeComponent(); this.pageService = pageService; this.repository = repository; this.initializeDatabase = initializeDatabase; settingsVM = new SettingsViewModel(pageService, repository, initializeDatabase); BindingContext = settingsVM; }
public SqlException Read() { string select = "SELECT * FROM Ward"; // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(select); SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public SqlException Create(InPatient ip) { //insert string insert = "INSERT INTO InPatient (PatientNumber, WardNumber, InWardOrWaitingList, DateExpectedToLeave, DatePlacedOnWaitingList, ExpectedDurationOfStay, ActualDateLeft)" + " VALUES(@PatientNumber, @WardNumber, @InWardOrWaitingList, @DateExpectedToLeave, @DatePlacedOnWaitingList, @ExpectedDurationOfStay, @ActualDateLeft)"; //create sql command, insert query, preparing quries, create parameterized quieries, // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(insert); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@PatientNumber", SqlDbType.Int) { Value = ip.PatientNumber }, new SqlParameter("@WardNumber", SqlDbType.Int) { Value = ip.WardNumber }, new SqlParameter("@DatePlacedOnWaitingList", SqlDbType.DateTime) { Value = ip.DatePlacedOnWaitingList }, new SqlParameter("@ExpectedDurationOfStay", SqlDbType.Int) { Value = ip.ExpectedDurationOfStay }, new SqlParameter("@ActualDateLeft", SqlDbType.DateTime) { Value = ip.ActualDateLeft }, new SqlParameter("@InWardOrWaitingList", SqlDbType.NVarChar) { Value = ip.InWardOrWaitingList }, new SqlParameter("@DateExpectedToLeave", SqlDbType.DateTime) { Value = ip.DateExpectedToLeave }, }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public SqlException Update(InPatient ip, int patientID) { string update = "UPDATE InPatient " + "SET PatientNumber = @PatientNumber, WardNumber = @WardNumber, DatePlacedOnWaitingList = @DatePlacedOnWaitingList," + "ExpectedDurationOfStay = @ExpectedDurationOfStay, ActualDateLeft = @ActualDateLeft, InWardOrWaitingList = @InWardOrWaitingList" + "WHERE PatientNumber = @PatientID;"; // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(update); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@PatientNumber", SqlDbType.Int) { Value = ip.PatientNumber }, new SqlParameter("@WardNumber", SqlDbType.Int) { Value = ip.WardNumber }, new SqlParameter("@DatePlacedOnWaitingList", SqlDbType.DateTime) { Value = ip.DatePlacedOnWaitingList }, new SqlParameter("@ExpectedDurationOfStay", SqlDbType.Int) { Value = ip.ExpectedDurationOfStay }, new SqlParameter("@ActualDateLeft", SqlDbType.DateTime) { Value = ip.ActualDateLeft }, new SqlParameter("@PatientID", SqlDbType.Int) { Value = patientID }, new SqlParameter("@InWardOrWaitingList", SqlDbType.DateTime) { Value = ip.InWardOrWaitingList } }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public SqlException Read() { string select = "SELECT Staff.FirstName, Staff.LastName, Ward.Number FROM Staff " + "JOIN IsIn ON Staff.StaffNumber=IsIn.StaffNumber JOIN Ward ON Ward.Number=IsIn.Number"; // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(select); SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public App() { InitializeComponent(); FlowListView.Init(); Mapper.Initialize(c => c.AddProfile <MappingProfile>()); var createDatabase = new InitializeDatabase(null); createDatabase.CreateCategoriesAndAccounts(); mainPage = new MainPage(); navigationPage = new NavigationPage(mainPage); SetNavigationBarColor(); MainPage = navigationPage; }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env) { //启用静态文件中间件 app.UseStaticFiles(); //初始化数据 InitializeDatabase.Initialize(app.ApplicationServices); //添加jwt验证 app.UseAuthentication(); #region swagger // Enable middleware to serve generated Swagger as a JSON endpoint. app.UseSwagger(c => { c.RouteTemplate = "api-docs/{documentName}/bendan.json"; }); // Enable middleware to serve swagger-ui (HTML, JS, CSS, etc.), // specifying the Swagger JSON endpoint. app.UseSwaggerUI(c => { c.DocumentTitle = "BenDan API"; c.SwaggerEndpoint("/api-docs/v1/bendan.json", "BenDan API V1"); c.RoutePrefix = string.Empty; c.IndexStream = () => GetType().Assembly.GetManifestResourceStream("BenDan.wwwroot.swagger.ui.index.html"); }); #endregion if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } app.UseHttpsRedirection(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddDataProtection() .SetApplicationName("WebApp") .PersistKeysToFileSystem(new System.IO.DirectoryInfo(System.Environment.CurrentDirectory)); services.AddIdentity <ApplicationUser, ApplicationRole>(options => { options.SignIn.RequireConfirmedAccount = false; options.SignIn.RequireConfirmedEmail = false; options.SignIn.RequireConfirmedPhoneNumber = false; options.Password.RequireDigit = false; options.Password.RequireLowercase = false; options.Password.RequiredLength = 3; options.Password.RequiredUniqueChars = 0; options.Password.RequireNonAlphanumeric = false; options.Password.RequireUppercase = false; }) .AddDefaultTokenProviders(); var _ConfigurationManager = new ConfigurationManager(Configuration); services.AddSingleton <IConfigurationManager>(_ConfigurationManager); services.AddSingleton <IUserStore <ApplicationUser>, UserStore>(); services.AddSingleton <IRoleStore <ApplicationRole>, RoleStore>(); services.AddSingleton <IArticleStore, ArticleStore>(); services.AddSingleton <IInitializeDatabase, InitializeDatabase>(); // Add application services. services.AddTransient <IEmailSender, EmailSender>(); services.ConfigureApplicationCookie(options => { options.LoginPath = "/Login"; options.AccessDeniedPath = "/AccessDenied"; }); // create database IInitializeDatabase database = new InitializeDatabase(_ConfigurationManager); services.AddSingleton <IInitializeDatabase>(database); #if (DEBUG) // This code create database and structure only in debug database.CreateUpdateDb(); #endif services.AddRazorPages(); }
public void ConfigureServices(IServiceCollection services) { services.AddMvc((x) => x.OutputFormatters.Add(new ContentFormatters())) .SetCompatibilityVersion(CompatibilityVersion.Version_2_2); // Adding some basic configurations. services.AddSingleton <IHttpContextAccessor, HttpContextAccessor>(); services.AddSingleton(Configuration); services.Configure <RouteOptions>(options => options.LowercaseUrls = true); #region [ -- Magic parts -- ] // Giving every module a chance to configure its services. Configurator.ConfigureServices(services, Configuration); // Initializing database. InitializeDatabase.Initialize(services, Configuration); // Configuring swagger. services.AddSwaggerGen(swag => { swag.SwaggerDoc("v1", new Info { Title = "Super DRY Magic", Version = "v1", Description = "An ASP.NET Core web API Starter Kit", License = new License { Name = "Affero GPL + Proprietary commercial (Closed Source)", Url = "https://github.com/polterguy/magic", }, Contact = new Contact { Name = "Thomas Hansen", Email = "*****@*****.**", Url = "https://github.com/polterguy/magic", }, }); foreach (var idxFile in Directory.GetFiles(AppContext.BaseDirectory, "*.xml")) { swag.IncludeXmlComments(idxFile); } swag.OperationFilter <FileUploadOperation>(); }); #endregion }
public SqlException Create(Ward ward) { //insert string insert = "INSERT INTO Ward (Number, WardName, Location, TotalNumberOfBeds, TelephoneExtentionNumber)" + " VALUES(@WardNumber, @WardName, @Location, @TotalNumberOfBeds, @TelephoneExtentionNumber); "; //create sql command, insert query, preparing quries, create parameterized quieries, // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(insert); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@WardNumber", SqlDbType.Int) { Value = ward.WardNumber }, new SqlParameter("@WardName", SqlDbType.NVarChar) { Value = ward.WardName }, new SqlParameter("@Location", SqlDbType.NVarChar) { Value = ward.Location }, new SqlParameter("@TotalNumberOfBeds", SqlDbType.Int) { Value = ward.TotalNumberOfBeds }, new SqlParameter("@TelephoneExtentionNumber", SqlDbType.NVarChar) { Value = ward.TelephoneExtentionNumber } }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public SqlException Create(WorkExperience WE) { //insert string insert = "INSERT INTO WorkExperience (WorkExperienceID, PreviousPosition, NameOfOrganisation, StartDate, FinishDate)" + " VALUES(@WorkExperienceID, @PreviousPosition, @NameOfOrganisation, @StartDate, @FinishDate)"; //create sql command, insert query, preparing quries, create parameterized quieries, // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(insert); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@WorkExperienceID", SqlDbType.Int) { Value = WE.WorkExperienceID }, new SqlParameter("@PreviousPosition", SqlDbType.NVarChar) { Value = WE.PreviousPosition }, new SqlParameter("@NameOfOrganisation", SqlDbType.NVarChar) { Value = WE.NameOfOrganisation }, new SqlParameter("@StartDate", SqlDbType.DateTime) { Value = WE.StartDate }, new SqlParameter("@FinishDate", SqlDbType.DateTime) { Value = WE.FinishDate }, }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
public static void AssemblyInitialize(TestContext TestContext) { IConfiguration Configuration = new ConfigurationBuilder() .AddJsonFile("appsettings.test.json") .Build(); AuthenticationHelper.Initialize(Configuration); var serviceProvider = GraphQLConfig.GetInitializedServiceProvider(); Schema = serviceProvider.GetService <ISchema>(); DocumentExecuter = serviceProvider.GetService <IDocumentExecuter>(); ValidationRule = serviceProvider.GetService <IEnumerable <IValidationRule> >(); InitializeDatabase.InitializeDatabaseObject(); }
// 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(); } if ((Configuration["INITDB"] ?? "false") == "true") { System.Threading.Thread.Sleep(10000); System.Console.WriteLine("Preparing Database ..."); InitializeDatabase prepareData = new InitializeDatabase(this.Configuration); prepareData.Execute(); System.Console.WriteLine("Database Preparation Complete"); } app.UseMvc(); }
public SqlException Update(Ward ward, int id) { string update = "UPDATE Ward " + "SET Number = @WardNumber, Location = @Location, TotalNumberOfBeds = @TotalNumberOfBeds, TelephoneExtentionNumber = @TelephoneExtentionNumber" + "WHERE WardNumber = @id;"; // 1. declare command object with parameter + insert query SqlCommand cmd = InitializeDatabase.CreateSqlCommand(update); // 2. define parameters used in command object List <SqlParameter> prm = new List <SqlParameter>() { new SqlParameter("@WardNumber", SqlDbType.Int) { Value = ward.WardNumber }, new SqlParameter("@Location", SqlDbType.NVarChar) { Value = ward.Location }, new SqlParameter("@TotalNumberOfBeds", SqlDbType.Int) { Value = ward.TotalNumberOfBeds }, new SqlParameter("@TelephoneExtentionNumber", SqlDbType.NVarChar) { Value = ward.TelephoneExtentionNumber }, new SqlParameter("@id", SqlDbType.Int) { Value = id } }; // 3. add new parameter to command object cmd.Parameters.AddRange(prm.ToArray()); //run SqlException res = InitializeDatabase.RunSqlCommand(cmd); return(res); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory) { loggerFactory.AddConsole(Configuration.GetSection("Logging")); loggerFactory.AddDebug(); loggerFactory.AddNLog(); // Configure nlog.config in your project root env.ConfigureNLog("nlog.config"); // Configure exception handling if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler(); } // Use built-in display of status code pages app.UseStatusCodePages(); // Ensure support of static resource files app.UseStaticFiles(); var context = app.ApplicationServices.GetService <ApiContext>(); var dbInit = new InitializeDatabase(env, context); dbInit.Seed(); // Add default mvc route definition app.UseMvcWithDefaultRoute(); // Enable middleware to serve generated Swagger as a JSON endpoint app.UseSwagger(); // Enable middleware to serve swagger-ui assets (HTML, JS, CSS etc.) app.UseSwaggerUi(); }
public TuitionFeesDatabase(string dbPath) { ini = new InitializeDatabase(); _database = new SQLiteAsyncConnection(dbPath); _database.CreateTableAsync <EnrolementFees>().Wait(); _database.CreateTableAsync <TuitionFees>().Wait(); _database.CreateTableAsync <FixedCharges>().Wait(); _database.CreateTableAsync <ExternalExaminationFees>().Wait(); _database.CreateTableAsync <SchoolMeals>().Wait(); _database.CreateTableAsync <WednesdayMeals>().Wait(); _database.CreateTableAsync <SchoolTransport>().Wait(); _database.CreateTableAsync <Supervision>().Wait(); _database.CreateTableAsync <Support>().Wait(); _database.CreateTableAsync <AssistanceDiscount>().Wait(); _database.CreateTableAsync <TermDiscount>().Wait(); _database.CreateTableAsync <Child>().Wait(); _database.CreateTableAsync <Family>().Wait(); }