public byte[] GetPDFFileByteArray(string formOrdKy, string formObjCaption, string formObjKy, string ReptNo) { List <paramClass> listParam = new List <paramClass>(); string CKy = HTNSession.CKy.ToString(); string UsrKy = HTNSession.UsrKy.ToString(); string UsrNm = HTNSession.UsrId.ToString(); string CNm = HTNSession.CNm.ToString(); string ServerName = ConfigurationManager.AppSettings["ReportServerName"].ToString(); string EnvironmentName = HTNSession.Environment; string ReportServerUrl = WebConfigurationManager.AppSettings["ReportpathforServer"]; string _userName = ConfigurationManager.AppSettings["ReportServerUserName"]; string _pasword = ConfigurationManager.AppSettings["ReportServerPwd"]; ApiOperation apiOpr = new ApiOperation(); List <ObjMasModel> selectedReportProp = apiOpr.UsrObjPrp_SelectWeb( EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), formObjKy, "ReportWeb", null); ObjMasModel selectedReportPropObj = new ObjMasModel(); if (ReptNo == "1") { selectedReportPropObj = selectedReportProp.Where(obj => obj.ObjNm == "SourceReport").SingleOrDefault(); } else { string dynmicObjNm = "SourceReport_" + ReptNo; selectedReportPropObj = selectedReportProp.Where(obj => obj.ObjNm == dynmicObjNm).SingleOrDefault(); } List <ObjMasModel> selectedReportParamProp = apiOpr.UsrObjPrp_SelectWeb( EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), selectedReportPropObj.ObjKy.ToString(), "ReportParameter", null); List <ObjMasModel> selectedReportPrameter = apiOpr.UsrObjPrp_SelectWeb( EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), selectedReportParamProp[0].ObjKy.ToString(), null, null); string paramString = ""; foreach (ObjMasModel dynobj in selectedReportPrameter) { paramClass param = new paramClass(); string ObjNm = dynobj.ObjNm.ToString(); param.Paramname = ObjNm; if (string.Equals(ObjNm, "CKy", StringComparison.CurrentCultureIgnoreCase)) { //paramList.Add(new ReportParameter(ObjNm, CKy)); paramString = paramString + "&" + ObjNm + "=" + CKy; param.ParamValue = CKy; } else if (string.Equals(ObjNm, "UsrKy", StringComparison.CurrentCultureIgnoreCase)) { //paramList.Add(new ReportParameter(ObjNm, UsrKy)); paramString = paramString + "&" + ObjNm + "=" + UsrKy; param.ParamValue = UsrKy; } else if (ObjNm == "ObjKy") { //paramList.Add(new ReportParameter("ObjKy", selectedReportPropObj.ObjKy.ToString())); paramString = paramString + "&ObjKy=" + selectedReportPropObj.ObjKy.ToString(); param.ParamValue = selectedReportPropObj.ObjKy.ToString(); } else if (string.Equals(ObjNm, "CNm", StringComparison.CurrentCultureIgnoreCase)) { //paramList.Add(new ReportParameter(ObjNm, CNm)); paramString = paramString + "&" + ObjNm + "=" + CNm; param.ParamValue = CNm; } else if (string.Equals(ObjNm, "UsrID", StringComparison.CurrentCultureIgnoreCase)) { //paramList.Add(new ReportParameter(ObjNm, UsrNm)); paramString = paramString + "&" + ObjNm + "=" + UsrNm; param.ParamValue = UsrNm; } else if (string.Equals(ObjNm, "RtpTitle", StringComparison.CurrentCultureIgnoreCase)) { //paramList.Add(new ReportParameter(ObjNm, selectedReportPropObj.ObjCaptn)); paramString = paramString + "&" + ObjNm + "=" + selectedReportPropObj.ObjCaptn; param.ParamValue = selectedReportPropObj.ObjCaptn; } else if (string.Equals(ObjNm, "RptTitle", StringComparison.CurrentCultureIgnoreCase)) { //paramList.Add(new ReportParameter(ObjNm, selectedReportPropObj.ObjCaptn)); paramString = paramString + "&" + ObjNm + "=" + selectedReportPropObj.ObjCaptn; param.ParamValue = selectedReportPropObj.ObjCaptn; } else if (ObjNm == "ServerName") { //paramList.Add(new ReportParameter("ServerName", ServerName)); paramString = paramString + "&ServerName=" + ServerName; param.ParamValue = ServerName; } else if (ObjNm == "EnvironmentName") { //paramList.Add(new ReportParameter("EnvironmentName", EnvironmentName)); paramString = paramString + "&EnvironmentName=" + EnvironmentName; param.ParamValue = EnvironmentName; } else if (ObjNm == "TrnKy") { //paramList.Add(new ReportParameter(ObjNm, formOrdKy)); paramString = paramString + "&" + ObjNm + "=" + formOrdKy; param.ParamValue = formOrdKy; } else if (ObjNm == "OdrKy") { //paramList.Add(new ReportParameter(ObjNm, formOrdKy)); paramString = paramString + "&" + ObjNm + "=" + formOrdKy; param.ParamValue = formOrdKy; } else if (ObjNm == "OrdKy") { //paramList.Add(new ReportParameter(ObjNm, formOrdKy)); paramString = paramString + "&" + ObjNm + "=" + formOrdKy; param.ParamValue = formOrdKy; } else if (ObjNm == "FromTrnKy") { //paramList.Add(new ReportParameter(ObjNm, formOrdKy)); paramString = paramString + "&" + ObjNm + "=" + formOrdKy; param.ParamValue = formOrdKy; } else if (ObjNm == "RptNm") { //paramList.Add(new ReportParameter(ObjNm, selectedReportPropObj.ObjCaptn)); paramString = paramString + "&" + ObjNm + "=" + selectedReportPropObj.ObjCaptn; param.ParamValue = selectedReportPropObj.ObjCaptn; } else { //if (ObjNm.EndsWith("Ky") || ObjNm.EndsWith("ky")) //{ // if (varNeededObjVal[ObjNm] == "") // varNeededObjVal[ObjNm] = 1; //} //else if ( // ObjNm.EndsWith("Cd") || // ObjNm.EndsWith("cd") || // ObjNm.EndsWith("CD") || // ObjNm.EndsWith("Nm") || // ObjNm.EndsWith("nm") || // ObjNm.EndsWith("NM")) //{ // if (varNeededObjVal[ObjNm] == "") // varNeededObjVal[ObjNm] = 1; //} //if (varNeededObjVal.ContainsKey(ObjNm)) //{ // string paramObjNm = ObjNm; // if (ObjNm.StartsWith("datPic")) // { // paramObjNm = ObjNm.Replace("datPic", ""); // string joinstring = "/"; // string[] tempsplit = varNeededObjVal[ObjNm].ToString().Split('/'); // varNeededObjVal[ObjNm] = tempsplit[2] + joinstring + tempsplit[1] + joinstring + tempsplit[0]; // } // if (ObjNm.StartsWith("cmb")) // paramObjNm = ObjNm.Replace("cmb", ""); // if (ObjNm.StartsWith("chckBox")) // paramObjNm = ObjNm.Replace("chckBox", ""); // paramList.Add(new ReportParameter(paramObjNm, varNeededObjVal[ObjNm].ToString())); //} } listParam.Add(param); } List <paramClass> listParamTemp = new List <paramClass>(); listParamTemp = listParam; string sTargetURL = ReportServerUrl + "?" + selectedReportPropObj.ReportPath + "&rs:Command=Render&rs:format=PDF"; sTargetURL = sTargetURL + paramString; HttpWebRequest req = (HttpWebRequest)WebRequest.Create(sTargetURL); req.Credentials = new System.Net.NetworkCredential( _userName, _pasword); req.PreAuthenticate = true; HttpWebResponse HttpWResp = (HttpWebResponse)req.GetResponse(); Stream str = HttpWResp.GetResponseStream(); byte[] fileBytes = ReadFully(str); // Working code commentexd by VGSan //FileStream fs = new FileStream(@"C:\Invoice.pdf", FileMode.Create); //fs.Write(fileBytes, 0, fileBytes.Length); //fs.Close(); HttpWResp.Close(); return(fileBytes); }
protected void Page_Load(object sender, EventArgs e) { string formObjKy = Request.QueryString["formObjKy"]; string formOrdKy = Request.QueryString["formOrdKy"]; string ReptNo = Request.QueryString["ReptNo"]; string formObjCaption = Request.QueryString["formObjCaption"]; if (!Page.IsPostBack) { List <paramClass> listParam = new List <paramClass>(); try { MyReportViewer.Visible = true; string CKy = HTNSession.CKy.ToString(); string UsrKy = HTNSession.UsrKy.ToString(); string UsrNm = HTNSession.UsrId.ToString(); string CNm = HTNSession.CNm.ToString(); string ServerName = ConfigurationManager.AppSettings["ReportServerName"].ToString(); string EnvironmentName = HTNSession.Environment; string ReportServerUrl = WebConfigurationManager.AppSettings["ReportpathforServer"]; string _userName = ConfigurationManager.AppSettings["ReportServerUserName"]; string _pasword = ConfigurationManager.AppSettings["ReportServerPwd"]; ApiOperation apiOpr = new ApiOperation(); List <ObjMasModel> selectedReportProp = apiOpr.UsrObjPrp_SelectWeb( EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), formObjKy, "ReportWeb", null); ObjMasModel selectedReportPropObj = new ObjMasModel(); if (ReptNo == "1") { selectedReportPropObj = selectedReportProp.Where(obj => obj.ObjNm == "SourceReport").SingleOrDefault(); } else { string dynmicObjNm = "SourceReport_" + ReptNo; selectedReportPropObj = selectedReportProp.Where(obj => obj.ObjNm == dynmicObjNm).SingleOrDefault(); } List <ObjMasModel> selectedReportParamProp = apiOpr.UsrObjPrp_SelectWeb( EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), selectedReportPropObj.ObjKy.ToString(), "ReportParameter", null); List <ObjMasModel> selectedReportPrameter = apiOpr.UsrObjPrp_SelectWeb( EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), selectedReportParamProp[0].ObjKy.ToString(), null, null); List <ReportParameter> paramList = new List <ReportParameter>(); foreach (ObjMasModel dynobj in selectedReportPrameter) { paramClass param = new paramClass(); string ObjNm = dynobj.ObjNm.ToString(); param.Paramname = ObjNm; if (string.Equals(ObjNm, "CKy", StringComparison.CurrentCultureIgnoreCase)) { paramList.Add(new ReportParameter(ObjNm, CKy)); param.ParamValue = CKy; } else if (string.Equals(ObjNm, "UsrKy", StringComparison.CurrentCultureIgnoreCase)) { paramList.Add(new ReportParameter(ObjNm, UsrKy)); param.ParamValue = UsrKy; } else if (ObjNm == "ObjKy") { paramList.Add(new ReportParameter("ObjKy", selectedReportPropObj.ObjKy.ToString())); param.ParamValue = selectedReportPropObj.ObjKy.ToString(); } else if (string.Equals(ObjNm, "CNm", StringComparison.CurrentCultureIgnoreCase)) { paramList.Add(new ReportParameter(ObjNm, CNm)); param.ParamValue = CNm; } else if (string.Equals(ObjNm, "UsrID", StringComparison.CurrentCultureIgnoreCase)) { paramList.Add(new ReportParameter(ObjNm, UsrNm)); param.ParamValue = UsrNm; } else if (string.Equals(ObjNm, "RtpTitle", StringComparison.CurrentCultureIgnoreCase)) { paramList.Add(new ReportParameter(ObjNm, selectedReportPropObj.ObjCaptn)); param.ParamValue = selectedReportPropObj.ObjCaptn; } else if (string.Equals(ObjNm, "RptTitle", StringComparison.CurrentCultureIgnoreCase)) { paramList.Add(new ReportParameter(ObjNm, selectedReportPropObj.ObjCaptn)); param.ParamValue = selectedReportPropObj.ObjCaptn; } else if (ObjNm == "ServerName") { paramList.Add(new ReportParameter("ServerName", ServerName)); param.ParamValue = ServerName; } else if (ObjNm == "EnvironmentName") { paramList.Add(new ReportParameter("EnvironmentName", EnvironmentName)); param.ParamValue = EnvironmentName; } else if (ObjNm == "TrnKy") { paramList.Add(new ReportParameter(ObjNm, formOrdKy)); param.ParamValue = formOrdKy; } else if (ObjNm == "OdrKy") { paramList.Add(new ReportParameter(ObjNm, formOrdKy)); param.ParamValue = formOrdKy; } else if (ObjNm == "OrdKy") { paramList.Add(new ReportParameter(ObjNm, formOrdKy)); param.ParamValue = formOrdKy; } else if (ObjNm == "FromTrnKy") { paramList.Add(new ReportParameter(ObjNm, formOrdKy)); param.ParamValue = formOrdKy; } else if (ObjNm == "RptNm") { paramList.Add(new ReportParameter(ObjNm, selectedReportPropObj.ObjCaptn)); param.ParamValue = selectedReportPropObj.ObjCaptn; } else { } listParam.Add(param); } List <paramClass> listParamTemp = new List <paramClass>(); listParamTemp = listParam; MyReportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; MyReportViewer.ServerReport.ReportServerUrl = new Uri(ReportServerUrl); MyReportViewer.ServerReport.ReportServerCredentials = new ReportViewerCredentials(_userName, _pasword); MyReportViewer.ServerReport.ReportPath = selectedReportPropObj.ReportPath; MyReportViewer.ShowParameterPrompts = false; MyReportViewer.ServerReport.SetParameters(paramList); MyReportViewer.ServerReport.Refresh(); } catch (Exception ex) { string errMsg = ex.Message.ToString(); throw new Exception(ex.Message.ToString()); } } }
protected void Page_Load(object sender, EventArgs e) { string formObjKy = Request.QueryString["formObjKy"]; string formOrdKy = Request.QueryString["formOrdKy"]; string ReptNo = Request.QueryString["ReptNo"]; string formObjCaption = Request.QueryString["formObjCaption"]; if (!Page.IsPostBack) { List <paramClass> listParam = new List <paramClass>(); try { ReportViewer1.Visible = true; string CKy = HTNSession.CKy.ToString(); string UsrKy = HTNSession.UsrKy.ToString(); string UsrNm = HTNSession.UsrId.ToString(); string CNm = HTNSession.CNm.ToString(); string EnvironmentName = HTNSession.Environment; ApiOperation apiOpr = new ApiOperation(); List <ObjMasModel> selectedReportProp = apiOpr.UsrObjPrp_SelectWeb(EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), formObjKy, "ReportWeb", null); ObjMasModel selectedReportPropObj = new ObjMasModel(); if (ReptNo == "1") { selectedReportPropObj = selectedReportProp.Where(obj => obj.ObjNm == "SourceReport").SingleOrDefault(); } else { string dynmicObjNm = "SourceReport_" + ReptNo; selectedReportPropObj = selectedReportProp.Where(obj => obj.ObjNm == dynmicObjNm).SingleOrDefault(); } List <ObjMasModel> selectedReportParamProp = apiOpr.UsrObjPrp_SelectWeb(EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), selectedReportPropObj.ObjKy.ToString(), "ReportParameter", null); List <ObjMasModel> selectedReportPrameter = apiOpr.UsrObjPrp_SelectWeb(EnvironmentName, Convert.ToInt32(CKy), Convert.ToInt32(UsrKy), selectedReportParamProp[0].ObjKy.ToString(), null, null); var uriReportSource = new Telerik.Reporting.UriReportSource(); string URL = AppDomain.CurrentDomain.BaseDirectory + @"\Reports\TelericcSample\" + selectedReportProp[0].ReportPath; foreach (ObjMasModel dynobj in selectedReportPrameter) { paramClass param = new paramClass(); string ObjNm = dynobj.ObjNm.ToString(); param.Paramname = ObjNm; if (string.Equals(ObjNm, "CKy", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, Convert.ToInt32(CKy))); } else if (string.Equals(ObjNm, "UsrKy", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, Convert.ToInt32(UsrKy))); } else if (ObjNm == "ObjKy") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportPropObj.ObjKy.ToString())); } else if (string.Equals(ObjNm, "CNm", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, CNm)); } else if (string.Equals(ObjNm, "UsrID", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, UsrNm)); } else if (string.Equals(ObjNm, "RtpTitle", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportPropObj.ObjCaptn)); } else if (string.Equals(ObjNm, "RptTitle", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(ObjNm, selectedReportPropObj.ObjCaptn); } else if (ObjNm == "EnvironmentName") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, EnvironmentName)); } else if (ObjNm == "TrnKy") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, Convert.ToInt32(formOrdKy))); } else if (ObjNm == "OdrKy") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, formOrdKy)); } else if (ObjNm == "OrdKy") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, formOrdKy)); } else if (ObjNm == "FromTrnKy") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, formOrdKy)); } else if (ObjNm == "RptNm") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportPropObj.ObjCaptn)); } else { } } uriReportSource.Uri = URL; ReportViewer1.ReportSource = uriReportSource; ReportViewer1.ParametersAreaVisible = false; ReportViewer1.ShowHistoryButtons = false; ReportViewer1.ShowParametersButton = false; ReportViewer1.RefreshReport(); } catch (Exception ex) { string errMsg = ex.Message.ToString(); throw new Exception(ex.Message.ToString()); } } }