MARKUS

using System;

using Xunit;

using Markus.Service.DataBase;

using Xunit.Priority;

using Markus.Service.Extensions;

namespace UnitTest.Markus.Service

{

    public class DataBaseTest

    {

        private readonly ConvertDatabase Database;

        private readonly string ConnectionString = @"data source=.\SQLEXPRESS;initial catalog=Markus;persist security info=True;user id=ConvertService;Password=ConvertService;MultipleActiveResultSets=True;";

        private readonly string ProjectNo;

        private readonly string ConvertID;

        public DataBaseTest()

        {

            Database = new ConvertDatabase(ConnectionString);

            ProjectNo = "000000";

            ConvertID = new Guid().CreateUniqueGuid().ToString();

        }

        [Fact,Priority(0)]

        public void AddConvertItem()

        {

            bool result = Database.SetConvertDoc(ProjectNo, ConvertID, @"c:Test.pdf", "aaaaa");

            Assert.True(result);

        }

        [Fact, Priority(1)]

        public void GetConvertItem()

        {

            var result = Database.GetConvertItem(ProjectNo, ConvertID);

            Assert.NotNull(result);

        }

        [Fact, Priority(2)]

        public void ConvertItemChnageState()

        {

            string testServiceID = new Guid().ToString();

            var result = Database.SetConvertState(testServiceID,ConvertID,1,10,10,"test");

            Assert.True(result);

        }

        [Fact, Priority(3)]

        public void ClearConvertItem()

        {

            var result = Database.SetCleanUpItem(ConvertID,1);

            Assert.True(result == 1);

        }

        [Fact, Priority(4)]

        public void RemoveConvertItem()

        {

            var result = Database.RemoveItem(ConvertID);

            Assert.True(result == 1);

        }

    }

}