Availability reminder/update system via SMS texting (VB.NET, SQL Server, Twilio)

The basic application is to remind and to request status updates from users each day via SMS text messages when they have not “checked-in” to our in-house application as to their availability. Once a reminder is sent each day, a user can then respond to the text message with a simple ‘Y’ or ‘N’ response that will trigger an update into the database. The application needs to implement essential logic to ensure only sending a maximum of one message per day, to stop sending messages after a repeated number of non-responses, and allowing for users to immediately cease sending reminder messages.

• All code should be written in VB.NET using Microsoft .NET framework 4.5 or later

• The database will be SQL Server 2016 or later

• Sending and receiving text messages should be via Twilio using their APIs ([login to view URL])

• The application needs to implement Twilio REST API webhook callback support using Windows IIS Server (version 8.0 or later)

• A single table with the following schema:

o [User_Name] [nvarchar](50) NOT NULL,

o [Last_Check_In_Time] [datetimeoffset](7) NULL,

o [User_Current_Status] [nchar](10) NULL,

o [Last_SMS_Sent_Time] [datetimeoffset](7) NULL,

o [Last_SMS_Received_Time] [datetimeoffset](7) NULL,

o [User_SMS_Phone_Number] [nvarchar](50) NULL,

o [Twilio_Last_MessageStatus] [nvarchar](50) NULL,

o [Twilio_Last_MessageSid] [nvarchar](50) NULL,

o [Twilio_Last_SmsStatus] [nvarchar](50) NULL,

o [Twilio_Last_SmsSid] [nvarchar](50) NULL,

o [SMS_Sent_No_Reply_Count] [int] NULL,

o [User_Enabled] [bit] NULL,

o [User_Time_Zone] [nvarchar](50) NULL,

o [User_Weekend_Alerts][bit] NULL

• The developer should use SQL Server 2016 “AT TIME ZONE” capability to simplify queries

• The basic logic as follows for each time the console application is run:

o To initiate requests there will be an hourly scheduled console application executed to send requests

o All records to have a SQL Server timezone populated in [User_Time_Zone]. If blank then use “Pacific Standard Time” as default

o Search for any records where the user is enabled [User_Enabled], has not checked in yet [Last_Check_In_Time] (populated by different application) since between midnight of current day and 10AM (adjusting for user’s local time zone from [User_Time_Zone]) and send an SMS text asking “Please update your availability status by responding ‘Y’ or ‘N’?”

o Keep track of SMS messages sent in the [Last_SMS_Sent_Time] field and do not send more than one SMS text message per day

o Do not send messages on weekends unless [User_Weekend_Alerts] is True

o For each text message sent without a reply increase the [SMS_Sent_No_Reply_Count] record by one. If a response is received reset the count to zero.

o If after 7 days of sending results with no reply then update database to disable user from future sending and send email alert as to the status change

o Record all Twilio callbacks with most recent message and SMS transmission status

o If user replies with text message then record into [User_Current_Status] field and [Last_SMS_Received_Time]

o If user replies with “STOP” then then update database to disable user from future sending and send email alert as to the status change

o The console application should provide reasonable debugging/operational information for Twilio requests to the console and to a text file. The wehook code should also log reasonable responses to a text file.

• The final project deliverable to be a Visual Studio 2012+ Solution

Taidot: ASP.NET, IIS, Microsoft SQL Server, VB.NET, Visual Basic

Näytä lisää: twilio sms registration, twilio c#, twilio org login, appointment scheduling mvc, twilio receive sms c#, twilio sms console, twilio sms log, how to set reminder in asp net c#, addin outlook vb net sql server, assignment project design inplement windows desktop application vb net sql server meeting room database, company creating sms application vb net, data tranfer vb net sql, develop payroll vb net sql server2005, display result vb net sql, fingerprint based attendance system vb net sql sever, mobile vb net sql server sample, save image table vb net sql server, saving xml files vb net sql server, tutorial sms banking system net sql server, vb net sql readxml update

Tietoa työnantajasta:
( 2 arvostelua ) San Mateo, United States

Projektin tunnus: #18898090

Myönnetty käyttäjälle:


This would be easier if the webhook written in classic so no complicated deploy. No worry about json POST parsing as I already the module. Also it can be used for POST the request to Twilio REST API Relevant Skills a Lisää

$300 USD 2 päivässä
(28 Arvostelua)

Hey, Interesting project I really like twillio api's. I have experience creating SMS​ based. Net applications. I worked on a 3rd party prison communication system where families could send sms's into the system wher Lisää

