public int InsertGenericEvent(DateTime entryDate, ContentLogEntryType entryType, int catalogID)
{
StringBuilder s = new StringBuilder("INSERT INTO ");
s.Append(dbTableName);
s.Append(" (EntryDate, EntryType, OrigClipID, ClientUserID, Message ) VALUES (");
s.AppendFormat("'{0}',", entryDate);
s.AppendFormat("{0},", (int)entryType);
s.AppendFormat("0,0,");
s.Append("'");
s.AppendFormat(DbContentLog.LogEntries[(int)entryType, 2], catalogID);
s.Append("');");
return(runOleDbCommand(s.ToString()));
}
private int InsertClipHit(DateTime entryDate, ContentLogEntryType entryType, int clipID, int parentClipID, int clientUserID, string clientData)
{
StringBuilder s = new StringBuilder("INSERT INTO ");
s.Append(dbTableName);
s.Append(" (EntryDate, EntryType, OrigClipID, ParentClipID, ClientUserID, Message ) VALUES (");
s.AppendFormat("'{0}',", entryDate);
s.AppendFormat("{0},", (int)entryType);
s.AppendFormat("{0},", clipID);
s.AppendFormat("{0},", parentClipID);
s.AppendFormat("{0},", clientUserID);
s.Append("'");
s.AppendFormat(DbContentLog.LogEntries[(int)entryType, 2], clipID, clientUserID, parentClipID, clientData);
s.Append("');");
return(runOleDbCommand(s.ToString()));
}
private int InsertTcsEvent(DateTime entryDate, ContentLogEntryType entryType, int clipID, int parentClipID, int clientUserID)
{
throw(new NotImplementedException("TCS Event Logging is not implemented in this version."));
// StringBuilder s = new StringBuilder("INSERT INTO ");
// s.Append(dbTableName);
// s.Append(" (EntryDate, EntryType, OrigClipID, ParentClipID, ClientUserID, Message ) VALUES (");
// s.AppendFormat("'{0}',", entryDate);
// s.AppendFormat("{0},", (int) entryType);
// s.AppendFormat("{0},", clipID);
// s.AppendFormat("{0},",parentClipID);
// s.AppendFormat("{0},",clientUserID);
//
// s.Append("'");
// s.AppendFormat(DbContentLog.LogEntries[(int) entryType,2], clipID, clientUserID);
// s.Append("');");
//
// return runOleDbCommand(s.ToString());
}
