コード例 #1
0
        public void ThenFileStatusShouldUpdateToRejectionWithOptionToStartAgain()
        {
            //Implement front end part here before below code
            int rowReturned = DBConnectHelper.RowReturnedQuery("Select * from ECO.MeasuresProcessingError where FileName" +
                                                               " ='MP_311204_December2018_Measure_Processing_Errors.csv' and StatusProcessingError = 5", DatabaseName.ECO);

            Assert.AreEqual(rowReturned, 7);
            bool deleteFile = DBConnectHelper.DeleteRow("dbo.documents", "fileName", Path.GetFileName(suppliersMRNsFile2), DatabaseName.Documents);

            Assert.IsTrue(deleteFile);
            bool deleteErrors = DBConnectHelper.DeleteRow("ECO.MeasuresProcessingError", "fileName", Path.GetFileName(suppliersMRNsFile2), DatabaseName.ECO);

            Assert.IsTrue(deleteErrors);
            StartAgain();
        }
コード例 #2
0
        public void ThenFileRecordWillContainFilenameUploadedUsernameAndCreationTimestamp(string p0)
        {
            string fileName = Path.GetFileName(validFile);

            switch (p0)
            {
            case "Initial Upload":
                GetFileDetailsInDB(fileName, 1, p0);
                break;

            case "Duplicate Upload":
                GetFileDetailsInDB(fileName, 2, p0);
                bool deleteFile = DBConnectHelper.DeleteRow("dbo.documents", "fileName", fileName, DatabaseName.Documents);
                Assert.IsTrue(deleteFile);
                break;
            }
        }
コード例 #3
0
ファイル: FileFormatSteps.cs プロジェクト: mrmervin/Ecotest
        public void ThenFileWillBeProcessedWithRecordCreatedInDatabase(string p0)
        {
            Logger.Info("Verifying database for file deatils");
            string fileName  = WhichFile(p0);
            int    numOfRows = DBConnectHelper.RowReturnedQuery("Select * from dbo.documents where filename = '" + fileName + "'; ", DatabaseName.Documents);

            Assert.AreEqual(1, numOfRows);
            List <DatabaseResult> output = DBConnectHelper.GetQueryResult(
                "SELECT Version,DocId,Created_at FROM dbo.Documents where filename = '" + fileName + "' order by Created_at desc", DatabaseName.Documents);
            string todaysDate          = DateTime.Now.ToString("M/d/yyyy");
            string dateRetrievedFromDB = output[0].thirdColumn.Split(' ')[0];

            Assert.AreEqual(todaysDate, dateRetrievedFromDB);
            bool deleteFile = DBConnectHelper.DeleteRow("dbo.documents", "fileName", fileName, DatabaseName.Documents);

            Assert.IsTrue(deleteFile);
        }