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.