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