C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO.Ports;

namespace WICED_SERIALPORT_TEST
{
    public partial class Form1 : Form

    {
        
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string[] ports = SerialPort.GetPortNames();
            foreach (string port in ports)
            {
                comboBox1.Items.Add(port);
            }

        }
        //
        string t;
        private void button2_Click(object sender, EventArgs e)
        {

            t = comboBox1.Text.ToString();
            sErial(t);
            
        }
        //
        SerialPort sp;
        void sErial(string Port_name)
        {
            sp = new SerialPort(Port_name, 115200, Parity.None, 8, StopBits.One);
            sp.DataReceived += new SerialDataReceivedEventHandler(DataReceivedHandler);
            sp.Open();
        }
        // 
        private void DataReceivedHandler(object sender, SerialDataReceivedEventArgs e)
        {
            SerialPort sp = (SerialPort)sender;
            string msg = string.Empty;
            bool canCont = false;

            while (!canCont)
            {
                msg += sp.ReadLine();
                if (msg.Contains("Scan complete "))
                {
                    canCont = true;
                }
            }

            //string w = sp.ReadLine();
            //string w = sp.ReadExisting();

            // string msg = sp.ReadExisting();

            string[] msgArr = msg.Split('\r');

            Invoke(new Action(() => listBox1.Items.Clear()));


            List<string[]> list = new List<string[]>();
            List<Networks> Scan = new List<Networks>();

            for (int i = 0; i < msgArr.Length; i++)
            {
                list.Add(msgArr[i].Split(new string[] { "  " }, StringSplitOptions.RemoveEmptyEntries));
            }

            for (int i = 0; i < list.Count; i++)
            {
                if (i > 2)
                {
                    if (list[i].Length > 4)
                    {
                        int numOfSplits = 0;
                        List<string> tempList = new List<string>();

                        for (int ii = 0; ii < list[i].Length; ii++)
                        {
                            if (numOfSplits < 6)
                            {
                                string[] temp1 = list[i][ii].Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
                                numOfSplits += temp1.Length;

                                for (int iii = 0; iii < temp1.Length; iii++)
                                {
                                    tempList.Add(temp1[iii]);
                                }
                            }
                            else
                            {
                                tempList.Add(list[i][ii]);
                            }
                        }

                        Scan.Add(new Networks()
                        {
                            ID = Convert.ToInt32(tempList[0]),
                            NetworkType = tempList[1],
                            MAC = tempList[2],
                            RSSi = Convert.ToInt32(tempList[3]),
                            Rate = Convert.ToDouble(tempList[4]),
                            Channel = Convert.ToInt32(tempList[5]),
                            Security = tempList[6],
                            SSID = tempList[7],
                        });
                    }
                }
            }
            if (msg != String.Empty)
            {
                Invoke(new Action(() => richTextBox1.AppendText(msg)));

            }
            for (int i = 0; i < Scan.Count; i++)
            {
                Invoke(new Action(() => listBox1.Items.Add(Scan[i].MAC)));
                Invoke(new Action(() => listBox2.Items.Add(Scan[i].RSSi)));
                Invoke(new Action(() => listBox3.Items.Add(Scan[i].SSID)));

                msg = string.Empty;
                list.Clear();
            }
        }

        private void richTextBox1_TextChanged(object sender, EventArgs e)
        {

            
            
           
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            
        }

        private void richTextBox2_TextChanged(object sender, EventArgs e)
        {
           
        }

        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
        public SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\AP_SCAN_DATA.mdf;Integrated Security=True");
        private void button3_Click(object sender, EventArgs e)
        {
            

            using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\AP_SCAN_DATA.mdf;Integrated Security=True"))
{
    using (SqlCommand command = new SqlCommand())
    {
        command.Connection = connection;            // <== lacking
        command.CommandType = CommandType.Text;
        command.CommandText = "INSERT into LOCATIONSCAN ((Scan[i].SSID),(Scan[i].MAC), (Scan[i].RSSi)) VALUES (@SSID, @MAC, @RSSi)";
        command.Parameters.AddWithValue("@SSID", listBox1);
        command.Parameters.AddWithValue("@MAC", listBox2);
        command.Parameters.AddWithValue("@RSSi",listBox3);

        try
        {
            connection.Open();
            int recordsAffected = command.ExecuteNonQuery();
        }
        catch(SqlException)
        {
            // error here
        }
        finally
        {
            connection.Close();
        }
    }
}





        }
       
    }
}

