public override async Task CreateWorksAsync()
{
Customers customerSaved = null;
Event EventSaved = null;
EventCustomer eventCustomerSaved = null;
var options = new DbContextOptionsBuilder <Project15Context>()
.UseInMemoryDatabase("db_eventcustomer_test_create").Options;
using (var db = new Project15Context(options));
// act (for act, only use the repo, to test it)
using (var db = new Project15Context(options))
{
var repo = new EventCustomerRepository(db);
//Create customer
Customers customer = new Customers {
Name = "Axel", Address1 = "111 Address"
};
await repo.SaveChangesAsync();
Event Event = new Event {
Name = "Jazz Fest", Type = "Music", Cost = 40
};
await repo.SaveChangesAsync();
EventCustomer eventCustomer = new EventCustomer
{
CustomerId = customer.Id,
EventId = Event.Id,
Paid = true
};
eventCustomerSaved = await repo.CreateAsync(eventCustomer);
await repo.SaveChangesAsync();
customerSaved = customer;
EventSaved = Event;
}
// assert (for assert, once again use the context directly for verify.)
using (var db = new Project15Context(options))
{
var repo = new EventCustomerRepository(db);
EventCustomer eventCustomer = Mapper.Map <EventsCustomers, EventCustomer>(db.EventsCustomers.First(m => m.Paid == true));
Assert.Equal(customerSaved.Id, eventCustomer.CustomerId);
Assert.Equal(EventSaved.Id, eventCustomer.EventId);
Assert.True(eventCustomer.Paid);
Assert.NotEqual(0, eventCustomer.Id);
}
}
public override async Task DeleteWorksAsync()
{
int id = 0;
Customer customerSaved = null;
Event EventSaved = null;
EventCustomer eventCustomerSaved = null;
// arrange (use the context directly - we assume that works)
var options = new DbContextOptionsBuilder <Project15Context>()
.UseInMemoryDatabase("db_eventcustomer_test_delete_2").Options;
using (var db = new Project15Context(options));
// act (for act, only use the repo, to test it)
using (var db = new Project15Context(options))
{
var customerRepo = new CustomerRepository(db);
var eventRepo = new EventRepository(db);
var repo = new EventCustomerRepository(db);
//Create customer
Customer customer = new Customer {
Name = "Axel", Address1 = "111 Address"
};
customer = await customerRepo.CreateAsync(customer);
await customerRepo.SaveChangesAsync();
Event Event = new Event {
Name = "Jazz Fest", Type = "Music", Cost = 40
};
Event = await eventRepo.CreateAsync(Event);
await eventRepo.SaveChangesAsync();
EventCustomer eventCustomer = new EventCustomer
{
CustomerId = customer.Id,
EventId = Event.Id,
Paid = true
};
eventCustomerSaved = await repo.CreateAsync(eventCustomer);
await repo.SaveChangesAsync();
EventSaved = Event;
customerSaved = customer;
id = eventCustomerSaved.Id;
}
// assert (for assert, once again use the context directly for verify.)
using (var db = new Project15Context(options))
{
var repo = new EventCustomerRepository(db);
EventCustomer eventCustomer = await repo.GetByIdAsync(id);
Assert.NotEqual(0, eventCustomer.Id);
Assert.Equal(eventCustomerSaved.Id, eventCustomer.Id);
Assert.True(eventCustomer.Paid);
await repo.DeleteAsync(id);
await repo.SaveChangesAsync();
eventCustomer = await repo.GetByIdAsync(id);
Assert.Null(eventCustomer);
}
}
public override async Task UpdateWorksAsync()
{
int id = 0;
int wrongId = 10;
EventCustomer eventCustomerSaved = null;
Event EventSaved = null;
Customer customerSaved = null;
// arrange (use the context directly - we assume that works)
var options = new DbContextOptionsBuilder <Project15Context>()
.UseInMemoryDatabase("db_eventcustomer_test_updatebyid").Options;
// act (for act, only use the repo, to test it)
using (var db = new Project15Context(options));
using (var db = new Project15Context(options))
{
var customerRepo = new CustomerRepository(db);
var eventRepo = new EventRepository(db);
var repo = new EventCustomerRepository(db);
Customer customer = new Customer {
Name = "Axel", Address1 = "111 Address"
};
customer = await customerRepo.CreateAsync(customer);
await customerRepo.SaveChangesAsync();
Event Event = new Event {
Name = "Jazz Fest", Type = "Music", Cost = 40
};
Event = await eventRepo.CreateAsync(Event);
await eventRepo.SaveChangesAsync();
EventCustomer eventCustomer = new EventCustomer
{
CustomerId = customer.Id,
EventId = Event.Id,
Paid = true
};
eventCustomerSaved = await repo.CreateAsync(eventCustomer);
await repo.SaveChangesAsync();
EventSaved = Event;
customerSaved = customer;
id = eventCustomerSaved.Id;
}
using (var db = new Project15Context(options))
{
var repo = new EventCustomerRepository(db);
EventCustomer eventCustomer = await repo.GetByIdAsync(id);
Assert.NotEqual(0, eventCustomer.Id); // should get some generated ID
Assert.Equal(eventCustomerSaved.Id, eventCustomer.Id);
Assert.Equal(EventSaved.Id, eventCustomer.EventId);
eventCustomer.Paid = false;
await repo.UpdateAsync(eventCustomer, id);
await repo.SaveChangesAsync();
eventCustomer = await repo.GetByIdAsync(eventCustomer.Id);
Assert.NotEqual(wrongId, eventCustomer.Id); // should get some generated ID
Assert.False(eventCustomer.Paid);
}
}
public override async Task GetAllWorksAsync()
{
List <EventCustomer> eventCustomersList = new List <EventCustomer>();
EventCustomer eventCustomerSaved = null;
Customer customerSaved = null;
Event EventSaved = null;
var options = new DbContextOptionsBuilder <Project15Context>()
.UseInMemoryDatabase("db_eventcustomer_test_getall").Options;
using (var db = new Project15Context(options));
using (var db = new Project15Context(options))
{
var customerRepo = new CustomerRepository(db);
var eventRepo = new EventRepository(db);
var repo = new EventCustomerRepository(db);
//Create customer
Customer customer = new Customer {
Name = "Axel", Address1 = "111 Address"
};
customer = await customerRepo.CreateAsync(customer);
await customerRepo.SaveChangesAsync();
Event Event = new Event {
Name = "Jazz Fest", Type = "Music", Cost = 40
};
Event = await eventRepo.CreateAsync(Event);
await eventRepo.SaveChangesAsync();
for (int i = 0; i < 5; i++)
{
EventCustomer eventCustomer = new EventCustomer
{
CustomerId = customer.Id,
EventId = Event.Id,
};
eventCustomerSaved = await repo.CreateAsync(eventCustomer);
await repo.SaveChangesAsync();
eventCustomersList.Add(eventCustomerSaved);
}
EventSaved = Event;
customerSaved = customer;
}
using (var db = new Project15Context(options))
{
var repo = new EventCustomerRepository(db);
List <EventCustomer> list = (List <EventCustomer>) await repo.GetAllAsync();
Assert.Equal(eventCustomersList.Count, list.Count);
for (int i = 0; i < 5; i++)
{
Assert.Equal(eventCustomersList[i].CustomerId, list[i].CustomerId);
Assert.Equal(eventCustomersList[i].EventId, list[i].EventId);
Assert.NotEqual(0, list[i].Id);
}
}
}