private void button2_Click(object sender, EventArgs e) { ConfirmationForm Confirmation = new ConfirmationForm(); Confirmation.ShowDialog(); }
protected override void Process(DPFP.Sample Sample) { //base.Process(Sample); // Process the sample and create a feature set for the enrollment purpose. DPFP.FeatureSet features = ExtractFeatures(Sample, DPFP.Processing.DataPurpose.Verification); // Check quality of the sample and start verification if it's good // TODO: move to a separate task if (features != null) { // Compare the feature set with our template DPFP.Verification.Verification.Result result = new DPFP.Verification.Verification.Result(); //Indexes , //string connstring = "Host=192.168.100.20;Username=postgres;Password=postgres;Database=Serenity"; string connstring = "Host=localhost;Username=sgeede_fingerprint;Password=;Database=SERENITY_PRODUCTION"; // Making connection with Npgsql provider NpgsqlConnection conn = new NpgsqlConnection(connstring); conn.Open(); string sql = "select id,name_related,fingerprint from hr_employee where is_referral = True and fingerprint is not null;"; // data adapter making request from our connection NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn); string spa_order = ""; using (var cmd = new NpgsqlCommand()) { cmd.Connection = conn; cmd.CommandText = "select id from paid_off_commission_referral_wizard order by id desc limit 1;"; var reader = cmd.ExecuteReader(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { spa_order = reader[i].ToString(); } } } ds.Reset(); // filling DataSet with result from NpgsqlDataAdapter da.Fill(ds); // since it C# DataSet can handle multiple tables, we will select first dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { byte[] _img = (byte[])dr["fingerprint"]; MemoryStream ms = new MemoryStream(_img); DPFP.Template Template = new DPFP.Template(); Template.DeSerialize(ms); DPFP.Verification.Verification Verificator = new DPFP.Verification.Verification(); base.Process(Sample); DPFP.FeatureSet features2 = ExtractFeatures(Sample, DPFP.Processing.DataPurpose.Verification); if (features2 != null) { DPFP.Verification.Verification.Result result2 = new DPFP.Verification.Verification.Result(); Verificator.Verify(features2, Template, ref result2); UpdateStatus(result2.FARAchieved); if (result2.Verified) { MakeReport("The fingerprint was VERIFIED."); MakeReport(dr["name_related"].ToString()); //MessageBox.Show(spa_order); //MessageBox.Show(dr["name_related"].ToString()); using (var cmd = new NpgsqlCommand()) { cmd.Connection = conn; cmd.CommandText = "update paid_off_commission_referral_wizard set referral_id = (@p) where id = (@q);"; cmd.Parameters.AddWithValue("p", dr["id"]); cmd.Parameters.AddWithValue("q", spa_order); //cmd.Parameters.AddWithValue("p", "Hello world"); cmd.ExecuteNonQuery(); } string message = "Referral is set to "; message += dr["name_related"].ToString(); //MessageBox.Show(message); //confirmation referral = dr["name_related"].ToString(); MakeName(referral); ConfirmationForm Confirmation = new ConfirmationForm(); //Confirmation.Text += message; Confirmation.TopMost = true; Confirmation.ShowDialog(); } else { //MakeReport("The fingerprint was NOT VERIFIED."); } } } } }