private void ConnectToDatabase() { Log("Connecting To Damocles 2"); // Connect to Database //TODO: Change login settings so that it uses the actual user's account details and not a generic one if (dbHelper == null) { Log("Creating New Database Helper"); dbHelper = new DBHelper(); } if (dbHelper.DBConnected) { Log("Connected to Damocles", LogType.Success); dbStatusIcon.Image = Properties.Resources.accept_database_16; lblPendingReports.Text = DBHelper.GetPendingReportCount(); } else { dbStatusIcon.Image = Properties.Resources.delete_database_16; Log("Failed to connect to Damocles!", LogType.Error); } Log("Database Connection Completed"); }
private void btnLinkSubmit_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(tbTrueDestinationLinkUrl.Text)) { HashingHelper hh = new HashingHelper(); CurrentInternalReport.TrueLinkUrl = tbTrueDestinationLinkUrl.Text; CurrentInternalReport.TrueLinkUrlHash = hh.GetSHA512(tbTrueDestinationLinkUrl.Text); hh = null; } btnLinkSubmit.Visible = false; DBHelper dbHelper = new DBHelper(); switch ((string)btnLinkSubmit.Tag) { case "X": dbHelper.SetLinkToGoneButNotForgotten(CurrentInternalReport.LinkUrl); break; case "A": dbHelper.SetLinkToAllowed(CurrentInternalReport.LinkUrl); break; case "R": dbHelper.SetLinkToRestricted(CurrentInternalReport.LinkUrl); break; case "C": dbHelper.SetLinkToCriminal(CurrentInternalReport.LinkUrl); break; default: break; } //TODO: Make Disposable? dbHelper = null; }
private void btnSrcSubmit_Click(object sender, EventArgs e) { CurrentInternalReport.SrcSaved = true; btnSrcSubmit.Visible = false; DBHelper dbHelper = new DBHelper(); switch ((string)btnSrcSubmit.Tag) { case "X": dbHelper.SetSrcToGoneButNotForgotten(CurrentInternalReport.SrcUrl); break; case "A": dbHelper.SetSrcToAllowed(CurrentInternalReport.SrcUrl); break; case "R": dbHelper.SetSrcToRestricted(CurrentInternalReport.SrcUrl); break; case "C": dbHelper.SetSrcToCriminal(CurrentInternalReport.SrcUrl); break; default: break; } // Save the Hashes HashingHelper hh = new HashingHelper(); string fMd5 = hh.GetFileMD5(CurrentInternalReport.ImagePath); dbHelper.SaveMD5Hash(fMd5); string fSha1 = hh.GetFileSha1(CurrentInternalReport.ImagePath); dbHelper.SaveSha1Hash(fSha1); string fSha256 = hh.GetFileSha256(CurrentInternalReport.ImagePath); dbHelper.SaveSha256Hash(fSha256); string fSha512 = hh.GetFileSha512(CurrentInternalReport.ImagePath); dbHelper.SaveSha512Hash(fSha512); // Now we need to save the Metadata! btnSrcSubmit.Tag = null; //TODO: Make Disposable? dbHelper = null; }