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());
}
}
}
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)
{
if ((!Page.IsPostBack))
{
List <paramClass> listParam = new List <paramClass>();
try
{
ReportViewer1.Visible = true;
string CKy = HTNSession.CKy.ToString();
string UsrKy = HTNSession.UsrKy.ToString();
string CNm = HTNSession.CNm.ToString();
string UsrNm = HTNSession.UsrId.ToString();
string SelectedReportObjKy = Session["SelectedReportObjKy"].ToString();
string SelectedReportObjKyX = "SESSIONXREPORT";
string ServerName = ConfigurationManager.AppSettings["ReportServerName"].ToString();
string EnvironmentName = HTNSession.Environment;
string NeededReportParams = Session["NeededReportParams"].ToString();
string NeededReportParamsFromObjMas = Session["NeededReportParamsFromObjMas"].ToString();
ApiOperation apiOpr = new ApiOperation();
List <ObjMasModel> selectedReportProp = apiOpr.ObjMas_SelectWeb(EnvironmentName, Convert.ToInt32(UsrKy), Convert.ToInt32(CKy), SelectedReportObjKy);
string ReportServerUrl = WebConfigurationManager.AppSettings["ReportpathforServer"];
string _userName = ConfigurationManager.AppSettings["ReportServerUserName"];
string _pasword = ConfigurationManager.AppSettings["ReportServerPwd"];
List <ReportParameter> paramList = new List <ReportParameter>();
List <Object> paramObject = new List <Object>();
JavaScriptSerializer js = new JavaScriptSerializer();
dynamic dynNeededReportParams = js.Deserialize <dynamic>(NeededReportParams);
var varNeededObjVal = dynNeededReportParams as IDictionary <String, object>;
dynamic dynNeededReportParamsFromObjMas = js.Deserialize <dynamic>(NeededReportParamsFromObjMas);
var uriReportSource = new Telerik.Reporting.UriReportSource();
string URL = AppDomain.CurrentDomain.BaseDirectory + @"\Reports\TelerikReport\" + selectedReportProp[0].ReportPath;
foreach (dynamic dynobj in dynNeededReportParamsFromObjMas)
{
paramClass param = new paramClass();
var varObj = dynobj as IDictionary <String, object>;
string ObjNm = varObj["ObjNm"].ToString();
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, SelectedReportObjKy));
}
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, CNm));
}
else if (string.Equals(ObjNm, "RtpTitle", StringComparison.CurrentCultureIgnoreCase))
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportProp[0].ObjCaptn));
}
else if (string.Equals(ObjNm, "RptTitle", StringComparison.CurrentCultureIgnoreCase))
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportProp[0].ObjCaptn));
}
else if (ObjNm == "ServerName")
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, ServerName));
}
else if (ObjNm == "EnvironmentName")
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, EnvironmentName));
}
else
{
if (varNeededObjVal.ContainsKey(ObjNm))
{
//********** Default Setting If NULL : VgSan
#region Default Setting If NULL
if (ObjNm.EndsWith("Ky") || ObjNm.EndsWith("ky"))
{
if (varNeededObjVal[ObjNm].ToString() == "")
{
varNeededObjVal[ObjNm] = 1;
}
}
else if (
ObjNm.EndsWith("Cd") ||
ObjNm.EndsWith("cd") ||
ObjNm.EndsWith("CD") ||
ObjNm.EndsWith("cD") ||
ObjNm.EndsWith("ID") ||
ObjNm.EndsWith("Id") ||
ObjNm.EndsWith("id") ||
ObjNm.EndsWith("iD") ||
ObjNm.EndsWith("Nm") ||
ObjNm.EndsWith("nm") ||
ObjNm.EndsWith("NM") ||
ObjNm.EndsWith("nM"))
{
if (varNeededObjVal[ObjNm].ToString() == "")
{
varNeededObjVal[ObjNm] = " ";
}
}
else if (
ObjNm.StartsWith("datPic"))
{
if (varNeededObjVal[ObjNm].ToString() == "")
{
varNeededObjVal[ObjNm] = null;
}
}
else if (
ObjNm.StartsWith("numricBox"))
{
if (varNeededObjVal[ObjNm].ToString() == "")
{
varNeededObjVal[ObjNm] = null;
}
}
#endregion Default Setting If NULL
if (varNeededObjVal.ContainsKey(ObjNm))
{
string paramObjNm = ObjNm;
if (ObjNm.StartsWith("datPic"))
{
paramObjNm = ObjNm.Replace("datPic", "");
string joinstring = "/";
if (varNeededObjVal[ObjNm] != null)
{
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("cmFrmCdMas_"))
{
paramObjNm = ObjNm.Replace("cmFrmCdMas_", "");
}
if (ObjNm.StartsWith("chckBox"))
{
paramObjNm = ObjNm.Replace("chckBox", "");
}
if (ObjNm.StartsWith("numricBox"))
{
paramObjNm = ObjNm.Replace("numricBox", "");
}
if (ObjNm.StartsWith("textBox"))
{
paramObjNm = ObjNm.Replace("textBox", "");
}
if (varNeededObjVal[ObjNm] != null)
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, varNeededObjVal[ObjNm].ToString()));
}
param.Paramname = paramObjNm;
}
}
else
{
string paramObjNm = ObjNm;
if (ObjNm.StartsWith("cmb"))
{
paramObjNm = ObjNm.Replace("cmb", "");
}
if (ObjNm.StartsWith("cmFrmCdMas_"))
{
paramObjNm = ObjNm.Replace("cmFrmCdMas_", "");
}
if (ObjNm.StartsWith("chckBox"))
{
paramObjNm = ObjNm.Replace("chckBox", "");
}
if (ObjNm.StartsWith("datPic"))
{
paramObjNm = ObjNm.Replace("datPic", "");
}
if (ObjNm.StartsWith("numricBox"))
{
paramObjNm = ObjNm.Replace("numricBox", "");
}
if (ObjNm.StartsWith("textBox"))
{
paramObjNm = ObjNm.Replace("textBox", "");
}
//********** Default Setting If NULL : VgSan
#region Default Setting If NULL
if (ObjNm.EndsWith("Ky") || ObjNm.EndsWith("ky"))
{
param.ParamValue = "1";
paramList.Add(new ReportParameter(paramObjNm, "1"));
}
else if (
ObjNm.EndsWith("Cd") ||
ObjNm.EndsWith("cd") ||
ObjNm.EndsWith("CD") ||
ObjNm.EndsWith("cD") ||
ObjNm.EndsWith("ID") ||
ObjNm.EndsWith("Id") ||
ObjNm.EndsWith("id") ||
ObjNm.EndsWith("iD") ||
ObjNm.EndsWith("Nm") ||
ObjNm.EndsWith("nm") ||
ObjNm.EndsWith("NM") ||
ObjNm.EndsWith("nM"))
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, " "));
}
else if (
ObjNm.StartsWith("datPic"))
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, string.Empty));
}
else if (
ObjNm.StartsWith("numricBox"))
{
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, null));
}
#endregion Default Setting If NULL
param.Paramname = paramObjNm;
}
}
listParam.Add(param);
}
List <paramClass> listParamTemp = new List <paramClass>();
listParamTemp = listParam;
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());
}
}
}
