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"));
}
