using System;
using System.Data;
using System.Data.SqlClient;

namespace FileSecurity_Server
{
    class Database
    {
        SqlConnection Connection;

        public Database()
        {
            Program.Writer.WriteLine(WriteType.Information, false, "Initializing Database Connection -> {0}!", Properties.Settings.Default.Database_Source);

            try
            {
                Connection = new SqlConnection(String.Format("Data Source={0};MultipleActiveResultSets=True;Integrated Security=SSPI", Properties.Settings.Default.Database_Source));

                OpenConnection();

                Program.Writer.WriteLine(WriteType.Information, true, "Initialized Database Connection!");
            }
            catch { Program.Shutdown(); }
        }

        public void InsertLog(String IP, String Mac, String UniqueID, Boolean Allowed)
        {
            try
            {
                OpenConnection();

                SqlCommand Command = new SqlCommand();
                Command.Connection = Connection;
                Command.CommandText = String.Format("INSERT INTO {0}..tSecurity(nID, sIP, sMac, sUniqueID, sAllowed, dDate) VALUES('{1}', '{2}', '{3}', '{4}')", Properties.Settings.Default.Database_Launcher, IP, Mac, UniqueID, Allowed);
                Command.ExecuteNonQuery();
            }
            catch { }
        }

        private void OpenConnection()
        {
            if (Connection.State != ConnectionState.Open) { Connection.Open(); }
        }
    }
}