New feature for building access control
-
At my place of employment we have access cards as a system for entering the building. We have a utility that shows who is in the building, and who is out. This utility gets the in and out employees from a SQL Database. My supervisor wants a new feature added, and I have been giving the task of doing the design work for this. I have been mulling around for a few hours, considering my options. I was wondering what the CPians think of this idea, or if you guys have a better idea. The new feature would allow you to select an employee from the "Out of the building list," and set a notification on the person. So, when they enter the building, you will recieve an E-Mail saying "Joe Shmoe entered the building at 5:00 PM." We want this added to enterprise namespace so this can be a re-usable object in any software we design. So, my Idea is as such: I would create a service running on one of the servers in the building. The user will look at the In&Out utility, select a user, and say "Hey I wanna be notified when they come in" The service will accept notification request, and store it in a database. The service will constantly monitor the In&Out database, and when a condition for one of the notification requests has been met, it will send an E-Mail to the requestor. Then, the service will remove the notification request from the list. I have been looking at This Article[^] and I believe a lot of this is applicable to me. What do you guys think?
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
-
At my place of employment we have access cards as a system for entering the building. We have a utility that shows who is in the building, and who is out. This utility gets the in and out employees from a SQL Database. My supervisor wants a new feature added, and I have been giving the task of doing the design work for this. I have been mulling around for a few hours, considering my options. I was wondering what the CPians think of this idea, or if you guys have a better idea. The new feature would allow you to select an employee from the "Out of the building list," and set a notification on the person. So, when they enter the building, you will recieve an E-Mail saying "Joe Shmoe entered the building at 5:00 PM." We want this added to enterprise namespace so this can be a re-usable object in any software we design. So, my Idea is as such: I would create a service running on one of the servers in the building. The user will look at the In&Out utility, select a user, and say "Hey I wanna be notified when they come in" The service will accept notification request, and store it in a database. The service will constantly monitor the In&Out database, and when a condition for one of the notification requests has been met, it will send an E-Mail to the requestor. Then, the service will remove the notification request from the list. I have been looking at This Article[^] and I believe a lot of this is applicable to me. What do you guys think?
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
Well - another way to accomplish this would be to use a Notifications system like, say, the one with SQL Server 2005. Take a look at it - it's really very, very good.
Deja View - the feeling that you've seen this post before.
-
At my place of employment we have access cards as a system for entering the building. We have a utility that shows who is in the building, and who is out. This utility gets the in and out employees from a SQL Database. My supervisor wants a new feature added, and I have been giving the task of doing the design work for this. I have been mulling around for a few hours, considering my options. I was wondering what the CPians think of this idea, or if you guys have a better idea. The new feature would allow you to select an employee from the "Out of the building list," and set a notification on the person. So, when they enter the building, you will recieve an E-Mail saying "Joe Shmoe entered the building at 5:00 PM." We want this added to enterprise namespace so this can be a re-usable object in any software we design. So, my Idea is as such: I would create a service running on one of the servers in the building. The user will look at the In&Out utility, select a user, and say "Hey I wanna be notified when they come in" The service will accept notification request, and store it in a database. The service will constantly monitor the In&Out database, and when a condition for one of the notification requests has been met, it will send an E-Mail to the requestor. Then, the service will remove the notification request from the list. I have been looking at This Article[^] and I believe a lot of this is applicable to me. What do you guys think?
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
Leaving the implementation to one side, the approach taken to establish if an employer is in or out of the building using the card system may not be 100% accurate i.e. employer holds the door open for another, some override over the lock is performed, employer is using a temporary card if they misplaced their assigned one etc... Might be worth making your supervisor aware of this. As for the implementation if your using sql server 2005 I believe you can use a SqlDependency to check for data changes, it might be worth investigating.
-
At my place of employment we have access cards as a system for entering the building. We have a utility that shows who is in the building, and who is out. This utility gets the in and out employees from a SQL Database. My supervisor wants a new feature added, and I have been giving the task of doing the design work for this. I have been mulling around for a few hours, considering my options. I was wondering what the CPians think of this idea, or if you guys have a better idea. The new feature would allow you to select an employee from the "Out of the building list," and set a notification on the person. So, when they enter the building, you will recieve an E-Mail saying "Joe Shmoe entered the building at 5:00 PM." We want this added to enterprise namespace so this can be a re-usable object in any software we design. So, my Idea is as such: I would create a service running on one of the servers in the building. The user will look at the In&Out utility, select a user, and say "Hey I wanna be notified when they come in" The service will accept notification request, and store it in a database. The service will constantly monitor the In&Out database, and when a condition for one of the notification requests has been met, it will send an E-Mail to the requestor. Then, the service will remove the notification request from the list. I have been looking at This Article[^] and I believe a lot of this is applicable to me. What do you guys think?
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
Leaving aside implementation specific details and assuming you have access to DB servers keeping this information. Whenever you get a request for monitoring someone you can create a trigger in the database. The trigger should get triggered when the employee uses his access card to enter the building. In the code for trigger you can do the necessary processing. In an even based programming model, you should have events for whenever someone enters or leaves the building (OnEnter, OnExit). When you get a request to monitor someone you can store that in DB, and when the onEnter event is triggered, you can check against the DB to see if this person is on the notification list. Of course you have to put in appropriate code to remove the trigger once the condition has been met. Hope this was helpful - Vivek