using System;
using System.Data;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Cisco.UnityConnection.OdbcSdk;

namespace UnityConnectionServerOdbcTests
{
    [TestClass]
    public class UnityConnectionServerOdbcIntegrationTest : BaseIntegrationTests
    {

        #region Fields and Properties

        private static bool _errorRaised;

        #endregion


        #region Additional test attributes

        //Use ClassInitialize to run code before running the first test in the class
        [ClassInitialize]
        public new static void MyClassInitialize(TestContext testContext)
        {
            BaseIntegrationTests.MyClassInitialize(testContext);
            Server.DatabaseFunctions.ErrorEvents += ServerOnErrorEvents;
        }

        private static void ServerOnErrorEvents(object sender, LogEventArgs logEventArgs)
        {
            _errorRaised = true;
        }

        #endregion


        [TestMethod]
        public void PrintServerStringPropertiesTests()
        {
            Assert.IsTrue(!string.IsNullOrEmpty(Server.CurrentDatabaseName), "CurrentDatabaseName value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.DatabaseLoginName), "DatabaseLoginName value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.DatabaseLoginPassword), "DatabaseLoginPassword value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.DatabaseServerIpAddress), "DatabaseServerIpAddress value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.DatabaseServerName), "DatabaseServerName value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.PrimaryLocationDisplayName), "PrimaryLocationDisplayName value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.PrimaryLocationDomainName), "PrimaryLocationDomainName value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.PrimaryLocationObjectId), "PrimaryLocationObjectId value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.PrimaryLocationServerAddress), "PrimaryLocationServerAddress value empty");
            Assert.IsTrue(!string.IsNullOrEmpty(Server.UnityVersionString), "UnityVersionString value empty");
        }

        [TestMethod]
        public void IntegerPropertyTests()
        {
            Console.WriteLine("Neighbor count=" + Server.NeighborLocations.Count);
            Assert.IsTrue(Server.DatabaseConnectionStatus == ConnectionStatus.Connected, "DatabaseConnectionStatus value false");
            Assert.IsTrue(Server.UnityVersionMajor >0, "Version Major is not greater than 0:"+Server.UnityVersionMajor);
            Console.WriteLine(Server.UnityVersionRev);
            Console.WriteLine(Server.UnityVersionMinor);
            Console.WriteLine(Server.UnityVersionBuild);
            Assert.IsFalse(Server.UnityVersionIsCoRes,"Server reporting as CoRes which is no longer supported");
        }


        [TestMethod]
        public void ChangeDatabaseTests()
        {
            bool ret = Server.ChangeActiveDatabase("junk");
            Assert.IsFalse(ret,"Changing active database to 'junk' did not fail");
            Console.WriteLine("Current database name =" + Server.CurrentDatabaseName);

            ret = Server.ChangeActiveDatabase("UnityDynDb");
            Assert.IsTrue(ret, "Changing active database to 'UnityDynDb' failed");
            Console.WriteLine("Current database name =" + Server.CurrentDatabaseName);

            ret = Server.ChangeActiveDatabase("UnityMbxDb1");
            Assert.IsTrue(ret, "Changing active database to 'UnityMbxDb1' failed");
            Console.WriteLine("Current database name =" + Server.CurrentDatabaseName);

            ret = Server.ChangeActiveDatabase("UnityRptDb");
            Assert.IsTrue(ret, "Changing active database to 'UnityRptDb' failed");
            Console.WriteLine("Current database name =" + Server.CurrentDatabaseName);

            ret = Server.ChangeActiveDatabase("UnityDirDb");
            Assert.IsTrue(ret, "Changing active database to 'UnityDirDb' failed");
            Console.WriteLine("Current database name =" + Server.CurrentDatabaseName);
        }

        [TestMethod]
        public void LanguageInstalledTest()
        {
            bool ret = Server.IsLanguageInstalled(1033);
            Assert.IsTrue(ret,"1033 language not installed, should always be by default");

            ret = Server.IsLanguageInstalled("1033");
            Assert.IsTrue(ret, "string version of 1033 language not installed, should always be by default");

            ret = Server.IsLanguageInstalled("7777");
            Assert.IsFalse(ret, "Invalid 7777 as string language reported as installed");

            ret = Server.IsLanguageInstalled(7777);
            Assert.IsFalse(ret, "invalid 7777 langauge Id reported as installed");
        }

        [TestMethod]
        public void DefaultLanguageTest()
        {
            Console.WriteLine("Default language=" + Server.GetDefaultLanguage());
            int iLang = Server.GetDefaultLanguage();
            Assert.IsTrue(iLang>0,"Default language Id invalid:"+iLang);
        }


        [TestMethod]
        public void VersionCheckTests()
        {
            Assert.IsTrue(Server.IsConnectionVersionAtLeast(1, 0, 0, 0),"Version is not reporting as greater than 1.0.0.0");
            Assert.IsFalse(Server.IsConnectionVersionAtLeast(22, 0, 0, 0), "Version is not reporting as less than 22.0.0.0");
        }

        [TestMethod]
        public void LargeDbOperationPause()
        {
            Server.LargeDbOperationPause(true);
        }

        [TestMethod]
        public void LoginLogoutTest()
        {
            UnityConnectionServerOdbc oServer = new UnityConnectionServerOdbc(new UnityConnectionDatabaseFunctionsInformixAdoNet("Test"));
            var res=oServer.LoginDatabaseBlocking(Server.DatabaseServerName,Server.DatabaseLoginName, Server.DatabaseLoginPassword);
            Assert.IsTrue(res.Successful,"Failed to log in to second instance of server:"+res);

            oServer.LogoutBlocking();
        }


        [TestMethod]
        public void UpdateStatisticsTest_Success()
        {
            var res = Server.UpdateStatisticsForMailstore("UnityDynDb");
            Assert.IsTrue(res.Successful, "Failed updating UnityDynDb statistics:" + res);
        }

        [TestMethod]
        public void UpdateStatisticsTest_InvalidDbNameFailure()
        {
            var res = Server.UpdateStatisticsForMailstore("Junk");
            Assert.IsFalse(res.Successful,"Updating statistics on invalid database name should fail:"+res);
        }

        [TestMethod]
        public void UpdateStatisticsTest_ValidDbNameNotPresentFailure()
        {
            var res = Server.UpdateStatisticsForMailstore("UnityMbxDb6");
            Assert.IsFalse(res.Successful, "Updating statistics on UnityMbxDb6 database name should fail:" + res);
        }

        [TestMethod]
        public void IsLanguageInstalled_NonNumericLanguageCode()
        {
            bool ret = Server.IsLanguageInstalled("xyz");
            Assert.IsFalse(ret,"false should be returned if language code cannot be parsed as an int");
        }

      

        [TestMethod]
        public void FillDataTableBlocking_InvalidQuery()
        {
            DataTable oTable;
            var res = Server.DatabaseFunctions.FillDataTableBlocking("invalid query string", out oTable);
            Assert.IsFalse(res.Successful, "FillDataTableBlocking call should fail with invalid query");
        }


    }
}