Task3

using Microsoft.Data.Sqlite;
using System;

namespace YoctoCoreDemo
{
    class Program
    {
        static SqliteConnection CreateConnection()
        {
            SqliteConnection sqlite_conn;
            sqlite_conn = new SqliteConnection("filename=Task3.db");
            try
            {
                sqlite_conn.Open();
            }
            catch (Exception ex)
            {

            }
            return sqlite_conn;
        }

        static void CreateTable(SqliteConnection conn)
        {
            SqliteCommand sqlite_cmd;
            string Createsql = "CREATE TABLE YoctoI2C (Timestamp VARCHAR(20), Temperature VARCHAR(20), Humidity VARCHAR(20))";
            sqlite_cmd = conn.CreateCommand();
            sqlite_cmd.CommandText = Createsql;
            sqlite_cmd.ExecuteNonQuery();
        }

        static void InsertData(SqliteConnection conn, string time, string temp, string hum)
        {
            SqliteCommand sqlite_cmd;
            sqlite_cmd = conn.CreateCommand();
            string commandText = "INSERT INTO YoctoI2C (timestamp, temperature, humidity) VALUES('"+time+"', + '"+temp+ "', + '"+hum+"')";
            sqlite_cmd.CommandText = commandText;
            sqlite_cmd.ExecuteNonQuery();
        }

        static void ReadData(SqliteConnection conn)
        {
            SqliteDataReader sqlite_datareader;
            SqliteCommand sqlite_cmd;
            sqlite_cmd = conn.CreateCommand();
            sqlite_cmd.CommandText = "SELECT * FROM YoctoI2C";

            sqlite_datareader = sqlite_cmd.ExecuteReader();
            while (sqlite_datareader.Read())
            {
                string myreader = sqlite_datareader.GetString(0);
                Console.WriteLine(myreader);
            }
            conn.Close();
        }
        static void Main(string[] args)
        {
            YModule m;
            string errmsg = "";

            if (YAPI.RegisterHub("usb", ref errmsg) != YAPI.SUCCESS)
            {
                Console.WriteLine("RegisterHub error: " + errmsg);
                Environment.Exit(0);
            }

            Console.WriteLine("Device list");
            m = YModule.FirstModule();
            while (m != null)
            {
                Console.WriteLine(m.get_serialNumber() +
                    " (" + m.get_productName() + ")");
                m = m.nextModule();
            }

            Console.WriteLine("Using Yoctopuce lib " + YAPI.GetAPIVersion());
            YSensor temperature = YTemperature.FirstTemperature();
            YSensor humidity = YHumidity.FirstHumidity();


            SqliteConnection sqlite_conn;
            sqlite_conn = CreateConnection();
            //CreateTable(sqlite_conn);

            for (int i = 0; i < 10; i++)
            {
                string currentTemperature = temperature.get_currentValue() + temperature.get_unit();
                string currentHumidity = humidity.get_currentValue() + " " + humidity.get_unit();
                InsertData(sqlite_conn, DateTime.Now.ToShortDateString(), currentTemperature, currentHumidity);
                Console.WriteLine("Current temperature for " + DateTime.Now + " is " + currentTemperature + ". Humidity is "+currentHumidity);
                System.Threading.Thread.Sleep(30000);
            }
            ReadData(sqlite_conn);
            YAPI.FreeAPI();
        }
    }
}