private SIMcard GetInfoFromNumber(string number) { DataAccessLayer dal = new DataAccessLayer(); dal.AddParameter("@Number", number.Substring(3), DbType.String); dal.AddParameter("@Simnumber", null, DbType.String, ParameterDirection.Output); dal.AddParameter("@MANR", null, DbType.String, ParameterDirection.Output); dal.AddParameter("@Stabsnummer", null, DbType.String, ParameterDirection.Output); dal.AddParameter("@Name", null, DbType.String, ParameterDirection.Output); dal.ExecuteScalar("SELECT @Simnumber = [Simnumber], @MANR = [MANR], @Stabsnummer = [Stabsnummer], @Name = [Name] FROM [SimcardView] WHERE [Number] = @Number"); SIMcard sim = new SIMcard(); sim.Number = number; sim.Simnumber = dal.GetParameterValue("@Simnumber").ToString(); sim.MANR = dal.GetParameterValue("@MANR").ToString(); sim.Stabsnummer = dal.GetParameterValue("@Stabsnummer").ToString(); sim.Name = dal.GetParameterValue("@Name").ToString(); dal.ClearParameters(); return(sim); }
private void btnRun_Click(object sender, EventArgs e) { dgvOutput.Rows.Clear(); if (File.Exists(txtFilePath.Text)) { try { StringBuilder text = new StringBuilder(); Regex re = new Regex(@"(\+45\d+)(.*) (\d*\.?\d+,\d+)"); using (PdfReader reader = new PdfReader(File.OpenRead(txtFilePath.Text))) { pbBottom.Maximum = reader.NumberOfPages; for (int i = 1; i <= reader.NumberOfPages; i++) { foreach (Match m in re.Matches(PdfTextExtractor.GetTextFromPage(reader, i))) { SIMcard sim = GetInfoFromNumber(m.Groups[1].Value); dgvOutput.Rows.Add(m.Groups[1], m.Groups[2], m.Groups[3], sim.Simnumber, $"{sim.Stabsnummer} {sim.Name}", sim.MANR); } pbBottom.PerformStep(); } } pbBottom.Value = 0; } catch (BadPdfFormatException) { MessageBox.Show("PDF-filen kunne ikke læses"); } } else { MessageBox.Show("Filen findes ikke"); } }