public void Load()
{
_qsoTable = GetDataFromTableInOrder(Constants.LOG_TABLE_QSOS, Constants.INDEX.ID.ToString(), Constants.ORDER.DESC);
if (_qsoTable == null)
{
return;
}
foreach (DataRow row in _qsoTable.Rows)
{
QSOs.AddLast(new QSO
{
ID = row.Field <long>((int)Constants.INDEX.ID),
Callsign = row.Field <string>((int)Constants.INDEX.CALLSIGN),
Name = row.IsNull((int)Constants.INDEX.NAME) ? null : row.Field <string>((int)Constants.INDEX.NAME),
Country = row.IsNull((int)Constants.INDEX.COUNTRY) ? null : row.Field <string>((int)Constants.INDEX.COUNTRY),
State = row.IsNull((int)Constants.INDEX.STATE) ? null : row.Field <string>((int)Constants.INDEX.STATE),
County = row.IsNull((int)Constants.INDEX.COUNTY) ? null : row.Field <string>((int)Constants.INDEX.COUNTY),
City = row.IsNull((int)Constants.INDEX.CITY) ? null : row.Field <string>((int)Constants.INDEX.CITY),
GridSquare = row.IsNull((int)Constants.INDEX.GRIDSQUARE) ? null : row.Field <string>((int)Constants.INDEX.GRIDSQUARE),
Frequency = row.IsNull((int)Constants.INDEX.FREQUENCY) ? null : row.Field <string>((int)Constants.INDEX.FREQUENCY),
Band = row.IsNull((int)Constants.INDEX.BAND) ? null : row.Field <string>((int)Constants.INDEX.BAND),
Mode = row.IsNull((int)Constants.INDEX.MODE) ? null : row.Field <string>((int)Constants.INDEX.MODE),
DateTimeOn = row.IsNull((int)Constants.INDEX.DATETIMEON) ? new DateTime() : row.Field <DateTime>((int)Constants.INDEX.DATETIMEON),
DateTimeOff = row.IsNull((int)Constants.INDEX.DATETIMEOFF) ? new DateTime() : row.Field <DateTime>((int)Constants.INDEX.DATETIMEOFF),
Operator = row.IsNull((int)Constants.INDEX.OPERATOR) ? null : row.Field <string>((int)Constants.INDEX.OPERATOR),
MyName = row.IsNull((int)Constants.INDEX.MY_NAME) ? null : row.Field <string>((int)Constants.INDEX.MY_NAME),
MyCountry = row.IsNull((int)Constants.INDEX.MY_COUNTRY) ? null : row.Field <string>((int)Constants.INDEX.MY_COUNTRY),
MyState = row.IsNull((int)Constants.INDEX.MY_STATE) ? null : row.Field <string>((int)Constants.INDEX.MY_STATE),
MyCounty = row.IsNull((int)Constants.INDEX.MY_COUNTY) ? null : row.Field <string>((int)Constants.INDEX.MY_COUNTY),
MyCity = row.IsNull((int)Constants.INDEX.MY_CITY) ? null : row.Field <string>((int)Constants.INDEX.MY_CITY),
MyGridSquare = row.IsNull((int)Constants.INDEX.MY_GRIDSQUARE) ? null : row.Field <string>((int)Constants.INDEX.MY_GRIDSQUARE)
});
}
NextRecord = QSOs.Count == 0 ? 1 : QSOs.First.Value.ID + 1;
_qsoTable = null;
}
public void InsertQSO(QSO qso)
{
qso.ID = NextRecord;
string sql = Constants.LOG_DB_INSERT_QSO;
using (SQLiteCommand sqliteCmd = new SQLiteCommand(sql, _dbConnection))
{
sqliteCmd.Parameters.AddWithValue("@callsign", qso.Callsign);
sqliteCmd.Parameters.AddWithValue("@name", qso.Name);
sqliteCmd.Parameters.AddWithValue("@country", qso.County);
sqliteCmd.Parameters.AddWithValue("@state", qso.State);
sqliteCmd.Parameters.AddWithValue("@county", qso.County);
sqliteCmd.Parameters.AddWithValue("@city", qso.City);
sqliteCmd.Parameters.AddWithValue("@grid", qso.GridSquare);
sqliteCmd.Parameters.AddWithValue("@freq", qso.Frequency);
sqliteCmd.Parameters.AddWithValue("@band", qso.Band);
sqliteCmd.Parameters.AddWithValue("@mode", qso.Mode);
sqliteCmd.Parameters.AddWithValue("@datetimeon", DateTimeToSQLite(qso.DateTimeOn));
sqliteCmd.Parameters.AddWithValue("@datetimeoff", DateTimeToSQLite(qso.DateTimeOff));
sqliteCmd.Parameters.AddWithValue("@operator", qso.Operator);
sqliteCmd.Parameters.AddWithValue("@myname", qso.MyName);
sqliteCmd.Parameters.AddWithValue("@mycountry", qso.MyCountry);
sqliteCmd.Parameters.AddWithValue("@mystate", qso.MyState);
sqliteCmd.Parameters.AddWithValue("@mycounty", qso.MyCounty);
sqliteCmd.Parameters.AddWithValue("@mycity", qso.MyCity);
sqliteCmd.Parameters.AddWithValue("@mygridsquare", qso.MyGridSquare);
sqliteCmd.ExecuteNonQuery();
sqliteCmd.Dispose();
}
NextRecord++;
QSOs.AddFirst(qso);
}
IEnumerator IEnumerable.GetEnumerator()
{
return(QSOs.GetEnumerator());
}
public IEnumerator <QSO> GetEnumerator()
{
return(QSOs.GetEnumerator());
}
