Home

rfid-based attendance system with remote monitoring muhammad

1. Clear button handles on clearing the record permanently while Refresh button used to update the grid view The design name of this interface is Form 7 38 Edit View Project Build Debug Data Format Tools Test Window Hep XtraForm8 cs Design XtraForm3 cs XtraForm3 cs Figure 3 11 Account Setting GUI Design Figure 3 11 shows the GUI design of Account Setting Three button controls Add Delete User User List and Change Password included in this interface as the main control to call their respective form A textbox with design name used to display the name of user who logged in Back button control used to return to previous form 39 File Edit View Project Build Debug Data Format Tools Test DevExpress Window Help XtraForm11 cs Design XtraForm8 cs Figure 3 12 Add Delete User GUI Design Figure 3 12 shows the interface design of Add Delete User the form that will be called when button Add Delete User in the Account Setting form pressed The design name of this form is Formll The design name for the textboxes are tb fnama fullname tb unama username tb_pass password tb _npass confirm password and 6 delfnama delete fullname 40 File Edit View Project Build Debug Data Format Tools Test DevExpress Window Help C Full Screen XtraForm3 cs Design XtraForm10 cs XtraForm9 cs Design Xtra
2. 2011 Mon Tue Wed Thu 18 19 25 26 27 p gt 3 Today 5 3 2011 Figure 3 19 Database GUI Design Figure 3 19 shows the database GUI design This interface used to display the details of every registered profile ID The number of days absent per meeting also can be viewed via this interface Besides that any profile ID can be searched via this interface by inserting its full name or ID number in the search s textbox A less detailed database view also provided by clicking the button View In List which will call another form that uses data grid view control to display the database 46 Edit View Project Build Debug Data Format Tools Test DevExpress Window Full Screen XtraForm3 cs XtraForm3 cs Design XtraForm4 cs XtraForm4 cs Design XtraForm5 cs Design i i a dim au m Time Limit is a feature that set the end time for attendance marking The attendance will be marked as LATE for the transactions after the Time Limit o Date and Time 4 2011 Sun Mon Tue Wed Thu 2 25 26 7 28 2 LE 18 19 25 2 1 2 Today 5 10 2011 Figure 3 20 Time Limit GUI Design Figure 3 20 shows the time limit GUI design This interface used to set the time limit after a session has been created Radio button control has been used as the options of the time range The range of time available is
3. 60 61 62 63 64 66 67 69 70 71 71 72 73 75 76 78 78 79 79 80 TABLE NO 3 1 LIST OF TABLES TITLE RFID Frequency Chart PAGE 11 1X FIGURES 1 1 1 2 1 3 2 1 2 2 2 3 2 4 2 5 2 6 2 7 3 1 3 2 3 3 3 4 3 5 3 6 3 7 3 8 3 9 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 LIST OF FIGURES TITLE System block diagram Gantt chart of the project schedule for Semester 1 Gantt chart of the project schedule for Semester 2 IDR 232 RFID Reader Serial Data Transmission Different Direction of Serial Data Flow Direct to Computer RS 232 Interface Pin Description of DB 9 Female Connector UART Architecture System Flow Diagram of RDP IDR 232 RFID Reader RFID Tags Host Computer Prototype USB to Serial Converter LoginDB Database TADB Database Flowchart of Login Transaction System Login Design Main Menu Interface Design Login Record GUI Design Account Setting GUI Design Add Delete GUI Design Time Attendance Main GUI Design New Registration Interface Design Insert Update Tag ID Design Flowchart of New Registration Operation Deletion Interface Design Flowchart of Delete ID Event Database GUI Design Time Limit GUI Design Login Form Design Monitor Form Design PAGE ON 12 13 14 15 15 16 24 27 28 29 30 32 32 34 35 36 37 38 39 40 4l 4l 42 43 44 45 46 47 48 3 23 3 24 3 25 3 26 3 27 3 28 3
4. Product User s Manual RFID IDR 232N 3 POWER SUPPLY RFID IDR 232N power source is from USB connection There is no communication through USB connector only 5V is taken from this connector The communication line is RS232 cable serial port with female DB9 Connect the USB to the USB port of PC or laptop After providing power to RFID IDR 232N the LED will light ON with the RED color and buzzer will beep 97 98 ROBOT HEAD to TOE Cytron Product User s Manual RFID IDR 232N 4 USING RFID IDR 232N The hardware connection must be setup before RFID IDR 232N can be used Connect RJ11 cable connector into RFID Reader as shown in figure The communication line has to be connected to serial port of PC 99 Cytron product Users SOT HEAD to TOE After both power and communication line are connected the HyperTerminal software need to be configured Open HyperTerminal b Choose COMI if you connect to COMI c Configure the properties of COMI to 1 Baudrate Bits per second 9600 i Data bits 8 Parity None iv Stop bits 1 v Flow control None Settings Bits per second Data bis 8 iv Patty Nore Stop bis Flow contrat Herde Now RFID IDR 232N is ready to read address of a 125 KHz passive tag Move the tag slowly towards RFID IDR 232N top at approximately 2cm from the casing the buzzer will sound LED will turn to green when the tag
5. limited language services to the user Microsoft Visual Basic Visual J Visual C and Visual C 2 5 Microsoft INET Framework The Microsoft NET Framework is a software framework that can be installed on computers running Microsoft Windows operating systems It includes a large library of coded solutions to common programming problems and a common language infrastructure that manages the execution of programs written specifically for the framework The NET Framework supports multiple programming languages in a manner that allows language interoperability whereby each language can utilize code written in other languages in particular the NET library is available to all the programming languages that NET encompasses The framework s Base Class Library provides a large range of features including user interface data access database connectivity cryptography web application development numeric algorithms and network communications The class library is used by programmers who combine it with their own code to produce applications Programs written for the NET Framework execute in a software environment that manages the program s runtime requirements Also part of the NET Framework this runtime environment is known as the Common Language Runtime CLR The CLR provides the appearance of an application virtual machine so that programmers need not consider the capabilities of the specific CPU that will execute the program The C
6. medical certificate as the proof of sickness The Remote Client Monitoring also can be improved by expanding the range of accessibility Instead of connecting to the host computer through Local Area Network the connection can be made between two different networks Thus it increases the mobility of this system 80 REFERENCES 1 Daniel M Dobkin and Steven M Weigand Environmental Effects on RFID Tag Antennas United States Enigmatics Sunnyvale CA USA and WJ Communications San Jose CA USA 2 Hosted Desktop Virtualization Team 2008 Remote Desktop Protocol Performance United States Microsoft Corporation 3 IDR 232N RFID Reader Manual Attp www cytron com 4 Visual programming http www csharpfriends com 5 Ahmad Zatri Bin Johari 2007 Car Park Control System Interface RFID to PIC Using Serial Port Universiti Teknologi Malaysia Degree Thesis 6 Hamizah Binti Mokhtor 2010 Implementation of Parking System Using Radio Frequency Identification Technology Universiti Teknologi Malaysia Degree Thesis 7 Amirjan Bin Nawabjan 2009 Automated Attendance Management Software Universiti Teknologi Malaysia Degree Thesis 8 Stevan Preradovic Nemai C Karmakar 2006 RFID Reader A Review Australia Monash University 9 Information en wikipedia org 10 Serial Port Communication Using Tutorial Attp www codeproject com 81 11 Nur Raimi binti Mohd Abdul Rashid 2008 Classroom Att
7. the request processing pipeline such as passing information and processing status to HTTP sys for logging reporting events and tracking requests currently executing in worker processes 26 3 METHODOLOGY In order to implement the RFID Based Attendance System with monitoring capability an RFID reader a host computer and a remote computer are required There are two software to be developed which are the Time Attendance that to be stored in the host computer and the Remote Monitoring Client that to be stored in the remote computer 3 1 Hardware Implementation The hardware required to complete the system are the RFID reader with its tag a host computer a remote computer which is any available computer and a USB to serial converter However there is no hardware to be developed as all the hardware required are plug and play type and this project is more focused on developing the software 27 3 11 RFID Reader The RFID reader used in this project is called IDN 232 RFID Reader This RFID reader uses low frequency band which is 125 kHz Practically the reading distance between the tag and the reader is about 2 cm The output of this reader is transmitted serially It also transmitted data at 9600 baud rates Figure 3 1 IDR 232 RFID Reader The reason that this reader has been chosen is because it has a DB9 female header which can be used to connect to the serial port of personal computer The IDN 232
8. 29 3 30 4 1 4 2 4 3 4 4 4 5 4 6 4 7 4 8 4 9 4 10 4 11 4 12 4 13 4 14 4 15 4 16 4 17 4 18 4 19 4 20 4 21 4 22 4 23 4 24 4 25 4 26 4 27 Source Code Used to Connect to Database SQL Queries with try catch statement Displaying Data in Database Interface using Data Row ASCII to Hexadecimal Converter SerialPort DataReceived declaration Cross Thread Operation using Delegate Method Basic DataReceived Event Handler Flowchart of Scanning Tag ID Transaction RFID reader output test in HyperTerminal application Login Form Main Menu Login Record Account Setting for Administration Account Setting for Guest User Add Delete User Interface Prohibition from deleting administrator account User List Interface Change Password Interface Time Attendance Interface Registration form for new registration Update tag ID Deletion Interface Deleting a Profile ID using Guest User Account Database Interface Database in List View Interface of Time Limit setting Choosing a record file through the interface Opening the record file using PDF file reader New Session Wizard form Start Session Event Transaction displayed on the terminal Today s List showing the attendance marking Attendance Summary Remote Client Interface Successful connection to the host computer xi 49 50 50 51 52 53 53 54 55 56 57 58 59 59 60 62 63 63 64 65 66 67 68 68 69 70 71 72 73 74 74 75 76 77
9. DateTime end xtime LE tb xptime Text NOT SET DisplayData MessageType Time DateTime Now DisplayData MessageType Normal drl Fnama ToString 91 DisplayData MessageType Idnum drl Idno ToString string SQLUpdateString UPDATE TodayAttDB SET Status xTime DateTime Now WHERE Fnama drl Fnama ToString AND Status PENDING OleDbCommand SQLCommand new OleDbCommand SOLCommand CommandText SQLUpdateString SQLCommand Connection database SOLCommand ExecuteNonQuery LoadTADB string String SELECT Num Fnama Icno Org Idno Tagid Status xTime Meeting Absent FROM TodayAttDB loadDataGrid String 1 if DateTime Compare start end lt 0 DisplayData MessageType Time DateTime Now DisplayData MessageType Normal drl Fnama ToString DisplayData MessageType Idnum drl Idno ToString J J string SQLUpdateString UPDATE TodayAttDB SET Status xTime DateTime Now WHERE Fnama drl Fnama ToString AND Status PENDING OleDbCommand SQLCommand new OleDbCommand SOLCommand CommandText SQLUpdateString SOLCommand Connection database SQLCommand Execut
10. Integrated Monitoring System Time Attendance Registration gt New Registration Full Name ID Number Department Class Tag ID minal Registration Time Limit Figure 3 14 New Registration Interface Design File Edit View Project Build Debug Data Format Tools Test DevExpress Window Help E Full Screen XtraForm3 cs XtraForm3 cs Design XtraForm4 cs XtraForm4 cs Design IMS Integrated Monitoring System Time Attendance XtraForm5 cs Design XtraForm7 cs Design XtraForm9 cs Design XtraForm8 cs Design XtraForm10 cs Insert Update Tag ID Full Name Tag ID Deletion Datab Time Limit XtraFormi0 cs Design Date and Time May 2011 Tue Wed 26 27 4 10 17 18 24 25 72 5 12 19 26 41 Fri 29 6 13 20 Today 5 3 2011 XtraForm10 cs Design May 2011 Tue Wed Thu 26 4 1 18 25 1 8 5 12 19 26 Date and Time Today 5 3 2011 Figure 3 15 Insert Update Tag ID Interface Design m 42 The design of Registration interface is consist of two tabbed interfaces which are New Registration and Insert Update Tag ID as shown in Figure 3 14 and Figure 3 15 New Registration interface used to execute full registration In contrast Insert Update Tag ID interface is used if the details inserted manually to database via Microsoft Access except for the tag ID This is because the tag ID stored in the database
11. RFID Reader also provides a simple way to check its functionality It can display the unique ID of the tag through the HyperTerminal application in Window operating system 28 3 1 2 RFID Tags Figure 3 2 RFID Tags Figure 3 2 shows the RFID tags used in this project These RFID tags are passive tags thus it has no internal power supply These tags activated by radio frequency transmitted by the reader The reading distance is about 3 cm When the RFID reader receives the data from the tag the data then will be compared with the data in the database to identify the holder of the tag 29 3 1 5 Host Computer In order to test and demonstrate the full system functionality a prototype host computer has been built Intel D410PT Desktop Board has been selected as the motherboard because of its mini ITX size and it also has on board Intel Atom 1GHz speed processor in a reasonable price A 1GB DDR2 RAM is used to run this computer and an 80GB SATA hard disk as the storage A Cooler Master CPU Fan also been used to enhance the cooling process To power up the computer a 300W ATX power supply is used Figure 3 3 Host Computer Prototype 30 3 1 4 USB to Serial Converter A USB to Serial Computer is used in order to provide versatility to this system With the help of this converter the RFID reader can be connected whether to the serial port or to the USB port of the host computer The converter has its own driver provided whic
12. Ring indicator N N DAN c nm CO A O Data terminal ready 55 N Figure 2 4 Direct to Computer RS 232 Interface DB9 Female Received Line Signa Detect lt 1 QT DCE Ready Transmitted Data gt 7 Clear to Send Received Data 3 8 Ready 4 Request to Send 9 Signal Ground 5 Ring Indicator Shield Figure 2 5 Pin Description of DB 9 Female Connector 16 2 2 2 UART Universal Asynchronous Receiver Transmitter UART is a component used to convert between parallel data transmission and serial data transmission Thus UART is essential especially for asynchronous serial data transmission As microprocessor uses parallel data transmission it has to be converted into serial data stream before it fed into serial data line UART convert byte into serial bit data or a group of serial bit data into byte When two or more devices communicate with each other using asynchronous communication and the devices operate at independent clock it requires synchronization bits to maintain the integrity of the signal This is because there is no guarantee that the clocks of the communicating devices have exactly same frequency and phase for an extended period Because of that UART is required to provide the synchronization bits The simplified UART architecture is shown in Figure 2 6 Receiver TxD DATA B
13. also the protocols to be used Because of the complex USB protocol requirements communication with USB ports on a computer is always performed via a device driver When the host powers up it queries all of the devices connected to the bus and assigns each one an address This process is called enumeration Devices are also enumerated when they connect to the bus The host also finds out from each device what type of data transfer it wishes to perform e Interrupt A device like a mouse or a keyboard which will be sending very little data would choose the interrupt mode 18 e Bulk A device like a printer which receives data in one big packet uses the bulk transfer mode A block of data is sent to the printer in 64 byte chunks and verified to make sure it s correct e sochronous A streaming device such as speakers uses the isochronous mode Data streams between the device and the host in real time and there is no error correction The host can also send commands or query parameters with control packets As devices are enumerated the host is keeping track of the total bandwidth that all of the isochronous and interrupt devices are requesting They can consume up to 90 percent of the 480 Mbps of bandwidth that s available USB 3 0 increases that speed to 4 8 gigabits per second After 90 percent is used up the host denies access to any other isochronous or interrupt devices Control packets and packets for bulk transfers use
14. any bandwidth left over at least 10 percent The Universal Serial Bus divides the available bandwidth into frames and the host controls the frames Frames contain 1 500 bytes and a new frame starts every millisecond During a frame isochronous and interrupt devices get a slot so they re guaranteed the bandwidth they need Bulk and control transfers use whatever space is left The technical links at the end of the article contain lots of detail if you d like to learn more 2 3 1 USB to Serial Converter Defining RS232 communications and ports are often almost directly accessed in the application program Settings like baud rate data bits and hardware software flow control can often be changed within the application In contrast the USB interface does not give this flexibility However when an RS232 port is used via an USB to RS232 19 converter this flexibility should be present in some way Therefore to use an RS232 port via an USB port a second device driver is necessary which emulates a RS232 UART but communicates via USB RS232 ports which are physically mounted in a computer are often powered by three power sources 5 Volts for the UART logic and 12 Volts and 12 Volts for the output drivers USB however only provides a 5 Volt power source Some USB to RS232 converters use integrated DC DC converters to create the appropriate voltage levels for the RS232 signals but in very cheap implementations the 5 Volt voltag
15. array of bytes to store the received bytes of data from the serial port buffer before reading the bytes Then it will be displayed by using the DisplayData function In order to display the name of the Tag ID holder it will be compared to the database before being displayed as shown in the flowchart in Figure 3 30 Display as UNREGISTERED in terminal Display name and ID number in termina Figure 3 30 Flowchart of Scanning Tag ID Transact 54 55 4 RESULT AND DISCUSSION 4 1 RFID Reader Output Test HyperTerminal application has been used to view the output of the RFID reader after reading the tag as shown in Figure 4 1 The output of the reader is 12 bytes data in ASCIL The weird characters at the first byte and the last byte are extra byte to indicate the start and the end of the data The 10 bytes data between it is the tag unique ID File Edit View Call Transfer Help DE 23 28 9001306 720 78 Figure 4 1 RFID reader output test in HyperTerminal application 56 4 2 System Login IMS Login IMS Integrated Monitoring System Username Fc Figure 4 2 Login Form Figure 4 2 shows the login form to get the access of the Time Attendance system There are two types of user which are administrator and guest user Administrator has no data manipulation restriction while guest user has some limitation The type of user is identified by comparing the details fille
16. between 5 to 30 minutes after the port has been opened When the time limit has end the attendees that scan their tags should be marked as late An identification to enable this feature also provided However this feature can be enabled by using both admin and guest user account as the username and password in the admin identification 47 3 2 2 2 Remote Monitoring Client GUI Two forms have been used to develop the Remote Monitoring Client GUI which is login form and the monitor form The login information is inserted in the login form while the monitor form will provides the view and control of the host computer The view and the control of the host computer are gained by using the Microsoft Terminal Service Control Library The GUI design of these forms are shown in Figure 3 21 and Figure 3 22 IM S Remote Client Interface Username ume Figure 3 21 Login Form Design 48 Edit View Project Build Debug Data Format Tools Test DevExpress Window C Full Screen Form2 cs Design Forma cs XtraFormi es Program cs XtraFormil cs Design RemoteClien zi Figure 3 22 Monitor Form Design 3 2 3 Coding Technique The code behind the interface is mostly class based code as in C NET every control has its own class library that provide the desired output when the controls have been interrupted Functions also have been used to make the
17. da4 new System Data OleDb OleDbDataAdapter SELECT FROM DepDB database ds2 new DataSet FROM da Fill ds2 RegDB dal Fill ds2 TodayAttDB da2 Fill ds2 SessionDB da3 Fill ds2 TempDB da4 Fill ds2 DepDB MaxRows ds2 Tables RegDB Rows Count Rowcount fendregion 90 Display Data region Display Data STAThread private void DisplayData MessageType type string msg _displayWindow Invoke new EventHandler delegate _displayWindow SelectedText string Empty _displayWindow SelectionFont new Font displayWindow SelectionFont FontStyle Bold _displayWindow SelectionColor MessageColor int type _displayWindow AppendText msg _displayWindow ScrollToCaret endregion Data Received region DataReceived void comPort DataReceived object sender SerialDataReceivedEventArgs LoadTADB switch CurrentTransmissionType case TransmissionType Text int bytes comPort BytesToRead byte comBuffer new byte bytes comPort Read comBuffer 0 bytes string msg ByteToHex comBuffer int re 0 DataRow returnedrow returnedrow ds2 Tables RegDB Select Tagid msg FE re returnedrow Length if re gt 0 DataRow drl drli returnedrow 0 DateTime start DateTime Now
18. general making it a universal attendance system Thus it can be implemented in an academic institution or in an office 5 2 Recommendation Some further improvements can be made on this project in order increases its reliability and effectiveness There are two parts of improvements which are hardware improvement and software improvement 79 5 2 1 Hardware Improvement The current RFID reader used in this project only support very short distance reading By replacing this reader with a long range reader it can increase the performance of the system as attendees just only need no walk pass by the reader without actually bringing the tag out Other than that a hardware user interface can be build by the usage of microcontroller LCD and LED so the attendees can view the transaction Furthermore an IP camera can be integrated into this system to enable the monitor to view the person who making the transaction As a result this can avoid problem like a person scans in for other person 5 2 22 Software Improvement In software part the database can be made with more detail approach thus every profile stored has full personal details A reminder alert also can be developed to effectively track any ID that has been absent for an unacceptable times in a row Besides that this attendance system can be improved by adding a feature where it can save and recount the absent record if the absentee has absent under emergency leave or has the
19. in hexadecimal format instead of its default format which is ASCII format Thus the interface provides the converter from ASCII format to hexadecimal format before the tag ID is stored into the database In this design Admin Identification feature also has been built in order to enable only Administrator type of user can makes the registration operation The New Registration implementation should follow the flowchart in Figure 3 16 Search for the full name inserted in the form im the database insert details filled into database Figure 3 16 Flowchart of New Registration operation 43 Edit View Project Build Debug Data Format Tools Test DevExpress Window Help E Full Screen XtraForm3 cs XtraForm3 cs Design XtraForm4 cs XtraForm4 cs Design XtraForm5 cs Design XtraForm7 cs Design XtraForm9 cs Design XtraForm amp cs Design XtraForm10 cs XtraFormi0 cs Design Date and Time May 2011 Sun Mon Tue Wed Thu 24 25 26 27 28 29 3 1 6 8 13 15 20 2 27 29 1 Today 5 3 2011 Figure 3 17 Deletion Interface Design Figure 3 17 shows the Deletion interface design An ID can be deleted by inserting its full name or its ID number This operation will also require Admin Identification as same as Registration operation The flowchart of Deletion operation is shown in Figure 3 18 Figure 3 18 Flowchart of Delete ID Event 44 45
20. in my opinion this work is adequate in terms of scope and quality for the purpose of awarding a degree of Bachelor of Engineering Electrical Computer Signature Name of Supervisor En Zuraimi Bin Yahya Date 19 MAY 2011 BASED ATTENDANCE SYSTEM WITH REMOTE MONITORING MUHAMMAD SAZALI BIN HISHAM A thesis submitted in fulfillment of the requirements for the award of the degree of Bachelor of Engineering Electrical Computer Faculty of Electrical Engineering Universiti Teknologi Malaysia May 2011 ii I declare that this work as the product of my own effort with the exception of excerpt cited from other works which the sources were duly noted Signature Name of Candidate Muhammad Sazali Bin Hisham Date 19 MAY 2011 Dedicated to my beloved father mother sisters and brother and not forgetting my friends iii iv ACKNOWLEDGMENT Alhamdulillah praise to Allah for the guidance and strength given to me to complete this project Peace and blessing upon Prophet Muhammad S A W who has bring the light to all mankind I would like to express the deepest gratitude to my supervisor Encik Zuraimi bin Yahya who has gave me some brilliant idea in order to complete the project His willingness to spend time to guide me is much appreciated I would like to thank my parents who have support me mentally and financially I also would like to thank my siblings who willing to share
21. move slowly towards RFID IDR 232N and HyperTerminal will show the tag s ID in 100 Cytron 5 ROBOT HEAD to TOE Ti Product User s Manual RFID IDR 232N RFID Hyper Terminal Edt View Cal Trarsfer Heb Oe 53 9800079 74478 Connacad 0 00 23 _ Aio datat 65009 ROL Figure above show the protocol of the RFID Reader The extra byte of data at the first and the last of tag ID s If the protocol users have is different from the protocol above please contact us at sales cytron com my immediately 101 Cytron 5 PIN CONFIGURATION ROBOT HEAD to TOE Product User s Manual RFID IDR 232N If RFID IDR 232N is require on embedded system where no PC is available hardware modification and interface is necessary USB will provide 5V and ground to RFID IDR 232N while female DB9 is commumication line to PC Below pin configuration of USB RJ11 and DB9 of RFID IDR 232 USB female Connector Female DB9 pin Configuration RJ11 male Configuration 102 103 Cytron Prout RED DR 6 RFID IDR 232N Protocol High level language which can access to serial port can be used to develop program for RFID IDR 232N on desktop PC or laptop Some examples of high level language are Visual Basic Labview and Visual If RFID IDR 232N is connected to microcontroller Assembly language or C compiler depending on microcontroller type can be used to write program RFID I
22. program well organized 49 3 2 3 1 Database Interfacing As the database is built using Microsoft Access the connection to the database can be established using OleDb connection DataAdapter also been used to implement dataset method to get the data from the database The example of source code used is shown in Figure 3 23 region Instance Declaration public OleDbConnection database DataSet dsl DataSet ds2 System Data OleDb OleDbDataAdapter System Data OleDb OleDbDataAdapter System Data OleDb OleDbDataAdapter System Data OleDb OleDbDataAdapter System Data OleDb OleDbDataAdapter System Data OleDb OleDbDataAdapter fendregion Connecting to the Database string connectionString Provider Microsoft Jet OLEDB 4 0 Data Source Databases LoginDB mdb Jet OLEDB Database Password admin database new OleDbConnection connectionString database Open string sql SELECT FROM PassDB dsl new DataSet da new System Data OleDb OleDbDataAdapter sql database da Fill dsl PassDB dal new System Data OleDb OleDbDataAdapter SELECT FROM LogDB database 1 111 451 LogDB Figure 3 23 Source Code used to connect to the database 50 3 2 3 2 Database Queries SQL statements such as INSERT DELETE and UPDATE are used to retrieve and manipulate data in the database Besides that getting data row from dataset method also been used to retrieve the data withou
23. such as displaying live ID tags transactions registering ID deleting ID recording attendance and the other minor functions This interface was installed in the host computer In contrast the Monitoring Client was installed in the remote computer where remote monitoring can be executed using Remote Desktop Protocol technology The host computer and the remote computer were connected using Local Area Network LAN This management system provides convenient and efficient attendance recording plus saving user s energy It is suitable for indoor use as an office solution or the class attendance system for academic institutes vi ABSTRAK Teknologi RFID telah digunakan secara meluas dalam pelbagai industri sebagai sebahagian daripada sistem automatik yang digunakan Dalam projek ini sebuah sistem kehadiran menggunakan teknologi RFID telah dibina Sistem ini terbahagi kepada tiga komponen iaitu pengimbas RFID komputer hos dan komputer remote Pengimbas RFID yang digunakan ialah pengimbas pada frekuensi rendah 125 kHz dan disambung ke komputer hos melalui port sesiri atau port USB Prototaip bagi komputer hos dibina menggunakan Intel Desktop Board D410PT yang mengintegrasikan pemproses Intel Atom Komputer ini beroperasi menggunakan sistem pengoperasian Window Terdapat dua GUI yang dibina iaitu Time Attendance dan juga Remote Monitoring Client GUI ini dibina di dalam Microsoft Visual Studio dengan menggunakan bahasa aturcara C Net Fu
24. their experiences which really motivate me to get my project done Besides that I would like to thank to all my friends especially close friends in UTM for helping me mentally in completing this project All the difficulties are shared together and it makes me keep going Lastly thanks to all lecturers and technicians who have taught me throughout my four years study in UTM The knowledge gained from them is one of the factor that contributing to this project completion Thank you very much May Allah bless all of you ABSTRACT Radio Frequency Identification RFID technology has been widely used by various industries as a part of an automation system In this study an RFID based system has been built in order to produce more efficient time attendance management system This system consists of 3 main parts which is an RFID reader a host computer and a remote computer The RFID reader which is a low frequency reader 125 kHz connected to the host computer either to via serial port or USB port The host computer prototype was built using Intel Desktop Board D401PT which has an integrated Intel Atom processor and run Windows operating system There were two graphical user interfaces GUI developed in which are the Time Attendance System and the Remote Monitoring Client These GUIs were developed via Microsoft Visual Studio using C Net language The Time Attendance Management System provides the functionalities of the overall system
25. 011 Figure 4 18 Interface of Time Limit setting 70 4 5 5 Records After a session has ended record has been saved so it be reviewed in future The record is saved in PDF format file and the file name is based on the name given to the session during new session wizard The file can be chose through the interface but will be opened by PDF file reader application such as Adobe Acrobat Reader as shown in Figure 4 19 and Figure 4 20 Selecta n bin IMS TimeAttendance Records Search Records Organize v folder 9 Favorites Date modified Type Desktop T TEST Tuesday April 19 2011 4 19 2011 305 PM Adobe Acrobat D Downloads E Recent Places J Libraries 2 Documents a Music Pictures Videos 8 Homegroup 1 Computer R Filename TEST Tuesday April 19 2011 v PDF files pdf April 2011 Sun Mon Tue Wed Thu Fri Sat 27 28 29 30 3 1 2 3 3 T7 B 9 10 11 12 13 14 15 16 17 18 19 20 aA 2 B 24 25 8 7 8 9 9 23 Time Limit Ex aque Terminal Figure 4 19 Choosing a record file through the interface File Edit View Window f Bet Baro Comment Figure 4 20 Opening the record file using PDF file reader 4 6 Attendance Marking Transaction Share 71 Today 4 19 2011
26. D 5 880923565121 MICROP 070253 1303031333036 4 13 2011 1 01 3030313330363 32 MUHAMAD 880224145811 MICROP 070212 1303031333037 4 13 2011 1 20 3030313330373 RegDB Table TodayAttDB E TodayAttDB Table 33 SUBRI 890727115405 5 5 070204 1303031333036 4 13 2011 1 20 3030313330363 SessionDB 35 MOHAMMAD 880719565001 SYSCOM AE070157 1303031333037 4 13 2011 1 23 3030313330373 SessionDB Table New E TempDE Table amp DepDB Table Figure 3 6 TADB Database 33 3 2 2 GUI Design As mentioned before the GUI of the Time Attendance and the Remote Monitoring Client is developed using Microsoft Visual Studio 2008 However it is difficult to design an attractive GUI using the basic controls provided by the Microsoft Visual Studio Thus third party add on software which is Developer Express 2010 has been used to enhance the appearance of the GUI This software is integrated into Microsoft Visual Studio 2010 3 2 2 1 Time Attendance GUI The Time Attendance interface is divided into two parts which are login part and the main interface part The purpose of the login part is to make the system more secure as user has to login before having the access of the main interface The folder of the design project is named Final GUI and the project file name is FGUI The output of the compilation is in Debug folder within the project folder The flowchart of
27. DR 232N will read the ID from RFID tag if the tag is near enough to RFID Reader The ID is normally 10 digit of number RFID IDR 232N will automatically send this ID with 1 of Start of heading 0x01 followed by 10 byte of ASCII character ID and 1 byte of Start of text 0x02 The 1 byte will be read is Start of heading followed with 10 bytes of RFID Identification number The last 1 byte is Start of Text
28. Every time the port is opened is treated as a session Thus in order to open the port a new session has to be created Once the port is opened the application can start reading any tag that has been scanned by the RFID reader 4 6 1 New Session Wizard New Session Wizard form will be called when a new session has to be created In this wizard the name of the session the date of the session and the time of the session entered This form also provides choices of department to be involved in that session There are two choices of taking attendance which are by department and by whole company or class The New Session Wizard form is shown in Figure 4 21 72 Figure 4 21 New Session Wizard form 4 6 2 Starting a Session Once a new session has been configured in the New Session Wizard the Start Session feature will be enabled When a new session has been created a temporary data is stored into temporary database When the Start Session event is called the program will refer to the temporary database to check whether a new session has been created or vice versa If the temporary data is in that database it will proceed to open the port for tag reading 73 Port Opened at 4 19 2011 3 35 50 Date and Time April 2011 Sun Mon Wed Thu 5 6 7 3 4 5 6 Today 4 19 2011 Figure 4 22 Start Session Event 4 6 3 Attendance Marking When the tag scanned the tag ID will be compared fo
29. Formi0 cs Design XtraFormll cs XtraFormil cs Design XtraForm8 cs Design XtraForm3 cs XtraForm7 cs XtraForm cs Design XtraForm2 cs IMS Time Attendance System 1 or dance Registrati Deletion Database Expiry amp Today s Li tus H Date and Time 2011 Sun Mon Tue Wed Thu 4 2 26 7 28 2 3 Terminal Registration Deletion Database Mose 2 Today 5 1 2011 Figure 3 13 Time Attendance Main GUI Design Figure 3 13 shows the Time Attendance Main Interface Design Tab control has been used to reduce forms required to implement the main features available Features included in this interface are live transaction terminal ID registration ID deletion view database searching set time limit and view session record Button controls in the Menu used to open the tab respectively according to their names except Exit button which used to close this form and return to Main Menu form and also Records button which use open file dialog control to open the record files Default tab opened when this form has loaded is the terminal tab as shown in Figure 3 13 File Edit View Project Build Debug Data Format Tools Test DevExpress Window Help Full Screen XtraForm3 cs XtraForm3 cs Design XtraForm4 cs XtraForm4 cs Design XtraForm5 cs Design XtraForm cs Design XtraForm9 cs Design XtraForm8 cs Design XtraFormi0 cs IMS
30. ID RFID GUI LAN USB EEPROM LF HF UHF LED UART RS 232 RDP TCP IIS xil LIST OF ABBREVIATIONS Radio Frequency Identification Radio Frequency Identification Graphical User Interface Local Area Network Universal Serial Bus Electrically Erasable Programmable Read Only Memory Low Frequency High Frequency Ultra High Frequency Light Emitting Diode Universal Asynchronous Receiver Transmitter Recommended Standard 232 Remote Desktop Protocol Transmission Control Protocol Internet Information Service IP LCD HTTP HTTPS FTP FTPS SMTP NNTP DAO VBA SQL xiii Random Access Memory Internet Protocol Liquid Crystal Display Hypertext Transfer Protocol Hypertext Transfer Protocol Secure File Transfer Protocol File Transfer Protocol Secure Simple Mail Transfer Protocol Network News Transfer Protocol Data Access Object Visual Basic for Application Structured Query Language xiv LIST OF APPENDICES APPENDIX NO TITLE PAGE A Source Code 82 B IDR 232N RFID Reader User Manual 93 1 INTRODUCTION 1 1 Background of Project In this modern world there still workplaces or academic institutions that still using traditional way of taking attendance For example attendance sheet method where attendees need to pass around the sheet to sign it as the proof of attending the session There is also punch card method which is usually used by factories to
31. LR also provides other important services such as security memory management and exception handling The class library and the CLR together constitute the NET Framework 21 2 6 C Programming Language is a multi paradigm programming language encompassing imperative declarative functional generic object oriented class based and component oriented programming disciplines It was developed by Microsoft within the NET initiative and later approved as a standard by ECMA ECMA 334 and ISO ISO IEC 23270 C is one of the programming languages designed for the Common Language Infrastructure The goals of this programming language design are e C language is intended to be simple modern general purpose object oriented programming language The language and implementations thereof should provide support for software engineering principles such as strong type checking array bounds checking detection of attempts to use uninitialized variables and automatic garbage collection Software robustness durability and programmer productivity are important e The language is intended for use in developing software components suitable for deployment in distributed environments e Source code portability is very important as is programmer portability especially for those programmers already familiar with C and C e Support for internationalization is very important e Cit is intended to be suitable for writing applicat
32. NET Framework 2 6 C Programming Language 27 Microsoft Office Access 2 8 Remote Desktop Protocol 2 9 Internet Information Service IIS vii PAGE iii vi vi Vii 1 xii xiv UU l2 10 10 12 13 14 16 17 18 19 20 21 22 23 24 3 METHODOLOGY 3 1 3 2 Hardware Implementation 3 1 1 RFID Reader 3 1 2 RFID Tags 3 1 3 Host Computer 3 14 USB to Serial Converter Software Implementation 3 2 1 Microsoft Access Database 3 2 2 GUI Design 3 2 2 1 Time Attendance GUI 3 2 2 2 Remote Monitoring Client GUI 3 2 3 Coding Technique 3 2 3 1 Database Interfacing 3 2 3 2 Database Queries 3 2 3 3 ASCII to Hexadecimal Converter 3 2 3 4 Comparing Two Time Format Number 3 2 3 5 Serial Port Interfacing 4 RESULT AND DISCUSSION 4 1 42 43 44 4 5 4 6 4 7 Reader Output Test System Login Main Menu Account Setting 4 41 Adding or Deleting User 4 4 2 User List 4 4 3 Change Password Time Attendance Main Interface 4 5 1 Registration 4 5 2 Deletion 4 5 3 Database Interface 4 5 4 Time Limit Setting 4 5 5 Records Attendance Marking Transaction 4 6 New Session Wizard 4 6 2 Starting a Session 4 6 3 Attendance Marking 4 6 4 Ending a Session Remote Monitoring Client 5 CONCLUSION AND RECOMMENDATION 5 1 5 2 Conclusion Recommendation 5 2 1 Hardware Improvement 5 2 2 Software Improvement REFERENCES 26 27 28 29 30 31 31 33 33 47 48 49 50 51 51 52 55 56 57 58
33. Ocx secured ClearTextPassword txtPassword Text f2 rdp Connect f2 Show this Hide this ShowInTaskbar false catch Exception Ex MessageBox Show Error Connecting Error connecting to remote desktop txtServer Text wo Ex Message MessageBoxButtons OK MessageBoxIcon Error txtPassword txtServer R ResetText setText txtUserNam 1 ResetText 84 Form 2 Monitor Form using System using System Collections Generic using System ComponentModel using System Data using System Drawing using System Text using System Windows Forms using DevExpress XtraEditors namespace RemoteClient public partial class Form2 DevExpress XtraEditors XtraForm public Form2 InitializeComponent private void simpleButtonl Click object sender EventArgs e try Check if connected before disconnecting if rdp Connected ToString 1 rdp Disconnect catch Exception Ex Forml frml new Forml MessageBox Show Error Disconnecting TEE disconnecting from remote desktop frml txtServer Text Error Ex Message MessageBoxButtons OK MessageBoxIcon Error Forml 1 new f1 Show this Close 85 Time Attendance Form3 Time Attendance Main GUI Register region Registration priv
34. RFID BASED ATTENDANCE SYSTEM WITH REMOTE MONITORING MUHAMMAD SAZALI BIN HISHAM UNIVERSITI TEKNOLOGI MALAYSIA UNIVERSITI TEKNOLOGI MALAYSIA DECLARATION OF THESIS UNDERGRADUATE PROJECT PAPER AND COPYRIGHT Author s full name MUHAMMAD SAZALI BIN HISHAM Date of birth 2374 SEPTEMBER 1988 Title RFID BASED ATTENDANCE SYSTEM WITH REMOTE MONITORING Academic Session 2010 2011 declare that this thesis is classified as CONFIDENTIAL Contains confidential information under the Official Secret Act 1972 RESTRICTED Contains restricted information as specified by the organisation where research was done OPEN ACCESS agree that my thesis to be published as online open access full text acknowledged that Universiti Teknologi Malaysia reserves the right as follows 1 The thesis is the property of Universiti Teknologi Malaysia 2 The Library of Universiti Teknologi Malaysia has the right to make copies for the purpose of research only 3 The Library has the right to make copies of the thesis for academic exchange Certified by SIGNATURE SIGNATURE OF SUPERVISOR 8809 23 56 5121 ZURAIMI BIN YAHYA NEW IC NO PASSPORT NO NAME OF SUPERVISOR Date 19 MAY 2011 Date 19 MAY 2011 NOTES If the thesis is CONFIDENTIAL or RESTRICTED please attach with the letter from the organisation with period and reasons for confidentiality or restriction declare that I have read this work and
35. Text Editor Main Menu ta ES XtraForml0 cs DX 10 2 Reporting EE XtraFormii cs 0 10 2 Navigation amp Layout EE XtraForm2 cs E DX 10 2 Data H XtraForm3 cs 89 DX 10 2 Components XtraForm4 cs DX 10 2 Common Controls amp E XtraForm5 cs Pointer m XtraForm 7 cs SimpleButton Properties vx ButtonEdit Form2 DevExpress XtraEditors XtraForm CalcEdit 1 BRE Toolbox Server Explorer gt Bl Size 557 290 Enor Ust Senape Auto StartPosition CenterScreen Q ore o Warnings LO o Messages T Description File Line Column Project Tet IMS Main Menu 5 Text The text associated with the control Figure 3 9 Main Menu Interface Design Figure 3 9 shows the GUI design of Main Menu This interface act as an intermediary interface because the three buttons Account Setting Time Attendance and Login Record only responsible to call their corresponding forms The button Logout used to return to the System Login form 37 Eile Edit View Project Build Debug Data Format Tools Test DevExpress Window Help FullScreen Figure 3 10 Login Record GUI Design Figure 3 10 shows the GUI design of Login Record In order to display the record a data grid view control has been used Three button controls also included which are Back Clear and Refresh Back button used to return to the Main Menu
36. USB converter is required if connection to the USB port of the host computer is chosen The Time Attendance GUI is stored in the host computer with the database while the Remote Client GUI is stored in the remote computer The remote computer access the host computer via internetwork within Local Area Network LAN 1 5 Work Contribution RFID based Attendance System which is able to be monitored remotely is successfully developed The main contributions of this project are e Manage to develop the Time Attendance GUI that capable to track absentees count overall absentees and provide lives transaction e Manage to develop the Remote Monitoring Client GUI that enable user to monitor the live transaction besides manipulating data Manage to integrate the GUI with the database to access data stored e Successfully tested the system The details of works involved in developing RFID Based Attendance System is shown in Figure 1 2 and Figure 1 3 Week Activity 14 15 16 Finding project title Discussio n on project title Informati on findings Submit project proposal Literature Review Learning Language Presentati on Report Writing Figure 1 2 Gantt chart of the project schedule for Semester 1 Week Activity Developing Remote Client GUI Work on receiv
37. Windows It is the second most used web server behind Apache HTTP Server The protocols supported in latest IIS IIS 7 5 include FTP FTPS SMTP NNTP and HTTP HTTPS There are some modules featured in IIS which are 25 HTTP modules Used to perform tasks specific to HTTP in the request processing pipeline such as responding to information and inquiries sent in client headers returning HTTP errors and redirecting requests Security modules Used to perform tasks related to security in the request processing pipeline such as specifying authentication schemes performing URL authorization and filtering requests Content modules Used to perform tasks related to content in the request processing pipeline such as processing requests for static files returning a default page when a client does not specify a resource in a request and listing the contents of a directory Compression modules Used to perform tasks related to compression in the request processing pipeline such as compressing responses applying Gzip compression transfer coding to responses and performing pre compression of static content Caching modules Used to perform tasks related to caching in the request processing pipeline such as storing processed information in memory on the server and using cached content in subsequent requests for the same resource Diagnostics modules Used to perform tasks related to logging and diagnostics in
38. ase Time Limit Records Today 4 19 2011 Figure 4 16 Database Interface Full Name NRIC Department ID Number 880923565121 MICROP AE070253 MUHAMAD ANWAR BIN ISMAIL 880224145811 MICROP AEO7C MOHD SUBRI BIN ABDUL RANI 890727115405 5 5 AE070204 MOHAMMAD HASBULLAH BIN MAZLAN 880719565001 SYSCOM AE070157 Date and Time 4 4 April 2011 Sun Mon Tue Wed Thu 27 28 29 30 31 3 7 amp 17 21 24 28 1 3 B 5 6 ea pete Database Time Limit 7 Today 4 19 2011 0 Terminal Registration Figure 4 17 Database in List View 69 4 5 4 Time Limit Setting Time Limit is developed to enable the system to set a time limitation of a session The range of duration that can be set is between 5 to 30 minutes The start time is the time port is opened and the end time is the time when the duration chosen has ended Any tag scanned after the duration has ended is still considered as attended but the status of the attendance is LATE Both administrator and guest user can set this time limit feature The interface of time limit setting is shown in Figure 4 18 Expiry Time es PP D am PP m a dt dt Limit i isa TII Mars set the end time for attendance marking The attendance will be marked as LATE for the transactions after the Time Limit 6 amp 4 April 2011 Sun Mon Tue Wed Thu Fri 2 28 2 3 1 8 5 2 29 6 Today 4 19 2
39. ate void Register string SQLString SOLString INSERT INTO RegDB Fnama Tagid Datereg Tagid2 VALUES name Replace Pm Ww nric LI idno I ConvertToHex tagid 2 DateTime Now ConvertToHex tagid OleDbCommand SQLCommand new OleDbCommand SOLCommand CommandText SQLString SQLCommand Connection database int response 1 RES response SQLCommand ExecuteNonQuery catch Exception ex MessageBox 5 ex Message if response gt 1 int no 0 string SQLString2 SOLString2 INSERT INTO TodayAttDB Fnama Icno Org Idno Tagid Status xTime Meeting Absent VALUES so names Laces Wr TERR meee qs p p idno 4 I1 ConvertToHex tagid T20 4 TAT 4 mfaW q wt qm Ut no ToString 4 ino ToString 4 g OleDbCommand SQLCommand2 new OleDbCommand SOLCommand2 CommandText SQLString2 SQLCommand2 Connection database int response2 1 response2 SQLCommand2 ExecuteNonQuery catch Exception ex MessageBox Show ex Message if response2 gt 1 DataRow row ds2 Tables DepDB Select Dep org Wa 86 int row Length if gt 0 Xt
40. b The System Status will show the configuration status of the port name session and time limit 4 5 1 Registration Date and Time lt May 2011 Sun Mon Tue Wed Thu Fri 4 25 7 23 3 123456 8 9 15 16 17 18 19 2 22 23 24 25 26 27 29 3 S 2 3 Today 5 10 2011 Figure 4 12 Registration form for new registration 65 Insert Update Tag ID Date and Time May 2011 n Tue Wed Thu Fri 2 27 28 2 30 3 4 5 18 19 25 26 27 1 2 3 Today 5 10 2011 Figure 4 13 Update tag ID The registration form is divided into two sections which are new registration and insert or update tag ID The purpose of new registration form is to register new ID with full detail required through the interface as shown in Figure 4 12 The details required are full name NRIC ID number department or class and tag ID Only administrator has the access to register the ID Besides that each person cannot have more than one profile in the same department The registration form for insert or update tag ID as shown in Figure 4 13 This option helps when direct registration is made Direct registration means the details inserted directly into the database tables All details can be inserted directly into the database table except for tag ID because it is stored in hexadecimal form Thus it has to be converted into hexadecimal first Because of that this interface provides the ID conversion into hexade
41. cimal before being stored in the database 66 4 5 2 Deletion April 2011 Sun Mon Tue Wed Thu 11 1 10 18 19 20 a 25 26 27 28 2S5 2 3 6 Today 4 19 2011 Figure 4 14 Deletion Interface Figure 4 14 shows the interface for delete profile ID A profile ID can be deleted by inserting its full name or ID number Only administrator has the access to delete profile as goes as registration Figure 4 15 shows the message generated when trying to delete a profile ID using a guest user account 67 Date and Time 2011 Sun Mon Tue Wed Thu Fri M 25 26 7 28 9 3 1 3 3 5 12 15 16 17 18 19 2 23 24 25 26 3 Mir l rf 3 Today 5 10 2011 Figure 4 15 Deleting a Profile ID using Guest User Account 4 5 3 Database Interface The Time Attendance also provides the interface to view the database as shown in Figure 4 16 Besides showing the personal details it also shows the absent count out of total meetings of every profile ID The database also can be viewed in list but in less detailed manner as shown in Figure 4 17 Refresh database function is required to effectively update the database after any data manipulation on the database has executed The profile also can be searched throughout the database by entering the full name or ID number of the profile 68 April 2011 Sun Mon Tue Wed Thu 7 28 29 30 3 b Terminal Deletion Datab
42. commended Standard 232 is a standard defines by Electronic Industries Association EIA for serial data transmission This standard uses asynchronous data transmission where a word consists of a start bit seven or eight data bits optional one parity bit and one or two stop bits The transmission can be executed minimally using three wires send data receive data and signal ground The minimum recognized voltage of this standard is 3V It specifies that logic 1 has been sent when the voltage is 3V to 15V while logic 0 when the voltage is 3V to 15V Typically the speed of the transmission measured in baud rate which is 150 times an integer power of 2 ranging from 0 to 7 150 300 600 19 200 The standard has not defines the maximum cable length but the maximum capacitance that a compliant drive circuit must tolerate A widely used rule of thumb indicates that cables more than 50 feet 15 meters long will have too much capacitance unless special cables are used The most common connector used for modern computer is DB 9 type DB25 o a a RS 232 Interface DB25 Frame Chassis Ground Carrier detect Carrier detect Data set ready Ring indicator Data terminal ready 1 2 Transmit data Transmit data 2 3 Receive data gt lt Receive data 3 7 Signal Ground 7 4 Request to send Request to send 4 COMPUTER Cleartosend jee 8 8 6 6 Data set ready
43. d in the form with the details matched in the database 57 4 3 Main Menu Main Menu Figure 4 3 Main Menu Figure 4 3 shows the main menu of the system There are three options which are account setting time attendance and login record Time attendance menu is chosen to access the time attendance system Login record displays the record of all login transaction as shown in Figure 4 4 58 Figure 4 4 Login Record 4 4 Account Setting In the account setting there are three menus which are Add or Delete User User List and Change Password However guest user is restricted from add or delete user and view user list Only password change can be done by guest user Figure 4 5 and Figure 4 6 shows the limitation in account setting menu using different account type 59 Figure 4 5 Account Setting for Administration Figure 4 6 Account Setting for Guest User 60 4 4 1 Adding or Deleting User This menu provides the interface for administrator to add or delete user However administrator s account itself cannot be deleted and there is only one administrator account in this system In the other words only guest user can be added into the database Username that is same with one of the username stored in the database cannot be deleted Figure 4 7 Add Delete User Interface 61 Figure 4 8 Prohibition from deleting administrator account 4 4 3 User List The Us
44. e an exception during runtime as illegal cross thread operation Furthermore as both serial port and the window form control is trying to manipulate the same data simultaneously race condition or deadlock may happen and the output will be incorrect In order to make a thread safe call delegate method used to invoke the cross thread operation as shown in Figure 3 28 53 private RichTextBox _displayWindow STAThread private void DisplayData MessageType type string msg _displayWindow Invoke new EventHandler delegate _displayWindow SelectedText string Empty _displayWindow SelectionFont new Font displayWindow SelectionFont FontStyle Bold _displayWindow SelectionColor MessageColor int type _displayWindow AppendText msg _displayWindow ScrollToCaret Figure 3 28 Cross Thread operation using delegate method void comPort DataReceived object sender SerialDataReceivedEventArgs e int bytes comPort BytesToRead byte comBuffer new byte bytes comPort Read comBuffer 0 bytes string msg ByteToHex comBuffer DisplayData MessageType Time DateTime Now t DisplayData MessageType Late msg n Figure 3 29 Basic DataReceived Event Handler Figure 3 29 shows the basic function of DataReceived event handler to display the data from serial port in the rich textbox control by using DisplayData function This function first creates an
45. eNonQuery LoadTADB string String SELECT Num Fnama Icno Org Idno Tagid Status xTime Meeting Absent FROM TodayAttDB loadDataGrid String else DisplayData MessageType Time DateTime Now DisplayData MessageType Late drl Fnama ToString DisplayData MessageType Lat drl Iidno IoString c I TREE Y string SQLUpdateString UPDATE TodayAttDB SET Status LATEY 1 DateTime Now WHERE Fnama drl Fnama ToString AND Status PENDING OleDbCommand SQLCommand new OleDbCommand SQLCommand CommandText SQLUpdateString SQLCommand Connection database SOLCommand ExecuteNonQuery LoadTADB string String S EL ECT Num Fnama Icno Org Idno Tagid Status xTime Meeting Absent TodayAttDB loadDataGrid String FROM 1 97 DisplayData MessageType Time DateTime Now t DisplayData MessageType Late UNREGISTERED n break default string strl CO mPort ReadExisting DisplayData MessageType Normal DateTime Now Nt strl break endregion Display Database private void Record Int if else int if ds2 Tables RegDB Rows Count r gt 0 DataRow dr ds2 Tables RegDB Rows inc tb fname Text dr ItemArray GetValue 1 ToString tb n
46. each loop also used to convert every single ASCII character The function is shown in Figure 3 26 public string ConvertToHex string asciiString string hex foreach char c in asciiString int tmp c hex String Format 0 x2 uint System Convert ToUInt32 tmp ToString return hex Figure 3 26 ASCII to Hexadecimal Converter 3 2 3 4 Comparing Two Time Format Number Time limit feature needs the comparison of the end time and the time the tag ID scanned However it cannot be arithmetically subtracted as time format number is not the same of integer format number Thus DateTime Compare Timel Time2 command is used instead Time is the first parameter that will be compared to Time2 52 3 2 3 5 Serial Port Interfacing Microsoft Visual Studio provides the serial port class library to make communication between serial port and the window form The SerialPort DataReceived need to be declared as it is the event handler to read the data from the serial port buffer as shown in Figure 3 27 This method is interrupt driven private SerialPort comPort new SerialPort comPort DataReceived new SerialDataReceivedEventHandler comPort_DataReceived Figure 3 27 SerialPort DataReceived declaration The data from the serial port will be displayed on a rich textbox control However the serial port and the rich textbox control are using different threads This by default will produc
47. endance Using RFID Universiti Teknologi Malaysia Degree Thesis 12 Understanding Remote Desktop Protocol http support microsoft com kb 186607 13 Mc Oswel Jamin Sibin 2010 RFID Based Attendance System Universiti Teknologi Malaysia Degree Thesis 14 C Net Programming using COM Interop Attp www c sharpcorner com 15 Intel Desktop Board Specifications http www intel com 16 Thread Safe Calls to Window Form http msdn microsoft com 17 Window Form Custom Controls http Avww devexpress com APPENDIX SOURCE CODE 82 83 Remote Monitoring Client Forml Login Form using System using System Co using System Co using System Da using System Dr using System Te using System Wi using DevExpres using MSTSCLib namespace Remot llections Generic mponentModel ta awing xt ndows Forms s XtraEditors Client public partial public Forml InitializeC private v txtPassword txtServer R class Forml DevExpress XtraEditors XtraForm omponent oid simpleButton2 Click object sender EventArgs e ResetText setText txtUserNam ResetText Application private v Form2 f2 n try f2 rdp S Exit oid simpleButtonl Click object sender EventArgs e ew Form2 rver txtServer Text f2 rdp U IMsTscNon IMsTscNo serName txtUserName Text Scriptable secured nScriptable f2 rdp Get
48. ength if r 0 DataRow drow drow row 0 DataRow drow2 drow2 row2 0 if drow drow2 if drow Utype ToString USER XtraMessageBox Show Access denied Mn You do not have the Privillege to Delete any ID Error MessageBoxButtons OK MessageBoxIcon Error 1 string queryDeleteString DELETE FROM RegDB WHERE Fnama name string queryDeleteString2 DELETE FROM TodayAttDB WHERE Fnama name OleDbCommand sqlDelete new OleDbCommand sqlDelete CommandText queryDeleteString 88 sqlDelete Connection database OleDbCommand sqlDelete2 new OleDbCommand sqlDelete2 CommandText queryDeleteString2 sqlDelete2 Connection database int response 1 int response2 1 try response sqlDelete ExecuteNonQuery response2 sqlDelete2 ExecuteNonQuery catch Exception ex XtraMessageBox Show ex Message if response gt 1 amp amp response2 gt 1 XtraMessageBox Show Profile successfully deleted Successful MessageBoxButtons OK MessageBoxIcon Information 11 else XtraMessageBox Show Access denied n Admin Identification not Matched Error MessageBoxButtons OK MessageBoxiIcon Error else XtraMessageBox Show Access denied n Admin Identification not Matched Er
49. er List interface shows the registered user that can access the Time Attendance system Only the administrator can view the list The list shows user s full name username and the type of account The interface is shown in Figure 4 9 62 Full Name Username MUHAMMAD SAZALI BIN HISHAM ADMIN SAZALI HISHAM SAZALI Figure 4 9 User List Interface 4 4 3 Change Password The system also enables the user to change their corresponding password Both administrator and guest user have the access of this interface as this is a private setting for every user The interface shown in Figure 4 10 63 Figure 4 10 Change Password Interface 4 5 Time Attendance Main Interface IMS in Terminal 09 1133 April 2011 Sun Mon Tue Wed Thu Fri 23 2 1 3 4 5 6 g 8 u 2 B HM 1 i 19 2 2 2 6 2 25 26 27 28 29 3 2 3 4 5 6 Port Name Settin j 0 4 6 Registration Deletion Database mec cr Today 4 18 2011 Figure 4 11 Time Attendance Interface 64 Figure 4 11 shows the main interface of the Time Attendance There are seven menus which are Terminal Registration Deletion Database Time Limit Records and Exit The System Status shows the current status of the system such as whether a session is running or otherwise and whether the time limit has been set or otherwise The Exit menu will close the form and return to the Main Menu interface while the other menus will open the corresponding ta
50. es is directly used to drive the output 2 4 Microsoft Visual Studio Microsoft Visual Studio is an Integrated Development Environment from Microsoft It can be uses to develop console and graphical user interface application along with Windows Forms applications web sites web applications and web services in both native code together with managed code for all platforms supported by Microsoft Windows Windows Mobile Windows CE NET Framework NET Compact Framework and Microsoft Silverlight Visual Studio includes a code editor supporting IntelliSense as well as code refactoring The integrated debugger works both as a source level debugger and a machine level debugger Other built in tools include a forms designer for building GUI applications web designer class designer and database schema designer Visual Studio supports different programming languages by means of language services which allow the code editor and debugger to support to varying degrees nearly any programming language provided a language specific service exists Built in languages include C C via Visual C VB NET via Visual Basic NET C via Visual C and F as of Visual Studio 2010 Support for other languages such as M Python and Ruby among others is available via language services installed 20 separately It also supports XML XSLT HTML XHTML JavaScript and CSS Individual language specific versions of Visual Studio also exist which provide more
51. et It is same goes to the punch card system Workers has to queue up for a long time as each worker need to punch the card and then put it in the slot provided according to their names In summary both system give drawback in term of performance In term of organizing the attendance there is also a possibility where the attendance sheet might be lost and this will cause difficulty to review the attendance Furthermore usually there is no copy of the record As a result this will produce an inaccurate overall attendance counting 1 3 Objectives of Project The main objective in this project is to provide a convenient way of attendance marking using the RFID technology In specific the objectives are I build an attendance system that consists of a GUI with the integration of the RFID technology To enable the attendance system to be monitored remotely 1 4 Scope of Project This project is mainly focused on GUI development There are two parts of GUI to be developed which is the Time Attendance and the Remote Monitoring Client A database also been built to store the data Local Area Network LAN Host Remote Computer Computer RFID Reader Serialto USB Converter Figure 1 1 System Block Diagram Figure 1 1 shows the block diagram of the system The RFID reader is connected to the host computer via serial port or USB port The RFID reader is using RS232 data communication thus a serial to
52. h has to be installed in the host computer The host computer will treats the data similarly to the serial port connection but using different COM port Figure 3 4 USB to Serial Converter 31 3 2 Software Implementation There are two interfaces that to be developed which are the Time Attendance and the Remote Monitoring Client These interfaces are developed using C programming language via Microsoft Visual Studio 2008 In the other hand the databases are built using Microsoft Access 2007 3 21 Microsoft Access Database There are two databases are built using Microsoft Access 2007 The databases named LoginDB and TADB The LoginDB database stores login information for Time Attendance interface This information also used in admin identification for manipulating attendance information In the other hand the TADB database stores all attendance related data The password data is saved in password character as it is a private data Besides that there are two tables inside the TADB database which act as temporary data storage which are SessionDB and TempDB Both tables are essential to the program flows In order to increase the security both databases are password protected 32 Utype gt Add New Field B MUHAMMADS ADMIN ADMIN 15 SAZALI HISHAN SAZALI teen USER New Figure 3 5 LoginDB Database Idno 31 MUHAMMA
53. iage return new line and end of text e Frequency band used 125 kHz Low Frequency 13 2 2 Serial Data Transmission Serial data transmission is widely for transmission of digital data Serial transmission means data is sent one bit after another sequentially bit serial in one transmission line It is also possible to have high data rate through this transmission as the increased time consumption required using this type of transmission is acceptable for most cases Figure 2 2 shows the simple 2 wire for bit serial data transmission transmitter receiver 2 lines 8 bit unit 8 bit unit Figure 2 2 Serial Data Transmission There are three types of data flow direction which are simplex half duplex and full duplex For simplex data direction is only in one flow In the other words it can only transmit or receives data Half duplex direction means the stations have to take turns to transmit data It shares a line to transmit their data so the data transmission for both stations cannot be at the same time The other type is full duplex which data from both stations can exchanges data simultaneously The illustration of the direction of serial data flow can be seen in Figure 2 3 14 unidirectional aap transmission simplex one transmission at a time half duplex bidirectional full duplex AIS Figure 2 3 Different Direction of Serial Data Flow 2 2 4 RS 232 Interface RS 232 Interface Re
54. ing serial data from the interface Work on interfacing database Developing Time Attendance GUI Debugging Hardware Installation and Final Check Presentation Thesis Writing Figure 1 3 Gantt chart of the project schedule for Semester 2 LITERATURE REVIEW 2 1 Radio Frequency Identification RFID Radio frequency identification RFID is a kind of automatic identification technology which uses radio waves as the medium to store or retrieve data stored in a device called RFID tags or transponders The tags can be applied on animals product or a person for the purpose of identification The distance for the tags to be read by the reader is varied based on the frequency of the radio wave A typical RFID system consists of antenna transponder and transceiver The antenna is used by both transponder and transceiver to transmit the radio waves The transceiver reads the radio wave emitted by the transponder and transfers the signal to the processing device A transponder is an integrated circuit that contains information to be transmitted As this technology is using radio frequency signal that s mean it works wireless Generally the reader emits radio wave via an antenna with specified frequency which is the carrier signal When the tags detected the signal from the reade
55. ions for both hosted and embedded systems ranging from the very large that use sophisticated operating systems down to the very small having dedicated functions e Although C applications are intended to be economical with regard to memory and processing power requirements the language was not intended to compete directly on performance and size with C or assembly language 22 2 7 Microsoft Office Access Microsoft Office Access previously known as Microsoft Access is a pseudo relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools It is a member of the Microsoft Office suite of applications included in the Professional and higher editions or sold separately In mid May 2010 the current version Microsoft Office Access 2010 was released by Microsoft in Office 2010 Microsoft Access 2007 was the prior version Access stores data in its own format based on the Access Jet Database Engine It can also import or link directly to data stored in other applications and databases Software developers and data architects can use Microsoft Access to develop application software and power users can use it to build simple applications Like other Office applications Access is supported by Visual Basic for Applications an object oriented programming language that can reference a variety of objects including DAO Data Access Ob
56. jects ActiveX Data Objects and many other ActiveX components Visual objects used in forms and reports expose their methods and properties in the VBA programming environment and VBA code modules may declare and call Windows operating system functions 23 2 8 Remote Desktop Protocol Remote Desktop Protocol RDP is a protocol developed by Microsoft where it enables a computer to have the graphical interface of another user The clients exist for most versions of Microsoft Windows including Windows Mobile Linux Unix Mac OS X and other modern operating systems By default the server listens on Transmission Control Protocol TCP port 3389 The TCP provide the service of exchanging data between to network hosts In order to enable the protocol the host computer makes a connection to Windows Terminal Server and the client computer get the access of the host from the terminal Thus only keyboard mouse and display information are transmitted over the network as all applications are hosted on the Terminal Server As a result it works well even under low bandwidth conditions The system flow diagram of RDP is shown in Figure 2 7 24 RDP connections using port 3389 Terminal Server management tools Figure 2 7 System Flow Diagram of RDP 2 9 Internet Information Service IIS Internet Information Services IIS is a web server application and set of feature extension modules created by Microsoft for use with Microsoft
57. login transaction is shown in Figure 3 7 Figure 3 7 Flowchart of login transaction 34 35 File Edit View Project Build Debug Data Format Tools Test DevExpress Window Help XtraForm1 cs Design XtraFor traForm3 cs Desigr aForm4 cs Design i IMS Integrated Monitoring System Username rd Cancel Figure 3 8 System Login Design Figure 3 8 shows the design of the system login interface Login button handles the login event by searching the username and password inserted in the corresponding textboxes in the database for matched ID The Cancel button control is responsible to close the application The design names of the textboxes are tb_uname and tb pass File Edit View Project Build Debug Data Format Tools Test DevExpress Window Help 1 Edgy dd B X 0 4 B Debug Any CPU 9 EE BH 56 os uz ipi te ogo XP C 22 md gt fele n Toolbox XtraForml cs XtraForml cs Design XtraForm3 c x Solution Explorer Solution 1 2 X DX XAF Win v10 2 amp DX XAF Modules v10 2 1 E DX 10 2 XAF Action Containers t icon ico Connections 98 Program cs 0 10 2 Scheduling H EE XtraForml cs y 9 DX 10 2 Rich
58. mark the attendance of its workers Workers need to slot their attendance card into the punch card machine and put the card into a shell like slot where the authority can review it As technology has advanced integrating the attendance system with an automation technology will provides more convenient way in marking the attendance The Radio Frequency Identification RFID technology is one of an automation technology that is beneficial in improving current traditional way of attendance marking As every tag has its own unique ID it is easy to differentiate every tag holder In addition a Graphical User Interface GUI provides more efficient way to review the attendance Thus the integration of RFID technology and the GUI in an attendance system will produces an automatic system which give better performance and efficiency than the traditional method of attendance marking 1 2 Problem Statement The traditional method of attendance marking has some drawbacks This method obviously not efficient as it wastes the user s energy and quite slow in term of completion For example a class that uses attendance sheet method requires the students to pass the sheet to each other to sign up the attendance If there is a large amount of students it will take time in order to complete the attendance marking Besides that there is possibility that some students might miss their turn to sign the attendance as they did not receive the attendance she
59. ngsi fungsi utama keseluruhan sistem ini terdapat di dalam Time Attendance seperti memaparkan transaksi tag ID secara langsung mendaftar ID memadam ID merekod kehadiran dan diikuti fungsi fungsi sampingan yang lain Perisian Time Attendance ini disimpan di dalam komputer hos Pengawasian jarak jauh boleh dilakukan menggunakan perisian Remote Monitoring Client yang disimpan di dalam komputer remote Remote Monitoring Client ini dibina berdasarkan teknologi Remote Desktop Protocol Komputer hos dan komputer remote berhubung melalui rangkaian dalaman LAN Sistem ini memudahkan pengrekodan kehadiran dan ia dilakukan secara efisyen Selain itu ia menjimatkan tenaga pengguna Sistem ini sesuai untuk kegunaan dalaman seperti di dalam pejabat ataupun di dalam kelas di institusi pengajian TABLE OF CONTENTS TITLE DEDICATION ACKNOWLEDGEMENT ABSTRACT ABSTRAK TABLE OF CONTENTS LIST OF TABLE LIST OF FIGURES LIST OF ABBREVIATIONS LIST OF APPENDICES INTRODUCTION 1 1 Background of Project 1 2 Problem Statement 1 3 Objectives of Project 1 4 Scope of Project 1 5 Work Contribution LITERATURE REVIEW 2 1 Radio Frequency Identification RFID 2 1 1 RFID tags 2 1 1 1 Passive RFID tag 2 1 1 2 Active RFID tag 2 1 2 RFID Frequency Band 2 1 3 IDR 232 RFID Reader 2 2 Serial Data Transmission 2 2 1 RS 232 Interface 2 2 2 UART 2 3 Universal Serial Bus 2 3 1 USB to Serial Converter 2 4 Microsoft Visual Studio 2 5 Microsoft
60. nputs required to connect to the host computer are server name username and password Server name is either the IP address of the host computer or the name of the host computer while the username and password are according to the host computer account setting The interface of login form of the Remote Monitoring Client is shown in Figure 4 26 and a successful connection is as in Figure 4 27 Remote Client Login IMS Remote Glient Interface Server sazali PC Username sazali Password Figure 4 26 Remote Client Interface with ti IMS integrated monitoring system Login Cancel YnHub 1 0 ULFIUSPI 1 12 start 2 KRM Liga Super 2011 00000 Warcraft IIT untitled Paint Documenti Microsof f IMS RemoteCleent Remote cient 0 7 30 Figure 4 27 Successful connection to the host computer 78 5 CONCLUSION AND RECOMMENDATION 5 1 Conclusion In conclusion the objective to build an RFID based attendance system that can be monitored remotely has successfully achieved In term of performance and efficiency this project has provided a convenient method of attendance marking compared to the traditional method of attendance system By using databases the data is more organized This system also is a user friendly system and easy to use as data manipulation and retrieval can be done via the interface Besides that all the data required are in
61. office solution Typically this tag has a useful life of twenty years or more and less expensive The response of a passive RFID tag is not necessarily just an ID number the tag chip can contain non volatile possibly writable EEPROM for storing data 10 2 1 1 2 Active RFID tag Active tag is equipped with a battery as the source of power to the tag s circuitry and antenna Some active tag contains replaceable battery for years to use It is also possible to use external power supply as the power source of the tag As active tag cannot function without a battery it has limited lifetime Active tag can be read from a long distance of hundred feet or more and may have other sensors that can use electricity for power It capable to initiate communication and has higher data bandwidth 2 1 2 RFID Frequency Band Frequency refers to the size of the radio waves used to communicate between the RFID system s components It can be assumed that higher frequency resulting faster data transfer rate and longer reading distance However as frequency increases the sensitivity to environmental factor also increases RFID system currently operates at Low Frequency LF High Frequency HF and Ultra High Frequency UHF Generally a lower frequency means a lower read range and slower data read rate but increased capabilities for reading near or on metal or liquid surfaces The frequency chart is shown in Table 2 1 Frequency De
62. or otherwise under any intellectual property riz5t 94 95 Cytron Product User s minea REB OR ZAN 1 INTRODUCTION AND OVERVIEW RFID IDR 232N is plug and use RFID reader It has been designed with capabilities and features of Low cost solution for reading passive RFID transponder tags Industrial grade casing for better outlook and protection Every reader has been tested before is being 9600 baud RS232 serial interface output only to PC Fully operation with SVDC power supply from USB port Buzzer as sound indication of activity Standard RS232 serial cable female ready to plug to desktop PC USB as power source from desktop PC 2cm reading range 0 1s response time 12 bytes of data received include start of heading RFID ID and start of text RFID IDR 232N is fully working RFID tags reader and can be applied Security system Car parking Office Hypermarket for item pricing Student projects RFID IDR 232N can be connected to PC or microcontroller as part of embedded system This document elaborates the method in using RFID IDR 23 96 yt ROBOT HEAD to TOE tron Product User s Manual RFID IDR 232N 2 PACKING LIST Please check the parts and components according to the packing list If there are any parts missing please contact us at sales cytron com my immediately 1 Ix RFID IDR 232N with Female RS232 cable with USB and RJ11 Cytron gt ROBOT _ HEAD to TOE
63. r it transmits a modulating signal which contains the information that has been stored in its integrated circuit and signal modulation occurs The antenna of the reader then receives the modulated signal and feeds it through signal processing circuit of the reader to translate the information 2 1 1 RFID tags There are three types of RFID tags passive active and semi passive The passive RFID tag requires no internal power source as it gains power from the signal transmitted by the reader Thus it becomes purely passive The active and semi passive tag requires a power source Commonly the power source is a small battery These tags communicate using backscattering or load modulation technique Typically load modulation technique used for short distance reading while the backscattering is used for far field 2 1 1 1 Passive RFID tag The passive RFID tag does not contain a battery The power is supplied by the RFID reader When the tag encounters the radio wave emitted by the reader the coiled antenna inside the tag forms a magnetic field thus current induced The tag draws power from it and energizes the circuit in the tag As a result the tag transmit signal that contain the information of its memory which received by the signal detector of the reader to be processed This type of tag can be read at only short distance typically a few feet at most thus it is more suitable for short distance reading application such as door access and
64. r a match in the database Once the ID found the full name and the ID number of the matched profile ID displayed in the terminal as shown in Figure 4 23 At the same time the attendance will be updated from initially PENDING to OK or LATE The attendance table can be viewed in Today s List feature as shown in Figure 4 24 74 IMS Integrated Monitoring System Time Attendance Port Opened at 4 19 2011 3 35 50 PM MUHAMMAD SAZALI BIN HISHAM Date and Time 4 April 2011 Sun Mon Tue Wed Thu Fri 7 B 31 5 8 15 2 4 29 1 2 3 4 5 6 Terminal Time Limit Records Today 4 19 2011 Figure 4 23 Transaction displayed on the terminal ted Monitoring System Time Attendance MOHAMMAD JLLAH BIN MAZLAN Date and Time 4 April 2011 Sun Mon Tue Wed Thu 30 6 13 20 2 7 4 5 4 Deletion Database Time Limit Records E Today 4 19 2011 Terminal Registration Figure 4 24 Today s List showing the attendance marking 75 4 6 4 Ending a Session Ending a session means stopping from taking the attendance Once the Stop Session event is called the form that shows the summary of that session is called Then record is written into PDF file and the temporary data in the database is cleared Lastly the port is closed The session summary form is shown in Figure 4 25 Tuesday April 19 2011 Figure 4 25 Attendance Summary 76 4 7 Remote Monitoring Client The i
65. raMessageBox Show Registration Successfully Completed Information LoadTADB 1 string SQLString3 SOLString3 INSERT INTO DepDB Dep VALUES org ur OleDbCommand SQLCommand3 new OleDbCommand SOLCommand3 CommandText SQLString3 SOLCommand3 Connection database int response3 1 try response3 SQLCommand3 ExecuteNonQuery catch Exception ex MessageBox Show ex Message if response3 gt 1 XtraMessageBox Show Registration Successfully Completed Information LoadTADB endregion Delete 87 private void Deletename name tb delname Text uname tb deluname Text pass tb delpass Text int re 0 DataRow returnedrow returnedrow ds2 Tables RegDB Select Fnama name re returnedrow Length Dat dri XUI dri if re 0 aRow drl returnedrow 0 aMessageBox Show Record Found Fnama ToString Record Found MessageBoxButtons OK MessageBoxIcon Information Di IE alogResult result result XtraMessageBox Show Delete This Profile Confirmation MessageBoxButtons YesNo MessageBoxIcon Question result DialogResult Yes int r 0 DataRow row row dsl Tables PassDB Select Unama uname r row Length int r2 0 DataRow row2 row2 dsl Tables PassDB Select Pass pass r2 row2 L
66. ric Text dr ItemArray GetValue 2 ToString tb dep Text dr ItemArray GetValue 3 ToString tb idno Text dr ItemArray GetValue 4 ToString string x dr ItemArray GetValue 7 ToString tb tagid Text HexString2Ascii x tb datereg Text dr ItemArray GetValue 6 ToString tb fname ResetText tb nric ResetText tb dep ResetText tb idno ResetText tb tagid ResetText tb datereg ResetText tb absent ResetText r2 ds2 Tables TodayAttDB Rows Count r2 0 DataRow dr2 ds2 Tables TodayAttDB Rows inc tb absent Text dr2 ItemArray GetValue 9 ToString out of dr2 ItemArray GetValue 8 ToString meeting s fendregion APPENDIX IDR 232N RFID READER MANUAL 93 Cytron Technologie RFID READER RFID IDR 232N USER S MANUAL V1 2 September 2010 eformatice comrmed in tes publcinon remands device xphorzomi and the like 1 inmoded throwsh onb and maw be superseded by updates X is your rez to ensure that your application mests with your specification No or warranty is given and no liability is assumed by Cyton Technologies Incorporated with respect to the accuracy Gr wee of sach information in ngscnant of patents cc other intoll ctual property right arising fom such use cc otherwise Use Seen ee ees R ee ee a o uritan approval by Cytron Technologies No Ecamses are conveyed
67. ror MessageBoxButtons OK MessageBoxIcon Error 11 else XtraMessageBox Show Record Not Found Error MessageBoxButtons OK MessageBoxIcon Error LoadTADB tb deluname ResetText tb delpass ResetText tb delname ResetText tb delid ResetText endregion Load Database region Load 89 Database private void LoadPassDB string connectionString Provider Microsoft Jet OLEDB 4 0 Data Source Databases LoginDB mdb Jet OLEDB Database Password admin database new OleDbConnection connectionString database Open string sql SELECT FROM PassDB dsl new DataSet da new System Data OleDb OleDbDataAdapter sql da Fill ds1 PassDB dal new System Data OleDb OleDbDataAdapter SELECT FROM LogDB database 1 111 451 LogDB database private void LoadTADB string connectionString2 Provider Microsoft Jet OLEDB 4 0 Data Source Databases TADB mdb Jet OLEDB Database Password admin database new OleDbConnection connectionString2 database Open da new System Data OleDb OleDbDataAdapter SELECT FROM RegDB database dal new System Data OleDb OleDbDataAdapter SELECT FROM TodayAttDB database da2 new System Data OleDb OleDbDataAdapter SELECT FROM SessionDB database da3 new System Data OleDb OleDbDataAdapter SELECT TempDB database
68. scription Operating Application Benefit Drawback Band Range 125 kHz to Low lt 5 e Access Works Short read 134 kHz frequency 1 5 ft Control well range and e Animal around slower Tracking water and read rate e Vehicle metal Immobilizer product S e Product Authenticati on e POS Application 13 56 MHz High lt Imor3 e Smartcards Low cost Higher frequency ft e Smart of tags read rate shelve tag than LF for item level tracking e Library books e Airline baggage e Maintenance data logging 860 MHz Ultra High 3morO9ft e Pallet EPC Does not to 930 Frequency tracking standard work well MHz UHF e Carton built with high tracking around water or e Electronic this metal toll frequency content collection e Parking lot access 2 4 GHz Microwave e Airline Most Fastest baggage expensive read rates e Electronic toll collection Table 2 1 RFID Frequency Chart 11 12 2 1 3 IDR 232 RFID Reader Figure 2 1 IDR 232 RFID Reader Description and specifications e 9600 baud RS232 serial interface output only to PC e Fully operation with 5VDC power supply from USB port e Red and green color LED for visual indication of activity e Standard RS232 serial cable female ready to plug to desktop PC e USB as power source from desktop PC e 2cm reading range e 0 15 response time 14 bytes of data received include start of text RFID ID carr
69. t manipulate it as used to display the data in the database interface Furthermore try catch statement is implemented to control the program exception during the queries string SQLString SOLString INSERT INTO RegDB Fnama Icno Org Idno Tagid Datereg Tagid2 VALUES name Replace TN nric 9 m idno I ConvertToHex tagid 2 DateTime Now ConvertToHex tagid OleDbCommand SQLCommand new OleDbCommand SOLCommand CommandText SQLString SQLCommand Connection database int response 1 response SQLCommand ExecuteNonQuery catch Exception ex MessageBox Show ex Message if response gt 1 Figure 3 24 Example of the usage of SQL queries with try catch statement DataRow dr ds2 Tables RegDB Rows i tb fname Text dr ItemArray GetValue 1 ToString tb nric Text dr ItemArray GetValue 2 ToString tb dep Text dr ItemArray GetValue 3 ToString tb idno Text dr ItemArray GetValue 4 ToString string x dr ItemArray GetValue 7 ToString tb tagid Text HexString2Ascii x tb datereg Text dr ItemArray GetValue 6 ToString nc Figure 3 25 Displaying data in database interface using data row method 51 3 2 3 3 ASCII to Hexadecimal Converter In order to convert ASCII format number into hexadecimal String format command used A for
70. us CPU ADDR Bus a CTRL Control States Generator amp Data Reg Transmitter TxD Figure 2 6 UART Architecture 17 CPU Bus Controller provides the parallel data I O interface to the local processor bus It generates the control signal to enable the CPU to have the access onto the data status and control register in the UART circuit The Baud Rate Generator generates a periodic pulse which determines the baud rate of the transmission This transmit and receive bit timing device is programmable so the baud rate can be set according the programming value The transmitter is responsible for serial transmitting of the data which is written by the CPU onto the TxD Hold Register or FIFO at the CPU Bus Controller block while the receiver block detects the start bit of the incoming serial data and sample the data bit by bit according to the baud clock of the baud rate generator It complete the receive process of a symbol 6 7 or 8 bit of data after detecting the stop bits It also executes parity check to ensure the correctness of the frame of data 2 3 Universal Serial Bus Universal Serial Bus USB is a bus system which allows more than one peripheral to be connected to a host computer via one USB port Hubs can be used in the USB chain to extend the cable length and allow for even more devices to connect to the same USB port The standard not only describes the physical properties of the interface but

rfid-based attendance system with remote monitoring muhammad

Contents

Download Pdf Manuals

Related Search

Related Contents