static void Main(string[] args) { string version = typeof(Program).Assembly.GetName().Version.ToString(); Console.WriteLine($"Drone Flight Log Database Management {version}"); Operation op = new CommandParser().ParseCommandLine(args); if (op.Valid) { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); DroneFlightLogFactory <DroneFlightLogDbContext> factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); try { switch (op.Type) { case OperationType.add: factory.Users.AddUser(op.UserName, op.Password); Console.WriteLine($"Added user {op.UserName}"); break; case OperationType.setpassword: factory.Users.SetPassword(op.UserName, op.Password); Console.WriteLine($"Set password for user {op.UserName}"); break; case OperationType.delete: factory.Users.DeleteUser(op.UserName); Console.WriteLine($"Deleted user {op.UserName}"); break; case OperationType.update: context.Database.Migrate(); Console.WriteLine($"Applied the latest database migrations"); break; default: break; } } catch (Exception ex) { Console.WriteLine($"Error : {ex.Message}"); } } else { string executable = AppDomain.CurrentDomain.FriendlyName; Console.WriteLine("Usage:"); Console.WriteLine($"[1] {executable} add username password"); Console.WriteLine($"[2] {executable} setpassword username password"); Console.WriteLine($"[3] {executable} delete username"); Console.WriteLine($"[4] {executable} update"); } }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); FlightLogUser user = _factory.Users.AddUser(UserName, Password); _factory.Context.SaveChanges(); _userId = user.Id; }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Location location = _factory.Locations.AddLocation(Name); _factory.Context.SaveChanges(); _locationId = location.Id; }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Manufacturer manufacturer = _factory.Manufacturers.AddManufacturer(Name); _factory.Context.SaveChanges(); _manufacturerId = manufacturer.Id; }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Address address = _factory.Addresses.AddAddress(Number, Street, Town, County, Postcode, Country); _factory.Context.SaveChanges(); _addressId = address.Id; }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Address address = _factory.Addresses.AddAddress(Number, Street, Town, County, Postcode, Country); _factory.Context.SaveChanges(); Operator op = _factory.Operators.AddOperator(FirstNames, Surname, DoB, FlyerNumber, OperatorNumber, address.Id); _factory.Context.SaveChanges(); Location location = _factory.Locations.AddLocation(LocationName); _factory.Context.SaveChanges(); Manufacturer manufacturer = _factory.Manufacturers.AddManufacturer(ManufacturerName); _factory.Context.SaveChanges(); Model model = _factory.Models.AddModel(ModelName, manufacturer.Id); _factory.Context.SaveChanges(); Drone drone = _factory.Drones.AddDrone(DroneName, DroneSerialNumber, model.Id); _factory.Context.SaveChanges(); Flight flight = _factory.Flights.AddFlight(op.Id, drone.Id, location.Id, DateTime.Now, DateTime.Now); _factory.Context.SaveChanges(); _flightId = flight.Id; FlightProperty property = _factory.Properties.AddProperty(PropertyName, PropertyType, true); _factory.Context.SaveChanges(); _propertyId = property.Id; FlightPropertyValue value = _factory.Properties.AddPropertyValue(_flightId, _propertyId, PropertyValue); _factory.Context.SaveChanges(); _propertyValueId = value.Id; }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Address firstAddress = _factory.Addresses.AddAddress(Number, Street, Town, County, Postcode, Country); Address secondAddress = _factory.Addresses.AddAddress(Number, Street, Town, County, SecondPostcode, Country); _factory.Context.SaveChanges(); _firstAddressId = firstAddress.Id; _secondAddressId = secondAddress.Id; Operator op = _factory.Operators.AddOperator(FirstNames, Surname, DoB, FlyerNumber, OperatorNumber, _firstAddressId); _factory.Context.SaveChanges(); _operatorId = op.Id; }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Address address = _factory.Addresses.AddAddress(Number, Street, Town, County, Postcode, Country); _factory.Context.SaveChanges(); Operator op = _factory.Operators.AddOperator(FirstNames, Surname, DoB, FlyerNumber, OperatorNumber, address.Id); Operator secondOp = _factory.Operators.AddOperator(SecondFirstNames, Surname, DoB, FlyerNumber, OperatorNumber, address.Id); _factory.Context.SaveChanges(); _operatorId = op.Id; _secondOperatorId = secondOp.Id; Location location = _factory.Locations.AddLocation(LocationName); Location secondLocation = _factory.Locations.AddLocation(SecondLocationName); _factory.Context.SaveChanges(); _locationId = location.Id; _secondLocationId = secondLocation.Id; Manufacturer manufacturer = _factory.Manufacturers.AddManufacturer(ManufacturerName); _factory.Context.SaveChanges(); Model model = _factory.Models.AddModel(ModelName, manufacturer.Id); _factory.Context.SaveChanges(); Drone drone = _factory.Drones.AddDrone(DroneName, DroneSerialNumber, model.Id); Drone secondDrone = _factory.Drones.AddDrone(SecondDroneName, SecondDroneSerialNumber, model.Id); _factory.Context.SaveChanges(); _droneId = drone.Id; _secondDroneId = secondDrone.Id; Flight flight = _factory.Flights.AddFlight(op.Id, drone.Id, location.Id, StartDate, EndDate); _factory.Context.SaveChanges(); _flightId = flight.Id; }
static void Main(string[] args) { if (args.Length == 1) { // Read the application settings IConfiguration configuration = new ConfigurationBuilder() .AddJsonFile("appsettings.json") .Build(); IConfigurationSection section = configuration.GetSection("AppSettings"); AppSettings settings = section.Get <AppSettings>(); // Create the factory for acessing the SQLite database DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); IDroneFlightLogFactory <DroneFlightLogDbContext> factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); CsvReader <DroneFlightLogDbContext> reader = null; try { // Use the CSV reader to read the flights reader = new CsvReader <DroneFlightLogDbContext>(settings, factory); IList <Flight> flights = reader.Read(args[0]); // Store the flights in the database FlightWriter <DroneFlightLogDbContext> writer = new FlightWriter <DroneFlightLogDbContext>(factory); writer.Save(flights); } catch (Exception ex) { Console.WriteLine($"{ex.Message}"); if ((reader != null) && (reader.LastError != null)) { Console.WriteLine($"Record {reader.LastError.Record} : {reader.LastError.Message}"); } } } else { string executable = AppDomain.CurrentDomain.FriendlyName; Console.WriteLine($"Usage : {executable} path_to_csv_file"); } }
public void TestInitialize() { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); _factory = new DroneFlightLogFactory <DroneFlightLogDbContext>(context); Manufacturer manufacturer = _factory.Manufacturers.AddManufacturer(ManufacturerName); _factory.Context.SaveChanges(); _manufacturerId = manufacturer.Id; Model model = _factory.Models.AddModel(ModelName, manufacturer.Id); _factory.Context.SaveChanges(); _modelId = model.Id; Drone drone = _factory.Drones.AddDrone(DroneName, DroneSerialNumber, _modelId); _factory.Context.SaveChanges(); _droneId = drone.Id; }
static void Main(string[] args) { DroneFlightLogDbContext context = new DroneFlightLogDbContextFactory().CreateDbContext(null); context.Database.Migrate(); }