public void IsDisapproved_ShouldReturnDisapprovalStatus()
        {
            InboundStrEmailsHandler iSEHandler = new InboundStrEmailsHandler(this.DbPath);
            bool actualApproval = iSEHandler.IsDisapproved("file1.xlsx");

            Assert.True(!actualApproval);
        }
        public void GetCurrentPhaseViaFileNameTests_ShouldReturnCorrectPhase()
        {
            InboundStrEmailsHandler iSEHandler = new InboundStrEmailsHandler(this.DbPath);
            string actualPhase   = iSEHandler.GetCurrentPhaseViaFileName("file1.xlsx");
            string expectedPhase = "PHASE2";

            Assert.Equal(expectedPhase, actualPhase);
        }
        public void InsertToDbTests_ShouldInsertInboundEmailsToDb()
        {
            foreach (List <string> emailX in InboundEmailsList)
            {
                string fileName      = emailX[0];
                string subject       = emailX[1];
                string emailUsername = emailX[2];
                string response      = emailX[3];
                string responseDate  = emailX[4];
                InboundStrEmailsHandler iSEHandler = new InboundStrEmailsHandler(this.DbPath, fileName, subject, emailUsername, response, responseDate);
                iSEHandler.InsertToDb();
            }
            MyDbUtils muForRead     = new MyDbUtils(this.DbPath);
            long      actualCount   = muForRead.CountEntries("InboundStrEmails");
            long      expectedCount = 12;

            Assert.Equal(expectedCount, actualCount);
        }