private void tsmAddDocumentEntry_Click(object sender, EventArgs e)
{
ExtDocuments addDocForm = new ExtDocuments();
if (addDocForm.ShowDialog() == DialogResult.OK)
{
SettingsPoke("DocEntry" + Guid.NewGuid(), Convert.ToBase64String(Encoding.UTF8.GetBytes(addDocForm.DocumentName)) + "|" + Convert.ToBase64String(Encoding.UTF8.GetBytes(addDocForm.DocumentPath)));
ReloadDocuments();
}
}
private void EditDocument(string pDocID)
{
confConnection.Open();
confCmd.CommandText = $"SELECT * FROM Settings WHERE Key = '{pDocID}'";
string docName = "";
string docPath = "";
using (SQLiteDataReader reader = confCmd.ExecuteReader())
{
while (reader.Read())
{
string[] docInfo = Convert.ToString(reader["Value"]).Split('|');
docName = Encoding.UTF8.GetString(Convert.FromBase64String(docInfo[0]));
docPath = Encoding.UTF8.GetString(Convert.FromBase64String(docInfo[1]));
}
}
confConnection.Close();
ExtDocuments editDoc = new ExtDocuments();
editDoc.DocumentName = docName;
editDoc.DocumentPath = docPath;
if (editDoc.ShowDialog() == DialogResult.OK)
{
confConnection.Open();
confCmd.CommandText = $"UPDATE Settings SET Value = '{Convert.ToBase64String(Encoding.UTF8.GetBytes(editDoc.DocumentName)) + "|" + Convert.ToBase64String(Encoding.UTF8.GetBytes(editDoc.DocumentPath))}' WHERE Key = '{pDocID}'";
confCmd.ExecuteNonQuery();
confConnection.Close();
}
ReloadDocuments();
}