A service/module to send, receive and process SMS messages from an existing University Management System. The code must be in Delphi 7 and should connect to an SQL Server 200x database. In the SQL Server database, we have a table called "Students" which stores details about students, including "CellPhoneNumber". Outbound and Inbound messages should be stored in a table called "Messages" with fields like Direction, Sender, Destination, Body, Status e.t.c.
Preferably, the module/service should work outside the campus system so that it can be called from other application, including a web-based version of the campus system. To this end, the service/module should continually query the database for new/unprocessed messages and process on them. To process inbound messages, the service should accept user defined codes respond by sending back appropriate information. The senders cellphone number is used to determine the validity of the user. For example, a student can register via sms as follows:
REGISTER BUS1, BUS2, BUS2
Where BUSx is a subject being offered in the current semester/term.