public void GetTotalTicketsByEventShouldReturnsCorrectTotalTicketsUsingDbContext()
{
var options = new DbContextOptionsBuilder <EventuresDbContext>()
.UseInMemoryDatabase("Eventures_Database_4")
.Options;
var context = new EventuresDbContext(options);
var service = new EventService(context);
var eventInDb = new Event
{
Name = "Event",
Place = "Sofia",
Start = DateTime.UtcNow,
End = DateTime.UtcNow,
TotalTickets = 100,
PricePerTicket = 25.5M
};
context.Events.Add(eventInDb);
context.SaveChanges();
var totalTickets = service.GetTotalTicketsByEvent(1);
Assert.Equal(100, totalTickets);
}
public void All_WithExistingData_ShouldReturnAllOfExistingData()
{
ServiceCollection services = new ServiceCollection();
services.AddDbContext <EventuresDbContext>(options =>
options.UseInMemoryDatabase("EventuresTestDB"));
Event eventModel = new Event {
Id = "Whatever", Name = "TestEvent", TotalTickets = 10
};
_db.Events.Add(eventModel);
_db.SaveChanges();
List <Event> result = _service.GetAllWithTicketPrice().ToList();
result.ShouldNotBeEmpty();
Event entity = result[0];
entity.ShouldBeSameAs(eventModel);
}
public void Seed(EventuresDbContext context)
{
if (!context.Roles.Any())
{
context.Roles.Add(new UserRole {
Name = "Admin", NormalizedName = "ADMIN"
});
context.Roles.Add(new UserRole {
Name = "User", NormalizedName = "USER"
});
context.SaveChanges();
}
}
public void Create(string name, string place, DateTime startDate, DateTime endDate, int tickets, decimal price)
{
var createdEvent = new Event()
{
Name = name,
Place = place,
Start = startDate,
End = endDate,
Tickets = tickets,
PricePerTicket = price
};
db.Events.Add(createdEvent);
db.SaveChanges();
}
public void Create(EventCreate model)
{
var @event = new Event
{
End = model.End,
Start = model.Start,
Name = model.Name,
Place = model.Place,
PricePerTicket = model.PricePerTicket,
TotalTickets = model.TotalTickets,
};
context.Events.Add(@event);
context.SaveChanges();
}
public void AllOrdersWorksCorrectly()
{
var options = new DbContextOptionsBuilder <EventuresDbContext>()
.UseInMemoryDatabase(databaseName: "All_Orders_Db")
.Options;
var db = new EventuresDbContext(options);
db.Orders.AddRange(this.TestData().AsQueryable());
db.SaveChanges();
Assert.True(db.Orders.Count() == 3);
Assert.True(db.Orders.First().Event.Name == "FootballGame");
Assert.True(db.Orders.ToList()[1].Event.Name == "PrivateParty");
Assert.True(db.Orders.Last().Event.Name == "New Years Eve");
}
public void Seed()
{
if (context.Roles.Any() == false)
{
context.Roles.Add(new IdentityRole()
{
Name = "Admin",
NormalizedName = "ADMIN"
});
context.Roles.Add(new IdentityRole()
{
Name = "User",
NormalizedName = "USER"
});
}
context.SaveChanges();
}
public async Task Seed()
{
if (!context.Roles.Any())
{
context.Roles.Add(new IdentityRole
{
Name = "Admin",
NormalizedName = "ADMIN"
});
context.Roles.Add(new IdentityRole
{
Name = "User",
NormalizedName = "USER"
});
}
context.SaveChanges();
}
private void CreateRoles(EventuresDbContext context,
Microsoft.AspNetCore.Identity.RoleManager <IdentityRole> roleManager)
{
var roles = new string[] { "Admin", "User" };
foreach (var role in roles)
{
if (!roleManager.RoleExistsAsync(role).Result)
{
context.Roles.Add(new IdentityRole
{
Name = role,
NormalizedName = role.ToUpper()
});
context.SaveChanges();
}
}
}
public void GetMyOrdersReturnsAllOrdersOfTheCurrentlyLoggedUser()
{
var options = new DbContextOptionsBuilder <EventuresDbContext>()
.UseInMemoryDatabase(databaseName: "Get_My_Orders_Db")
.Options;
var db = new EventuresDbContext(options);
db.Orders.AddRange(TestData().AsQueryable());
db.SaveChanges();
var currentlyLoggedInUser = db.Users.FirstOrDefault(u => u.UserName == "Pesho");
var orderService = new OrderService(db);
var orders = orderService.GetMyOrders(currentlyLoggedInUser.UserName);
Assert.True(orders.Count() == 1);
}
public IActionResult Create(EventCreateBindingModel bindingModel)
{
if (this.ModelState.IsValid)
{
Event eventForDb = new Event()
{
Name = bindingModel.Name,
End = bindingModel.End,
Start = bindingModel.Start,
Place = bindingModel.Place,
PricePerTicket = bindingModel.PricePerTicket,
TotalTckets = bindingModel.TotalTickets
};
_context.Events.Add(eventForDb);
_context.SaveChanges();
return(this.Redirect("All"));
}
return(this.View());
}
public void CreateOrderWorksCorrectlyAndSavesItInDb()
{
var options = new DbContextOptionsBuilder <EventuresDbContext>()
.UseInMemoryDatabase(databaseName: "Create_Order_Db")
.Options;
var db = new EventuresDbContext(options);
var eventt = new Event
{
Id = "123",
Name = "FootballGame",
PricePerTicket = 10.25m,
Place = "Somewhere",
TotalTickets = 15000,
Start = new DateTime(2018, 12, 23, 19, 30, 0),
End = new DateTime(2018, 12, 23, 21, 0, 0)
};
var user = new EventuresUser
{
Id = "456",
UserName = "******",
FirstName = "Peter",
LastName = "Petrov",
UCN = "1234567890",
Email = "*****@*****.**",
PasswordHash = "21312312412412"
};
db.Events.Add(eventt);
db.Users.Add(user);
db.SaveChanges();
var orderService = new OrderService(db);
orderService.CreateOrder("123", "456", 5000);
Assert.True(db.Orders.First().Event.Name == "FootballGame");
Assert.True(db.Orders.First().Customer.UserName == "Pesho");
}
