A few years ago, I was asked to develop a Windows application for a nursing home that allows them to keep track of their residents and the medications they get. I was given some drawings that their users created and was asked to use them to throw together a simple prototype that demonstrates what could be possible. After about an hour or two, I had taken their drawings and converted them into an actual working application. Since this was only supposed to be a prototype, I never finished out all of its functionality. However, I did put enough work into it so that they could enter some basic information for their residents (name, DOB, apartment #, SSN, etc…). Along with the basic resident information, the app also allowed them to record contacts for their residents as well as any medications, diseases, allergies, or dietary information they needed for their residents. I even added the ability to store pictures of their residents and even added reporting capabilities so that whatever was viewed in the app could be printed on paper.
The very next day, I took what I had done so far and showed it to the customer who loved it. We discussed how I could put a larger database behind it and make it so that different users using the same computer or users on multiple computers could access the application. I mentioned the idea of making this a web application that could run on an internal server. But, they didn’t like that idea and preferred the thick client version just like the prototype. I even went thru an extensive whiteboard session to begin discussing what the app would eventually grow to become for the production-ready version of the app.
Shortly into the conversation, it came time to talk about the brass tax. At that point, the customer got all defensive and started acting like I should have been doing all of this work for free. In fact, he was so adamant that he crossed a boundary that I wasn’t willing to stick around for any longer. So, I grabbed my laptop, left the building, and never spoke to him again.
Today I was going thru some of my personal projects and stumbled across this one. Instead of deleting it from my computer or leaving it to waste away, I thought I would share it with anyone that might find a simple application like this useful. So, that’s just what I am going to do.
The application is written in C# and currently uses SQLite for its database. But, for anyone that knows a thing or two about programming, you could easily swap out SQLite with something larger such as SQL Server or MySQL. For reporting, I decided to use something called “MyNeoReport” which is something I used for another project shortly before this project. You can get the MyNeoReport Designer from http://www.codeproject.com/Articles/15168/A-New-NET-Reporting-Way.
When you run the app, you can choose to enter a new resident or open an existing resident from the File menu at the top. If you choose to open a current resident, you will be presented with a dialog window that allows you to search. You can enter a first name, last name, apartment #, or nothing at all. To see all residents, leave the search boxes empty and just click the Search button. When you do, you will see a list of example residents that I created when testing the app. You can either click on a resident from the list and click the OK button, or you can just double-click the resident to open their form.
As previously mentioned, this was only a prototype. So, I’m sure there are probably some bugs in there and not all functionality was completed. But, any decent C# developer could easily finish this out and make a great product out of it. If you do turn this into a commercially available product, I only ask that you come back here and tell the rest of us about it. Even if you’re not a programmer or don’t have access to a programmer, the application should still be complete enough that you can use it for capturing resident information as well as their medications, diseases, allergies, and dietary details. If you do use this, I don’t expect anything more than to know you’re using it.
Below are some screenshots to give you an idea of what the app looks like. You can find the link to download the app (including source code) below the screenshots. If you want to jump right into using the app, just unzip it and go to MedMan > bin > Debug, and run the MedMan.exe file. Make sure you have the .NET library installed before running the app.
Download: MedMan.zip (1.6MB)
PayPal will open in a new tab.