A Survey On Knowledgeable Medical Care Explosion System

The healthcare sector is one of the most challenging and fastest growing sectors inresearch issues. One of these is medical care. The hospital management needs to control theprocess of report generation and distribution of reports to the user (patient or doctor). Theprocess is done manually. We propose a project that develops an automated medical reportingservice 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 andselects 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 storedprocedure and parameters to execute them and get the data which are required to generatethe report. These data are stored in the data sets and they are connected to the RDLC filewhere the design of report is specified. A folder is been created named with the user-id in aspecified location and the generated medical report is saved into the created folder as a PDFfile. The window service then updates the states of the field as “WIP” (Work in process). TheWindow service2 also checks the status field and selects the rows for which email should besent, where the status field is “WIP”. It fetches the appropriate PDF file which is saved bywindow service1 and sends it as e-mail to the user, where the E-Mail ID of the user is retrievedfrom database. Finally, when the email is sent it updates the status as “CLS” thatrepresents close. Each and every action performed by both the Window Services is recordedin the Event Log. It is very useful see the happenings in the window services and also, we cansave it as a file if needed.