public static bool LoadLog()
{
System.Diagnostics.Debug.Assert(gbl == null); // no double instancing!
gbl = new GlobalCaptainsLogList();
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: SQLLiteExtensions.SQLExtConnection.AccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from CaptainsLog"))
{
List <CaptainsLogClass> logs = new List <CaptainsLogClass>();
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
logs.Add(new CaptainsLogClass(rdr));
}
}
if (logs.Count == 0)
{
return(false);
}
else
{
foreach (var bc in logs)
{
gbl.globallog.Add(bc);
}
return(true);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.ToString());
return(false);
}
}
public static bool LoadLog()
{
System.Diagnostics.Debug.Assert(gbl == null); // no double instancing!
gbl = new GlobalCaptainsLogList();
try
{
return(UserDatabase.Instance.ExecuteWithDatabase <bool>(cn =>
{
using (DbCommand cmd = cn.Connection.CreateCommand("select * from CaptainsLog"))
{
List <CaptainsLogClass> logs = new List <CaptainsLogClass>();
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
logs.Add(new CaptainsLogClass(rdr));
}
}
if (logs.Count == 0)
{
return false;
}
else
{
foreach (var bc in logs)
{
gbl.globallog.Add(bc);
}
return true;
}
}
}));
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.ToString());
return(false);
}
}
public static bool LoadLog()
{
System.Diagnostics.Debug.Assert(gbl == null); // no double instancing!
gbl = new GlobalCaptainsLogList();
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: SQLLiteExtensions.SQLExtConnection.AccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from CaptainsLog"))
{
DataSet ds = null;
ds = cn.SQLQueryText(cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(false);
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
CaptainsLogClass bc = new CaptainsLogClass(dr);
gbl.globallog.Add(bc);
}
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.ToString());
return(false);
}
}