private void CreateFrontSheet(XLWorkbook workbook, UsedFilterDto usedFilter) { var sheet = workbook.Worksheets.Add("Filters"); var row = sheet.Row(FrontSheetRows.MainHeading); row.Style.Font.SetBold(); row.Style.Font.SetFontSize(14); row.Cell(1).Value = "Export of invitation to punch-outs"; AddUsedFilter(sheet.Row(FrontSheetRows.Plant), "Plant", usedFilter.Plant, true); AddUsedFilter(sheet.Row(FrontSheetRows.ProjectName), "Project name", usedFilter.ProjectName, true); AddUsedFilter(sheet.Row(FrontSheetRows.FilterHeading), "Filter values:", "", true); AddUsedFilter(sheet.Row(FrontSheetRows.Invitation), "Ipo number starts with", usedFilter.IpoIdStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.Title), "Title starts with", usedFilter.IpoTitleStartWith); AddUsedFilter(sheet.Row(FrontSheetRows.CommPkg), "CommPkg number starts with", usedFilter.CommPkgNoStartWith); AddUsedFilter(sheet.Row(FrontSheetRows.McPkg), "McPkg number starts with", usedFilter.McPkgNoStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.PunchOutDateFrom), "Punch out dates from", usedFilter.PunchOutDateFromUtc); AddUsedFilter(sheet.Row(FrontSheetRows.PunchOutDateTo), "Punch out dates to", usedFilter.PunchOutDateToUtc); AddUsedFilter(sheet.Row(FrontSheetRows.LastChangedFrom), "Last changed dates from", usedFilter.LastChangedFromUtc); AddUsedFilter(sheet.Row(FrontSheetRows.LastChangedTo), "Last changed dates to", usedFilter.LastChangedToUtc); AddUsedFilter(sheet.Row(FrontSheetRows.Status), "Ipo status", usedFilter.IpoStatuses); AddUsedFilter(sheet.Row(FrontSheetRows.Role), "Functional role invited", usedFilter.FunctionalRoleInvited); AddUsedFilter(sheet.Row(FrontSheetRows.Person), "Person invited", usedFilter.PersonInvited); sheet.Columns(1, 2).AdjustToContents(); }
private void AssertFiltersSheet(IXLWorksheet worksheet, UsedFilterDto expextedFilterDto) { Assert.IsNotNull(worksheet); AssertRow(worksheet, ExcelConverter.FrontSheetRows.MainHeading, 1, "Export of preserved tags"); AssertBlankRow(worksheet, ExcelConverter.FrontSheetRows.Blank1); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Plant, 2, "Plant", expextedFilterDto.Plant); AssertRow(worksheet, ExcelConverter.FrontSheetRows.ProjectName, 2, "Project", expextedFilterDto.ProjectName); AssertRow(worksheet, ExcelConverter.FrontSheetRows.ProjectDesc, 2, "Project description", expextedFilterDto.ProjectDescription); AssertBlankRow(worksheet, ExcelConverter.FrontSheetRows.Blank2); AssertRow(worksheet, ExcelConverter.FrontSheetRows.FilterHeading, 1, "Filter values:"); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Tag, 2, "Tag number starts with", expextedFilterDto.TagNoStartsWith); AssertRow(worksheet, ExcelConverter.FrontSheetRows.PO, 2, "Purchase order number starts with", expextedFilterDto.PurchaseOrderNoStartsWith); AssertRow(worksheet, ExcelConverter.FrontSheetRows.CO, 2, "Calloff number starts with", expextedFilterDto.CallOffStartsWith); AssertRow(worksheet, ExcelConverter.FrontSheetRows.CommPkg, 2, "CommPkg number starts with", expextedFilterDto.CommPkgNoStartsWith); AssertRow(worksheet, ExcelConverter.FrontSheetRows.McPkg, 2, "McPkg number starts with", expextedFilterDto.McPkgNoStartsWith); AssertRow(worksheet, ExcelConverter.FrontSheetRows.StorageArea, 2, "Storage area starts with", expextedFilterDto.StorageAreaStartsWith); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Status, 2, "Preservation status", expextedFilterDto.PreservationStatus); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Actions, 2, "Preservation actions", expextedFilterDto.ActionStatus); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Voided, 2, "Voided/unvoided tags", expextedFilterDto.VoidedFilter); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Due, 2, "Preservation due date", string.Join(",", expextedFilterDto.DueFilters)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Journeys, 2, "Journeys", string.Join(",", expextedFilterDto.JourneyTitles)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Modes, 2, "Modes", string.Join(",", expextedFilterDto.ModeTitles)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Reqs, 2, "Requirements", string.Join(",", expextedFilterDto.RequirementTypeTitles)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.TF, 2, "Tag functions", string.Join(",", expextedFilterDto.TagFunctionCodes)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Disc, 2, "Disciplines", string.Join(",", expextedFilterDto.DisciplineCodes)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Resp, 2, "Responsibles", string.Join(",", expextedFilterDto.ResponsibleCodes)); AssertRow(worksheet, ExcelConverter.FrontSheetRows.Areas, 2, "Areas", string.Join(",", expextedFilterDto.AreaCodes)); }
private void CreateFrontSheet(XLWorkbook workbook, UsedFilterDto usedFilter) { var sheet = workbook.Worksheets.Add("Filters"); var row = sheet.Row(FrontSheetRows.MainHeading); row.Style.Font.SetBold(); row.Style.Font.SetFontSize(14); row.Cell(1).Value = "Export of preserved tags"; AddUsedFilter(sheet.Row(FrontSheetRows.Plant), "Plant", usedFilter.Plant, true); AddUsedFilter(sheet.Row(FrontSheetRows.ProjectName), "Project", usedFilter.ProjectName, true); AddUsedFilter(sheet.Row(FrontSheetRows.ProjectDesc), "Project description", usedFilter.ProjectDescription, true); AddUsedFilter(sheet.Row(FrontSheetRows.FilterHeading), "Filter values:", "", true); AddUsedFilter(sheet.Row(FrontSheetRows.Tag), "Tag number starts with", usedFilter.TagNoStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.PO), "Purchase order number starts with", usedFilter.PurchaseOrderNoStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.CO), "Calloff number starts with", usedFilter.CallOffStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.CommPkg), "CommPkg number starts with", usedFilter.CommPkgNoStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.McPkg), "McPkg number starts with", usedFilter.McPkgNoStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.StorageArea), "Storage area starts with", usedFilter.StorageAreaStartsWith); AddUsedFilter(sheet.Row(FrontSheetRows.Status), "Preservation status", usedFilter.PreservationStatus); AddUsedFilter(sheet.Row(FrontSheetRows.Actions), "Preservation actions", usedFilter.ActionStatus); AddUsedFilter(sheet.Row(FrontSheetRows.Voided), "Voided/unvoided tags", usedFilter.VoidedFilter); AddUsedFilter(sheet.Row(FrontSheetRows.Due), "Preservation due date", usedFilter.DueFilters); AddUsedFilter(sheet.Row(FrontSheetRows.Journeys), "Journeys", usedFilter.JourneyTitles); AddUsedFilter(sheet.Row(FrontSheetRows.Modes), "Modes", usedFilter.ModeTitles); AddUsedFilter(sheet.Row(FrontSheetRows.Reqs), "Requirements", usedFilter.RequirementTypeTitles); AddUsedFilter(sheet.Row(FrontSheetRows.TF), "Tag functions", usedFilter.TagFunctionCodes); AddUsedFilter(sheet.Row(FrontSheetRows.Disc), "Disciplines", usedFilter.DisciplineCodes); AddUsedFilter(sheet.Row(FrontSheetRows.Resp), "Responsibles", usedFilter.ResponsibleCodes); AddUsedFilter(sheet.Row(FrontSheetRows.Areas), "Areas", usedFilter.AreaCodes); sheet.Columns(1, 2).AdjustToContents(); }
private void AssertUsedFilter(UsedFilterDto usedFilter) { Assert.AreEqual(TestPlant, usedFilter.Plant); Assert.AreEqual(_projectName, usedFilter.ProjectName); Assert.IsNull(usedFilter.IpoIdStartsWith); Assert.IsNull(usedFilter.IpoTitleStartWith); Assert.IsNull(usedFilter.McPkgNoStartsWith); Assert.IsNull(usedFilter.CommPkgNoStartWith); Assert.AreEqual(0, usedFilter.IpoStatuses.Count()); Assert.IsNull(usedFilter.PunchOutDateFromUtc); Assert.IsNull(usedFilter.PunchOutDateToUtc); Assert.IsNull(usedFilter.LastChangedFromUtc); Assert.IsNull(usedFilter.LastChangedToUtc); Assert.IsNull(usedFilter.FunctionalRoleInvited); Assert.IsNull(usedFilter.PersonInvited); }
public ExportDto(IList <ExportTagDto> tags, UsedFilterDto usedFilter) { UsedFilter = usedFilter; Tags = tags ?? new List <ExportTagDto>(); }
public void Setup() { _dut = new ExcelConverter(); _usedFilterDto = new UsedFilterDto( "presActions", new List <string> { "ac1", "ac2" }, "callOffStartsWith", "commPkgNoStartsWith", new List <string> { "dc1", "dc2" }, new List <string> { "df1", "df2" }, new List <string> { "j1", "j2" }, "mcPkgNoStartsWith", new List <string> { "m1", "m2" }, "preservationStatus", "projectDescription", "plant", "projectName", "purchaseOrderNoStartsWith", new List <string> { "rt1", "rt2" }, new List <string> { "r1", "r2" }, "storageAreaStartsWith", new List <string> { "tf" }, "tagNoStartsWith", "voidedFilter"); _exportTagDtoWithoutActionsAndHistory = new ExportTagDto( new List <ExportActionDto>(), "actionStatus1", 1, "areaCode1", 2, "commPkgNo1", "disciplineCode1", true, "journey1", "mcPkgNo1", "mode1", "nextDueAsYearAndWeek1", 4, 5, 6, "purchaseOrderTitle1", "remark1", "requirementTitles1", "responsibleCode1", "status1", "step1", "storageArea1", "tagDescription1", "tagNo1" ); var actionDtos1 = new List <ExportActionDto> { new ExportActionDto( 1, "A", "ADesc", true, new DateTime(1970, 1, 1, 1, 1, 1, DateTimeKind.Utc), null), new ExportActionDto( 2, "B", "BDesc", false, null, new DateTime(2020, 1, 1, 1, 1, 1, DateTimeKind.Utc)) }; _exportTagDtoWithTwoActionsAndTwoHistoryItems = new ExportTagDto( actionDtos1, "actionStatus2", 11, "areaCode2", 12, "commPkgNo2", "disciplineCode2", false, "journey2", "mcPkgNo2", "mode2", "nextDueAsYearAndWeek2", 14, 15, 16, "purchaseOrderTitle2", "remark2", "requirementTitles2", "responsibleCode2", "status2", "step2", "storageArea2", "tagDescription2", "tagNo2" ); _exportTagDtoWithTwoActionsAndTwoHistoryItems.History.Add( new ExportHistoryDto(1, "H1", new DateTime(2021, 2, 3, 4, 5, 6, DateTimeKind.Utc), "Espen Askeladd", null, null, null)); _exportTagDtoWithTwoActionsAndTwoHistoryItems.History.Add( new ExportHistoryDto(2, "H2", new DateTime(2021, 4, 5, 14, 15, 16, DateTimeKind.Utc), "Espen Askeladd", 2, "Details2", "Comment2")); var actionDtos2 = new List <ExportActionDto> { new ExportActionDto( 3, "C", "CDesc", false, null, null) }; _exportTagDtoWithOneActionAndOneHistoryItems = new ExportTagDto( actionDtos2, "actionStatus3", 110, "areaCode3", 120, "commPkgNo3", "disciplineCode3", false, "journey3", "mcPkgNo3", "mode3", "nextDueAsYearAndWeek3", 140, 150, 160, "purchaseOrderTitle3", "remark3", "requirementTitles3", "responsibleCode3", "status3", "step3", "storageArea3", "tagDescription3", "tagNo3" ); _exportTagDtoWithOneActionAndOneHistoryItems.History.Add( new ExportHistoryDto(3, "H3", new DateTime(2021, 4, 5, 14, 15, 16, DateTimeKind.Utc), "Espen Askeladd", 2, "Details3", "Comment3")); }