DAS Access Control System (DASACS)

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.IO;
using System.Net;
using System.Net.Sockets;
using System.Text;
/// <summary>
/// SOCKET COMM WITH THE ARDUNIO
/// 
/// ==============================
/// Find out more: support@dasdata.co 
/// </summary>
namespace DasSocketClient
{
    class Program
    {
       // comm with the DB - change connection details 
        static _db _myDb = new _db();
        static System.Timers.Timer aTimer = new System.Timers.Timer();
        static IPAddress localAddr = IPAddress.Any;

        static void Main(string[] args)
        {
            try
            {
                // arduino connection 
                cmdGetConnected("192.168.1.116");
            }
            catch (Exception ex)
            {
            }
        }
       
        
        //Connection arduino
        public static void cmdGetConnected(String _ClientIP)
        {
            TcpListener server = null;
            server = null;
            try
            {
                // Set the TcpListener on port 8800. 
                Int32 port = 8800;
                server = new TcpListener(localAddr, port);
                // Start listening for client requests.
                server.Start();
                // Buffer for reading data 
                byte[] bytes = new byte[1025];
                string data = null;

                // Enter the listening loop. 
                while (true)
                {
                    try
                    {
                        Console.Write("Waiting for a connection... ");
                        TcpClient client = server.AcceptTcpClient();
                        Console.WriteLine("Connected!");
                        data = null;
                        // Get a stream object for reading and writing 
                        NetworkStream stream = client.GetStream();
                        Int32 i = default(Int32);
                        // Loop to receive all the data sent by the client.
                        i = stream.Read(bytes, 0, bytes.Length);
                        while ((i != 0))
                        {
                            // Translate data bytes to a ASCII string.
                            data = System.Text.Encoding.ASCII.GetString(bytes, 0, i);
                            if (data.Length > 5)
                            {
                                Console.Clear();
                                Console.Write("* " + System.DateTime.Now.ToString() + " - Ticket: " + data + " ");

                                //     cmdGeticketValidation(data);
                                // DATABASE VERIFICATION 
                                string _srvValidation = cmdGeticketValidation(data).ToString();
                                Console.ForegroundColor = ConsoleColor.Green;
                                string _srvValidationMessage = "Valid entry";
                                if (Convert.ToInt32(_srvValidation) == 0)
                                {
                                    _srvValidationMessage = "Acces denied";
                                    Console.ForegroundColor = ConsoleColor.Red;
                                }
                                string strResponse = _srvValidation + " ";
                                byte[] myResponse = Encoding.ASCII.GetBytes(strResponse);
                                stream.Write(myResponse, 0, myResponse.Length);
                                Console.WriteLine(_srvValidationMessage);
                                Console.ForegroundColor = ConsoleColor.White;
                            }
                            i = stream.Read(bytes, 0, bytes.Length);
                        }
                        // Shutdown and end connection 
                        client.Close();
                    }
                    catch (Exception ex)
                    {
                    }
                }
            }
            catch (SocketException ex) { }
            finally
            {      //   server.Stop()
            }
            //   Console.WriteLine(ControlChars.Cr + "Hit enter to continue....")
            //    Console.Read()
        }

        //MAKE VALIDATION ON THE DATABASE SERVER
        public static object cmdGeticketValidation(string _TicketID)
        {
            try
            {
                DataSet _dsTicketsValid = new DataSet();
                _dsTicketsValid = _myDb.getDB("salGetTicketValidation", "UID", _TicketID);
                string _ticketValid = _dsTicketsValid.Tables[0].Rows[0]["Valid"].ToString();
                return _ticketValid;
            }
            catch (Exception ex)
            {
                return "0";
            }
        }

      //end 

    }
}