C# Artificial Intelligence Login Details - Application Based On SQL Store Procedure

Introduction

Artificial Intelligence is built to perform smart tasks. This application shows the login detail record values based on a SQL store procedure. Voice recognition receives the input string value showing the output parameters. First, we must create a simple SQL database. Then create a simple table and insert some sample values.

SQL Database Process

Step 1 - SQL Database Creation

The database name is MobileContact.

CREATE DATABASE MobileContact;

Step 2 - Create a sample table

The Table name is Contact.

CREATE TABLE Contact (
ID int NOT NULL,
Username nchar(10),
Mobile nchar(10)
PRIMARY KEY (ID),
pword nchar(10),
MailID nchar(20)
);

Step 3 - Inserting Sample Records

insert into Contact(Username,Mobile, pword, MailID) Values('Barath','12345', ‘test123 ’,’ BarathID’);

Step 4 - Create the Random select Procedure

The randomly selected procedure name is the login.

Create PROCEDURE login @ID nchar(10)
AS
Select * from Contact where ID=@ID
go

Step 5

Declare the Class Headers. (Speech.Recognition, Speech.Synthesis, System.Data, System.SqlClient)

using System.Speech.Recognition;
using System.Speech.Synthesis;

using System.Data;
using System.Data.SqlClient;

SQL Database connection string,

public static string sqlDataSource = "Data Source=DESKTOP-UG1HSPR\\SQLEXPRESS;Initial Catalog=MobileContact;Integrated Security=True";

Sample Code of Console Application

The console application is suitable for C# AI development.
In an open-source operating system and in the testing process it's easy to add more reference edition classes.
It has a low build time.

Step 1

Create a new project

Step 2

Select Console Application

Step 3

Open Program.cs to type the below code

Explanation of RecognizeSpeechAndWriteToConsole()

After creating a Recognize speech and write to console, recognize that the string value has loaded grammar. If speech is recognized, call the specified method. Then Set the input to the default audio device to Recognize speech asynchronously.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Threading;
using System.Speech.Recognition;
using System.Speech.Synthesis;
using System.Data;
using System.Data.SqlClient;
namespace AI1
{
class Program
{
static SpeechRecognitionEngine _recognizer = null;
static ManualResetEvent manualResetEvent = null;
static void Main(string[] args)
{
manualResetEvent = new ManualResetEvent(false);
Console.WriteLine("To recognize speech, and Show 'Login Details" +
"' to the console, press 0");
ConsoleKeyInfo pressedKey = Console.ReadKey(true);
char keychar = pressedKey.KeyChar;
Console.WriteLine("Please Tell me your username '{0}'", keychar);
switch (keychar)
{
case '0':
RecognizeSpeechAndWriteToConsole();
break;
}
if (keychar != '5')
{
manualResetEvent.WaitOne();
}
if (_recognizer != null)
{
_recognizer.Dispose();
}
Console.WriteLine("Press any key to continue . . .");
Console.ReadKey(true);
}
static void RecognizeSpeechAndWriteToConsole()
{
_recognizer = new SpeechRecognitionEngine();
_recognizer.LoadGrammar(new Grammar(new GrammarBuilder("Barath")));
_recognizer.LoadGrammar(new Grammar(new GrammarBuilder("Logout")));
_recognizer.SpeechRecognized += _recognizeSpeechAndWriteToConsole_SpeechRecognized;
_recognizer.SpeechRecognitionRejected += _recognizeSpeechAndWriteToConsole_SpeechRecognitionRejected;
_recognizer.SetInputToDefaultAudioDevice();
_recognizer.RecognizeAsync(RecognizeMode.Multiple);
}
static void _recognizeSpeechAndWriteToConsole_SpeechRecognized(object sender, SpeechRecognizedEventArgs e)
{
if (e.Result.Text == "Barath")
{
string val = "Barath";
SqlConnection dc = new SqlConnection("Data Source=DESKTOP-UG1HSPR\\SQLEXPRESS;Initial Catalog=MobileContact;Integrated Security=True");
using (SqlCommand cmd = new SqlCommand("login", dc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@username", val.ToString());
dc.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (!dr.Read())
{
Console.Write("Record not found ");
}
else
{
string b = Convert.ToString(val);
b = dr[1].ToString();
string c = Convert.ToString(val);
c = dr[2].ToString();
string d = Convert.ToString(val);
d = dr[3].ToString();
string f = Convert.ToString(val);
f = dr[4].ToString();
Console.WriteLine("Your User name is: {0}", b.ToString());
Console.WriteLine("Your Mobile No is: {0}", c.ToString());
Console.WriteLine("Your Password is: {0}", d.ToString());
Console.WriteLine("Your Mail ID is: {0}", f.ToString());
Console.ReadLine();
}
dc.Close();
}
}
else if (e.Result.Text == "Logout")
{
manualResetEvent.Set();
}
}
static void _recognizeSpeechAndWriteToConsole_SpeechRecognitionRejected(object sender, SpeechRecognitionRejectedEventArgs e)
{
Console.WriteLine("Speech rejected. Did you mean:");
foreach (RecognizedPhrase r in e.Result.Alternates)
{
Console.WriteLine(" " + r.Text);
}
}
}
}

Sample Output

Summary

More Artificial Intelligence references are available in C#. For developers, they're easy to download and add a reference file to build large-scale applications.

This application is the basic structure of future development endeavors. The grammar builder functionality is recognizing static speech. Try to implement this on dynamic based speech.

I hope this article helps you with your future development.