public void InsertPDF(DocumentClass thePDF)
{
NpgsqlCMD = new NpgsqlCommand();
NpgsqlCMD.CommandText = @"INSERT INTO EXPERIMENT_DOCUMENT
(EXPERIMENT_DOCUMENT_ID, EXPERIMENT_ID, EXPERIMENT_DOCUMENT_TITLE, EXPERIMENT_DOCUMENT_DESCRIPTION,
EXPERIMENT_DOCUMENT_TYPE, EXPERIMENT_DOCUMENT)
VALUES(nextval('EXPERIMENT_DOCUMENT_ID_SEQ'), :EX_ID, :TITLE, :DESC, :DOCTYPE, :PDF)";
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("TITLE", NpgsqlDbType.Varchar));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("DESC", NpgsqlDbType.Varchar));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("EX_ID", NpgsqlDbType.Integer));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("DOCTYPE", NpgsqlDbType.Varchar));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("PDF", NpgsqlDbType.Bytea));
NpgsqlCMD.Parameters[0].Value = thePDF.DOCUMENT_TITLE;
NpgsqlCMD.Parameters[1].Value = thePDF.DOCUMENT_DESCRIPTION;
NpgsqlCMD.Parameters[2].Value = thePDF.EXPERIMENT_ID;
NpgsqlCMD.Parameters[3].Value = thePDF.DOCUMENT_TYPE;
NpgsqlCMD.Parameters[4].Value = thePDF.DOCUMENT;
if (GlobalVariables.GlobalConnection.insertData(NpgsqlCMD))
MessageBox.Show("Picture successfully inserted.", "Picture Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
MessageBox.Show("Error inserting picture.", "Insert Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
public void DeletePDF(DocumentClass thePDF)
{
NpgsqlCMD = new NpgsqlCommand();
NpgsqlCMD.CommandText = @"DELETE FROM EXPERIMENT_DOCUMENT
WHERE EXPERIMENT_DOCUMENT_ID = :DOCID";
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("DOCID", NpgsqlDbType.Integer));
NpgsqlCMD.Parameters[0].Value = thePDF.DOCUMENT_ID;
GlobalVariables.GlobalConnection.deleteData(NpgsqlCMD);
}
public frmAddDocument(bool bAllowMulti, DocumentClass docEdit)
{
InitializeComponent();
thePDF = docEdit;
openFileDialog1.Multiselect = bAllowMulti;
cmbDocType.SelectedText = thePDF.DOCUMENT_TYPE;
rtbDescription.Text = thePDF.DOCUMENT_DESCRIPTION;
rtbTitle.Text = thePDF.DOCUMENT_TITLE;
rtbTitle.Enabled = true;
btnBrowse.Enabled = true;
bIsEdit = true;
}
public void UpdatePDF(DocumentClass thePDF)
{
NpgsqlCMD = new NpgsqlCommand();
NpgsqlCMD.CommandText = @"UPDATE EXPERIMENT_DOCUMENT
SET EXPERIMENT_DOCUMENT_TITLE = :TITLE,
EXPERIMENT_DOCUMENT_DESCRIPTION = :DESC,
EXPERIMENT_DOCUMENT_TYPE = :DOCTYPE
WHERE EXPERIMENT_DOCUMENT_ID = :DOCID";
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("TITLE", NpgsqlDbType.Varchar));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("DESC", NpgsqlDbType.Varchar));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("DOCID", NpgsqlDbType.Integer));
NpgsqlCMD.Parameters.Add(new NpgsqlParameter("DOCTYPE", NpgsqlDbType.Varchar));
NpgsqlCMD.Parameters[0].Value = thePDF.DOCUMENT_TITLE;
NpgsqlCMD.Parameters[1].Value = thePDF.DOCUMENT_DESCRIPTION;
NpgsqlCMD.Parameters[2].Value = thePDF.DOCUMENT_ID;
NpgsqlCMD.Parameters[3].Value = thePDF.DOCUMENT_TYPE;
if (GlobalVariables.GlobalConnection.updateData(NpgsqlCMD))
MessageBox.Show("Picture successfully inserted.", "Picture Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
MessageBox.Show("Error inserting picture.", "Insert Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}