public async Task AddIngredientAsyncAdds() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("AddIngredientAsyncAdds") .Options; Ingredient ingredient = new Ingredient { Id = 1, TypeId = 1, Name = "name", Price = 1, IngredientType = new IngredientType { Id = 1, Name = "name", } }; using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); await repo.AddIngredientAsync(ingredient); await repo.SaveAsync(); using var arrangeContext = new Project2JAGVContext(options); var result = arrangeContext.Ingredients; Assert.NotNull(result); }
public void GetUsersAsyncGetsAllUsers() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("GetUsersAsyncGetsAllUsers") .Options; using var arrangeContext = new Project2JAGVContext(options); int id = 1; string name = "name"; string password = "******"; int addressId = 1; int userTypeId = 1; arrangeContext.Users.Add(new Users { Id = id, Name = name, Password = password, UserTypeId = userTypeId, AddressId = addressId, }); arrangeContext.SaveChanges(); using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); // act var result = repo.GetUsersAsync(id: id, name: name, password: password); // assert Assert.NotNull(result); }
public async Task AddPizzaAsyncAdds() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("AddOrderAsyncAdds") .Options; Pizza pizza = new Pizza { Id = 1, OrderId = 1, Name = "name", }; using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); await repo.AddPizzaAsync(pizza); await repo.SaveAsync(); using var arrangeContext = new Project2JAGVContext(options); var result = arrangeContext.Pizzas; Assert.NotNull(result); }
public async Task GetPizzasAsyncGets() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("GetOrdersAsynGetsc") .Options; Pizzas pizzas = new Pizzas { Id = 1, OrderId = 1, Name = "name", }; using var arrangeContext = new Project2JAGVContext(options); arrangeContext.Add(pizzas); arrangeContext.SaveChanges(); using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); var result = await repo.GetPizzasAsync(id : pizzas.Id, orderId : pizzas.OrderId, name : pizzas.Name); Assert.NotNull(result); }
public async Task GetOrdersAsynGetsc() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("GetOrdersAsynGetsc") .Options; Orders orders = new Orders { Id = 1, UserId = 1, DelivererId = 1, Delivered = false, Date = DateTime.Now, }; using var arrangeContext = new Project2JAGVContext(options); arrangeContext.Add(orders); arrangeContext.SaveChanges(); using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); var result = await repo.GetOrdersAsync(id : orders.Id, userId : orders.UserId, delivererId : orders.DelivererId, delivered : orders.Delivered, date : orders.Date); Assert.NotNull(result); }
public async Task AddOrderAsyncAdds() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("AddOrderAsyncAdds") .Options; Order order = new Order { Id = 1, UserId = 1, DelivererId = 1, Delivered = false, Date = DateTime.Now, }; using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); await repo.AddOrderAsync(order); await repo.SaveAsync(); using var arrangeContext = new Project2JAGVContext(options); var result = arrangeContext.Orders; Assert.NotNull(result); }
public async Task AddAddressAsyncAdds() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("AddAddressAsyncGets") .Options; Address address = new Address { Id = 1, Street = "Street", City = "City", State = "State", ZipCode = "ZipCode", }; using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); // act await repo.AddAddressAsync(address); await repo.SaveAsync(); using var arrangeContext = new Project2JAGVContext(options); var result = arrangeContext.Addresses; // assert Assert.NotNull(result); }
public async Task GetIngredientsAsyncGets() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("GetIngredientsAsyncGets") .Options; Ingredients ingredients = new Ingredients { Id = 1, Name = "name", Price = 1, }; using var arrangeContext = new Project2JAGVContext(options); arrangeContext.Add(ingredients); arrangeContext.SaveChanges(); using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); var result = await repo.GetIngredientsAsync(); Assert.NotNull(result); }
public async Task GetAddressesAsyncGets() { var options = new DbContextOptionsBuilder <Project2JAGVContext>() .UseInMemoryDatabase("GetAddressesAsyncGets") .Options; using var arrangeContext = new Project2JAGVContext(options); Addresses addresses = new Addresses { Id = 1, Street = "Street", City = "City", State = "State", ZipCode = "ZipCode", }; Address address = new Address { Id = 1, Street = "Street", City = "City", State = "State", ZipCode = "ZipCode", }; arrangeContext.Addresses.Add(addresses); arrangeContext.SaveChanges(); using var actContext = new Project2JAGVContext(options); var repo = new DataAccess.DataAccess(actContext, new MapperStub()); var result = await repo.GetAddressesAsync(id : addresses.Id, address : address); Assert.NotNull(result); }
/// <summary> /// constructor for the project0 database access /// </summary> /// <param name="context">Dbcontext for accessing the database</param> public DataAccess(Project2JAGVContext context, IMappers mapper) { _context = context ?? throw new ArgumentNullException(nameof(context)); _mapper = mapper ?? throw new ArgumentNullException(nameof(mapper)); }