Đang Thực Hiện

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

Kĩ năng: ASP.NET, IIS, Microsoft SQL Server, VB.NET, Visual Basic

Xem nhiều hơn: twilio sms registration, twilio c#, twilio org login, appointment scheduling asp.net 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

Về Bên Thuê:
( 0 nhận xét ) San Mateo, United States

ID dự án: #18898090

Được trao cho:

khanicha

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 Thêm

$300 USD trong 2 ngày
(11 Đánh Giá)
7.8
Constructionist

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 Thêm

$250 USD trong 4 ngày
(1 Nhận xét)
1.1

27 freelancer đang chào giá trung bình $587 cho công việc này

giviniinternet

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 vb.net I have 8+ year exp. in a Thêm

$750 USD trong 10 ngày
(215 Nhận xét)
8.1
ask2itsolutions

We have good experience team in asp.net, 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 Thêm

$750 USD trong 20 ngày
(13 Nhận xét)
7.1
arityinfoway

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 Thêm

$616 USD trong 10 ngày
(45 Nhận xét)
6.3
shaktistanwar

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 Thêm

$555 USD trong 10 ngày
(23 Nhận xét)
6.4
TSCreators

Hi Dear , I have 4 year experience over vb.net asp.net(webform 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] Thêm

$555 USD trong 10 ngày
(34 Nhận xét)
5.4
mingxiao2008

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. Thêm

$500 USD trong 10 ngày
(6 Nhận xét)
5.5
adeelpirzada

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 Thêm

$250 USD trong 10 ngày
(11 Nhận xét)
5.2
sanjaybhansali

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

$777 USD trong 10 ngày
(6 Nhận xét)
4.2
ludiac

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 trong 10 ngày
(3 Nhận xét)
4.2
devbaloni1983

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 Thêm

$555 USD trong 10 ngày
(15 Nhận xét)
4.2
novepi1

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 Thêm

$550 USD trong 7 ngày
(2 Nhận xét)
3.5
binarycodersvw

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 Thêm

$1357 USD trong 10 ngày
(4 Nhận xét)
3.4
rsharma583

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 Thêm

$555 USD trong 10 ngày
(7 Nhận xét)
3.4
Sivamurugan13

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 Thêm

$250 USD trong 4 ngày
(11 Nhận xét)
3.2
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we Thêm

$250 USD trong 5 ngày
(4 Nhận xét)
2.9
Webbleu

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 Thêm

$555 USD trong 10 ngày
(1 Nhận xét)
2.4
kusal77

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 Thêm

$295 USD trong 10 ngày
(2 Nhận xét)
1.8
akhileshgandhi

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 Thêm

$600 USD trong 10 ngày
(1 Nhận xét)
1.4
udalcorpo

Respected Sir, Greetings of the Day ! I am Subham Das. I have 9+ years of competitive experience in web application development using asp.net web form and SQL server. I have 7+ years of experience in Database Thêm

$666 USD trong 20 ngày
(1 Nhận xét)
1.9
ENVERITE

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 Thêm

$350 USD trong 5 ngày
(2 Nhận xét)
0.4