public static Oolite_System_Info AddSystem(int ID, string s)
{
Oolite_System_Info info = null;
foreach (Oolite_System_Info x in Systems)
{
Console.WriteLine(x.ToString());
if (String.Compare(x.ToString(), s, true) == 0)
{
info = x;
break;
}
}
if (info == null)
{
try
{
info = new Oolite_System_Info(s, ID, grid.Tables["Systems"].NewRow());
}
catch (Exception e)
{
Console.WriteLine(e);
}
//Save();
}
return(info);
}
private void CreateOrFindSystem(object sender, EventArgs e)
{
if (String.Compare(SelectedItem.ToString(), "<New>") == 0)
{
QueryNewName name = new QueryNewName("Enter new SyStem Name");
name.ShowDialog();
if (name.DialogResult == DialogResult.OK)
{
Oolite_System_Info info = Local.AddSystem(name.textBox1.Text);
Items.Add(info);
}
}
}
public static bool AddSystem(string s, DataRow row)
{
Oolite_System_Info info = null;
foreach (Oolite_System_Info x in Systems)
{
if (String.Compare(x.ToString(), s, true) == 0)
{
if ((x.data != row))
{
{
// // row.RejectChanges(); casues application fault.
row[1] = DBNull.Value;
row[0] = DBNull.Value;
//--- these don't work either...
//row.Table.AcceptChanges();
//row.Delete();
////row.RowState = DataRowState.Deleted;
//row.Table.AcceptChanges();
//--- thrown an exception is not caught nicely by top level (middle)
////throw new Exception("Abort NewRow()");
////row.AcceptChanges();
}
return(false);
}
else
{
info = x;
}
//else fall through - and rename will happen ...
// allowed to change this name...
}
}
if (info == null)
{
try
{
Systems.Add(info = new Oolite_System_Info(s, row, false));
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
//Save();
}
return(true);
}
public void Load()
{
#if asdfasdf
if (Local.odbc.State != ConnectionState.Closed)
{
OdbcCommand c = new OdbcCommand("select system_id,name,Population,Gross,Type from Oolite_Systems", Local.odbc);
try
{
OdbcDataReader r = c.ExecuteReader();
while (r.Read())
{
Oolite_System_Info osi = Local.AddSystem(r.GetInt32(0), r.GetString(1));
osi.data[2] = r.GetString(2);
osi.data[3] = r.GetString(3);
osi.data[4] = r.GetString(4);
//?select max(time),Commodity_Name from Oolite_Price_History group by Commodity_Name
//select * from Oolite_Price_History where time in (select max(time) from Oolite_Price_History group by Commodity_Name )
OdbcCommand c2 = new OdbcCommand("select Commodity_Name,price from Oolite_Price_History where time in (select max(time) from Oolite_Price_History where system_id="
+ osi.data[0]
+ " group by Commodity_Name )"
, Local.odbc);
try
{
OdbcDataReader r2 = c2.ExecuteReader();
while (r2.Read())
{
osi.data[r2.GetString(0)] = r2.GetDouble(1);
}
}
catch (Exception e2)
{
Console.WriteLine(e2);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
#endif
}
static bool something(Oolite_System_Info s)
{
return(false);
}
