Exemple #1
0
        void timer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
        {
            if (!ocr.IsInTimeRange)
            {
                return;
            }

            try
            {
                (sender as Timer).Enabled = false;

                using (SqlConnection conn = new SqlConnection(Settings.Default.Database))
                {
                    using (SqlCommand cmd = new SqlCommand(Settings.Default.GetScanProcedureName, conn))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        if (conn.State != ConnectionState.Open)
                        {
                            conn.Open();
                        }
                        using (IDataReader dr = cmd.ExecuteReader())
                        {
                            if (!dr.Read())
                            {
                                return;
                            }

                            string filename, originalFilename;
                            Guid   guid;
                            guid             = (Guid)dr["guid"];
                            filename         = dr["fsguid"].ToString();
                            originalFilename = dr["oryginalnanazwa"].ToString();

                            filename = Path.Combine(Settings.Default.DocumentsDirectory, filename);

                            List <PageInfo> pages = ocr.DoOCR(filename);

                            saveOCRResults(pages, guid);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Trace.WriteLine(ex.Message);
            }
            finally
            {
                (sender as Timer).Enabled = true;
            }
        }
Exemple #2
0
        void timer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
        {
            if (!ocr.IsInTimeRange)
            {
                return;
            }

            try
            {
                (sender as Timer).Enabled = false;

                using (SqlConnection conn = new SqlConnection(Settings.Default.Database))
                {
                    using (SqlCommand cmd = new SqlCommand(Settings.Default.GetScanProcedureName, conn))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        if (conn.State != ConnectionState.Open)
                        {
                            conn.Open();
                        }
                        using (IDataReader dr = cmd.ExecuteReader())
                        {
                            if (!dr.Read())
                            {
                                return;
                            }

                            byte[] scanContent = null;

                            Guid guid;
                            guid        = (Guid)dr["ScanID"];
                            scanContent = (byte[])dr["ScanContent"];

                            List <PageInfo> pages = ocr.DoOCR(scanContent);

                            saveOCRResults(pages, guid);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Trace.WriteLine(ex.Message);
            }
            finally
            {
                (sender as Timer).Enabled = true;
            }
        }