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