private void cboEmails_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt;
dt = dbi.queryToDataTable($"SELECT * FROM Abonnenter Where [E-Mail] = '{cboEmails.Text}'");
txtName.Text = dt.Rows[0][0].ToString();
txtMail.Text = dt.Rows[0][1].ToString();
txtNumber.Text = dt.Rows[0][2].ToString();
}
private void btnXportPdf_Click(object sender, EventArgs e)
{
DataTable dt = db.queryToDataTable("SELECT Alarmtype, Tidsrom, [Verdi\\temperatur] FROM Alarmer WHERE[aktiv\\ikke aktiv] = 1 Order by Tidsrom desc");
pdfHandler handler = new pdfHandler(dt);
handler.CreateDocument(cbOpenFile.Checked);
if (cbSendEmail.Checked)
{
mail.SendMailAttatchment(cboEmails.Text, "Rapport", "Vedlagt ligger rapport med aktive alarmer", handler.filename);
}
}
