public async Task DeleteAsyncReturnsFalseIfTransportWorkTicketDoesNotExist() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()); var repository = new EfDeletableEntityRepository <TransportWorkTicket>(new ApplicationDbContext(options.Options)); var workTicketOne = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200100, TravelledDistance = 441, EndKilometers = 200541, FuelAvailability = 55, FuelConsumption = 441 * (5 / 100), Residue = 55 - (441 * (5 / 100)) }; var workTicketTwo = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200541, TravelledDistance = 100, EndKilometers = 200641, FuelAvailability = 55, FuelConsumption = 100 * (5 / 100), Residue = 55 - (100 * (5 / 100)) }; await repository.AddAsync(workTicketOne); await repository.AddAsync(workTicketTwo); await repository.SaveChangesAsync(); var transportWorkTicketsService = new TransportWorkTicketsService(repository); var isDeleted = await transportWorkTicketsService.DeleteAsync("4738-djsk-r4-3456", "Силвия Петрова"); var carsCount = repository.AllAsNoTracking().Count(); Assert.Equal(2, carsCount); Assert.False(isDeleted); }
public void GetAllTransportWorkTicketsForPeriodAsQueryable() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()); var repository = new EfDeletableEntityRepository <TransportWorkTicket>(new ApplicationDbContext(options.Options)); var workTicketOne = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200100, TravelledDistance = 441, EndKilometers = 200541, FuelAvailability = 55, FuelConsumption = 441 * (5 / 100), Residue = 55 - (441 * (5 / 100)) }; var workTicketTwo = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200541, TravelledDistance = 100, EndKilometers = 200641, FuelAvailability = 55, FuelConsumption = 100 * (5 / 100), Residue = 55 - (100 * (5 / 100)) }; repository.AddAsync(workTicketOne); repository.AddAsync(workTicketTwo); repository.SaveChangesAsync(); var transportWorkTicketsService = new TransportWorkTicketsService(repository); AutoMapperConfig.RegisterMappings(typeof(TransportWorkTicketViewModel).Assembly); var workTickets = transportWorkTicketsService.GetAllTransportWorkTicketsForPeriod <TransportWorkTicketViewModel>(workTicketTwo.CarId, DateTime.UtcNow.AddDays(-10), DateTime.UtcNow); Assert.Equal(2, workTickets.Count()); }
public async Task EditAsyncUpdatesTransportWorkTicketInfo() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()); var repository = new EfDeletableEntityRepository <TransportWorkTicket>(new ApplicationDbContext(options.Options)); var workTicketOne = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200100, TravelledDistance = 441, EndKilometers = 200541, FuelAvailability = 55, FuelConsumption = 441 * (5 / 100), Residue = 55 - (441 * (5 / 100)) }; var workTicketTwo = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200541, TravelledDistance = 100, EndKilometers = 200641, FuelAvailability = 55, FuelConsumption = 100 * (5 / 100), Residue = 55 - (100 * (5 / 100)) }; await repository.AddAsync(workTicketOne); await repository.AddAsync(workTicketTwo); await repository.SaveChangesAsync(); var transportWorkTicketsService = new TransportWorkTicketsService(repository); workTicketTwo.StartKilometers = 200700; workTicketTwo.TravelledDistance = 200; await transportWorkTicketsService.EditAsync(workTicketTwo); var workTicket = repository.AllAsNoTracking().FirstOrDefault(tr => tr.Id == workTicketTwo.Id); Assert.Equal(workTicketTwo.Date, workTicket.Date); Assert.Equal(workTicketTwo.StartKilometers, workTicket.StartKilometers); Assert.Equal(workTicketTwo.TravelledDistance, workTicket.TravelledDistance); }
public async Task CreateAsyncAddsCar() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()); var repository = new EfDeletableEntityRepository <TransportWorkTicket>(new ApplicationDbContext(options.Options)); var transportWorkTicket = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200100, TravelledDistance = 441, EndKilometers = 200541, FuelAvailability = 55, FuelConsumption = 441 * (5 / 100), Residue = 55 - (441 * (5 / 100)), }; var transportWorkTicketsService = new TransportWorkTicketsService(repository); await transportWorkTicketsService.CreateAsync(transportWorkTicket); var workTickets = repository.AllAsNoTracking().ToList(); Assert.Single(workTickets); }
public async Task GetByIdReturnsTransportWorkTicket() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()); var repository = new EfDeletableEntityRepository <TransportWorkTicket>(new ApplicationDbContext(options.Options)); var workTicketOne = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200100, TravelledDistance = 441, EndKilometers = 200541, FuelAvailability = 55, FuelConsumption = 441 * (5 / 100), Residue = 55 - (441 * (5 / 100)) }; var workTicketTwo = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "341414153", CarId = "72804eudajhkhfvs-dasfa", StartKilometers = 200541, TravelledDistance = 100, EndKilometers = 200641, FuelAvailability = 55, FuelConsumption = 100 * (5 / 100), Residue = 55 - (100 * (5 / 100)) }; var workTicketThree = new TransportWorkTicket { Date = DateTime.UtcNow, UserId = "3414141890", CarId = "72804eu-jhkhfvs-dasfa", StartKilometers = 200800, TravelledDistance = 100, EndKilometers = 200900, FuelAvailability = 55, FuelConsumption = 100 * (5 / 100), Residue = 55 - (100 * (5 / 100)) }; await repository.AddAsync(workTicketOne); await repository.AddAsync(workTicketTwo); await repository.SaveChangesAsync(); var transportWorkTicketsService = new TransportWorkTicketsService(repository); AutoMapperConfig.RegisterMappings(typeof(TransportWorkTicketViewModel).Assembly); var workTicket = transportWorkTicketsService.GetById(workTicketOne.Id); Assert.Equal(workTicketOne.StartKilometers, workTicket.StartKilometers); Assert.Equal(workTicketOne.EndKilometers, workTicket.EndKilometers); Assert.Equal(workTicketOne.TravelledDistance, workTicket.TravelledDistance); Assert.Equal(workTicketOne.Date, workTicket.Date); Assert.Equal(workTicketOne.FuelAvailability, workTicket.FuelAvailability); Assert.Equal(workTicketOne.FuelConsumption, workTicket.FuelConsumption); }