Document Type : Primary Research paper
Assistant Professor, Bannari Amman Institute of Technology, Erode, Tamil nadu, India
Professor, Saveetha Engineering College, Erode, Tamil nadu, India
The healthcare sector is one of the most challenging and fastest growing sectors in
research issues. One of these is medical care. The hospital management needs to control the
process of report generation and distribution of reports to the user (patient or doctor). The
process is done manually. We propose a project that develops an automated medical reporting
service for health care environment. This is achieved by creating two window services.
Initially the window service1 checks the status field of all rows in the transaction table and
selects the rows for which the reports should be generated where the status field is “OPEN”.
For each row selected, it browses through the master tables and gets the appropriate stored
procedure and parameters to execute them and get the data which are required to generate
the report. These data are stored in the data sets and they are connected to the RDLC file
where the design of report is specified. A folder is been created named with the user-id in a
specified location and the generated medical report is saved into the created folder as a PDF
file. The window service then updates the states of the field as “WIP” (Work in process). The
Window service2 also checks the status field and selects the rows for which email should be
sent, where the status field is “WIP”. It fetches the appropriate PDF file which is saved by
window service1 and sends it as e-mail to the user, where the E-Mail ID of the user is retrieved
from database. Finally, when the email is sent it updates the status as “CLS” that
represents close. Each and every action performed by both the Window Services is recorded
in the Event Log. It is very useful see the happenings in the window services and also, we can
save it as a file if needed.