using System;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Tango.DAL;
using System.Linq;
using Tango.Settings;
using Tango.Core;

namespace Tango.UnitTesting
{
    [TestClass]
    [TestCategory("DAL")]
    public class DAL_TST
    {
        [TestMethod]
        public void Validate_Server_SQLServer_Connection()
        {
            String guid = Guid.NewGuid().ToString();

            using (var db = new DAL.Remote.DB.RemoteDB(SettingsManager.Default.GetOrCreate<CoreSettings>().SQLServerAddress, false))
            {
                var action = new DAL.Remote.DB.ACTION_TYPES();
                action.CODE = 1;
                action.NAME = "Action 1";
                action.DESCRIPTION = "Description 1";
                action.GUID = guid;
                action.LAST_UPDATED = DateTime.UtcNow;

                db.ACTION_TYPES.Add(action);
                db.SaveChanges();
            }

            using (var db = new DAL.Remote.DB.RemoteDB(SettingsManager.Default.GetOrCreate<CoreSettings>().SQLServerAddress, false))
            {
                var action = db.ACTION_TYPES.Single(x => x.GUID == guid);
                db.ACTION_TYPES.Remove(action);
                db.SaveChanges();
            }
        }

        [TestMethod]
        public void Validate_Local_SQLite_Connection()
        {
            String guid = Guid.NewGuid().ToString();

            using (var db = new DAL.Local.DB.LocalDB(Helper.GetSQLiteFilePath()))
            {
                var action = new DAL.Local.DB.ACTION_TYPES();
                action.CODE = 1;
                action.NAME = "Action 1";
                action.DESCRIPTION = "Description 1";
                action.GUID = guid;

                db.ACTION_TYPES.Add(action);
                db.SaveChanges();
            }

            using (var db = new DAL.Local.DB.LocalDB(Helper.GetSQLiteFilePath()))
            {
                var actions = db.ACTION_TYPES.ToList();
                var action = db.ACTION_TYPES.Single(x => x.GUID == guid);
                db.ACTION_TYPES.Remove(action);
                db.SaveChanges();
            }
        }
    }
}