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; } }
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; } }