public void AdaptProductsPlace_ShouldRecognizeByEurocodeAndAddThem()
{
string testFile = $@"{projectDirectory}\ProductExcelSheets.app.tests\testGlasses_{this.GetCurrentMethod()}.xlsx";
if (File.Exists(testFile))
{
File.Delete(testFile);
}
File.Copy(filePath, testFile);
ExcelManager excelManager = new ExcelManager(mockedFileLogger.Object, "test.info", testFile);
string quantitiesSheet = "quantities";
string interchangeablesSheet = "interchangeables";
string targetSheet = "SaintGobain";
excelManager.AdaptProductsPlace(quantitiesSheet, targetSheet, interchangeablesSheet);
var fileinfo = new FileInfo(testFile);
if (fileinfo.Exists)
{
using (ExcelPackage excelPackage = new ExcelPackage(fileinfo))
{
ExcelWorkbook excelWorkBook = excelPackage.Workbook;
ExcelWorksheet excelWorksheet = excelWorkBook.Worksheets.Where(s => s.Name == targetSheet).FirstOrDefault();
var euroCodeTargetColumn = excelWorksheet.Cells["1:1"].First(c => c.Value.ToString() == "Eurocode").Start.Column;
var liulinTargetColumn = excelWorksheet.Cells["1:1"].First(c => c.Value.ToString() == "Liulin").Start.Column;
var slatinaTargetColumn = excelWorksheet.Cells["1:1"].First(c => c.Value.ToString() == "Slatina").Start.Column;
var rouseTargetColumn = excelWorksheet.Cells["1:1"].First(c => c.Value.ToString() == "Rouse").Start.Column;
int rangeMaxRows = excelWorksheet.Dimension.End.Row;
for (int i = 2; i <= rangeMaxRows; i++)
{
string cellStrEurocode = excelWorksheet.Cells[i, euroCodeTargetColumn].Value.ToString();
if (cellStrEurocode == "2436LGNS4RD")
{
string cellLiulin = excelWorksheet.Cells[i, liulinTargetColumn].Value.ToString();
Assert.AreEqual(cellLiulin, "Стойка 1");
string cellSlatina = excelWorksheet.Cells[i, slatinaTargetColumn].Value.ToString();
Assert.AreEqual(cellSlatina, "Стойка 2");
string cellRuse = excelWorksheet.Cells[i, rouseTargetColumn].Value.ToString();
Assert.AreEqual(cellRuse, "Стойка 3");
}
else if (cellStrEurocode == "3030ASMM")
{
string cellLiulin = excelWorksheet.Cells[i, liulinTargetColumn].Value.ToString();
Assert.AreEqual(cellLiulin, "16");
string cellSlatina = excelWorksheet.Cells[i, slatinaTargetColumn].Value.ToString();
Assert.AreEqual(cellSlatina, "18");
string cellRuse = excelWorksheet.Cells[i, rouseTargetColumn].Value.ToString();
Assert.AreEqual(cellRuse, "35");
}
else if (cellStrEurocode == "8534AGNGN" || cellStrEurocode == "testEurocodeAGNGN")
{
string cellLiulin = excelWorksheet.Cells[i, liulinTargetColumn].Value.ToString();
Assert.AreEqual(cellLiulin, "3");
string cellSlatina = excelWorksheet.Cells[i, slatinaTargetColumn].Value.ToString();
Assert.AreEqual(cellSlatina, "3");
string cellRuse = excelWorksheet.Cells[i, rouseTargetColumn].Value.ToString();
Assert.AreEqual(cellRuse, "3");
}
else if (cellStrEurocode == "4633AGN" || cellStrEurocode == "8834AGN")
{
string cellLiulin = excelWorksheet.Cells[i, liulinTargetColumn].Value.ToString();
Assert.AreEqual(cellLiulin, "55");
string cellSlatina = excelWorksheet.Cells[i, slatinaTargetColumn].Value.ToString();
Assert.AreEqual(cellSlatina, "55");
string cellRuse = excelWorksheet.Cells[i, rouseTargetColumn].Value.ToString();
Assert.AreEqual(cellRuse, "55");
}
else
{
Assert.IsTrue(excelManager.IsCellEmpty(excelWorksheet.Cells[i, liulinTargetColumn].Value));
Assert.IsTrue(excelManager.IsCellEmpty(excelWorksheet.Cells[i, slatinaTargetColumn].Value));
Assert.IsTrue(excelManager.IsCellEmpty(excelWorksheet.Cells[i, rouseTargetColumn].Value));
}
}
}
}
this.RemoveFile(testFile);
}