public void Reset()
{
string queryString = string.Empty;
queryString = queryString + "DELETE from " + messages_table + " WHERE " +
"beginstring=" + "'" + _sessionID.BeginString + "' and " +
"sendercompid=" + "'" + _sessionID.SenderCompID + "' and " +
"targetcompid=" + "'" + _sessionID.TargetCompID + "' and " +
"session_qualifier=" + "'" + _sessionID.SessionQualifier + "'";
try
{
using (OdbcConnection odbc = GetODBCConnection())
{
OdbcCommand cmdReset = new OdbcCommand(queryString, odbc);
cmdReset.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
cache_.Reset();
DateTime?time = cache_.CreationTime;
string sqlTime = ODBCHelper.DateTimeToODBCConverter(time.Value);
queryString = "UPDATE " + sessions_table + " SET creation_time={ts '" + sqlTime + "'}, " +
"incoming_seqnum=" + cache_.GetNextTargetMsgSeqNum() + ", "
+ "outgoing_seqnum=" + cache_.GetNextSenderMsgSeqNum() + " WHERE "
+ "beginstring=" + "'" + _sessionID.BeginString + "' and "
+ "sendercompid=" + "'" + _sessionID.SenderCompID + "' and "
+ "targetcompid=" + "'" + _sessionID.TargetCompID + "' and "
+ "session_qualifier=" + "'" + _sessionID.SessionQualifier + "'";
try
{
using (OdbcConnection odbc = GetODBCConnection())
{
OdbcCommand cmdReset = new OdbcCommand(queryString, odbc);
cmdReset.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}