18-07-2011, 02:59 PM
[attachment=14591]
Sms library.
INTRODUCTION
Mobile and cellular technology-most common.
Our idea uses cell phone to check availability of books in a library, reserve a book and to remind the due date.
User friendly, reliable and fast.
This project is developed in .NET as WinFroms using C# as the frontend and MS Sql Server as the back end. The server system has a GSM-modem which receives the sms sent by the registered users.
GENERAL FLOW
MODULES
Registration
Transaction
Search & Reservation
Read SMS
Sent SMS
REQUIREMENT ANALYSIS
SOFTWARE REQUIREMENTS
Platform : .NET Framework 3.5
Front End : WinForms
Back End : MS SQL Server 2005
IDE : Visual Studio 2008
Operating System : WIN XP
HARDWARE REQUIREMENTS
Processor : Pentium IV or above
Main Memory : 1 GB RAM
Cache Memory : 512 KB
CPU Speed : 1.9 GHz or above
Hard Disk Capacity : 20 GB or above
GSM Modem SIM 300
ARCHITECTURE DESIGN
3-Tier
Presentation Layer.
Business Logic Layer.
Data Access Layer (DAL).
REGISTRATION
Book Registration
User Registration
BOOK REGISTRATION
USER REGISTRATION
TRANSACTIONS
TRANSACTIONS
BOOK RETURN
BOOK SEARCH(DESKTOP)
RESERVATION(DESKTOP)
REPORTS
SMS HANDLING
BY GSM MODEM
Connected through a serial cable.
Requires a SIM card .
Support AT Commands & Extended AT Commands.
AT-Attention Telephone or Attention Terminal.
With the extended AT commands:
Reading Writing & Deleting SMS.
Sending SMS.
Monitoring the signal strength.
AT COMMANDS
+CMGS - Send Message
+CMGR - Read Message
+CMGL - List Messages
+CMGW - Write Message to Memory
AT+CMGF=1 -Operate in text mode.
AT+CMGL="ALL“ –Read all messages.
AT+CMGL="REC UNREAD“-Read unread messages
SMS READING
We use AT+CMGL =“REC UNREAD”it retrieves
1. Index
2.Status
3.Orginator phone no:
4.Text associated orginator
5.Time & Date.
6.Body &Length.
Example- AT+CMGL=“REC UNREAD”
+CMGL:1,"REC UNREAD","+8089794241",,"07/02/18,00:05:10+32"Reading text messages is easy.
Message Formats(1/2)
CARE
Replay
SUB-For getting Subject code.
SUBC<>SUBJECT_CODE- Details of available books.
RES<>BOOK_CODE-Reservation
SUB
Replay-Subject code
Eg: DBMS-database Mgt System.
CP -C Programming.
Message Formats(2/2)
3.SUBC <>SUBJECT_CODE
Eg:SUBC CP
Replay
CP01-Balaguruswamy(10)
CP02-K R Venugopal(5)
CP03-K John(0)
4.RES<space>BOOK_CODE
Eg:RES CP03
Replay: Book is Reserved.
SMS ALERTS
Alerts for return dates.
Alerts for Fine.
Alerts if reserved book is available.
CONCLUSION
This project aim to explain one of the application of GSM modem.
This can be extended to other fields like sms controlled switches, ticket reservation .
Economically feasible.
Sms library.
INTRODUCTION
Mobile and cellular technology-most common.
Our idea uses cell phone to check availability of books in a library, reserve a book and to remind the due date.
User friendly, reliable and fast.
This project is developed in .NET as WinFroms using C# as the frontend and MS Sql Server as the back end. The server system has a GSM-modem which receives the sms sent by the registered users.
GENERAL FLOW
MODULES
Registration
Transaction
Search & Reservation
Read SMS
Sent SMS
REQUIREMENT ANALYSIS
SOFTWARE REQUIREMENTS
Platform : .NET Framework 3.5
Front End : WinForms
Back End : MS SQL Server 2005
IDE : Visual Studio 2008
Operating System : WIN XP
HARDWARE REQUIREMENTS
Processor : Pentium IV or above
Main Memory : 1 GB RAM
Cache Memory : 512 KB
CPU Speed : 1.9 GHz or above
Hard Disk Capacity : 20 GB or above
GSM Modem SIM 300
ARCHITECTURE DESIGN
3-Tier
Presentation Layer.
Business Logic Layer.
Data Access Layer (DAL).
REGISTRATION
Book Registration
User Registration
BOOK REGISTRATION
USER REGISTRATION
TRANSACTIONS
TRANSACTIONS
BOOK RETURN
BOOK SEARCH(DESKTOP)
RESERVATION(DESKTOP)
REPORTS
SMS HANDLING
BY GSM MODEM
Connected through a serial cable.
Requires a SIM card .
Support AT Commands & Extended AT Commands.
AT-Attention Telephone or Attention Terminal.
With the extended AT commands:
Reading Writing & Deleting SMS.
Sending SMS.
Monitoring the signal strength.
AT COMMANDS
+CMGS - Send Message
+CMGR - Read Message
+CMGL - List Messages
+CMGW - Write Message to Memory
AT+CMGF=1 -Operate in text mode.
AT+CMGL="ALL“ –Read all messages.
AT+CMGL="REC UNREAD“-Read unread messages
SMS READING
We use AT+CMGL =“REC UNREAD”it retrieves
1. Index
2.Status
3.Orginator phone no:
4.Text associated orginator
5.Time & Date.
6.Body &Length.
Example- AT+CMGL=“REC UNREAD”
+CMGL:1,"REC UNREAD","+8089794241",,"07/02/18,00:05:10+32"Reading text messages is easy.
Message Formats(1/2)
CARE
Replay
SUB-For getting Subject code.
SUBC<>SUBJECT_CODE- Details of available books.
RES<>BOOK_CODE-Reservation
SUB
Replay-Subject code
Eg: DBMS-database Mgt System.
CP -C Programming.
Message Formats(2/2)
3.SUBC <>SUBJECT_CODE
Eg:SUBC CP
Replay
CP01-Balaguruswamy(10)
CP02-K R Venugopal(5)
CP03-K John(0)
4.RES<space>BOOK_CODE
Eg:RES CP03
Replay: Book is Reserved.
SMS ALERTS
Alerts for return dates.
Alerts for Fine.
Alerts if reserved book is available.
CONCLUSION
This project aim to explain one of the application of GSM modem.
This can be extended to other fields like sms controlled switches, ticket reservation .
Economically feasible.