static public List <TravelLogUnit> GetAll()
{
List <TravelLogUnit> list = new List <TravelLogUnit>();
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from TravelLogUnit"))
{
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(list);
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
TravelLogUnit sys = new TravelLogUnit(dr);
list.Add(sys);
}
return(list);
}
}
}
public static bool TryGet(string name, out TravelLogUnit tlu)
{
tlu = Get(name);
return(tlu != null);
}