Posts

Showing posts from May, 2020

Send mail when Rss news is published using Logic Apps - Azure portal

Image
Basically Logic App is use to Automate the process  Today we are going to demonstrate How to Send Mail(gmail) using Logic App when new Item or news feed is published step 1 :- Create Logic App using Azure Portal , give any meaningful name to the logic App  step 2 :- step 3 :- click on create and after that when app get published click on Go To Resources and go inside newly created Logic App and click on Blank Logic App step 4:- click on RSS  and Search for action like when a feed item is published after that provide  url  :-  http://feeds.reuters.com/reuters/topNews  and click on next step step 5 :- Add Gmail account add necessary details and allow access to use logic app  and select action send mail  step 6 :-  click on the save Button and Run the Logic App step 7 :- Go to gmail and check after sometime  step 8 :- Go to Azure portal inside logic app check summery of mail and after that go to overview and disab

Create Azure Table Storage using console Application

Image
Create a C# Console Application using Visual Studio   Install  Below DLL Using Nuget Package WindowsAzure.Storage Microsoft.WindowsAzure.ConfigurationManager Inside of your Console app, you will see  App.config , now add the following section: <appSettings> <add key="StorageConnection" value="YOUR-CONNECTION-STRING-COPIED-FROM-EARLIER"/> </appSettings> Copy the following code into your Main method:            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(             CloudConfigurationManager.GetSetting("StorageConnection"));             CloudTableClient tableClient = storageAccount.CreateCloudTableClient();             // Name of table to be create             CloudTable table = tableClient.GetTableReference("AzureDemo");             table.CreateIfNotExists();             Console.ReadKey(); Run the Project  This code will get our connection string from the 

Retrieve Data From Multiple Tables Using Asp.Net MVC

Image
Today, in this article, we will see the step-by-step process of joining multiple tables using LINQ Join and displaying records in a View. So, let's start. Step 1 Open SQL server and create a database and 3 tables. I have created three tables as - Employee, Department, and Incentive respectively. Employee Table CREATE TABLE [dbo].[Employee](     [EmployeeId] [int] IDENTITY(1,1) NOT NULL,     [Name] [nvarchar](50) NULL,     [Gender] [char](10) NULL,     [Age] [int] NULL,     [Position] [nvarchar](50) NULL,     [Salary] [int] NULL,     [HireDate] [datetime] NULL,     [Department_Id] [int] NULL,     [Incentive_Id] [int] NULL,     CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED      (         [EmployeeId] ASC     )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]     ) ON [PRIMARY]          GO    Department Table CREATE TABLE [dbo].[Department](    

How To Upload Multiple Images /Files into Database Using Angular web Api

Image
Introduction  In this article, I am going to explain how to upload multiple images using angular 8 and Web API, This article will help beginners who are getting started with Angular. Prerequisites Angular 8 Web API SQL Server HTML/Bootstrap  Steps required Create a database and  tables in SQL Server Create a Web API using ASP.NET Web API Create a new project in Angular   Create Database using Sql server create   database  db_multiplefile Create Table using using below fileds Id ,ImageName, and remark  I Have Created Web Api Project using Visual studio 2019 Now Create Edmx for Dababase Operations  Now Create a Empty controller I Have Created Controller name  FileUploadController I am sharing all code that I have written for controller  using FilesUpload.Models; using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http;