Exemplo n.º 1
0
        public async void RegisterDevice(string ID)
        {
            //FormattedStringBuilder
            var res = await db.ScalarQueryAsync($"SELECT COUNT(*) FROM DeviceInfo WHERE Mac_Address={ID}"); //Posso fare anche un UPSERT

            if ((long)res > 0)
            {
                //Console.WriteLine("Bentornato {0}!", ID);
            }
            else
            {
                await db.QueryAsync($"INSERT INTO DeviceInfo(Mac_Address,OTP_Key) Values({ID},'Test') ");

                //await db.QueryAsync($"INSERT INTO RegisteredDevices(ID,Last_Seen) Values({ID},{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}) ");
                //Console.WriteLine("Benvenuto {0}!", ID);
            }
        }