public System.Text.StringBuilder processCSVData(System.Text.StringBuilder sb1, string url)
{
List <Classes.DataColumns> genericResults = new List <Classes.DataColumns>();
ScraperClasses.Contracts sc = new ScraperClasses.Contracts();
int rowCounter = 0;
sc.getHTMLContents(genericResults, url);
sb1.Append(genericResults[0].column1 + ",");
sb1.Append(genericResults[0].column2 + ",");
sb1.Append(genericResults[0].column3 + ",");
sb1.Append(genericResults[0].column4);
sb1.Append(System.Environment.NewLine);
foreach (Classes.DataColumns s in genericResults)
{
if (!rowCounter++.Equals(0))
{
sb1.Append(String.Format("\"{0}\"", s.column1));
sb1.Append(",");
sb1.Append(String.Format("\"{0}\"", s.column2));
sb1.Append(",");
sb1.Append(String.Format("\"{0}\"", s.column3));
sb1.Append(",");
sb1.Append(String.Format("\"{0}\"", s.column4));
sb1.Append(System.Environment.NewLine);
}
}
WebOperationContext.Current.OutgoingResponse.ContentType = "text/csv";
WebOperationContext.Current.OutgoingResponse.Headers.Add("content-disposition", "attachment; filename=" + Resources.Contracts.filename + ".csv");
return(sb1);
}
public XmlDocument writeXML(string url, string quarter, string langid)
{
XmlNode rootNode;
XmlNode node1, node2, node3, node4;
String _quarter = String.Empty;
String _topLevelNode = String.Empty;
String _column = String.Empty;
String _header1, _header2, _header3, _header4;
int rowCounter = 0;
XmlDocument doc = new XmlDocument();
XmlNode docNode = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
doc.AppendChild(docNode);
List <Classes.DataColumns> genericResults = new List <Classes.DataColumns>();
ScraperClasses.Contracts sc = new ScraperClasses.Contracts();
sc.getHTMLContents(genericResults, url);
XmlNode topLevelNode = doc.CreateElement(Resources.Contracts.topLevelNode);
doc.AppendChild(topLevelNode);
// the first row contains the header information and is used to build the xml nodes
_header1 = genericResults[0].column1;
_header2 = genericResults[0].column2;
_header3 = genericResults[0].column3;
_header4 = genericResults[0].column4;
foreach (Classes.DataColumns s in genericResults)
{
if (!rowCounter++.Equals(0))
{
rootNode = doc.CreateElement(getRootNode(quarter));
topLevelNode.AppendChild(rootNode);
node1 = doc.CreateElement(_header1);
node1.AppendChild(doc.CreateTextNode(s.column1));
rootNode.AppendChild(node1);
node2 = doc.CreateElement(_header2);
node2.AppendChild(doc.CreateTextNode(s.column2));
rootNode.AppendChild(node2);
node3 = doc.CreateElement(_header3);
node3.AppendChild(doc.CreateTextNode(s.column3));
rootNode.AppendChild(node3);
node4 = doc.CreateElement(_header4);
node4.AppendChild(doc.CreateTextNode(s.column4.Replace(",", String.Empty).Replace("$", String.Empty)));
rootNode.AppendChild(node4);
}
}
return(doc);
}
