using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;
using System.IO;


public partial class _Default : System.Web.UI.Page
{
   // CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1 = new CrystalDecisions.Web.CrystalReportViewer();
    protected void Page_Load(object sender, EventArgs e)
    {
       // Response.Write(Server.MapPath("CTF005.rpt"));
        Page.Controls.Add(CrystalReportViewer1);
      
        try
        {

           // string reportid = Request["reportid"];
            string reportid = "CTF005";
            string objid = "2db9ced16f7947c4a7d7667eaf8cf982";
            if (reportid != null)
            {


                if (!IsPostBack)
                {
                    //Session["XmlStr"] = Server.HtmlDecode(Server.UrlDecode(Request["XMLDATA"]));
                    SqlConnection cnSQL = new SqlConnection(@"Data Source=XXXXXX;");

                    SqlCommand cmd = new SqlCommand();
                    SqlDataAdapter da = new SqlDataAdapter();


                    cmd.CommandText = "select CONTENT from XXX  where objid='" + objid + "'"; //Request["objid"] + "'";
                    cmd.Connection = cnSQL;
                    cnSQL.Open();
                    da.SelectCommand = cmd;
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                    DataRow dr;
                    dr = ds.Tables[0].Rows[0];
                    Session["XmlStr"] = Server.HtmlDecode(Server.UrlDecode(System.Text.Encoding.UTF8.GetString((byte[])dr["CONTENT"])));
                    cnSQL.Close();


                    if (Session["XmlStr"] == null)
                    {
                        Response.Write("Attenzione: Nessun dato da caricare");
                        return;
                    }

                    StringReader XMLstrReader = new StringReader((string)Session["XmlStr"]);
                    DataSet dsTemp = new DataSet();
                    dsTemp.ReadXml(XMLstrReader);
                    ReportDocument Report = new ReportDocument();

                    switch (reportid)
                    {
                        case "CTF005":

                           Report.Load(Server.MapPath("CTF005.rpt"));
                           Report.SetDataSource(dsTemp.Tables[0]);

                           CrystalReportViewer1.ReportSource = Report;
                           CrystalReportViewer1.DataBind();




                            
                        //    CrystalReportViewer1.Visible = true;
                            
                           // ReportExporter1.Visible = true;
                           // ReportExporter1.ReportSource = Server.MapPath("CTF005.rpt");
                          //  CrystalReportViewer1.DataBind();
                            //Report.ExportToHttpResponse(ExportFormatType.WordForWindows, Response, true, "avvocati.doc"); 


                            //Report.Export();
                          
                           // CrystalReportViewer1.ExportReport();
                           // CrystalReportViewer1.HyperlinkTarget = "_blank";

                            // CrystalReportViewer1.HasToggleGroupTreeButton = false;
                            //  CrystalReportViewer1.HasToggleParameterPanelButton = false;
                            //  CrystalReportViewer1.DisplayGroupTree = false;
                            //  CrystalReportViewer1.HasSearchButton = false;
                            //  CrystalReportViewer1.HasRefreshButton = false;
                           // CrystalReportViewer1.HasExportButton = true;
                           // CrystalReportViewer1.HasPrintButton = true;
                            Session["Crreport"] = Report;
                            break;

                        case "CTF006":
                            Report.Load(Server.MapPath("CTF006.rpt"));
                            Report.SetDataSource(dsTemp.Tables[0]);
                            CrystalReportViewer1.ReportSource = Report;
                            Session["Crreport"] = Report;
                            break;
                        case "CTF007":
                            Report.Load(Server.MapPath("CTF007.rpt"));
                            Report.SetDataSource(dsTemp.Tables[0]);
                            CrystalReportViewer1.ReportSource = Report;
                            Session["Crreport"] = Report;
                            break;
                        case "CTF008":
                            Report.Load(Server.MapPath("CTF008.rpt"));
                            Report.SetDataSource(dsTemp.Tables[0]);
                            CrystalReportViewer1.ReportSource = Report;
                            Session["Crreport"] = Report;
                            break;
                        case "CTF009":
                            Report.Load(Server.MapPath("CTF009.rpt"));
                            Report.SetDataSource(dsTemp.Tables[0]);
                            CrystalReportViewer1.ReportSource = Report;
                            Session["Crreport"] = Report;
                            break;
                        case "CTF010":
                            Report.Load(Server.MapPath("CTF010.rpt"));
                            Report.SetDataSource(dsTemp.Tables[0]);
                            CrystalReportViewer1.ReportSource = Report;
                            Session["Crreport"] = Report;
                            break;
                        case "CTF011":
                            Report.Load(Server.MapPath("CTF011.rpt"));
                            Report.SetDataSource(dsTemp.Tables[0]);
                            CrystalReportViewer1.ReportSource = Report;
                            Session["Crreport"] = Report;
                            break;

                    }
                }
                else
                {
                    CrystalReportViewer1.ReportSource = Session["Crreport"];
                }

            }

            else
            {
                Response.Write("Attenzione: Specificare un report da visualizzare");
            }
        }

        catch (Exception ee)
        {
            Response.Write(ee.ToString());
        }

    }
}