public void insertEntry(string fName, string lName, string permissionsLevel, string id, Bitmap imageBmp, NLTemplate template, string vidLoc)
{
OleDbConnection myDbConnection = new OleDbConnection(connectionString);
using (myDbConnection)
{
cryptography encrypt = new cryptography();
string crypFName = encrypt.encryptString(fName);
string cryptLName = encrypt.encryptString(lName);
string cryptAccessLevel = encrypt.encryptString(permissionsLevel);
string cryptUserId = encrypt.encryptString(id);
string cryptVidLoc = encrypt.encryptString(vidLoc);
byte[] cryptImage = encrypt.encryptImage(imageBmp);
byte[] cryptTemplate = encrypt.encryptTemplate(template);
OleDbCommand command = new OleDbCommand();
command.CommandType = CommandType.Text;
command.Connection = myDbConnection;
command.CommandText = "INSERT INTO myTable (firstName, lastName, userId, permission, picture, template, videoLink) Values (@p1,@p2,@p3,@p4,@p5,@p6, @p7)";
command.Parameters.AddWithValue("@P1", crypFName);
command.Parameters.AddWithValue("@p2", cryptLName);
command.Parameters.AddWithValue("@p3", cryptUserId);
command.Parameters.AddWithValue("@p4", cryptAccessLevel);
command.Parameters.AddWithValue("@p5", cryptImage);
command.Parameters.AddWithValue("@p6", cryptTemplate);
command.Parameters.AddWithValue("p7", cryptVidLoc);
try
{
myDbConnection.Open();
command.ExecuteNonQuery();
}
catch (OleDbException ex)
{
DisplayOleDbErrorCollection(ex);
MessageBox.Show("No records were recorded");
}
finally
{
myDbConnection.Close();
}
}
}