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