public void TestInvoiceHasCorrectPay() { //Arrange DateTime registrationTime = DateTime.Now; int minutes = 10; DateTime payTime = registrationTime.AddMinutes(minutes); int expectedPayAmount = (minutes * Invoice.BASE_COST_PER_MINUTE) + Invoice.BASE_COST_PER_MINUTE; Person person = new Person { Name = "Test Testsson2", SSN = Guid.NewGuid().ToString() }; Invoice invoice = new Invoice { RegistrationTime = registrationTime, Paid = false, Person = person }; //Act invoice.AddEntityToDatabase(); invoice.Pay(payTime); //Assert Assert.AreEqual(expectedPayAmount, invoice.AmountPaid); using SpacePortDBContext context = new SpacePortDBContext(); context.Persons.Remove(person); context.Invoices.Remove(invoice); context.SaveChanges(); }
public SpacePort SpacePortExists(int spacePortID) { using var context = new SpacePortDBContext(); var result = context.SpacePorts.Where(x => x.SpacePortID == spacePortID); return((result.Count() == 0) ? null : result.First()); }
internal static Person GetEntityFromDatabase(string ssn) { using SpacePortDBContext context = new SpacePortDBContext(); var person = context.Persons.Where(x => x.SSN == ssn).First(); return(person); }
internal void UpdateEntityInDatabase() { using var context = new SpacePortDBContext(); var invoiceContext = context.Set <ParkingSpot>(); invoiceContext.Update(this); context.SaveChanges(); }
public static void FreeSpotByID(int parkingSpotID) { using var context = new SpacePortDBContext(); var res = context.ParkingSpots.Where(x => x.ParkingSpotID == parkingSpotID).FirstOrDefault(); if (res != null) { res.Occupied = false; context.Set <ParkingSpot>().Update(res); context.SaveChanges(); } }
internal static void AddEntityToDatabase(string ssn, string name) { var myperson = new Person { Name = name, SSN = ssn }; using var context = new SpacePortDBContext(); context.Set <Person>().Add(myperson); context.SaveChanges(); }
private void DisplaySpacePorts() { Styling.ConsolePrint("\nExisting spaceports:"); using var context = new SpacePortDBContext(); var spaceports = context.SpacePorts; foreach (SpacePort spaceport in spaceports) { Styling.ConsolePrint($"ID: {spaceport.SpacePortID} " + $"\tName: {spaceport.Name.PadRight(14,' ')} " + $"\tStatus: {(spaceport.HasAvailableParkingspots() ? "Available Parkingspots" : "Closed")}", 0); } }
internal void AddEntityToDatabase() { using var context = new SpacePortDBContext(); var session = new ParkingSession() { ParkingToken = this.ParkingToken, ParkingSpotID = ParkingSpot.ParkingSpotID, SpaceShipID = SpaceShip.SpaceShipID, SpacePortID = this.SpacePort.SpacePortID, InvoiceID = this.Invoice.InvoiceID }; context.ParkingSessions.Add(session); context.SaveChanges(); }
internal static bool EntityExistsInDatabase(string ssn) { using var context = new SpacePortDBContext(); return(context.Persons.Any(x => x.SSN == ssn)); }