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)
{
if ((!Page.IsPostBack))
{
List <paramClass> listParam = new List <paramClass>();
try
{
MyReportViewer.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";
//SelectedReportObjKy = Convert.ToInt32(SelectedReportObjKy) <= Int64.MaxValue * ((int)SelectedReportObjKyX[7]) ? SelectedReportObjKy.ToString() : "1278";
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>();
// EX : CKy, FrmDt, ToDt, BUKy, PrjKy, isHideZeroTrn, isStk, PFrmDt, PToDt
JavaScriptSerializer js = new JavaScriptSerializer();
dynamic dynNeededReportParams = js.Deserialize <dynamic>(NeededReportParams);
var varNeededObjVal = dynNeededReportParams as IDictionary <String, object>;
dynamic dynNeededReportParamsFromObjMas = js.Deserialize <dynamic>(NeededReportParamsFromObjMas);
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))
{
param.ParamValue = CKy.ToString();
paramList.Add(new ReportParameter(ObjNm, CKy));
}
else if (string.Equals(ObjNm, "UsrKy", StringComparison.CurrentCultureIgnoreCase))
{
param.ParamValue = UsrKy.ToString();
paramList.Add(new ReportParameter(ObjNm, UsrKy));
}
else if (ObjNm == "ObjKy")
{
param.ParamValue = SelectedReportObjKy.ToString();
paramList.Add(new ReportParameter("ObjKy", SelectedReportObjKy));
}
else if (string.Equals(ObjNm, "CNm", StringComparison.CurrentCultureIgnoreCase))
{
param.ParamValue = CNm;
paramList.Add(new ReportParameter(ObjNm, CNm));
}
else if (string.Equals(ObjNm, "UsrID", StringComparison.CurrentCultureIgnoreCase))
{
param.ParamValue = UsrNm;
paramList.Add(new ReportParameter(ObjNm, UsrNm));
}
else if (string.Equals(ObjNm, "RtpTitle", StringComparison.CurrentCultureIgnoreCase))
{
param.ParamValue = selectedReportProp[0].ObjCaptn;
paramList.Add(new ReportParameter(ObjNm, selectedReportProp[0].ObjCaptn));
}
else if (string.Equals(ObjNm, "RptTitle", StringComparison.CurrentCultureIgnoreCase))
{
param.ParamValue = selectedReportProp[0].ObjCaptn;
paramList.Add(new ReportParameter(ObjNm, selectedReportProp[0].ObjCaptn));
}
else if (ObjNm == "ServerName")
{
param.ParamValue = ServerName;
paramList.Add(new ReportParameter("ServerName", ServerName));
}
else if (ObjNm == "EnvironmentName")
{
param.ParamValue = EnvironmentName;
paramList.Add(new ReportParameter("EnvironmentName", 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)
{
param.ParamValue = varNeededObjVal[ObjNm].ToString();
paramList.Add(new ReportParameter(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"))
{
param.ParamValue = " ";
paramList.Add(new ReportParameter(paramObjNm, " "));
}
else if (
ObjNm.StartsWith("datPic"))
{
param.ParamValue = null;
paramList.Add(new ReportParameter(paramObjNm, string.Empty));
}
else if (
ObjNm.StartsWith("numricBox"))
{
param.ParamValue = null;
//paramList.Add(new ReportParameter(paramObjNm, null));
}
#endregion Default Setting If NULL
param.Paramname = paramObjNm;
}
}
listParam.Add(param);
}
List <paramClass> listParamTemp = new List <paramClass>();
listParamTemp = listParam;
MyReportViewer.ProcessingMode = ProcessingMode.Remote;
MyReportViewer.ServerReport.ReportServerUrl = new Uri(ReportServerUrl);
MyReportViewer.ServerReport.ReportServerCredentials = new ReportViewerCredentials(_userName, _pasword);
MyReportViewer.ServerReport.ReportPath = selectedReportProp[0].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());
}
}
}