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()); }