public void WriteTo(MSExcel2003XmlFile xmlFile)
{
int tableIndex = xmlFile.AddWorksheet(SHEET_NAME);
xmlFile.AddHeaderRow(tableIndex, new List <string>()
{
STATUS_NAME, ACTIVE_NAME, "", CATEGORY_NAME, "", ID_NAME
});
List <XmlNode> statusNodes = Statuses.Select(status => xmlFile.GenerateTextCell(status.Name)).ToList();
List <XmlNode> activeNodes = Statuses.Select(status => xmlFile.GenerateTextCell((status.Active ? "Active" : "Inactive"))).ToList(); //todo: make constants, but not connected to table names
List <XmlNode> categoryNodes = Categories.Select(category => xmlFile.GenerateTextCell(category)).ToList();
xmlFile.AddColumns(tableIndex, new List <List <XmlNode> >()
{
statusNodes,
activeNodes,
new List <XmlNode>(),
categoryNodes,
new List <XmlNode>(),
new List <XmlNode>()
{
xmlFile.GenerateNumberCell(MaxId)
}
});
}
public void MSExcel2003XmlFile_GenerateNumberCell()
{
//arrange
string comparisonFilename = "data/MSExcel2003XmlFile_NumberCell.txt";
int number = 100;
MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile();
//act
XmlNode node = xmlFile.GenerateNumberCell(number);
string text = XmlDocumentHelper.XmlToString(node);
//assert
Assert.AreEqual(Utilities.LoadText(comparisonFilename), text);
}
public void MSExcel2003XmlFile_GenerateCell_Integer()
{
//arrange
int data = 123;
MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile();
//act
XmlNode nodeA = xmlFile.GenerateCell(data);
XmlNode nodeB = xmlFile.GenerateNumberCell(data);
string textA = XmlDocumentHelper.XmlToString(nodeA);
string textB = XmlDocumentHelper.XmlToString(nodeB);
//assert
Assert.AreEqual(textA, textB);
}
public void WriteTask(MSExcel2003XmlFile xmlFile, int tableIndex, Task task, bool isActive)
{
List <XmlNode> cellNodes = new List <XmlNode>()
{
xmlFile.GenerateNumberCell(task.Id),
xmlFile.GenerateParagraphCell(task.Description),
xmlFile.GenerateTextCell(task.Status),
xmlFile.GenerateTextCell(task.Category),
xmlFile.GenerateDateCell(task.CreateDate)
};
if (!isActive && task.DoneDate.HasValue)
{
cellNodes.Add(xmlFile.GenerateDateCell(task.DoneDate.Value));
}
xmlFile.AddRow(tableIndex, cellNodes);
}
