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);
        }
        public void MSExcel2003XmlFile_GenerateDateCell()
        {
            //arrange
            string             comparisonFilename = "data/MSExcel2003XmlFile_DateCell.txt";
            DateTime           date    = new DateTime(1999, 3, 2);
            MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile();
            //act
            XmlNode node = xmlFile.GenerateDateCell(date);
            string  text = XmlDocumentHelper.XmlToString(node);

            //assert
            Assert.AreEqual(Utilities.LoadText(comparisonFilename), text);
        }
        public void MSExcel2003XmlFile_GenerateCell_DateTime()
        {
            //arrange
            DateTime           data    = new DateTime(1999, 3, 2);
            MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile();
            //act
            XmlNode nodeA = xmlFile.GenerateCell(data);
            XmlNode nodeB = xmlFile.GenerateDateCell(data);
            string  textA = XmlDocumentHelper.XmlToString(nodeA);
            string  textB = XmlDocumentHelper.XmlToString(nodeB);

            //assert
            Assert.AreEqual(textA, textB);
        }