public void PicklistXlsxFileCreator_CanSetReservationLinesOnPageOne() { var work_book = new XLWorkbook(); work_book.AddWorksheet("TestSheet"); var work_sheet = work_book.Worksheets.First(); work_sheet.Range(10, 1, 39, 3).Merge(); work_sheet.Range(66, 1, 95, 3).Merge(); var picklist = new LugBulkPicklist(); for (int i = 0; i < 30; i++) { picklist.Reservations.Add(new LugBulkReservation() { Buyer = new LugBulkBuyer() { Id = i, Name = ("B" + i.ToString()) } }); } PicklistXlsxFileCreator.Create(work_sheet, picklist); for (int i = 0; i < 30; i++) { Assert.That(work_sheet.Cell(i + 2, "E").Value.ToString(), Is.EqualTo(i.ToString())); Assert.That(work_sheet.Cell(i + 2, "F").Value.ToString(), Is.EqualTo("B" + i.ToString())); } }
public void PicklistXlsxFileCreator_CanSetElementInfoOnPageTwo() { var work_book = new XLWorkbook(); work_book.AddWorksheet("TestSheet"); var work_sheet = work_book.Worksheets.First(); work_sheet.Range(10, 1, 39, 3).Merge(); work_sheet.Range(66, 1, 95, 3).Merge(); var picklist = new LugBulkPicklist(); picklist.BricklinkColor = "Tan"; picklist.BricklinkDescription = "Brick Brick"; picklist.ElementID = "1234"; picklist.MaterialColor = "Brick Yellow"; for (int i = 0; i < 60; i++) { picklist.Reservations.Add(new LugBulkReservation() { Buyer = new LugBulkBuyer() }); } PicklistXlsxFileCreator.Create(work_sheet, picklist); Assert.That(work_sheet.Cell(57, "B").Value.ToString(), Is.EqualTo("1234")); Assert.That(work_sheet.Cell(58, "B").Value.ToString(), Is.EqualTo("Brick Brick")); Assert.That(work_sheet.Cell(61, "B").Value.ToString(), Is.EqualTo("Tan")); Assert.That(work_sheet.Cell(62, "B").Value.ToString(), Is.EqualTo("Brick Yellow")); }
public void PicklistXlsxFileCreator_WillDeletePageTwoMergedCellsWhenOnlyPageOneIsNeeded() { var work_book = new XLWorkbook(); work_book.AddWorksheet("TestSheet"); var work_sheet = work_book.Worksheets.First(); work_sheet.Range(2, 2, 4, 3).Merge(); work_sheet.Range(10, 1, 39, 3).Merge(); work_sheet.Range(58, 2, 60, 3).Merge(); work_sheet.Range(66, 1, 95, 3).Merge(); var picklist = new LugBulkPicklist(); Assert.That(work_sheet.MergedRanges.Count, Is.EqualTo(4)); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 2), Is.True); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 10), Is.True); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 58), Is.True); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 66), Is.True); PicklistXlsxFileCreator.Create(work_sheet, picklist); Assert.That(work_sheet.MergedRanges.Count, Is.EqualTo(2)); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 2), Is.True); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 10), Is.True); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 58), Is.False); Assert.That(work_sheet.MergedRanges .Any(x => x.RangeAddress.FirstAddress.RowNumber == 66), Is.False); }
public void PicklistXlsxFileCreator_WillDeletePageTwoElementInfoWhenOnlyPageOneIsNeeded() { var work_book = new XLWorkbook(); work_book.AddWorksheet("TestSheet"); var work_sheet = work_book.Worksheets.First(); work_sheet.Range(10, 1, 39, 3).Merge(); work_sheet.Range(66, 1, 95, 3).Merge(); var picklist = new LugBulkPicklist(); picklist.BricklinkColor = "Tan"; picklist.BricklinkDescription = "Brick Brick"; picklist.ElementID = "1234"; picklist.MaterialColor = "Brick Yellow"; work_sheet.Cell(57, "A").Value = "Junk"; work_sheet.Cell(58, "A").Value = "Junk"; work_sheet.Cell(61, "A").Value = "Junk"; work_sheet.Cell(62, "A").Value = "Junk"; work_sheet.Cell(57, "B").Value = "Junk"; work_sheet.Cell(58, "B").Value = "Junk"; work_sheet.Cell(61, "B").Value = "Junk"; work_sheet.Cell(62, "B").Value = "Junk"; PicklistXlsxFileCreator.Create(work_sheet, picklist); Assert.That(work_sheet.Cell(57, "A").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(58, "A").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(61, "A").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(62, "A").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(57, "B").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(58, "B").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(61, "B").Value.ToString(), Is.EqualTo("")); Assert.That(work_sheet.Cell(62, "B").Value.ToString(), Is.EqualTo("")); }
public void PicklistXlsxFileCreator_CanSetElementInfoOnPageOne() { var work_book = new XLWorkbook(); work_book.AddWorksheet("TestSheet"); var work_sheet = work_book.Worksheets.First(); work_sheet.Range(10, 1, 39, 3).Merge(); work_sheet.Range(66, 1, 95, 3).Merge(); var picklist = new LugBulkPicklist(); picklist.BricklinkColor = "Tan"; picklist.BricklinkDescription = "Brick Brick"; picklist.ElementID = "1234"; picklist.MaterialColor = "Brick Yellow"; PicklistXlsxFileCreator.Create(work_sheet, picklist); Assert.That(work_sheet.Cell(1, "B").Value.ToString(), Is.EqualTo("1234")); Assert.That(work_sheet.Cell(2, "B").Value.ToString(), Is.EqualTo("Brick Brick")); Assert.That(work_sheet.Cell(5, "B").Value.ToString(), Is.EqualTo("Tan")); Assert.That(work_sheet.Cell(6, "B").Value.ToString(), Is.EqualTo("Brick Yellow")); }