Esempio n. 1
0
        public void SCR_203_002_RakeForceNewArrivalTime()
        {
            string rakeCode = "";

            string testDataFile = this.testDataPath + @"SCR_203_002_RakeForceNewArrivalTime.xlsx";
            string sheetName    = "TestData";

            using (FileStream stream = File.Open(testDataFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
            {
                using (ExcelPackage package = new ExcelPackage(stream))
                {
                    // get the first worksheet in the workbook
                    ExcelWorksheet workSheet = package.Workbook.Worksheets[sheetName];

                    int rowNumber = 2;

                    Dashboard.GoTo();
                    RakeConstraints.GoToRakesConstraints();

                    while (workSheet.Cells[rowNumber, 1].Value != null)
                    {
                        rakeCode = workSheet.Cells[rowNumber, 1].Value.ToString();
                        if (rakeCode == string.Empty)
                        {
                            break;
                        }

                        RakeConstraintPage rakeConstraint = new RakeConstraintPage();

                        if (workSheet.Cells[rowNumber, 2].Value != null)
                        {
                            rakeConstraint.reason = workSheet.Cells[rowNumber, 2].Value.ToString();
                        }

                        if (workSheet.Cells[rowNumber, 3].Value != null)
                        {
                            rakeConstraint.newArrivalDatetime = workSheet.Cells[rowNumber, 3].Value.ToString();
                        }
                        else
                        {
                            //Add 8 hours
                            rakeConstraint.newArrivalDatetime = System.DateTime.Now.AddHours(8).ToLocalTime().ToString("dd/MM/yyyy HH:mm");
                        }

                        RakeConstraints.SCR_203_002_RakeForceNewArrivalTime(rakeCode, rakeConstraint);

                        RakeConstraintPage rakeConstraintPage = new RakeConstraintPage();

                        RakeConstraints.SCR_203_002_RakeForceNewArrivalTime_Checking(rakeCode, rakeConstraintPage);

                        Assert.AreEqual(rakeConstraint.newArrivalDatetime, rakeConstraintPage.newArrivalDatetime);
                        Assert.AreEqual(rakeConstraint.reason, rakeConstraintPage.reason);

                        rowNumber++;
                    }
                }
            }
        }
Esempio n. 2
0
        public void SCR_203_003_RakeForceUnallocated()
        {
            string rakeCode = "";

            string testDataFile = this.testDataPath + @"SCR_203_003_RakeForceUnallocated.xlsx";
            string sheetName    = "TestData";

            using (FileStream stream = File.Open(testDataFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
            {
                using (ExcelPackage package = new ExcelPackage(stream))
                {
                    // get the first worksheet in the workbook
                    ExcelWorksheet workSheet = package.Workbook.Worksheets[sheetName];

                    int rowNumber = 2;

                    Dashboard.GoTo();
                    RakeConstraints.GoToRakesConstraints();

                    while (workSheet.Cells[rowNumber, 1].Value != null)
                    {
                        rakeCode = workSheet.Cells[rowNumber, 1].Value.ToString();
                        if (rakeCode == string.Empty)
                        {
                            break;
                        }

                        RakeConstraintPage rakeConstraint = new RakeConstraintPage();

                        if (workSheet.Cells[rowNumber, 2].Value != null)
                        {
                            rakeConstraint.reason = workSheet.Cells[rowNumber, 2].Value.ToString();
                        }

                        rakeConstraint.forceRakeToRemainUnallocated = true;
                        RakeConstraints.SCR_203_003_RakeForceUnallocated(rakeCode, rakeConstraint);

                        RakeConstraintPage rakeConstraintPage = new RakeConstraintPage();

                        RakeConstraints.SCR_203_003_RakeForceUnallocated_Checking(rakeCode, rakeConstraintPage);

                        Assert.IsTrue(rakeConstraintPage.forceRakeToRemainUnallocated);
                        Assert.AreEqual(rakeConstraint.reason, rakeConstraintPage.reason);

                        //Change forceRakeToRemainUnallocated back to 'No' so that other tests can go on
                        rakeConstraint.forceRakeToRemainUnallocated = false;
                        RakeConstraints.SCR_203_003_RakeForceUnallocated(rakeCode, rakeConstraint);

                        rowNumber++;
                    }
                }
            }
        }
Esempio n. 3
0
        public void SCR_203_009_RakeForceDumpingDurationOffset()
        {
            string rakeCode = "";

            string testDataFile = this.testDataPath + @"SCR_203_009_RakeForceDumpingDurationOffset.xlsx";
            string sheetName    = "TestData";

            using (FileStream stream = File.Open(testDataFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
            {
                using (ExcelPackage package = new ExcelPackage(stream))
                {
                    // get the first worksheet in the workbook
                    ExcelWorksheet workSheet = package.Workbook.Worksheets[sheetName];

                    int rowNumber = 2;

                    Dashboard.GoTo();
                    RakeConstraints.GoToRakesConstraints();

                    while (workSheet.Cells[rowNumber, 1].Value != null)
                    {
                        rakeCode = workSheet.Cells[rowNumber, 1].Value.ToString();
                        if (rakeCode == string.Empty)
                        {
                            break;
                        }

                        RakeConstraintPage rakeConstraint = new RakeConstraintPage();

                        if (workSheet.Cells[rowNumber, 2].Value != null)
                        {
                            rakeConstraint.reason = workSheet.Cells[rowNumber, 2].Value.ToString();
                        }

                        if (workSheet.Cells[rowNumber, 3].Value != null)
                        {
                            rakeConstraint.dumpingDurationOffset = workSheet.Cells[rowNumber, 3].Value.ToString();
                        }

                        RakeConstraints.SCR_203_009_RakeForceDumpingDurationOffset(rakeCode, rakeConstraint);

                        RakeConstraintPage rakeConstraintPage = new RakeConstraintPage();

                        RakeConstraints.SCR_203_009_RakeForceDumpingDurationOffset_Checking(rakeCode, rakeConstraintPage);

                        Assert.AreEqual(rakeConstraint.dumpingDurationOffset, rakeConstraintPage.dumpingDurationOffset);
                        Assert.AreEqual(rakeConstraint.reason, rakeConstraintPage.reason);

                        rowNumber++;
                    }
                }
            }
        }