using NUnit.Framework;
using PP.Core.Extension;
using PP.Core.Helper;
using PP.Core.Models;
using SPE.BatchProcess.Tests.Integration.Utilities;
using SPE.Data;
using SPE_Model.Batch;
using SPE_Model.Models;
using SPE_Model.TFSO;
using SPS_Test_System.StepDefinitions.Helpers;
using System;
using System.Collections.Generic;
using System.Data.Entity.Migrations;
using System.Linq;
using System.Net.Mail;
using System.Text;
using System.Threading.Tasks;
using NSubstitute;
using PP.Core.MailService;
using SPE.BatchProcess.Batches;
using SPE.Services.MailService;
using SPE.Services.WelcomeBatch;

namespace SPE.BatchProcess.Tests.Integration.Batches.WelcomeBatchTest
{
    public class CreateWelcomeBatchTest : IntegrationBaseTest
    {
        private BatchMaster _welcomeBatch;


        [SetUp]
        public void SetupTestCompany()
        {
            SeedHelper.SeedDefaultCompany1AndEmployee();
            SeedHelper.SeedDefaultCompany2AndEmployee();
            UpdateSeedingCompany();


        }

        #region MainFlow


        [Test]
        public void Create_BatchFilterFor1CompanyAndProcessComplete_ReturnCompanyAndBatchSuccess()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            InsertWelcomBatchWithFilterForCompany1();
            UpdateCompany1WithCorrectDataInWelcomeBatch();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Draft
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual("System Test Company 1", companyWelcomeBatch.Company.Name);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Success, companyWelcomeBatch.Status);
            AssertCompany1AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterFor1CompanyAndProcessFailed_ReturnCompanyAndBatchFailed()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            InsertWelcomBatchWithFilterForCompany1();
            UpdateCompany1Id24ToInvalid();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Failed
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual("System Test Company 1", companyWelcomeBatch.Company.Name);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Failed, companyWelcomeBatch.Status);
            AssertCompany1AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterFor1CompanyAndStatusIsAddedToBatch_ReturnBatchSuccess()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.AddedToWelcomeBatch);
            InsertWelcomBatchWithFilterForCompany1();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Draft
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.IsNull(companyWelcomeBatch);
        }

        [Test]
        public void Create_BatchFilterForAllCompanyAnd2CompanyHasCompleteStatus_ReturnBatchAndCompanySuccess()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            UpdateCompany2ImportStatus(StateConst.AddedToWelcomeBatch);
            UpdateCompany1WithCorrectDataInWelcomeBatch();

            InsertWelcomBatchWithFilterEmpty();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Draft
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual("System Test Company 1", companyWelcomeBatch.Company.Name);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Success, companyWelcomeBatch.Status);
            AssertCompany2AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterForAllCompanyAnd1CompanyHasProcessFailed_ReturnBatchAndCompanyFailed()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.AddedToWelcomeBatch);
            UpdateCompany2ImportStatus(StateConst.Completed);
            UpdateCompany2Id24ToInvalid();

            InsertWelcomBatchWithFilterEmpty();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Failed
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual("System Test Company 2", companyWelcomeBatch.Company.Name);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Failed, companyWelcomeBatch.Status);
            AssertCompany2AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterFor2CompanyAnd1CompanyHasProcessFailed_ReturnBatchAndCompanyFailed()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            UpdateCompany2ImportStatus(StateConst.Completed);
            UpdateCompany2Id24ToInvalid();
            UpdateCompany1WithCorrectDataInWelcomeBatch();
            UpdateCompany2WithCorrectDataInWelcomeBatch();

            InsertWelcomBatchWithFilter2Company();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Failed
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatchs = this.DataContext.CompanyWelcomeBatch.ToList();
            Assert.AreEqual(2, companyWelcomeBatchs.Count());
            Assert.AreEqual("System Test Company 1",
                companyWelcomeBatchs.First(c => c.Status == (int) CompanyWelcomeBatchStatus.Success).Company.Name);
            Assert.AreEqual("System Test Company 2",
                companyWelcomeBatchs.First(c => c.Status == (int) CompanyWelcomeBatchStatus.Failed).Company.Name);
            AssertCompany1AddedToBatchStatus();
            AssertCompany2AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterFor2CompanyAndProcessSucceed_ReturnBatchAndCompanySuccess()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            UpdateCompany2ImportStatus(StateConst.AddedToWelcomeBatch);
            UpdateCompany1WithCorrectDataInWelcomeBatch();

            InsertWelcomBatchWithFilter2Company();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Draft
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatchs = this.DataContext.CompanyWelcomeBatch.ToList();
            Assert.AreEqual(1, companyWelcomeBatchs.Count());
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Success,
                companyWelcomeBatchs.First(c => c.Company.Name == "System Test Company 1").Status);
            AssertCompany1AddedToBatchStatus();
            AssertCompany2AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterFor2CompanyAndProcessFailed_ReturnBatchAndCompanyFailed()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            UpdateCompany2ImportStatus(StateConst.Completed);
            UpdateCompany1Id24ToInvalid();
            UpdateCompany2Id24ToInvalid();

            InsertWelcomBatchWithFilterEmpty();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Failed
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatchs = this.DataContext.CompanyWelcomeBatch.ToList();
            Assert.AreEqual(2, companyWelcomeBatchs.Count());
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Failed,
                companyWelcomeBatchs.First(c => c.Company.Name == "System Test Company 1").Status);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Failed,
                companyWelcomeBatchs.First(c => c.Company.Name == "System Test Company 2").Status);
            AssertCompany1AddedToBatchStatus();
            AssertCompany2AddedToBatchStatus();
        }

        [Test]
        public void Create_BatchFilterFor1CompanyAndProcessEmailComplete_ReturnCompanyAndBatchSuccess()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            InsertWelcomBatchWithFilterForCompany1();
            UpdateCompany1WithCorrectDataInWelcomeBatch();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                CommandConst.Create,
                StateConst.Draft
            );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                _welcomeBatch.Command,
                _welcomeBatch.State
            );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual("System Test Company 1", companyWelcomeBatch.Company.Name);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Success, companyWelcomeBatch.Status);
            AssertCompany1AddedToBatchStatus();
        }


        #endregion


        #region EmailToAccountant

        [Test]
        public void Create_WithCompanyWithOutSalarySystem_ReturnBatchAndCompanyFailed()
        {
            // arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            UpdateCompany1SalarySystem(string.Empty);
            UpdateCompany2ImportStatus(StateConst.Completed);
            InsertEmailForCompany1();
            InsertWelcomBatchWithFilterForCompany1();


            // act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(CommandConst.Create,
                StateConst.Failed);
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(_welcomeBatch.Command,
                _welcomeBatch.State);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Failed, companyWelcomeBatch.Status);
        }

        [Test]
        public void Create_WithCompany1CorrectedData_ReturnBatchAndCompanyCompleted()
        {
            // arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            InsertEmailForCompany1();
            UpdateCompany1SalarySystem("Visma");
            UpdateCompany1EmailAddress(RoleConstant.Accountant, "liie.m@excelbangkok.com");
            UpdateCompany1FirstDateSavings(DateTime.Now);

            var mailBase = AutoSubstitute.SubstituteFor<IMailService>();
            mailBase.PrepareContent(Arg.Any<string>(), Arg.Any<string>(), "liie.m@excelbangkok.com", Arg.Any<string>(),
                    Arg.Any<List<string>>())
                .Returns(new EmailContent() {Body = "", EmailParameter = new EmailParameter(), Header = "header"});


            InsertWelcomBatchWithFilterForCompany1();

            // act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(CommandConst.Create,
                StateConst.Draft);
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(_welcomeBatch.Command,
                _welcomeBatch.State);

            var companyWelcomeBatch = this.DataContext.CompanyWelcomeBatch.FirstOrDefault();
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);
            Assert.AreEqual((int) CompanyWelcomeBatchStatus.Success, companyWelcomeBatch.Status);
        }

        [Test]
        public void Create_BatchFilterFor1CompanyAndHasAgentContact_ReturnBatchSuccessAndSendFile()
        {
            // Arrange
            UpdateCompany1ImportStatus(StateConst.Completed);
            UpdateCompany2ImportStatus(StateConst.Completed);
            AddAgentContactForCompany2();
            UpdateCompany2WithCorrectDataInWelcomeBatch();
            InsertWelcomBatchWithFilterForCompany2();

            // Act
            this.AutoSubstitute.Resolve<SPE.BatchProcess.Batches.WelcomeBatch>().Start(_welcomeBatch);

            // Assert
            _welcomeBatch = this.DataContext.BatchMasters.Find(_welcomeBatch.BatchId);
            string expectBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                    CommandConst.Create,
                    StateConst.Draft
                );
            string actualBatchStatusStr = ValidationHelper.compareBatchStatus.FormatWith(
                    _welcomeBatch.Command,
                    _welcomeBatch.State
                );
            Assert.AreEqual(expectBatchStatusStr, actualBatchStatusStr);

            var companyWelcomeBatchs = this.DataContext.CompanyWelcomeBatch.ToList();
            Assert.AreEqual(1, companyWelcomeBatchs.Count());
            Assert.AreEqual((int)CompanyWelcomeBatchStatus.Success, companyWelcomeBatchs.First(c => c.Company.Name == "System Test Company 2").Status);
            AssertCompany2AddedToBatchStatus();

        }
        #endregion


        #region [Privates]

        private void AddAgentContactForCompany2()
        {
            using (var speContext = new SPEContext())
            {
                var personArtId = Guid.Parse("16000000-0000-0000-0000-000000000001");
                var personArt = speContext.Persons.FirstOrDefault(p => p.PersonId == personArtId);
                var company2Id = Guid.Parse("30000000-0000-0000-0000-000000000002");
                var company1 = speContext.Companies.FirstOrDefault(c => c.CompanyId == company2Id);
                var contact = new Contact()
                {
                    Id = Guid.NewGuid(),
                    ContactId = (int)personArt.PersonId24,
                    Company = company1,
                    Person = personArt,
                    FirstName = "Art",
                    LastName = "Sanut",
                    Role = RoleConstant.Agent
                };
                speContext.Contacts.Add(contact);
                speContext.SaveChanges();
            }
        }

        private void InsertEmailForCompany1()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            var company = this.DataContext.Contacts.FirstOrDefault(c => c.Company.CompanyId == companyId);
            var emaiAddress = ConfigHelper.GetAppSetting("emailSupport", "art.a@excelbangkok.com");
            //var emaiAddress = "";
            company.Email = emaiAddress;
            company.Role = RoleConstant.PrimaryContact;
            this.DataContext.SaveChanges();
        }

        private void InsertEmailCedingForCompany1() {

            var savingProviders = "SavingsProviders_1";
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            var otpContract = this.DataContext.OTPContracts.FirstOrDefault(c => c.Company.CompanyId == companyId);
            otpContract.SeedingComp = savingProviders;
            var savingProvider = this.DataContext.SavingsProviders.FirstOrDefault(a => a.ProviderName == savingProviders);
            var emaiAddress = ConfigHelper.GetAppSetting("emailSupport", "art.a@excelbangkok.com");
            savingProvider.EmailCedingCompany = emaiAddress;

            this.DataContext.SaveChanges();
        }

        private void AssertCompany1AddedToBatchStatus()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            var company = this.DataContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
            Assert.AreEqual(StateConst.AddedToWelcomeBatch, company.ImportStatus);
        }

        private void AssertCompany2AddedToBatchStatus()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            var company = this.DataContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
            Assert.AreEqual(StateConst.AddedToWelcomeBatch, company.ImportStatus);
        }

        private void InsertWelcomBatchWithFilter2Company()
        {
            _welcomeBatch = this.ModelFactory.CreateModelWithTemplate<SPE_Model.Batch.BatchMaster>();
            _welcomeBatch.BatchService =
                this.DataContext.BatchServices.Where(s => s.ServiceName == BatchName.WelcomeBatch).FirstOrDefault();

            _welcomeBatch.Command = CommandConst.Create;
            _welcomeBatch.State = StateConst.Failed;
            _welcomeBatch.Filter = "412298772,169776792";

            this.DataContext.BatchMasters.Add(_welcomeBatch);
            this.DataContext.SaveChanges();
        }

        private void UpdateCompany2Id24ToInvalid()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.Id24 = -1;
                speContext.SaveChanges();
            }
        }

        private void InsertWelcomBatchWithFilterEmpty()
        {
            _welcomeBatch = this.ModelFactory.CreateModelWithTemplate<SPE_Model.Batch.BatchMaster>();
            _welcomeBatch.BatchService =
                this.DataContext.BatchServices.Where(s => s.ServiceName == BatchName.WelcomeBatch).FirstOrDefault();

            _welcomeBatch.Command = CommandConst.Create;
            _welcomeBatch.State = StateConst.Failed;
            _welcomeBatch.Filter = "";

            this.DataContext.BatchMasters.Add(_welcomeBatch);
            this.DataContext.SaveChanges();
        }

        private void UpdateCompany2ImportStatus(int importStatus)
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.ImportStatus = importStatus;
                company.UpdatedSPE = DateTime.Now;
                speContext.SaveChanges();
            }
        }

        private void UpdateCompany1Id24ToInvalid()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.Id24 = -1;
                speContext.SaveChanges();
            }
        }

        private void InsertWelcomBatchWithFilterForCompany1()
        {
            _welcomeBatch = this.ModelFactory.CreateModelWithTemplate<SPE_Model.Batch.BatchMaster>();
            _welcomeBatch.BatchService =
                this.DataContext.BatchServices.Where(s => s.ServiceName == BatchName.WelcomeBatch).FirstOrDefault();

            _welcomeBatch.Command = CommandConst.Create;
            _welcomeBatch.State = StateConst.Failed;
            _welcomeBatch.Filter = "412298772";

            this.DataContext.BatchMasters.Add(_welcomeBatch);
            this.DataContext.SaveChanges();

        }
        private void InsertWelcomBatchWithFilterForCompany2()
        {
            _welcomeBatch = this.ModelFactory.CreateModelWithTemplate<SPE_Model.Batch.BatchMaster>();
            _welcomeBatch.BatchService = this.DataContext.BatchServices.Where(s => s.ServiceName == BatchName.WelcomeBatch).FirstOrDefault();

            _welcomeBatch.Command = CommandConst.Create;
            _welcomeBatch.State = StateConst.Failed;
            _welcomeBatch.Filter = "169776792";

            this.DataContext.BatchMasters.Add(_welcomeBatch);
            this.DataContext.SaveChanges();

        }

        private void UpdateCompany1ImportStatus(int importStatus)
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.ImportStatus = importStatus;
                company.UpdatedSPE = DateTime.Now;
                speContext.SaveChanges();
            }
        }

        private void UpdateCompany1SalarySystem(string salarySystem)
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.OTPContracts.FirstOrDefault().SalarySystem = salarySystem;
                company.UpdatedSPE = DateTime.Now;
                speContext.SaveChanges();
            }
        }

        private void UpdateCompany2SalarySystem(string salarySystem)
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.OTPContracts.FirstOrDefault().SalarySystem = salarySystem;
                company.UpdatedSPE = DateTime.Now;
                speContext.SaveChanges();
            }
        }

        private void UpdateCompany1FirstDateSavings(DateTime datetime)
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.OTPContracts.FirstOrDefault().SavingsStartDate = datetime;
                company.UpdatedSPE = DateTime.Now;
                speContext.SaveChanges();
            }
        }

        private void UpdateCompany2FirstDateSavings(DateTime datetime)
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.FirstOrDefault(c => c.CompanyId == companyId);
                company.OTPContracts.FirstOrDefault().SavingsStartDate = datetime;
                company.UpdatedSPE = DateTime.Now;
                speContext.SaveChanges();
            }
        }

        private void UpdateCompany1WithCorrectDataInWelcomeBatch()
        {

            #region Accountant Flow

            //Add accountant/company email
            UpdateCompany1EmailAddress(RoleConstant.Accountant, "accountant@email.com");
            UpdateCompany1EmailAddress(RoleConstant.PrimaryContact, "company@email.com");

            //update salary system
            UpdateCompany1SalarySystem("Visma");

            //update first date savings
            UpdateCompany1FirstDateSavings(DateTime.Now);

            UpdateCompany1CeedingCompany();

            #endregion
        }

        private void UpdateCompany2WithCorrectDataInWelcomeBatch()
        {
            UpdateCompany2EmailAddressAndName(RoleConstant.Accountant, "accountant@email.com", "AccountantFirstName", "AccounantLastName");
            UpdateCompany2EmailAddressAndName(RoleConstant.PrimaryContact, "company2@email.com","CompanyFirstName", "CompanyLastName");
            UpdateCompany2EmailAddressAndName(RoleConstant.Agent, "agent@email.com", "Admin", "SPE");

            UpdateCompany2SalarySystem("Visma");

            UpdateCompany2FirstDateSavings(DateTime.Now);

            UpdateCompany2CeedingCompany();
        }

        private void UpdateCompany2EmailAddressAndName(string roleConstant, string email, string firstName = null, string  lastName = null)
        {

            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            using (var speContext = new SPEContext())
            {
                var company = speContext.Companies.Find(companyId);
                company.Contacts.Add(new Contact()
                {
                    Id = Guid.NewGuid(),
                    Company = company,
                    Email = email,
                    Role = roleConstant,
                    FirstName = firstName ?? "Admin",
                    LastName = lastName ?? "SPE"
                });
                speContext.SaveChanges();
            }


        }

        private void UpdateCompany1EmailAddress(string roleConstant, string email)
            {
                var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
                using (var speContext = new SPEContext())
                {
                    var company = speContext.Companies.Find(companyId);
                    company.Contacts.Add(new Contact() {Id = Guid.NewGuid(), Company = company, Email = email, Role = roleConstant});
                    speContext.SaveChanges();
                }
            }

        private void UpdateSeedingCompany()
        {
            using (var context = new SPEContext())
            {
                context.SavingsProviders.Add(SavingsProvidersTest1);
                context.SaveChanges();
            }
        }

        private void UpdateCompany2CeedingCompany()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000002");
            using (var context = new SPEContext())
            {
                var comp2 = context.Companies.Find(companyId);
                comp2.OTPContracts.FirstOrDefault().SeedingComp = SavingsProvidersTest1.ProviderName;
                context.SaveChanges();
            }
        }

        private void UpdateCompany1CeedingCompany()
        {
            var companyId = Guid.Parse("30000000-0000-0000-0000-000000000001");
            using (var context = new SPEContext())
            {
                var comp2 = context.Companies.Find(companyId);
                comp2.OTPContracts.FirstOrDefault().SeedingComp = SavingsProvidersTest1.ProviderName;
                context.SaveChanges();
            }

        }

        private SavingsProviders SavingsProvidersTest1 => new SavingsProviders() { EmailCedingCompany = "ceeding@email.com", ProviderName = "SavingProviderProviderTest1" , Id = Guid.Parse("A0000000-0000-0000-0000-000000000001"), IsActive = true, Sequence = 10};

        #endregion
    }
}