/// <summary> /// Logs the specified /// </summary> /// <param name="log"></param> public static void Log(BaseLog log) { Type logType = log.GetType(); Dictionary<string, string> toLog = new Dictionary<string, string> { {"print", "true"}, {"date", log.Date}, {"time", log.Time}, {"action", log.Action.ToString().SplitAtCapitalLetter()} }; DatabaseHandler handler = new DatabaseHandler(); if (logType == typeof(WebpageActionsLog)) { //webpage_actions (date TEXT, time TEXT, action TEXT, url TEXT, file_name TEXT, hash TEXT, note TEXT WebpageActionsLog webpageAction = (WebpageActionsLog)log; toLog.Add("url", webpageAction.Url); toLog.Add("file", webpageAction.File); toLog.Add("hash", webpageAction.Hash); toLog.Add("note", webpageAction.Note); handler.Insert("webpage_actions", toLog); } else if (logType == typeof(WebsiteLog)) { //webpage_log (date TEXT, time TEXT, action TEXT, url TEXT)" WebsiteLog webSiteLog = (WebsiteLog)log; toLog.Add("url", webSiteLog.Url); handler.Insert("webpage_log", toLog); } else if (logType == typeof(AttachmentsLog)) { //date TEXT, time TEXT, action, file TEXT , hash TEXT, notes TEXT) AttachmentsLog attachLog = (AttachmentsLog)log; toLog.Add("file", attachLog.File); toLog.Add("hash", attachLog.Hash); toLog.Add("note", attachLog.Note); handler.Insert("attachments", toLog); } else if(logType == typeof(OsirtActionsLog)) { //osirt_actions (id INTEGER PRIMARY KEY, print BOOLEAN, date TEXT, time TEXT, action TEXT, file TEXT, hash TEXT)" OsirtActionsLog osirtAction = (OsirtActionsLog)log; toLog.Add("hash", osirtAction.Hash); toLog.Add("file", osirtAction.File); handler.Insert("osirt_actions", toLog); } else if (logType == typeof(VideoLog)) { //date TEXT, time TEXT, action, file TEXT , hash TEXT, notes TEXT) VideoLog attachLog = (VideoLog)log; toLog.Add("file", attachLog.File); toLog.Add("hash", attachLog.Hash); toLog.Add("note", attachLog.Note); handler.Insert("videos", toLog); } }
private void AddCaseDetailsToDb() { DatabaseHandler handler = new DatabaseHandler(); handler.Insert("case_details", caseDetails); }