using UnityEngine;
using System.Collections;

namespace InaneGames {
/// <summary>
/// Hang man game script
/// </summary>
public class HangMan : MonoBehaviour
{ // high score
		public char str;
		public GUISkin guiskin;
		// high score
	public enum State	
	{
		IDLE,
		NEXT_WORD
	};
		public static bool check;


		// my full word


		public static  bool FW=true;


		// my  full wors ends
		public bool rc;
	private State m_state;
	/// <summary>
	/// The time before displaying the next word
	/// </summary>
	public float nextWordTime = 1;
	private float m_nextWordTime;
	
	/// <summary>
	/// An array of text files
	/// </summary>
	public TextAsset[] fileTexts;
	
	/// <summary>
	/// The score bonus per letter.
	/// </summary>
	public int scoreBonusPerLetter = 15;
	
	/// <summary>
	/// The score punish per wrong letter.
	/// </summary>
	public int scorePunishPerWrongLetter = 20;
	
	/// <summary>
	/// The mystery letter for displaying when a letter has not been pressed
	/// </summary>
	public char mysteryLetter = '!';	
	
	private bool resetLivesOnCorrectWord = true;	
	
	/// <summary>
	/// The number of lives for the hangman
	/// </summary>
	public int lives;
	
	/// <summary>
	/// The max number of questions.
	/// </summary>
	public int maxQuestions = 8;
	
	/// <summary>
	/// the number of lives the player starts off with
	/// </summary>
	public string freeLetters = " ";
	
	/// <summary>
	/// The audio clip to play when you get the right letter
	/// </summary>
	public AudioClip onCorrectAC;
	
	/// <summary>
	/// The audio clip to play when you get the incorrect letter
	/// </summary>
	public AudioClip onIncorrectAC;
	
	/// <summary>
	/// The audio clip to play when you get the right word
	/// </summary>	
	public AudioClip onRightWordAC;
	
	/// <summary>
	/// The audio clip to play when you lose
	/// </summary>	
	public AudioClip onLoseAC;
	
	private string[] m_words;
	private bool[] m_gotLetter;
	
	private string m_currentWord;
	private int m_wordIndex=0;
	private string m_word = "";

	
	private int m_lives;
	private int m_score = 0;

		// HIGH SCORE
		public int highScore;
		// hogh score ends


	private HangManGUI m_hangManGUI;
	public bool chooseRandomCategory = true;
	
		// high score
		public void OnGUI () {
			GUI.skin = guiskin;
			
			
			
			

			
			

			
			GUI.Label ( new Rect (0, 0, 300, 40),   " High Scores:" + highScore); 
		}


		// high score ends



		public void Awake()
	{



			// HIGH SCORE
			highScore = PlayerPrefs.GetInt ("High Score", 0);
			// HIGH SCORE ENDS


		m_lives = lives;
		int r = Misc.getIntValue("CATEGORY_INDEX");

		if(chooseRandomCategory)
		{
			r = Random.Range(0,fileTexts.Length-1);
		}
		
		TextAsset ta = fileTexts[r];
		//make all words uppercase
		string str = ta.text.ToUpper();
		
		//split our words
		m_words = str.Split('\n');
		m_words = randomizeArray(m_words);
		m_hangManGUI = gameObject.GetComponent<HangManGUI>();
		
		setNextWord();

		if(m_hangManGUI)
		{
			m_hangManGUI.init( ta.name, m_word,m_lives);
		}
	}
		
