public static List<WantedSystemClass> GetAllWantedSystems()
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from wanted_systems"))
{
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return null;
}
List<WantedSystemClass> retVal = new List<WantedSystemClass>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
WantedSystemClass sys = new WantedSystemClass(dr);
retVal.Add(sys);
}
return retVal;
}
}
}
catch
{
return null;
}
}
public static List <WantedSystemClass> GetAllWantedSystems()
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from wanted_systems"))
{
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
List <WantedSystemClass> retVal = new List <WantedSystemClass>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
WantedSystemClass sys = new WantedSystemClass(dr);
retVal.Add(sys);
}
return(retVal);
}
}
}
catch
{
return(null);
}
}
public List <WantedSystemClass> GetAllWantedSystems()
{
try
{
using (SQLiteConnection cn = new SQLiteConnection(ConnectionString))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
DataSet ds = null;
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 30;
cmd.CommandText = "select * from wanted_systems";
ds = SqlQueryText(cn, cmd);
if (ds.Tables.Count == 0)
{
return(null);
}
//
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
List <WantedSystemClass> retVal = new List <WantedSystemClass>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
WantedSystemClass sys = new WantedSystemClass(dr);
retVal.Add(sys);
}
return(retVal);
}
}
}
catch
{
return(null);
}
}
public void AddWantedSystem(string sysName)
{
if (wanted == null) wanted = new List<WantedSystemClass>();
WantedSystemClass entry = wanted.Where(x => x.system == sysName).FirstOrDefault();
if (entry == null)
{
WantedSystemClass toAdd = new WantedSystemClass(sysName);
wanted.Add(toAdd);
SystemClass star = SystemClass.GetSystem(sysName);
if (star == null)
star = new SystemClass(sysName);
var index = dataGridViewClosestSystems.Rows.Add("Local");
dataGridViewClosestSystems[1, index].Value = sysName;
dataGridViewClosestSystems[1, index].Tag = star;
}
}
public void AddWantedSystem(string sysName)
{
if (wanted == null)
PopulateLocalWantedSystems();
WantedSystemClass entry = wanted.Where(x => x.system == sysName).FirstOrDefault(); //duplicate?
if (entry == null)
{
WantedSystemClass toAdd = new WantedSystemClass(sysName); // make one..
toAdd.Add(); // add to db.
wanted.Add(toAdd);
SystemClass star = SystemClass.GetSystem(sysName);
if (star == null)
star = new SystemClass(sysName);
var index = dataGridViewClosestSystems.Rows.Add("Local");
dataGridViewClosestSystems[1, index].Value = sysName;
dataGridViewClosestSystems[1, index].Tag = star;
}
}