ACE collects weekly commodity prices from 30 markets, In each market there is a trade agent who collects the prices and send to the System Administrator through SMS codes, who upload to the system. Farmers subscribe to receive these market prices through SMS.
We want the system to generate and send sms to a list of eligible recipients using data from the database.
A farmer can receive a sms with commodity prices for a market of their choice. The sms should contain the market and commodities a farmer has chosen and send it to the phone number of the farmer.
There are 2 rules, If you select one commodity per SMS alert you have maximum of 6 Markets to select for one commodity and if you select two commodities then you will have maximum of 3 markets per commodity .
When setting up the alert the following details are required.
3. Price type
4. Start and end date
5. Day to send out the SMS
The database stores data of the recipient as well as content of the sms (which are the weekly market prices).
Below is a snapshot of a section of the database.
The database is already designed but what remains is the generation of the sms and the queuing.
4 freelancers are bidding on average $678 for this job
Hello Sir We have read your requirements and they are very much clear to us We have already developed many .net applications Waiting for your response Regards