public DataTable GetAllDatabaseData() { Dictionary <string, string> tabs = new Dictionary <string, string>() { { "Websites Loaded", "webpage_log" }, { "Websites Actions", "webpage_actions" }, { "OSIRT Actions", "osirt_actions" }, { "Attachments", "attachments" }, { "Videos", "videos" }, }; DataTable merged = new DataTable(); foreach (string table in tabs.Values) { string columns = DatabaseTableHelper.GetTableColumns(table); DataTable data = GetRowsFromColumns(table: table, columns: columns); merged.Merge(data, true, MissingSchemaAction.Add); } DataTable dt = new DatabaseHandler().GetRowsFromColumns("case_notes", "", "date", "time", "note"); merged.Merge(dt, true, MissingSchemaAction.Add); merged.TableName = "merged"; DataView view = new DataView(merged); view.Sort = "date asc, time asc"; DataTable sortedTable = view.ToTable(); return(sortedTable); }
public CaseCreator(Dictionary<string,string> caseDetails, DatabaseTableHelper tables) { this.caseDetails = caseDetails; Constants.CaseContainerName = caseDetails["case_reference"]; CreateCaseContainer(); CreateCaseDatabase(); tables.CreateTables(); AddCaseDetailsToDb(); UserSettings settings = UserSettings.Load(); settings.Hash = caseDetails["hash_function"]; settings.Save(); Logger.Log(new OsirtActionsLog(Enums.Actions.CaseLoaded, "[No Hash - Case Created]", Constants.CaseContainerName)); }