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.