Web Development

protected void btnAuthenticateAndPrint_Click(object sender, EventArgs args)
    {
        try
         {
            //SSRS Report Print

            //Getting Values from grid
            LinkButton lb = (LinkButton)sender;
            GridViewRow row = (GridViewRow)lb.NamingContainer;
            Label lbOrderID = row.FindControl("lbOrderID") as Label;
            int OrderId = Convert.ToInt32(lbOrderID.Text);
            da = new SqlDataAdapter("Get_PODetails", con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.AddWithValue("@MPDI_ID", OrderId);
            ds = new DataSet();
            da.Fill(ds, "PO");
            if (ds.Tables["PO"].Rows.Count > 0)
            {
                lblPOId.Text=ds.Tables["PO"].Rows[0]["MPDI_ID"].ToString();
                lblVendid.Text = ds.Tables["PO"].Rows[0]["MVDI_ID"].ToString();
                lblBranch.Text = ds.Tables["PO"].Rows[0]["MBRI_ID"].ToString();
                lblDate.Text = Convert.ToDateTime(ds.Tables["PO"].Rows[0]["MPDI_Date"]).ToString("dd-MMM-yyyy");
            }

           //Setting/Referencing Report Server
            rs = new RSWebService.ReportingService2005();
            rsExec = new REWebService.ReportExecutionService();
            rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rs.Url = "http://localhost/ReportServer/ReportService2005.asmx";
            rsExec.Url = "http://localhost/ReportServer/ReportExecution2005.asmx";
            byte[] Sendresults = null;
            byte[] bytes = null;
            string historyID = null;
            string deviceInfo = @"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
            string format = "PDF";
            string encoding = null;
            string mimeType = null;
            string extension = null;
            //string fileName = "somefilename.txt";
            REWebService.Warning[] warnings = null;
            string[] streamIDs = null;
            //Getting Report Name
            string _reportName = @"/FIMO GOF Assets Reports/GOF PURCHASE ORDER";
            REWebService.ExecutionInfo ei = rsExec.LoadReport(_reportName, historyID);
            //Getting Report Parameters
            REWebService.ParameterValue[] parameters = new REWebService.ParameterValue[3];
            parameters[0] = new REWebService.ParameterValue();
            parameters[0].Name = "MVDI_ID";
            parameters[0].Value = lblVendid.Text;
            parameters[1] = new REWebService.ParameterValue();
            parameters[1].Name = "MBRI_ID";
            parameters[1].Value = lblBranch.Text;
            //parameters[2] = new REWebService.ParameterValue();
            //parameters[2].Name = "MPDI_Date";
            //parameters[2].Value = lblDate.Text;
            parameters[2] = new REWebService.ParameterValue();
            parameters[2].Name = "MPDI_DocNo";
            parameters[2].Value = lblPOId.Text;
            rsExec.SetExecutionParameters(parameters, "en-us");

            //Assingning to byte stream
            Sendresults = rsExec.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
            MemoryStream ms = new MemoryStream(Sendresults);


            //To create a PDF file from byte stream
            FileStream stream = File.Create("Asset Module/Reports/PO_Report.PDF");
            stream.Write(Sendresults, 0, Sendresults.Length);
            stream.Close();

            //Getting the PDF as Output
            Label lbpath1 = new Label();
            lbpath1.Text = "Reports/PO_Report.PDF";
            FileInfo f = new FileInfo(Server.MapPath(lbpath1.Text));
            System.Diagnostics.Process.Start(@"" + f.FullName + "");


         }
        catch (Exception Ex)
        {

            throw Ex;
        }
    }
    #endregion