	public bool checkIfWordContainsLetter(string str)
	{
		 rc = false;
		for(int i=0; i<m_currentWord.Length; i++)
		{
			string tmp = m_currentWord[i].ToString();
			if(tmp.Equals(str))			
			{
				m_gotLetter[i]=true;
				rc=true;
			}

		}
		return rc;
	}
	public void fillWord()
	{



		m_word = "";
		for(int i=0; i<m_currentWord.Length; i++)
		{
			if(m_gotLetter[i])
			{
				m_word += m_currentWord[i];
			}else{
				m_word += mysteryLetter.ToString(); 
					//m_word+=m_currentWord[i];
			} 

		}

	}

	void Update()
		{ 

		

			// high score
			if(m_score > highScore){
				highScore = m_score;
				PlayerPrefs.SetInt("High Score", highScore);
				PlayerPrefs.Save();
				// high score ends

				
			}

		if(m_state == State.NEXT_WORD)
		{
			handleNextWord();
		}


	}
	void handleNextWord()
	{

		m_nextWordTime-=Time.deltaTime;
		if(m_nextWordTime<0)
		{
			m_state = State.IDLE;
			setNextWord();
			if(resetLivesOnCorrectWord)
			{
				m_lives = lives;
			}
			m_hangManGUI.setLives(m_lives);			
		}
	}  
	void onCorrectLetter()
	{ 



			fillWord ();
		m_hangManGUI.setWord( m_word );
			
		if(m_word.Equals(m_currentWord))
		{	
			if(audio)
			{
				audio.PlayOneShot(onRightWordAC);
			}
			m_score += m_currentWord.Length * scoreBonusPerLetter;
			m_hangManGUI.setScore (m_score);		
			m_nextWordTime = nextWordTime;
			m_state = State.NEXT_WORD;
			

		
		}else{
			if(audio)
			{
				audio.PlayOneShot(onCorrectAC);
			}
		}
	}
	void onIncorretLetter()
	{

		m_lives--;
		m_hangManGUI.setLives ( m_lives );
		m_score -= scorePunishPerWrongLetter;
		m_hangManGUI.setScore(m_score);



		if (m_lives > 0) {	
								if (audio) {
										audio.PlayOneShot (onIncorrectAC);
								}
						} else {
		 
								if (audio) {


										audio.PlayOneShot (onLoseAC);
								}
				             

			
								m_hangManGUI.setGameOver (false);
	
						
					
				}

	}
	public void selectLetter(string str)
	{
		if(checkIfWordContainsLetter(str))
		{
			onCorrectLetter();			
		}else{
			onIncorretLetter();
		}

					
	}
	
	void setNextWord()
	{
		if(m_wordIndex+1 <= m_words.Length)
		{
			m_currentWord = m_words[m_wordIndex++];
			m_word = "";
			m_gotLetter = new bool[m_currentWord.Length];
			for(int i=0; i<m_currentWord.Length; i++)
			{
				m_gotLetter[i]=false;
				if(isFreeLetter(m_currentWord[i]))
				{
					m_word += m_currentWord[i].ToString();
					m_gotLetter[i]=true;
				}else{
					m_word += mysteryLetter.ToString();
					
				}
			}
			m_hangManGUI.clearButtons();
			m_hangManGUI.setWord(m_word);
		}else{
			m_hangManGUI.setGameOver(true);
		}
	}
	
	public bool isFreeLetter(char str)
	{
	
							 rc = false;


								for (int i=0; i<freeLetters.Length; i++) {
										if (str == freeLetters [i]) {
												rc = true;
										}

								}
						
		 

								return rc;
						 


	}

		//my function start
		public bool wholeword(){
				
			rc = true;
			for (int j=0; j<freeLetters.Length; j++) {
				if (str == freeLetters[j]){
					rc=true;
				}}
			return rc;}
		// my function ends.

	
	string[] randomizeArray(string[] arr)
	{
	    for (int i = arr.Length - 1; i > 0; i--) 
		{
	        int r = Random.Range(0,i);
	        var tmp = arr[i];
	        arr[i] = arr[r];
	        arr[r] = tmp;
	    }
		return arr;
	}
}
}