$250 USD 4 päivässä
(2 Arvostelua)

23 freelanceria on tarjonnut keskimäärin 602$ tähän työhön


Hi, sure, I have already done this kind of work with twillio. I can show you demo as well. I will get this application build for you with all requirements you have mentioned in I have 8+ year exp. in a Lisää

$750 USD 10 päivässä
(229 arvostelua)

We have good experience team in, mvc, angular, we can handle any small to big complex projects. Portfolio HelpDesk [login to view URL] admin[at][login to view URL], admin123 EZTBM Lisää

$750 USD 20 päivässä
(16 arvostelua)

Hi I have worked on twilio I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong Lisää

$555 USD 10 päivässä
(33 arvostelua)

Hello Sir, I have gone through your requirements regarding Availability reminder/update system via SMS texting (VB.NET, SQL Server, Twilio). we brief and understand your idea and preference for job as you are look Lisää

$616 USD 10 päivässä
(48 arvostelua)

hi, i read your requirements on reminder app on .net. I am an Experienced Full Stack Lead Developer with a Decade of Experience in versatile software development methods and technologies. Expertise in C#, Python, Nod Lisää

$250 USD 10 päivässä
(14 arvostelua)

Hi Dear , I have 4 year experience over and mvc) for responsiveness work on bootstrap. you can see our sites and portfolio in our site below is the url: [login to view URL] Lisää

$555 USD 10 päivässä
(37 arvostelua)

I have massive experience using SMS API's . I build SMS system with my Previous employer to send reminder . check logins , send useful info using clickatell API... I am a Senior .Net Developer and Dedicated D Lisää

$295 USD 10 päivässä
(11 arvostelua)

Hello, Dear How are you? I have read your project description and am ready for discussing with you about project for now. I have experienced in developing ASP.NET, IIS, Microsoft SQL Server, VB.NET, Visual Basic. Lisää

$500 USD 10 päivässä
(8 arvostelua)

Dear Hiring Manager, I'm a Software Developer with 10+ experiences in software development and I'm very interested in your job post. I have very good experience in SQL server. I have good experience [login to view URL], MVC, Angu Lisää

$555 USD 10 päivässä
(26 arvostelua)

Dear sir, hello sir I have 10 year experience in both asp and technology. I have read your requirements carefully and I am confident to do this work perfectly... I have made lots of project like this . Lisää

$777 USD 10 päivässä
(6 arvostelua)

Hi there, We've read and understood the requirements of the job. Is it possible to use C# instead of VB.Net? We are good with rest. Looking forward to work with you. Thank you!

$555 USD 10 päivässä
(3 arvostelua)

Hi Sir, I read your description very carefully.. Yes I can fullfill your work.. I build so many Window Application and ASP.NET in my past days. And am also strong in DB side. so i can handle your project and do Lisää

$250 USD 4 päivässä
(17 arvostelua)

Hi there, Everything is crystal clear from top to bottom so no questions really except one. Is the email alert will be sent to a certain support email address you'll be watching or to the user's own address? If it's Lisää

$550 USD 7 päivässä
(2 arvostelua)

Hi.I am a Visual Basic .NET programmer with 14 years experience(others say this too but I can show proof). This is not another automated bid like the ones you see around. I have read the description of your project an Lisää

$1357 USD 10 päivässä
(4 arvostelua)

I have gone through your application details . I will deliver you Console application with all requested features like check whether SMS sent for today is user check in or not , if yes not wait for reply or send again Lisää

$555 USD 10 päivässä
(7 arvostelua)

Hello Web have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. I have done 557+ projects successfully an Lisää

$555 USD 10 päivässä
(1 arvostelu)

Hello. I have gone through your job description. MoreYeahs has 90+ dedicated developers working at our development center based in India. We have worked with many enterprises which are in to Real Estate, Manufacturing Lisää

$600 USD 10 päivässä
(2 arvostelua)

Hi i am a french VB, VB.NET and C# expert. I am ready to develop your tool. I need more information about your functionals and technicals specifications. I can start asap. if you need more information about me, you c Lisää

$350 USD 5 päivässä
(3 arvostelua)

Hi, I am a Microsoft Certified Developer, with more than 9 years experience in software companies, successfully delivering projects to my customers, building teams and coordinating complex projects for big companies Lisää

$550 USD 3 päivässä
(1 arvostelu)

Hi there,    Greetings,  I wish to have a discussion on chat. Please check once.. 1. Case Management system. [login to view URL] you can create activity, can view on cale Lisää

$1500 USD 281 päivässä
(0 arvostelua)