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() // CAN return null
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: SQLLiteExtensions.SQLExtConnection.AccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from wanted_systems"))
{
DataSet ds = cn.SQLQueryText(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 (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.ToString());
return(null);
}
}
public static List <WantedSystemClass> GetAllWantedSystems() // CAN return null
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: SQLLiteExtensions.SQLExtConnection.AccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from wanted_systems"))
{
List <WantedSystemClass> retVal = new List <WantedSystemClass>();
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
WantedSystemClass sys = new WantedSystemClass(rdr);
retVal.Add(sys);
}
}
return(retVal);
}
}
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.ToString());
return(null);
}
}
public static List <WantedSystemClass> GetAllWantedSystems() // CAN return null
{
try
{
return(UserDatabase.Instance.ExecuteWithDatabase <List <WantedSystemClass> >(cn =>
{
using (DbCommand cmd = cn.Connection.CreateCommand("select * from wanted_systems"))
{
List <WantedSystemClass> retVal = new List <WantedSystemClass>();
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
WantedSystemClass sys = new WantedSystemClass(rdr);
retVal.Add(sys);
}
}
return retVal;
}
}));
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.ToString());
return(null);
}
}