Schedule SQL Jobs in Azure

Hello Guys,

Here I'm providing link from where you will get step by step information in order to schedule SQL job in Azure.

https://www.netwoven.com/2017/12/12/schedule-execution-sql-jobs-azure-automation-service/

Workflow to call Stored procedure e.g.

workflow RB_Daily_Job
{
Write-Output('RB_Daily_Job job starting.')
Write-Output('Job is calling UpdateStatus SP.')
$dataTable = RB_Record_AzureScheduler -sqlServer 'dbtest.database.windows.net' -Database 'dbTest' -SprocName 'UpdateStatus' -Parameters '' -SqlCredentialName 'SQLDBCredential'
Write-Output('('RB_Daily_Job  job executed successfully.')
}

Thanks

Build Proactive Bot

Hello techies,

Here I'm sharing a link to know how Proactive BOT is working.

https://www.youtube.com/watch?v=Am1NPUceFvA&t=1s

Send SMS using Twilio API in C#

Hello Friends,

Here, I'm providing link to send SMS using Twilio API in C#.

https://www.twilio.com/docs/sms/quickstart/csharp-dotnet-core#sign-up-for-twilio-and-get-a-twilio-phone-number

Twilio API has all the features to know status of SMS & it's very easy to integrate in application.

Thanks

Integrate Bootstrap Full year calendar control

Hello Friends,

Here, I'm providing links where we've all the information to integrate Bootstrap Full year calendar control.

This control has all inbuilt functionality like.

• Show event information on tooltip
• Show booked event with different background color
• Open modal pop-up to add event data

URL : http://www.bootstrap-year-calendar.com/#Examples/Full%20example

Feel free to reach me if you face any difficulty while integrating it.

Thanks

Paste JSON As Class Or XML As Class in Visual Studio

Hello Friends,

In this article I'm explaining how we can quickly create class entities from json/xml data.

let's consider we've below JSON data based on it we've to generate class with same entity name.

How to generate class within Visual Studio

Step 1: Create a blank class

Step 2: Delete high lighted code. And keep your cursor inside namespace curly braces

Step 3: Open menu as per high lighted sub menu

Step 4 : Paste JSON code in class

Here you can see your JSON data have been converted into class. You can follow same step to paste XML As Class convert.