private void viewEditButton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count < 1)
return;
string certNumber = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
Form stressRelieveForm;
if (!canWrite)
stressRelieveForm = new StressRelieveCert(certNumber, false, userName);
else if (isAdmin)
stressRelieveForm = new StressRelieveCert(certNumber, true, userName);
else
{
// check if owner of cert
using (OdbcConnection conn = new OdbcConnection(connectionString))
{
conn.Open();
string query = "SELECT owner\n" +
"FROM ATIDelivery.dbo.StressRelieveCertificationLog\n" +
"WHERE CertNumber = '" + certNumber.Trim() + "';";
OdbcCommand com = new OdbcCommand(query, conn);
OdbcDataReader reader = com.ExecuteReader();
reader.Read();
bool isOwner = reader.IsDBNull(0) ? false : reader.GetString(0).Equals(userName);
stressRelieveForm = new StressRelieveCert(certNumber, isOwner, userName);
}
}
stressRelieveForm.ShowDialog();
}
private void newButton_Click(object sender, EventArgs e)
{
Form stressRelieveForm = new StressRelieveCert(canWrite, userName);
stressRelieveForm.ShowDialog();
}
