public void Initialize()
{
connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
options = new DbContextOptionsBuilder <KlantContext>()
.UseSqlite(connection)
.Options;
using (var context = new KlantContext(options))
{
context.Database.EnsureCreated();
}
_context = new TestBusContext();
var services = new ServiceCollection();
services.AddTransient <ICommandPublisher, CommandPublisher>();
services.AddSingleton <DbContextOptions>(options);
services.AddSingleton <KlantContext>();
services.AddTransient <IKlantDatamapper, KlantDatamapper>();
services.AddSingleton <IBusContext <IConnection> >(_context);
services.AddTransient <IEventPublisher, EventPublisher>();
var builder = new MicroserviceHostBuilder()
.RegisterDependencies(services)
.WithContext(_context)
.AddCommandListener <KlantListener>();
_host = builder.CreateHost();
_host.StartListening();
Thread.Sleep(1000);
}
public async Task InsertAddsKlantToDatabase()
{
var klant = new Klant
{
Id = "1",
Voornaam = "Hans",
Achternaam = "van Huizen",
AdresRegel = "Voorstraat 8",
Plaats = "Groningen",
Postcode = "1345df",
Telefoonnummer = "0665234365"
};
using (var context = new KlantContext(_options))
{
var dataMapper = new KlantDatamapper(context);
await dataMapper.Insert(klant);
}
using (var context = new KlantContext(_options))
{
var result = context.Klanten.SingleOrDefault(a => a.Id == "1");
Assert.IsNotNull(result);
Assert.AreEqual("Hans", result.Voornaam);
Assert.AreEqual("van Huizen", result.Achternaam);
Assert.AreEqual("Voorstraat 8", result.AdresRegel);
Assert.AreEqual("Groningen", result.Plaats);
Assert.AreEqual("1345df", result.Postcode);
Assert.AreEqual("0665234365", result.Telefoonnummer);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (var db = new KlantContext())
{
string Naam = NaamBox.Text;
string Email = EmailBox.Text;
string Adresgegevens = AdresBox.Text;
string Zorgverzekering = VerzekeringBox.Text;
var klant = new Klant
{
Naam = Naam,
Email = Email,
Adresgegevens = Adresgegevens,
Verzekering = Zorgverzekering.ToString()
};
db.Klanten.Add(klant);
db.SaveChanges();
var query = from b in db.Klanten
orderby b.KlantId
select b;
var Form1 = new Form1();
Form1.dataGridView1.DataSource = query.ToList();
Hide();
}
}
catch (Exception Eerror)
{
MessageBox.Show(Eerror.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (var db = new KlantContext())
{
string Naam = NaamBox.Text;
string Beschrijving = BeschrijvingBox.Text;
string Bijwerkingen = BijwerkingBox.Text;
var medicijn = new Medicatie
{
Naam = Naam,
Beschrijving = Beschrijving,
Bijwerking = Bijwerkingen
};
db.Medicijnen.Add(medicijn);
db.SaveChanges();
var query = from b in db.Medicijnen
orderby b.MedicatieId
select b;
var Form1 = new Form1();
Form1.dataGridView2.DataSource = query.ToList();
Hide();
}
}
catch (Exception Eerror)
{
MessageBox.Show(Eerror.Message);
}
}
public void Initialize()
{
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
_options = new DbContextOptionsBuilder <KlantContext>()
.UseSqlite(_connection)
.Options;
using (var context = new KlantContext(_options))
{
context.Database.EnsureCreated();
}
}
public void Initialize()
{
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
var options = new DbContextOptionsBuilder <KlantContext>()
.UseSqlite(_connection)
.EnableSensitiveDataLogging()
.Options;
_context = new KlantContext(options);
_context.Database.EnsureCreated();
}
public KlantToevoegenSteps()
{
SpecFlowTestLock.Lock();
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
var options = new DbContextOptionsBuilder <KlantContext>()
.UseSqlite(_connection)
.Options;
_context = new KlantContext(options);
_context.Database.EnsureCreated();
}
private static void Main(string[] args)
{
var connectionString = Environment.GetEnvironmentVariable("SPRINTERDB");
var options = new DbContextOptionsBuilder <KlantContext>()
.UseNpgsql(connectionString)
.Options;
//Deprecated method, maar kan even niet anders
ILoggerFactory loggerFactory = new LoggerFactory();
loggerFactory.AddProvider(
new ConsoleLoggerProvider(
(text, logLevel) => logLevel >= LogLevel.Debug, true));
var connectionBuilder = new RabbitMQContextBuilder()
.ReadFromEnvironmentVariables();
var nijnContext = connectionBuilder.CreateContext();
var services = new ServiceCollection();
services.AddTransient <ICommandPublisher, CommandPublisher>();
services.AddTransient <IEventPublisher, EventPublisher>();
services.AddTransient <IKlantDatamapper, KlantDatamapper>();
services.AddSingleton <DbContextOptions>(options);
services.AddTransient <KlantContext, KlantContext>();
services.AddSingleton <IBusContext <IConnection> >(nijnContext);
var builder = new MicroserviceHostBuilder()
.SetLoggerFactory(loggerFactory)
.RegisterDependencies(services)
.WithContext(nijnContext)
.UseConventions();
var host = builder.CreateHost();
host.CreateQueues();
using (var context = new KlantContext(options))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
host.StartListeningInOtherThread();
var logger = NijnLogger.CreateLogger <Program>();
logger.LogInformation("Started...");
}
private void ConfigureDatabase()
{
DbContextOptions <KlantContext> options = new DbContextOptionsBuilder <KlantContext>()
.UseNpgsql(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING") ?? throw new InvalidOperationException())
.Options;
_services.AddSingleton(options);
using (var context = new KlantContext(options))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Klanten.AddRange(DummyKlanten.Klanten);
context.SaveChanges();
}
}
public void Repository_InsertsKlant()
{
// Arrange
var options = CreateNewContextOptions();
IRepository target = new KlantRepository(options);
var klant = new Klant()
{
};
// Act
target.Insert(klant);
// Assert
using (var context = new KlantContext(options))
{
Assert.AreEqual(1, context.Klanten.Count());
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (var db = new KlantContext())
{
string artsbox = ArtsBox.Text;
string functie = FunctieBox.Text;
string email = EmailBox.Text;
DateTime aflooptdatum = dateTimePicker1.Value.Date;
var contract = new Contract
{
Dokter = artsbox,
Functie = functie,
Afloopdatum = aflooptdatum,
Email = email
};
db.Contracten.Add(contract);
db.SaveChanges();
var query = from b in db.Contracten
orderby b.Afloopdatum
select b;
var Form1 = new Form1();
Form1.dataGridView3.DataSource = query.ToList();
Hide();
}
}
catch (Exception Eerror)
{
MessageBox.Show(Eerror.Message);
}
}
public void BeforeEach()
{
_klantBuilder = new KlantBuilder();
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
var options = new DbContextOptionsBuilder <KlantContext>()
.UseSqlite(_connection)
.EnableSensitiveDataLogging()
.Options;
_dbContext = new KlantContext(options);
_dbContext.Database.EnsureCreated();
SeedDatabase();
_nijnContext = new TestBusContextBuilder().CreateTestContext();
var klantDataMapper = new KlantDataMapper(_dbContext);
var eventPublisher = new EventPublisher(_nijnContext);
_target = new KlantController(klantDataMapper, eventPublisher, new LoggerFactory());
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (var db = new KlantContext())
{
string Naam = NaamBox.Text;
string Email = EmailBox.Text;
string Adresgegevens = AdresBox.Text;
string Telefoon = TelefoonBox.Text;
var Arts = new Arts
{
Naam = Naam,
Email = Email,
Adresgegevens = Adresgegevens,
Telefoon = Telefoon
};
db.Artsen.Add(Arts);
db.SaveChanges();
var query = from b in db.Artsen
orderby b.ArtsId
select b;
var Form1 = new Form1();
Form1.dataGridView3.DataSource = query.ToList();
Hide();
}
}
catch (Exception Eerror)
{
MessageBox.Show(Eerror.Message);
}
}
public KlantRepository(KlantContext klantContext)
{
_klantContext = klantContext;
}
public KlantDataMapper(KlantContext context)
{
_context = context;
}
