public void DeleteSatellite(Satellite satellite) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("delete from Satellites where ID = @satellite_ID", satellite); } }
public void UpdateSatellite(Satellite satellite) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("update table Satellites set Name = @satellite_Name, Planet_ID = @planet_ID where ID = @satellite_ID", satellite); } }
public void SaveSatellite(Satellite satellite) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("insert into Planets (Name,Planet_ID) values (@satellite_Name,@planet_ID)", satellite); } }
public Satellite GetIndividualSatellite(Satellite satellite) { Satellite individualSatellite = new Satellite(); using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { individualSatellite.satellite_Name = cnn.Execute("select Name from Satellites where ID = @satellite_ID", satellite).ToString(); individualSatellite.satellite_ID = cnn.Execute("select ID from Satellites where ID = @satellite_ID", satellite); individualSatellite.planet_ID = cnn.Execute("select Planet_ID from Satellites where ID = @satellite_ID", satellite); return(individualSatellite); } }
public override void Update(float dt) { if (Game.Setting.LaunchSatellite) { var satellite = new Satellite(); satellite.LoadContent(); Children.Add(satellite); } if (Game.Setting.RemoveSatellite) { Children.Clear(); } foreach (var child in Children) { child.Update(dt); } }
static void Main(string[] args) { Satellite moon = new Satellite("Earth", "Moon"); ManMadeSat station = new ManMadeSat("Earth", "The ISS", "Nasa"); // Object Initializer doesn't call a constructor to set values Satellite europa = new Satellite() { Name = "Europa", Primary = "Jupiter" }; moon.Name = "The Moon"; moon.PrintSystem(); Console.WriteLine(); europa.PrintSystem(); Console.WriteLine(); station.PrintSystem(); Console.ReadKey(); }