public static string GetFormattedPage(string table, string exportPath, string containerName, string gscp, bool isHtmlReport)
{
DatabaseHandler db = new DatabaseHandler();
string columns = DatabaseTableHelper.GetTableColumns(table);
string page = DatatableToHtml.ConvertToHtml(db.GetRowsFromColumns(table: table, columns: columns), exportPath, containerName);
return(ReplaceReportDetails(page, gscp, isHtmlReport));
}
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));
}
private static DataTable GetMergedDataTable()
{
DatabaseHandler db = new DatabaseHandler();
DataTable merged = new DataTable();
foreach (string table in DatabaseTableHelper.GetTables())
{
string columns = DatabaseTableHelper.GetTableColumns(table);
DataTable dt = db.GetRowsFromColumns(table: table, columns: columns);
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);
}
private DataTable GetMergedDataTable()
{
DatabaseHandler db = new DatabaseHandler();
DataTable merged = new DataTable();
foreach (string table in GetSelectedTables())
{
string columns = DatabaseTableHelper.GetTableColumns(table);
DataTable dt = db.GetRowsFromColumns(table: table, columns: columns);
merged.Merge(dt, true, MissingSchemaAction.Add);
}
//added
if (uiMergeCaseNotesCheckBox.Checked)
{
DataTable dt = new DatabaseHandler().GetRowsFromColumns("case_notes", "", "date", "time", "note");
merged.Merge(dt, true, MissingSchemaAction.Add);
}
//end add
merged.TableName = "artefact"; //was "merged" but changed to artefacts for neater xml output
DataView view = new DataView(merged);
if (uiDateSelectionCheckBox.Checked)
{
string firstDate = uiFirstDateTimePicker.Value.ToString("yyyy-MM-dd");
string endDate = uiSecondDateTimePicker.Value.ToString("yyyy-MM-dd");
Debug.WriteLine("First date: " + firstDate + " second: " + endDate);
view.RowFilter = $"date >= '{firstDate}' and date <= '{endDate}'";
}
view.Sort = "date asc, time asc";
DataTable sortedTable = view.ToTable();
return(sortedTable);
}
