Development of Hospital Management System

Development of infirmary Management transcription conception infirmary Management is a sack based exercise to cut the activities relate to doctor and long-suffering of. Hospital Management is based on distri wholeed architecture. This involves the web function which receives invite from the web based application and service processes the request and sends the response back to the application. Web function answers the infobase operations standardized insert, rub out and modify the information about the patients, doctors etc. This kind of distributed architecture is called as wait on Oriented Architecture (SOA). This application contains login form, patient registration, doctor registration. Hospital Management application allow patients to edit their information like patient name, contact number, address, disease from which he is suffering from etc.The concept of hospital worry is rattling big. The scope of hospital management involves protestent staffs like logi n module, patient info, doctor info, billing module, registration module and administration module. Login module go out include the operation related to login, forgot tidings, password change, sending confirmations or alerts etc. Patient info module entrust include the detail about the patient like patient history about his discourse and doctors heterogeneous in the treatment, details of medicines suggested by doctors. Billing Module leave al superstar include the details of fees, elbow room of payment apply by the patient to pay the fees. Registration module will allow the substance abusers to register their profiles. arrangement module allows performing operations like creating the new users, performing password change operations, loading the information of doctors for the first duration. Hospital Management uses sql waiter 2005 as the backend. The infobase is of importtained on the remote server, this infobase holds all the information related to the hospital.Abstr actBefore SOA architecture, DCOM or (ORBs) physical endeavor request brokers based on CORBA detailations were utilise to break up the distributed applications. DCOM is known was distributed comp unmatchednt goal molding. DCOM is an extension of COM (component object modal valuel), DCOM was released in 1996. It flora primarily with Microsoft windows. It will work with Java Applets and ActiveX components through its use of COM.Service Oriented Architecture is nothing but battle array of serve. These services atomic number 18 deployed at divergent servers at different locations. These services communicate with each otherwise to perform necessitate operations. The communication bottom of the inning be simple information passing.Service Provider The endurer will create the service apply every technology like .net or java and publishes its information for deviling the outside world. The willr decides which service to be make and one service shag provide ternary o perations, how to price the services or without charge like free services. Provider to a fault decides the course of the services. The most everyday broker service is UDDI (Universal Description Discovery and Integration) provides a way publish and discover the information about the services.Service Requester The requester identifies the services using UDDI or whatsoever other service broker. The services provide the undeniable operations then the requester should take it to the service provider for contract. therefore requester clear bind the services to the application and execute to get the required information.The principles used for emergence, brinytenance and usage of SOA arReuse, comparability, granularity and interoperability.Identifying the services and categorizing them. supervise and tracking.The specific architectural principles of SOA design atomic number 18Service loose colligationService encapsulationService contractService abstractionService reusabilitySer vice discoverabilityPROJECT SCOPE AND OBJECTIVESCOPEDevelopment of a computerized Hospital management agreement with the provision of flexible, accurate and true(p)d entryway to entropy and then bringing in the highly useful end product for the users as well as for the management.OBJECTIVETo develop a dodge that maintains a sophisticated Hospital management details bringing out the flexibility and the ease with which the users depose use it.To track and improve internal instruction death penalisation of the financial corporation thereby allowing the flexible and secured transactions to happen.FEATURES OF THE CURRENT organisationIn the exist administration the information required for the Hospital management is maintained in records. These argon to be modifyd according to the requirements of the customer. It takes time to pursuit for the required info. alone the details regarding the hospitals and its timings are hard to maintain.The work will be more so the tru nks take away more number of faction to follow out the requirements. on that point may be a chance of stroke since it is manual. A simple fault of the system may lead to unhinge and in addition cause a vast destruction. So these faults make the system slight effective and executing of the system is very slow. Hence, there should be a system to overcome all these defects and provide the users with more facilities.CHARACTERISTICS OF THE mean SYSTEMIn the proposed system everything is computerized. The system provides all the details regarding the hospitals, its details, and soon. The users send packing search the required data advantageously at heart no time. A very less number of people are required to wish the system.The patients need not wait for long time to fulfill his requirement. There is no chance of any failure in the system, which improves the performance of the system and also increases the efficiency of the system. Though this system is very beneficial a mino r failure in the server or else the computer leads to a major loss of data.PROJECT OVERVIEWThe project performs the followers functionsIn 1997, a team of Medical professionals has set up the first hospital, it signaled the dawn of a new era in medical allot. At the heart of this performance was a burning desire to practice medicine with Compassion, Concern and Care, with a single-minded objective the recovery of the patient. Today, with Multi-Specialty HOSPITAL across the state, and a account for humanitarian and selfless service of the highest order, Hospital enjoys an unbelievable amount of goodwill. A million smiles will bear testimony to that.At hospital, we operate on a physician driven model. This means that all the main constituents of the bid movement the promoters, administrators and service providers are physicians. At the centre of the compassionate model is the patient and the over-riding motive of all of Cares activities is to provide quality medical care at an affordable cost. Technology, Training and Teamwork form the very core of the CARE model. We emphasize on a comprehensive and continuous education and fostering of every individual involved in patient care. Every labor will be taken to ensure that our g courseth is one indomitable by the patients needs, and not one decided by our corporate requirements.Our hospital believes atA patient is the most important person in our hospital.He is not an interruption to our work he is the purpose of it.He is not an outsider in our hospital. He is a part of it.We are not doing him a favour by serving him.He is doing us a favour by giving us an opportunity to do so.NEED FOR COMPUTERIZATIONThe use of computerized hospital is to provide effective facilities to the people, which are suffering from any problems. The advantages areLess costNo mediators fine servicesThe main goal of this hospital management system is to deliver the goods the people satisfaction. Hospital management system provides effective facilities to the people from any place in the world.SYSTEM REQUIREMENTSSoftware Requirement SpecificationsOperating outlines Windows 2000 Prof selective informationbase server Sql Srver 2005 Programming Language C surdware Requirement Specifications coat horde material bodyComputer Processor Pentium IV Clock travel rapidly 700MHZ Processor Hard Disk 40GB RAM 256/512 MB Modem 56KBPSselective informationbase Server ConfigurationComputer Processor Pentium IV Clock Speed 700MHZ Processor Hard Disk 40GB RAM 256/512 MBSYSTEM ANALYSISExisting SystemIn the current system the data required is maintained in records. They are to be updated according to the requirements of the users. It takes time to search for the required query. All the details regarding the hospital and its patients are hard to maintain. The work will be more, so the system needs more number of crew to fulfill the requirements. There may be a chance of failure since it is manual. A one fault of the system may lead to inconvenience and also causes a vast destruction. So these faults make the system less good and performance of the system is very slow. Hence, there should be a system to overcome all these defaults and provide the users with more facilities.In the current system if the user was suffering from any pain or etc heshe has no predilection how to control the pain and suffering. Just they will be no thought for them and they become sicker and died more sooner And to know the availability for the treatment they discombobulate to go to hospital but mostly the government hospital doesnt plant more facilities to the patient as the patients want from the doctors. But in the berth of the private hospital the patients has to pay more fares for the treatment and they do more delays in the case of the treatment they will be more formality to be fulfil by the patients which take lot of time waste.Proposed SystemIn the proposed system everything is computerized. The system provides all the details regarding the Hospital, doctors, patients, bed numbers, and fares also and so on. The user cornerstone search required data easily with no time. A very less number of staff is required to handle the system.The patients need not wait for a long time to fulfil his requirement. There is no chance of any failure in the system, which improves the performance of the system and also increases the efficiency of the system.Though this system is very beneficial a minor failures in the server or else the computer leads a major loss of data.FEASIBILITY STUDYIn previous investigation we got the result that the computerized Hospital management system is feasible. This includes following aspects.technical foul FeasibilityTechnical feasibleness is nothing but implementing the project with existing technology. Computerized Hospital management System is feasible.Economical FeasibilityEconomic feasibility means the cost of under taking project should be less than existing s ystem Hospital management system is economically feasible, because it reduces the expenditures in the manual system.TECHNOLOGY OVERVIEW.NET exemplarThe .NET mannequin is a new work out platform that simplifies application development in the highly distributed environment of the meshwork. The .NET modelling is designed to fulfill the following objectivesTo provide a consistent object-oriented schedule environment whether object rule is stored and executed locally, executed locally but Internet-distributed, or executed remotely.To provide a enter-execution environment that minimizes computer software deployment and straining conflicts.To provide a code-execution environment that guarantees safe execution of code, including code created by an mysterious or semi-trusted third party.To provide a code-execution environment that eliminates the performance problems of script or interpreted environments.To make the developer experience consistent across astray alter roles of applications, much(prenominal) as Windows-based applications and Web-based applications.To build all communication on industry standards to ensure that code based on the .NET mannikin tolerate integrate with any other code..NET FRAMEWORK HAS TWO MAIN COMPONENTSThe commonality Language Runtime and the .NET material categorise Library The common talking to runtime is the asylum of the .NET example. You can think of the runtime as an agent that manages code at execution time, providing core services such(prenominal) as reminiscence management, thread management, and remoting, temporary hookup also enforcing strict typewrite safety and other forms of code the true that ensure security and robustness. In fact, the concept of code management is a fundamental principle of the runtime. Code that butts the runtime is known as managed code, while code that does not target the runtime is known as unmanaged code. The class library, the other main component of the .NET manakin, is a comprehensive, object-oriented show of useful types that you can use to develop applications ranging from traditional bid-line or graphical user interface (GUI) applications to applications based on the latest innovations provided by ASP.NET, such as Web Forms and XML Web services.The .NET Framework can be hosted by unmanaged components that load the common oral communication runtime into their processes and in good-tempered the execution of managed code, thereby creating a software environment that can consummation both(prenominal) managed and unmanaged features. The .NET Framework not only provides several runtime hosts, but also supports the development of third-party runtime hosts.For example, ASP.NET hosts the runtime to provide a ascendable, server-side environment for managed code. ASP.NET works directly with the runtime to change Web Forms applications and XML Web services, both of which are discussed later in this topic.Internet Explorer is an example of an un managed application that hosts the runtime (in the form of a MIME type extension). Using Internet Explorer to host the runtime enables you to embed managed components or Windows Forms controls in HTML documents. Hosting the runtime in this way makes managed mobile code (similar to Microsoft ActiveX controls) possible, but with pregnant improvements that only managed code can offer, such as semi-trusted execution and secure isolated file storage.The following illustration shows the relationship of the common delivery runtime and the class library to your applications and to the overall system. The illustration also shows how managed code operates within a larger architecture..NET COMPONENTS AND FEATURES.NET ArchitectureFeatures of the Common Language RuntimeThe common language runtime manages memory, thread execution, code execution, code safety verification, compilation, and other system services. These features are intrinsic to the managed code that runs on the common language ru ntime.With regards to security, managed components are awarded varying degrees of trust, depending on a number of factors that include their origin (such as the Internet, endeavor ne cardinalrk, or local computer). This means that a managed component might or might not be able to perform file-access operations, registry-access operations, or other sensitive functions, even if it is being used in the alike lively application.The runtime enforces code access security. For example, users can trust that an executable embedded in a Web page can play an animation on screen or sing a song, but cannot access their individualised data, file system, or network. The security features of the runtime thus enable legitimate Internet-deployed software to be exceptionally featuring rich.The runtime also enforces code robustness by implementing a strict type- and code-verification infrastructure called the common type system (CTS). The CTS ensures that all managed code is self-describing. The va rious Microsoft and third-party language compilers generate managed code that conforms to the CTS. This means that managed code can consume other managed types and instances, while strictly enforcing type fidelity and type safety.In addition, the managed environment of the runtime eliminates many common software issues. For example, the runtime automatically handles object layout and manages references to objects, rel easement them when they are no longer being used. This automatic memory management resolves the two most common application errors, memory leaks and handicap memory references.The runtime also accelerates developer productivity. For example, programmers can write applications in their development language of choice, yet take full advantage of the runtime, the class library, and components written in other languages by other developers. Any compiler vendor who chooses to target the runtime can do so. Language compilers that target the .NET Framework make the features o f the .NET Framework available to existing code written in that language, greatly easing the migration process for existing applications.While the runtime is designed for the software of the future, it also supports software of today and yesterday. Interoperability amongst managed and unmanaged code enables developers to continue to use necessary COM components and DLLs.The runtime is designed to enhance performance. Although the common language runtime provides many standard runtime services, managed code is never interpreted. A feature called just-in-time (JIT) compiling enables all managed code to run in the native machine language of the system on which it is executing. Meanwhile, the memory jitney removes the possibilities of fragmented memory and increases memory locality-of-reference to further increase performance.Finally, the runtime can be hosted by high-performance, server-side applications, such as Microsoft SQL Server and Internet Information serve (IIS). This infras tructure enables you to use managed code to write your business logic, while still enjoying the superior performance of the industrys best enterprise servers that support runtime hosting..NET Framework Class LibraryThe .NET Framework class library is a collection of reusable types that tightly integrate with the common language runtime. The class library is object oriented, providing types from which your own managed code can derive functionality. This not only makes the .NET Framework types easy to use, but also reduces the time associated with learning new features of the .NET Framework. In addition, third-party components can integrate seamlessly with classes in the .NET Framework.For example, the .NET Framework collection classes implement a set of interfaces that you can use to develop your own collection classes. Your collection classes will blend seamlessly with the classes in the .NET Framework.As you would expect from an object-oriented class library, the .NET Framework typ es enable you to accomplish a range of common programming tasks, including tasks such as draw and quarter management, data collection, database bondivity, and file access. In addition to these common tasks, the class library includes types that support a variety specialized development scenarios.ADO.NETADO.NET IN CONNECTED MODEADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources bring ond via OLE DB and XML. data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data.ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately or in tandem. ADO.NET includes .NET data providers for connecting to a database, executing commands, and retrieving results. Those results are either processed directly, or placed in an ADO.NET selective informationset object in order to be exposed to the user in an ad-hoc manner, combined with data from multiple sources, or remotes between tiers. The ADO.NET entropyset object can also be used independently of a .NET data provider to manage data local to the application or sourced from XML.The ADO.NET classes are found in System. entropy.dll, and are integrated with the XML classes found in System.Xml.dll. When compiling code that uses the System.Data namespace, reference both System.Data.dll and System.Xml.dll.ADO.NET provides functionality to developers writing managed code similar to the functionality provided to native COM developers by ADO.The most important change from classic ADO is that ADO.NET doesnt reply on OLE DB providers and uses .NET managed providers instead. A .NET provider works as a bridge between your application and the data source. ADO .NET and .NET managed data providers dont use COM at all, so a .NET application can access data without undergoing any performance penalty deriving the switch between managed and unmanaged code.The most important difference between ADO and ADO.NET is that dynamic and Key set server -side cursors are no longer supported. ADO.NET supports only forward-only read-only result sets and disconnected result sets..NET Data Providers.NET data providers play the same role that OLE DB providers play under ADO, they enable your application to read and write data stored in a data source. Microsoft Currently supplies five ADO.NET providersOLE DB .NET Data ProviderThis provider lets you access a data source for which an OLE DB provider exists, although at the expense of a switch from managed to unmanaged code and the performance degradation that ensues.SQL Server .NET Data ProviderThis provider has been specifically written to access SQL Server version 7.0 or later using Tabular Data Stream (TDS) as the communication medium. TDS is SQL Servers native protocol, so you can expect this provider to arrest you better performance than the OLE DB Data Provider. Additionally, the SQL Server, .NET Data Provider exp oses SQL Server specific features, such as named transactions and support for the FOR XML clause in SELECT queries.ODBC .NET Data ProviderThis provider works as a bridge toward an ODBC source, so in theory you can use it to access any source for which an ODBC driver exists. As of this writing, this provider officially supports only the Access, SQL Server, and vaticinator ODBC drivers, so theres no clear advantage in using it instead of the OLE DB .NET Data Provider. The convenience of this provider will be more evident when more ODBC drivers are added to the list of those officially supported..NET Data Provider for OracleThis provider can access an Oracle data source version 8.1.7 or later. It automatically uses contact pooling to increase performance if possible, and supports most of the features of the Microsoft OLEDB Provider for Oracle, even though these two accessing techniques can differ in a few detailsfor example, the .NET Data Provider for Oracle doesnt support the TABLE data type and ODBC escape sequences.SQLXML LibraryThis DLL, which you can download from the Microsoft Web site, includes a few managed types that let you query and update a Microsoft SQL Server 2000 data source over HTTP. It supports XML templates, XPath queries, and can expose stored procedures and XML templates as Web services. The ODBC and Oracle providers are included in .NET Framework 1.1 but were missing in the first version of the .NET Framework. If you work with .NET Framework 1.0, you can download these providers from the Microsoft Web site. The downloadable versions of these providers differ from the versions that come with .NET Framework 1.1, chiefly in the namespaces they use Microsoft.Data.Odbc and Microsoft.Data.Oracle instead of System.Data.Odbc and System.Data.Oracle.ADO.NET Object ModelIts time to commence a closer look at the individual objects that make up the ADO.NET architecture illustrated in Figure 21-1. Youll see that objects are divided into two severali ze outs, the objects included in the .NET Data Provider, and those that belong to the ADO.NET disconnected architecture. (In practice, the second group includes only the Dataset and its secondary objects.) Dataset (Disconnected data) .NET Data Provider Connection DataAdapter see to it Data Reader ADO.NET Objects at a GlanceThe Connection object has the same function it has under ADO establishing a connection to the data source. desire its ADO counterpart, it has the Connection String property, the Open and Close systems, and the ability to stimulate a transaction using the Begin transaction method. The ADO be given method isnt supported, and the ADO.NET Connection object lacks the ability to send a command to the database.The Command object lets you query the database, send a command to it, or invoke one of its stored procedures. You can perform these actions by using one of the objects fulfilxxxx methods. More specifically, you use the ExecuteNonQuery method to send an action query to the databasefor example, an install or DELETE SQL statementan Execute Reader method to perform a SELECT query that returns a result set, or an Execute Scalar method to perform a SELECT query that returns a single value. Other properties let you set the command timeout and prepare the parameters for a call to a stored procedure. You must manually associate a Command object with the Connection object previously connected to the data source.The Data Reader object is the object returned by the Execute Reader method of the command object and represents a forward-only, read-only result set. A new row of results becomes available each time you invoke the Data Readers Read method, after(prenominal) which you can query each individual field using the pop Value method or one of the strongly typed Getxxxx methods, such as Get String or Get Float. Remember that you cant update the database by means of a Data Reader object.The Dataset object is the main object in the ADO.NET disconn ected architecture. It works as a sort of small relational database that resides on the client and is realizedly unrelated to any specific database. It consists of a collection of DataTable objects, with each DataTable object holding a distinct result set (typically the result of a query to a different database table). A DataTable object contains a collection of Data class objects, each one holding data coming from a different row in the result. A Dataset also contains a collection of Data Relation objects, in which each item corresponds to a relationship between different Data Table objects, much like the relationships you meet between the tables of a relational database. These relations let your code navigate among tables in the same DataSet using a simple and effective syntax.The DataAdapter object works as a bridge between the Connection object and the DataSet object. Its fill method moves data from the database to the client-side DataSet, whereas its Update method moves dat a in the blow direction and updates the database with the rows that your application has added, modified, or deleted from the DataSet.Connection ObjectWhether you work in connected or in disconnected mode, the first action you need to perform when working with a data source is to open a connection to it.InADO.NET terms, this means that you create a Connection object that connects to the specific database. The Connection object is similar to the ADO object of the same name, so youll feel immediately at ease with the new ADO.NET object if you have any experience with ADO programming. Setting the Connection String station the key property of the Connection class is Connection String, a gearing that defines the type of the database youre connecting to, its location, and other semicolon-delimited attributes. When you work with the OleDbConnection object, the connection string matches the connection string that you use with the ADO Connection object. Such a string typically contains th e following information,The Provider attribute, which specifies the name of the underlying OLE DB Provider, used to connect to the data. The only values that Microsoft guarantees as valid are SQLOLEDB (the OLE DB provider for Microsoft SQL Server), Microsoft.Jet.OLEDB.4.0 (the OLE DB provider for Microsoft Access), and MSDAORA (the OLE DB provider for Oracle).The Data Source attributes, which specifies where the database is. It can be the path to an Access database or the name of the machine on which the SQL Server or the Oracle database is located.The User ID and Password attributes, which specify the user name and the password of a valid account for the database.The Initial compose attributes, which specifies the name of the database when youre connecting to a SQL Server or an Oracle data source. erst youve set the Connection String property correctly, you can open the connection by invoking the Open methodADO.NET in Disconnected ModelIn the preceding chapter, you saw how to wor k with ADO.NET in connected mode, processing data coming from an active connection and sending SQL commands to one.ADO.NET in connected mode behaves much like classic ADO, even though the names of the involved properties and methods (and their syntax) are often different. Youll see how ADO.NET differs from its predecessor when you start working in disconnected mode. ADO 2.x permits you to work in disconnected mode using client-side static record sets opened in optimistic batch update mode. This was one of the great new features of ADO that proved to be a winner in client/server applications of any size. As a matter of fact, working in disconnected mode is the most scalable technique you can adopt because it takes resources on the client (instead of on the server) and, preceding(prenominal) all, it doesnt enforce any locks on database tables (except for the short-lived locks that are created during the update operation).The following Imports statements are used at the file or projec t takeImports System. Data Imports System.Data.Common Imports System.Data.OleDb Imports System.Data.SqlClient Imports System.Data.Odbc Imports System.IO Imports System.Text.RegularExpressionsThe DataSet Object Because ADO.NET (and .NET in general) is all about scalability and performance, the disconnected mode is the preferred way to code client/server applications. Instead of a simple disconnected recordset, ADO.NET gives you the DataSet object, which is much like a small relational database held in memory on the client. As such, it provides you with the ability to create multiple tables, fill them with data coming from different sources, enforce relationships between pairs of tables, and more.Data SetThe DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident delegation of data that provides a consistent relational programming model irrespective of the data source. It can be used with multiple and differing data sources, used with XML data, or used to manage data local to the application. The DataSet represents a complete set of data including related tables, constraints, and relationships among the tables.The DataAdapter object, which works as a connexion between the DataSet and the actual data source. The DataAdapter is in charge of filling one or more DataTable objects with data taken from the database so that the application can then close the connection and work in a wholly disconnected mode. After the end user has performed all his or her change chores, the application can reopen the connection and reuse the same DataAdapter object to send changes to the database. Admittedly, the disconnected nature of the DataSet complicates matters for developer