application case study: clinical drug research process web application on .net mvc
DESCRIPTION
http://www.alliancetek.com/ : We implemented Windows Authentication for users in local intranet network to validate user into the system along with their necessary details.TRANSCRIPT
St. Luke’s Health Network
Client Background
Challenges
Solutions
Implementation
St. Luke's University Health Network is a health care provider with a regional network of hospitals, physicians, and related organizations primarily in Pennsylvania and New Jersey. The network consists of over 80 owned physician-practice sites and more than 125 employed primary care/specialist physician sites. St. Luke's handles over 55,000 annual admissions and nearly 200,000 annual emergency room visits.
In order to leverage technology to further medical research, St. Luke's wanted to implement a web application to support the Clinical Drug Research Process. The application would assist with medication management, allowing users to digitally check-out and check-in medications in the workflow.
St. Luke's University Health Network sought the assistance of AllianceTek, a leading IT solutions and software development company with experience in developing custom applications for medical organizations. AllianceTek studied the requirements and designed a solution that would best fit St. Luke's. AllianceTek implemented Windows Authentication so users could use their Windows login credentials on their local intranet network. By using Windows Authentication, users could be validated into the system along with their necessary details (first name, last name, email, phone, role, etc.) to be stored and retrieved from the application data storage.
The application is built on .NET MVC architecture with SQL Server and uses Windows Authentication so users can log into the system along with their necessary details. During the implementation, there was a difficulty with a database concurrency conflict, which occurred when two or more users were trying to edit the same record at the same time. This was overcome by implementing the functionality 'RowVersion'. 'RowVersion' is used to maintain the integrity of the database when multiple users are updating the row at the same time by creating optimistic concurrency control. In order to promote efficient workflow, an email system was created at every step of the check-in/check-out process to alert the next user in line about the update. When the status changes the next user immediately receives an update via email, before logging into the system. The application also implemented an administration section where users could be added and deleted, as well as a role system of privileges that helped utilize the resources to be accessible to relevant persons.
112 Moores Road, Suite 200, Malvern, PA 19355
484-892-5713 [email protected]
AllianceTek, Inc
www.alliancetek.com
St. Luke’s Health Network
Result
As a result of working with AllianceTek to develop the intranet application, St. Luke's University Health Network was able to more efficiently conduct medical research. The email flow at the completion of each check-in/check-out process helps system users get updates quickly with better synchronization without even accessing the system, thereby filling communication gaps.
112 Moores Road, Suite 200, Malvern, PA 19355
484-892-5713 [email protected]
AllianceTek, Inc
www.alliancetek.com