Need method to return XElement instead of byte[]

Question

I have the following method that I need to return an XElement. The problem is that can't figure out how to convert a byte[] into an XElement.

public XElement ServiceCallForNewMadidPlantReport()
{
    var kpiReportClient = new ReportExecutionService();
    kpiReportClient.Credentials = System.Net.CredentialCache.DefaultCredentials;
    var endPoint = new EndpointAddress("*****");
    kpiReportClient.Url = endPoint.ToString();

    //render arguments 
    byte[]result = null;
    string reportSickTimePlants = "/Human Resources/KPI POW/Kpi_Fmla_Summarized_Plants_Prg"; //report path
    string format = "XML";
    string historyID = null;
    string devInfo = "";

    //prepare report parameter
    ParameterValue[] parameters = new ParameterValue[4];
    parameters[0] = new ParameterValue();
    parameters[0].Name = "Location";
    parameters[0].Value = "4"; //New Madrid
    parameters[1] = new ParameterValue();
    parameters[1].Name = "UnCode";
    parameters[1].Value = "Non-Union";
    parameters[2] = new ParameterValue();
    parameters[2].Name = "StartDate";
    parameters[2].Value = "01/01/2006";
    parameters[3] = new ParameterValue();
    parameters[3].Name = "EndDate";
    parameters[3].Value = "08/08/2012";

    string encoding;
    string mimeType;
    string extension;
    Warning[] warnings = null;            
    string[] streamIDs;

    ExecutionInfo execInfo = new ExecutionInfo();
    ExecutionHeader execHeader = new ExecutionHeader();
    kpiReportClient.ExecutionHeaderValue = execHeader;

    var trustedUserHeader = new TrustedUserHeader();            

    execInfo = kpiReportClient.LoadReport(reportSickTimePlants, historyID);

    kpiReportClient.SetExecutionParameters(parameters, "en-us");

    String SessionId = kpiReportClient.ExecutionHeaderValue.ExecutionID;

    Console.WriteLine("SessionID: {0}", kpiReportClient.ExecutionHeaderValue.ExecutionID);

    try
    {
        result = kpiReportClient.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
        Console.WriteLine(result);
        execInfo = kpiReportClient.GetExecutionInfo();
    }
    catch (SoapException e)
    {
        Console.WriteLine(e.Detail.OuterXml);
    }
    try
    {
        FileStream sickTimReportForPlants = File.Create("SickTimeNonRepEmpReport.xml", result.Length);
        Console.WriteLine("File created.");
        Console.WriteLine(sickTimReportForPlants);
        sickTimReportForPlants.Write(result, 0, result.Length);
        Console.WriteLine("Result written to the file.");                
        sickTimReportForPlants.Close();
    }
    catch (Exception e)
    {
        Console.WriteLine(e.Message);
    }
    return ? (must be XElement)
}

Here is what I have tried but it doesn't work:

result = kpiReportClient.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
Console.WriteLine(result);
string resultString  = Convert.ToBase64String(result);
var nonRepSickReportForNM = XElement.Parse(resultString);

This gives me the following error:

System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.

I've tried several other ways as well but no matter what I do I get the same error. Here is what the xml file looks like:

I'm not sure what I am doing wrong.

EDIT:

after doing the following:

string resultFromBytes = UTF8Encoding.UTF8.GetString(result);
return XDocument.Parse(resultFromBytes).Root;

I still get the same error message but here is my xml from resultFromBytes

EDIT:

After doing this:

string resultFromBytes = UTF8Encoding.UTF8.GetString(result);
var regex = new System.Text.RegularExpressions.Regex(@"xsi:schemaLocation="".+""");
string strippedxml = regex.Replace(resultFromBytes, "");
return XDocument.Parse(strippedxml).Root;

I get the same failure. This is what the strippedxml looks like:

EDIT:

Tried this and xml looks much better but still fails with same error:

string resultFromBytes = UTF8Encoding.UTF8.GetString(result);
var regex = new System.Text.RegularExpressions.Regex(@"xsi:schemaLocation="".+""");
string strippedxml = regex.Replace(resultFromBytes, "");
return XDocument.Parse(strippedxml).Root;

here's what the xml from strippedxml looks like:

Programming Newbie · Accepted Answer

I have the answer. I was trying to converti it from a byte[] to an XElement. Instead, I converted it into a stream and THEN into the Xelement. Like this:

result = kpiReportClient.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
Console.WriteLine(result);
result = kpiReportClient.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
Stream resStream = new MemoryStream(result);
var nonRepSickReportForNM = XElement.Load(resStream);
return nonRepSickReportForNM

I can't take credit for it though. My boss figured it out.

Need method to return XElement instead of byte[]

Answers (2)

Related Questions