public void SCR_203_035_StockpileForceOpeningStatus() { string stockpile = ""; string testDataFile = this.testDataPath + @"SCR_203_035_StockpileForceOpeningStatus.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(); StockpileConstraints.GoToStockpilesConstraints(); while (workSheet.Cells[rowNumber, 1].Value != null) { StockpileConstraintPage stockpileConstraint = new StockpileConstraintPage(); stockpile = workSheet.Cells[rowNumber, 1].Value.ToString(); if (stockpile == string.Empty) { break; } if (workSheet.Cells[rowNumber, 2].Value != null) { stockpileConstraint.reason = workSheet.Cells[rowNumber, 2].Value.ToString(); } if (workSheet.Cells[rowNumber, 3].Value != null) { stockpileConstraint.forceOpeingStatus = workSheet.Cells[rowNumber, 3].Value.ToString(); } StockpileConstraints.SCR_203_035_StockpileForceOpeningStatus(stockpile, stockpileConstraint); StockpileConstraintPage stockpileConstraintPage = new StockpileConstraintPage(); StockpileConstraints.SCR_203_035_StockpileForceOpeningStatus_Checking(stockpile, stockpileConstraintPage); Assert.AreEqual(stockpileConstraint.forceOpeingStatus, stockpileConstraintPage.forceOpeingStatus); Assert.AreEqual(stockpileConstraint.reason, stockpileConstraintPage.reason); rowNumber++; } } } }
public void SCR_203_038_StockpileForceUnavailableForReclaiming() { string stockpile = ""; string testDataFile = this.testDataPath + @"SCR_203_038_StockpileForceUnavailableForReclaiming.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(); StockpileConstraints.GoToStockpilesConstraints(); while (workSheet.Cells[rowNumber, 1].Value != null) { StockpileConstraintPage stockpileConstraint = new StockpileConstraintPage(); stockpile = workSheet.Cells[rowNumber, 1].Value.ToString(); if (stockpile == string.Empty) { break; } if (workSheet.Cells[rowNumber, 2].Value != null) { stockpileConstraint.reason = workSheet.Cells[rowNumber, 2].Value.ToString(); } if (workSheet.Cells[rowNumber, 3].Value != null) { stockpileConstraint.unavailableForReclaimingFromDatetime = workSheet.Cells[rowNumber, 3].Value.ToString(); } else { //Add 7 hours stockpileConstraint.unavailableForReclaimingFromDatetime = System.DateTime.Now.AddHours(7).ToLocalTime().ToString("dd/MM/yyyy HH:mm"); } if (workSheet.Cells[rowNumber, 4].Value != null) { stockpileConstraint.unavailableForReclaimingToDatetime = workSheet.Cells[rowNumber, 4].Value.ToString(); } else { //Add 8 hours stockpileConstraint.unavailableForReclaimingToDatetime = System.DateTime.Now.AddHours(8).ToLocalTime().ToString("dd/MM/yyyy HH:mm"); } StockpileConstraints.SCR_203_038_StockpileForceUnavailableForReclaiming(stockpile, stockpileConstraint); StockpileConstraintPage stockpileConstraintPage = new StockpileConstraintPage(); StockpileConstraints.SCR_203_038_StockpileForceUnavailableForReclaiming_Checking(stockpile, stockpileConstraintPage); Assert.AreEqual(stockpileConstraint.unavailableForReclaimingFromDatetime, stockpileConstraintPage.unavailableForReclaimingFromDatetime); Assert.AreEqual(stockpileConstraint.unavailableForReclaimingToDatetime, stockpileConstraintPage.unavailableForReclaimingToDatetime); Assert.AreEqual(stockpileConstraint.reason, stockpileConstraintPage.reason); rowNumber++; } } } }