public async Task InsertAddsArtikelToDatabase()
{
var artikel = new Artikel
{
AfbeeldingUrl = "Afbeelding.jpg",
Artikelnummer = 1234,
Beschrijving = "Grote fiets voor iedereen",
Leverancier = "Fietsen bv",
Leveranciercode = "1",
LeverbaarTot = new DateTime(2018, 5, 5),
LeverbaarVanaf = new DateTime(2017, 1, 1),
Naam = "Fiets",
Prijs = 299.3m
};
using (var context = new WebshopContext(options))
{
var dataMapper = new ArtikelDatamapper(context);
dataMapper.Insert(artikel);
}
using (var context = new WebshopContext(options))
{
var artikelDatamapper = new ArtikelDatamapper(context);
var result = await artikelDatamapper.Get(1234);
Assert.IsNotNull(result);
Assert.AreEqual("Fiets", result.Naam);
Assert.AreEqual(0, result.Voorraad);
}
}
public void ChangeVoorraadChangesVoorraadOfArtikel()
{
var artikel = new Artikel
{
AfbeeldingUrl = "Afbeelding.jpg",
Artikelnummer = 1234,
Beschrijving = "Grote fiets voor iedereen",
Leverancier = "Fietsen bv",
Leveranciercode = "1",
LeverbaarTot = new DateTime(2019, 8, 8),
LeverbaarVanaf = new DateTime(2017, 3, 3),
Naam = "Fiets",
Prijs = 299.3m
};
using (var context = new WebshopContext(options))
{
var dataMapper = new ArtikelDatamapper(context);
dataMapper.Insert(artikel);
}
using (var context = new WebshopContext(options))
{
var dataMapper = new ArtikelDatamapper(context);
dataMapper.ChangeVoorraad(1234, 10);
}
using (var context = new WebshopContext(options))
{
var result = context.Artikelen.SingleOrDefault(a => a.Artikelnummer == 1234);
Assert.IsNotNull(result);
Assert.AreEqual("Fiets", result.Naam);
Assert.AreEqual(10, result.Voorraad);
}
}
public void InsertArtikelFromEvent()
{
var artikelEvent = new ArtikelAanCatalogusToegevoegd
{
AfbeeldingUrl = "Afbeelding.jpg",
Artikelnummer = 1234,
Beschrijving = "Grote fiets voor iedereen",
Leverancier = "Fietsen bv",
Leveranciercode = "1",
LeverbaarTot = new DateTime(2018, 5, 5),
LeverbaarVanaf = new DateTime(2017, 1, 1),
Naam = "Fiets",
Prijs = 299.3m
};
var eventPublisher = new EventPublisher(_context);
eventPublisher.Publish(artikelEvent);
Thread.Sleep(500);
using (var context = new WebshopContext(options))
{
var result = context.Artikelen.SingleOrDefault(a => a.Artikelnummer == 1234);
Assert.IsNotNull(result);
Assert.AreEqual("Fiets", result.Naam);
Assert.AreEqual(0, result.Voorraad);
}
}
public CaffFileController(WebshopContext context, UserManager <SiteUser> userManager, IAuthorizationService authorizationService, ILogger <CaffFileController> logger)
{
_context = context;
_userManager = userManager;
_authorizationService = authorizationService;
_logger = logger;
}
public async Task GetKlantByIdReturnsKlant()
{
var klant = new Klant
{
Id = "1",
Voornaam = "Hans",
Achternaam = "van Huizen",
AdresRegel = "Voorstraat 8",
Plaats = "Groningen",
Postcode = "1345df",
Telefoonnummer = "0665234365",
};
using (var context = new WebshopContext(options))
{
var dataMapper = new KlantDatamapper(context);
dataMapper.Insert(klant);
}
using (var context = new WebshopContext(options))
{
var klantmapper = new KlantDatamapper(context);
var result = await klantmapper.GetKlant("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);
}
}
public void CreateNijnHostBuilder(IServiceCollection services)
{
var connectionString = Environment.GetEnvironmentVariable("SPRINTERDB");
var options = new DbContextOptionsBuilder <WebshopContext>()
.UseNpgsql(connectionString)
.Options;
services.AddTransient <ICommandPublisher, CommandPublisher>();
services.AddSingleton <DbContextOptions>(options);
services.AddTransient <WebshopContext, WebshopContext>();
services.AddTransient <IArtikelDatamapper, ArtikelDatamapper>();
services.AddTransient <IBestellingDatamapper, BestellingDatamapper>();
services.AddTransient <IKlantDatamapper, KlantDatamapper>();
var nijnContext = CreateNijnConfig(services);
using (var context = new WebshopContext(options))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
if (!context.Artikelen.Any())
{
ScrapeAuditLog(services, nijnContext, DateTime.Now).Wait();
}
}
services.AddSingleton(nijnContext);
}
public void ChangeVoorraadEvent()
{
using (var context = new WebshopContext(options))
{
var artikel = new Artikel
{
AfbeeldingUrl = "Afbeelding.jpg",
Artikelnummer = 1234,
Beschrijving = "Grote fiets voor iedereen",
Leverancier = "Fietsen bv",
Leveranciercode = "1",
LeverbaarTot = new DateTime(2018, 5, 5),
LeverbaarVanaf = new DateTime(2017, 1, 1),
Naam = "Fiets",
Prijs = 299.3m
};
new ArtikelDatamapper(context).Insert(artikel);
}
var voorraadEvent = new VoorraadVerhoogdEvent
{
Artikelnummer = 1234,
Aantal = 5,
NieuweVoorraad = 5
};
var eventPublisher = new EventPublisher(_context);
eventPublisher.Publish(voorraadEvent);
Thread.Sleep(500);
using (var context = new WebshopContext(options))
{
var result = context.Artikelen.SingleOrDefault(a => a.Artikelnummer == 1234);
Assert.IsNotNull(result);
Assert.AreEqual("Fiets", result.Naam);
Assert.AreEqual(5, result.Voorraad);
}
var voorraadVerlaagdEvent = new VoorraadVerlaagdEvent
{
Artikelnummer = 1234,
Aantal = 3,
NieuweVoorraad = 2
};
eventPublisher.Publish(voorraadVerlaagdEvent);
Thread.Sleep(500);
using (var context = new WebshopContext(options))
{
var result = context.Artikelen.SingleOrDefault(a => a.Artikelnummer == 1234);
Assert.IsNotNull(result);
Assert.AreEqual("Fiets", result.Naam);
Assert.AreEqual(2, result.Voorraad);
}
}
// Changed DataContext type to WebshopContext
private async Task attachAccountToContext(HttpContext context, WebshopContext dataContext, string token)
{
try
{
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(_appSettings.Secret);
tokenHandler.ValidateToken(token, new TokenValidationParameters
{
ValidateIssuerSigningKey = true,
IssuerSigningKey = new SymmetricSecurityKey(key),
ValidateIssuer = false,
ValidateAudience = false,
// set clockskew to zero so tokens expire exactly at token expiration time (instead of 5 minutes later)
ClockSkew = TimeSpan.Zero
}, out SecurityToken validatedToken);
var jwtToken = (JwtSecurityToken)validatedToken;
var accountId = int.Parse(jwtToken.Claims.First(x => x.Type == "id").Value);
// attach account to context on successful jwt validation
// ***** Changed Account to Logins
context.Items["Account"] = await dataContext.Logins.FindAsync(accountId);
}
catch
{
// do nothing if jwt validation fails
// account is not attached to context so request won't have access to secure routes
}
}
public CartService(WebshopContext context, AuthService authService, IHttpContextAccessor httpContext, IMapper mapper)
{
_user = httpContext.HttpContext.User;
_mapper = mapper;
_context = context;
_authService = authService;
}
protected override void Seed(WebshopContext context)
{
var produkter = new List<Produkt>()
{
new Produkt
{
navn = "Banan",
beskrivelse = "Gul. Litt rar form.",
pris = 12,
},
new Produkt
{
navn = "Eple",
beskrivelse = "Grønne med stilk",
pris = 25,
},
new Produkt
{
navn = "Pære",
beskrivelse = "Ikke til opplysning.",
pris = 7,
}
};
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, WebshopContext context)
{
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: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
DBInitializer.Initialize(context);
}
public UserService(
WebshopContext context,
IOptions <AppSettings> appSettings)
{
_context = context;
_appSettings = appSettings.Value;
}
public void Initialize()
{
connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
options = new DbContextOptionsBuilder <WebshopContext>()
.UseSqlite(connection)
.Options;
using (var context = new WebshopContext(options))
{
context.Database.EnsureCreated();
}
var services = new ServiceCollection();
services.AddSingleton <DbContextOptions>(options);
services.AddTransient <WebshopContext, WebshopContext>();
services.AddTransient <IArtikelDatamapper, ArtikelDatamapper>();
services.AddTransient <IKlantDatamapper, KlantDatamapper>();
_context = new TestBusContext();
var builder = new MicroserviceHostBuilder()
.RegisterDependencies(services)
.WithContext(_context)
.AddEventListener <MagazijnListener>();
_host = builder.CreateHost();
_host.StartListening();
}
public void Initialize()
{
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
_options = new DbContextOptionsBuilder <WebshopContext>()
.UseSqlite(_connection)
.Options;
using (var context = new WebshopContext(_options))
{
context.Database.EnsureCreated();
}
var artikel = new Artikel
{
Artikelnummer = 1,
Beschrijving = "Grote fiets voor iedereen",
LeverbaarTot = new DateTime(2018, 5, 5),
LeverbaarVanaf = new DateTime(2017, 1, 1),
Naam = "Fiets",
Prijs = 100.50m,
Voorraad = 5
};
var artikel2 = new Artikel
{
Artikelnummer = 2,
Beschrijving = "HELE grote fiets voor iedereen",
LeverbaarTot = new DateTime(2018, 5, 5),
LeverbaarVanaf = new DateTime(2017, 1, 1),
Naam = "Fiets Groot",
Prijs = 600.50m,
Voorraad = 8
};
var klant = new Klant
{
Voornaam = "Hans",
Achternaam = "Van Huizen",
Id = "1",
Telefoonnummer = "0612341234",
AdresRegel = "Grote straat 1",
Email = "*****@*****.**",
Plaats = "Groningen",
Postcode = "6123AA",
Wachtwoord = "Geheim_101"
};
using (var context = new WebshopContext(_options))
{
var klantDatamapper = new KlantDatamapper(context);
klantDatamapper.Insert(klant);
var dataMapper = new ArtikelDatamapper(context);
dataMapper.Insert(artikel);
dataMapper.Insert(artikel2);
}
}
public ProductsController(WebshopContext context)
{
var Products = _context.Products.ToList();
ProductViewModel viewModel = new ProductViewModel();
viewModel.Products = Products;
_context = context;
}
public ReviewService(IMapper mapper, WebshopContext context, AuthService authService, IHubContext <WebshopHub> hubContext, IHttpContextAccessor httpContext)
{
_user = httpContext.HttpContext.User;
_mapper = mapper;
_context = context;
_hubContext = hubContext;
_authService = authService;
}
public AuthService(WebshopContext context, CryptoService cryptoService, IMapper mapper, IOptions <JwtSettings> jwtSettings, IHttpContextAccessor httpContext)
{
_mapper = mapper;
_context = context;
_httpContext = httpContext;
_cryptoService = cryptoService;
_jwtSettings = jwtSettings.Value;
}
public async Task InsertBestellingIntoDatabaseAndUpdate()
{
var bestelling = new Bestelling
{
Id = 1,
KlantId = "1",
AdresRegel1 = "Laagstraat 11",
Plaats = "Laaghoven",
Postcode = "1234FG",
BestellingStatus = BestellingStatus.TerControleVoorSales,
BesteldeArtikelen = new List <BestellingItem>
{
new BestellingItem(1, 3)
{
Id = 1
},
new BestellingItem(2, 5)
{
Id = 2
}
}
};
using (var context = new WebshopContext(_options))
{
var mapper = new BestellingDatamapper(context);
await mapper.Insert(bestelling);
}
using (var context = new WebshopContext(_options))
{
var mapper = new BestellingDatamapper(context);
var result = await mapper.Get(1);
Assert.AreEqual("1", result.KlantId);
Assert.AreEqual("Laagstraat 11", result.AdresRegel1);
Assert.AreEqual("Laaghoven", result.Plaats);
Assert.AreEqual("1234FG", result.Postcode);
Assert.AreEqual(2, result.BesteldeArtikelen.Count);
Assert.IsTrue(result.BesteldeArtikelen.Any(b => b.Artikel.Naam == "Fiets" && b.Aantal == 3));
result.BestellingStatus = BestellingStatus.GereedVoorBehandeling;
using (var context2 = new WebshopContext(_options))
{
var mapper2 = new BestellingDatamapper(context2);
await mapper2.Update(result);
}
}
using (var context = new WebshopContext(_options))
{
var mapper = new BestellingDatamapper(context);
var result = await mapper.Get(1);
Assert.AreEqual(BestellingStatus.GereedVoorBehandeling, result.BestellingStatus);
}
}
public UserManagementController(
WebshopContext dbContext,
UserManager <Users> userManager,
RoleManager <IdentityRole> roleManager)
{
_dbContext = dbContext;
_userManager = userManager;
_roleManager = roleManager;
}
public ActionResult Index()
{
WebshopContext db = new WebshopContext();
return(View(
db.Products.ToList()
.OrderBy(p => p.UpdatedOn).Reverse()
));
}
public HomeController(
UserManager <Users> userManager,
SignInManager <Users> signInManager, WebshopContext context)
{
mUserManager = userManager;
mSignInManager = signInManager;
_context = context;
}
/// <summary>
/// Initializes a new instance of the <see cref="GenericRepository{TEntity}"/> class.
/// </summary>
/// <param name="context">The context.</param>
internal protected GenericRepository(WebshopContext context)
{
if (context == null)
{
throw new ArgumentNullException("context");
}
Context = context;
DbSet = context.Set <TEntity>();
}
// Changed DataContext type to WebshopContext
public async Task Invoke(HttpContext context, WebshopContext dataContext)
{
var token = context.Request.Headers["Authorization"].FirstOrDefault()?.Split(" ").Last();
if (token != null)
{
await attachAccountToContext(context, dataContext, token);
}
await _next(context);
}
public void Initialize()
{
connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
options = new DbContextOptionsBuilder <WebshopContext>()
.UseSqlite(connection)
.Options;
using (var context = new WebshopContext(options))
{
context.Database.EnsureCreated();
}
}
public async Task GetAllArtikelenReturnsAll()
{
var artikel = new Artikel
{
AfbeeldingUrl = "Afbeelding.jpg",
Artikelnummer = 1,
Beschrijving = "Grote fiets voor iedereen",
Leverancier = "Fietsen bv",
Leveranciercode = "1",
LeverbaarTot = new DateTime(2019, 8, 8),
LeverbaarVanaf = new DateTime(2017, 3, 3),
Naam = "Fiets",
Prijs = 299.3m
};
var artikel2 = new Artikel
{
AfbeeldingUrl = "Afbeelding.jpg",
Artikelnummer = 2,
Beschrijving = "Ultra zacht zadel voor de meest comfortabele fietstocht",
Leverancier = "FietszadelsWinkel",
Leveranciercode = "3",
LeverbaarTot = new DateTime(2019, 8, 8),
LeverbaarVanaf = new DateTime(2017, 3, 3),
Naam = "Zadel",
Prijs = 19.49m
};
using (var context = new WebshopContext(options))
{
var dataMapper = new ArtikelDatamapper(context);
dataMapper.Insert(artikel);
dataMapper.Insert(artikel2);
}
using (var context = new WebshopContext(options))
{
var dataMapper = new ArtikelDatamapper(context);
var artikelen = await dataMapper.GetAll();
Assert.AreEqual(2, artikelen.Count);
Assert.IsTrue(artikelen.Any(a => a.Artikelnummer == 2 && a.Naam == "Zadel" && a.PrijsWithBtw == 23.58m));
Assert.IsTrue(artikelen.Any(a => a.Artikelnummer == 1 && a.Naam == "Fiets" && a.PrijsWithBtw == 362.15m));
}
}
static void Main(string[] args)
{
using WebshopContext db = new WebshopContext();
User zvone = new User()
{
Name = "Zvonimir Matic",
Email = "*****@*****.**",
Addresses = new List <Address>()
{
new Address()
{
Country = "Croatia",
City = "Rijeka",
PostalCode = "51000",
StreetName = "Petra Jurcica",
StreetNumber = "16"
}
}
};
User john = new User()
{
Name = "John Smith",
Email = "*****@*****.**"
};
db.Users.Add(zvone);
db.Users.Add(john);
db.SaveChanges();
IEnumerable <User> queryUsers = db.Users.Where(x => x.Name.ToLower().Contains("john"));
foreach (User user in queryUsers)
{
user.Name = "Zvonimir Matic";
}
db.SaveChanges();
}
public StatsController(WebshopContext context)
{
this.db = context;
}
public InvoiceRepo(WebshopContext context)
{
_webshopContext = context;
}
public CartService(Controller controller)
{
_controller = controller;
_context = new WebshopContext();
}
public ProductReader(WebshopContext context, IMapper mapper)
{
_context = context ?? throw new ArgumentNullException($"{GetType().Name}.Ctor - parameter {nameof(context)} cannot be null.");
_mapper = mapper ?? throw new ArgumentNullException($"{GetType().Name}.Ctor - parameter {nameof(mapper)} cannot be null.");
}
public UserExistsAttribute()
{
_context = new WebshopContext();
base.ErrorMessage = ErrorMessage;
}
public WebshopDSO(WebshopContext db)
{
this.db = db;
}
