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();
}
