protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { RPT_DependentReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_DependentReport.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter Department; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "DependentsInformation"; if (Convert.ToString(Request.QueryString["DEPT"]) != "") { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); } else { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { DateTime dt = new DateTime(); dt = Convert.ToDateTime(DateTime.Now.Date); Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(dt)); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, Period, BusinessGroup, Department }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_DependentReport.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "DependentsInformationReports", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { RPT_EmployeeLeavesDetails.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_EmployeeLeavesDetails.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter FromDate; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter ToDate; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "EmployeeLeavesDetails"; if (Convert.ToString(Request.QueryString["TO"]) != "") { ToDate = new Microsoft.Reporting.WebForms.ReportParameter("PeriodEnddate", Convert.ToString(Request.QueryString["TO"])); } else { ToDate = new Microsoft.Reporting.WebForms.ReportParameter("PeriodEnddate", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["FROM"]) != "") { FromDate = new Microsoft.Reporting.WebForms.ReportParameter("PeriodStartdate", Convert.ToString(Request.QueryString["FROM"])); } else { FromDate = new Microsoft.Reporting.WebForms.ReportParameter("PeriodStartdate", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, FromDate, BusinessGroup, ToDate }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_EmployeeLeavesDetails.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeLeaveDetailsReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { RPT_JobOfferReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_JobOfferReport.ServerReport; RPT_JobOfferReport.AsyncRendering = false; if (!RPT_JobOfferReport.Enabled) { RPT_JobOfferReport.CurrentPage = 1; } string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "JobOffer"; Microsoft.Reporting.WebForms.ReportParameter ApplicantId; Microsoft.Reporting.WebForms.ReportParameter JobId; if (Convert.ToString(Request.QueryString["ApplicantId"]) != "") { ApplicantId = new Microsoft.Reporting.WebForms.ReportParameter("ApplicantId", Session["JOBOFFRS_APPLICANT_ID"].ToString()); // Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Request.QueryString["ORG_ID"])); } else { ApplicantId = new Microsoft.Reporting.WebForms.ReportParameter("ApplicantId", "-1"); } if (Convert.ToString(Request.QueryString["JobId"]) != "") { JobId = new Microsoft.Reporting.WebForms.ReportParameter("JobId", Session["JOBOFFRS_REQCODE"].ToString()); // Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Request.QueryString["ORG_ID"])); } else { JobId = new Microsoft.Reporting.WebForms.ReportParameter("JobId", "-1"); } Microsoft.Reporting.WebForms.ReportParameter[] parameters = { ApplicantId, JobId }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_JobOfferReport.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "JobOfferReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Submit_Click(object sender, EventArgs e) { try { RPT_WhtReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_WhtReport.ServerReport; RPT_WhtReport.AsyncRendering = false; if (!RPT_WhtReport.Enabled) { RPT_WhtReport.CurrentPage = 1; } string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); serverReport.ReportPath = "/SmartHR/" + "WHTreport"; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter Department; if (ddl_Department.SelectedIndex != 0) { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", ddl_Department.SelectedValue); } else { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); } if (ddl_BusinessUnit.SelectedIndex != 0) { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", ddl_BusinessUnit.SelectedValue); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (rcmb_payElements.SelectedIndex != 0) { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(rcmb_payElements.SelectedValue)); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, Period, BusinessGroup, Department }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_WhtReport.Visible = true; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Wht", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = ReportViewer1.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter Department; if (Convert.ToString(Request.QueryString["DEPT"]) != null) { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); } else { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != null) { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["PRD"]) != null) { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, Period, BusinessGroup, Department }; serverReport.SetParameters(parameters); serverReport.Refresh(); ReportViewer1.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Default2", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { rvGratuityReportZSReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = rvGratuityReportZSReport.ServerReport; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter Businessunit; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "GrauityReport-ZurichSystems"; if (Convert.ToString(Request.QueryString["zsBU"]) != "") { Businessunit = new Microsoft.Reporting.WebForms.ReportParameter("Businessunit", Convert.ToString(Request.QueryString["zsBU"])); } else { Businessunit = new Microsoft.Reporting.WebForms.ReportParameter("Businessunit", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, Businessunit }; serverReport.SetParameters(parameters); serverReport.Refresh(); rvGratuityReportZSReport.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmGratuityReportZSReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { rv_AssignmentDetails.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = rv_AssignmentDetails.ServerReport; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); serverReport.ReportPath = "/SmartHR/" + "AssignmentDetails"; serverReport.Refresh(); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Emp_AssignmentDetails", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void BindServerReport(MsServerReport serverReport, IReport report) { IRemoteReportProcessingLocation location = (IRemoteReportProcessingLocation)report.ReportProcessingLocation; try { using (ImpersonationCodeSection i = ImpersonationCredentials.FromConnectionString("AnalysisServices").LogOn()) { serverReport.ReportPath = location.Path; serverReport.ReportServerUrl = location.ServerUrl; if (serverReport.IsDrillthroughReport) { // do not need to handle the callback } else { IList <MsReportParameter> parameters = new List <MsReportParameter>(); foreach (IReportParameter parameter in report.ReportParameters) { parameters.Add(new MsReportParameter(parameter.Name, GetParameterValue(parameter))); } serverReport.SetParameters(parameters); } serverReport.Refresh(); } } catch { // can do nothing ? } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { RPT_SalarySlip.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_SalarySlip.ServerReport; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Employee; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter PeriodDetails; string sDomain = ConfigurationSettings.AppSettings["MyReportViewerDomain"]; string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; WebClient wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string Report_Name = string.Empty; if (Convert.ToString(Request.QueryString["Localisation"]) == "AUSTRALIA") { Report_Name = "SalarySlip_Australia"; } else if (Convert.ToString(Request.QueryString["Localisation"]) == "INDIA") { Report_Name = "SalarySlip"; } else { Report_Name = "SalarySlip_Kenya"; } serverReport.ReportPath = MyReportPath + Report_Name; if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } if (Convert.ToString(Request.QueryString["PRDDTL"]) != "") { PeriodDetails = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", Convert.ToString(Request.QueryString["PRDDTL"])); } else { PeriodDetails = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", "-1"); } if (Convert.ToString(Request.QueryString["EMP"]) != "") { Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", Convert.ToString(Request.QueryString["EMP"])); } else { Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, BusinessGroup, Employee, Period, PeriodDetails }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_SalarySlip.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "SalarySlipReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { RPT_CmprsnRptWithPrevMnth.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_CmprsnRptWithPrevMnth.ServerReport; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter PeriodElement; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter BusinessUnit; Microsoft.Reporting.WebForms.ReportParameter Status; string sDomain = ConfigurationSettings.AppSettings["MyReportViewerDomain"]; string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; WebClient wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string Report_Name = string.Empty; Report_Name = "RptWithreportWithPreviousMonth"; serverReport.ReportPath = MyReportPath + Report_Name; if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } if (Convert.ToString(Request.QueryString["PRDDTL"]) != "") { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", Convert.ToString(Request.QueryString["PRDDTL"])); } else { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", "-1"); } if (Convert.ToString(Request.QueryString["ORG"]) != "") { Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Request.QueryString["ORG"])); } else { Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["sts"]) != "") { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", Convert.ToString(Request.QueryString["sts"])); } else { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", "-1"); } Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, BusinessUnit, Period, PeriodElement, Status }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_CmprsnRptWithPrevMnth.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "CmprsnRptWithPrevMnthReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { RPT_Leavebalancesnew.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_Leavebalancesnew.ServerReport; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Employee; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter PeriodElement; Microsoft.Reporting.WebForms.ReportParameter Status; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "RptLeaveBalances"; if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } if (Convert.ToString(Request.QueryString["EMP"]) != "") { Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", Convert.ToString(Request.QueryString["EMP"])); } else { Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", "-1"); } if (Convert.ToString(Request.QueryString["PRDDTL"]) != "") { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", Convert.ToString(Request.QueryString["PRDDTL"])); } else { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); if (Convert.ToString(Request.QueryString["sts"]) != "") { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", Convert.ToString(Request.QueryString["sts"])); } else { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", "-1"); } Microsoft.Reporting.WebForms.ReportParameter[] parameters = { BusinessGroup, Period, Employee, PeriodElement, Organisation, Status }; /// Microsoft.Reporting.WebForms.ReportParameter[] parameters = {Employee,Organisation }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_Leavebalancesnew.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LeaveBalancesReportNew", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { RPT_Ec.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_Ec.ServerReport; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; //Microsoft.Reporting.WebForms.ReportParameter Department; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter PeriodElement; Microsoft.Reporting.WebForms.ReportParameter Employee; /////// Microsoft.Reporting.WebForms.ReportParameter Status; string sDomain = ConfigurationSettings.AppSettings["MyReportViewerDomain"]; string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; WebClient wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); if (Convert.ToString(Session["frm"]) == "edu") { serverReport.ReportPath = MyReportPath + "EducationClaimBalanceReport"; } else { serverReport.ReportPath = MyReportPath + "MedicalClaimReport"; } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("EMPBUSINESSUNITID", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("EMPBUSINESSUNITID", "-1"); } //if (Convert.ToString(Request.QueryString["EMP"]) != "") //{ // Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", Convert.ToString(Request.QueryString["EMP"])); //} //else //{ // Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", "-1"); //} //if (Convert.ToString(Request.QueryString["ORG"]) != "") //{ // Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Request.QueryString["ORG"])); //} //else //{ // Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", "-1"); //} if (Convert.ToString(Request.QueryString["Emp"]) != "") { Employee = new Microsoft.Reporting.WebForms.ReportParameter("EMPID", Convert.ToString(Request.QueryString["Emp"])); } else { Employee = new Microsoft.Reporting.WebForms.ReportParameter("EMPID", "-1"); } if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("EDUPERIODID", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("EDUPERIODID", "-1"); } if (Convert.ToString(Request.QueryString["PRDDTL"]) != "") { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PRDDTLID", Convert.ToString(Request.QueryString["PRDDTL"])); } else { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PRDDTLID", "-1"); } //Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { BusinessGroup, Employee, Period, PeriodElement }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_Ec.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "SpouseReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { rv_PFcontribution.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = rv_PFcontribution.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessUnit; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; //Microsoft.Reporting.WebForms.ReportParameter Department; Microsoft.Reporting.WebForms.ReportParameter PeriodElement; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "PROVIDENTFUND_CONTRIBUTION"; if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } if (Convert.ToString(Request.QueryString["PERIODELEMENT"]) != "") { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", Convert.ToString(Request.QueryString["PERIODELEMENT"])); } else { PeriodElement = new Microsoft.Reporting.WebForms.ReportParameter("PeriodElement", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } //if (Convert.ToString(Request.QueryString["DEPT"]) != "") //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); //} //else //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); //} Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Period, PeriodElement, BusinessUnit, Organisation }; serverReport.SetParameters(parameters); serverReport.Refresh(); rv_PFcontribution.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "PF_contributionReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Submit_Click(object sender, EventArgs e) { try { RPT_ExpenseReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_ExpenseReport.ServerReport; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); serverReport.ReportPath = "/SmartHR/" + "Employee Expense Report"; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Employee; Microsoft.Reporting.WebForms.ReportParameter StartDate; Microsoft.Reporting.WebForms.ReportParameter EndDate; Microsoft.Reporting.WebForms.ReportParameter Includedates; Microsoft.Reporting.WebForms.ReportParameter Organisation; Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); if (ddl_BusinessUnit.SelectedIndex != 0) { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", ddl_BusinessUnit.SelectedValue); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (ddl_Employee.SelectedIndex != 0) { Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", Convert.ToString(ddl_Employee.SelectedValue)); } else { Employee = new Microsoft.Reporting.WebForms.ReportParameter("Employee", "-1"); } if ((txt_StartDate.SelectedDate != null) && (txt_EndDate.SelectedDate != null)) { Includedates = new Microsoft.Reporting.WebForms.ReportParameter("Includedates", "YES"); StartDate = new Microsoft.Reporting.WebForms.ReportParameter("StartDate", txt_StartDate.SelectedDate.Value.ToShortDateString()); EndDate = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", txt_EndDate.SelectedDate.Value.ToShortDateString()); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { BusinessGroup, Employee, Includedates, StartDate, EndDate }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_ExpenseReport.Visible = true; } if ((txt_StartDate.SelectedDate != null) && (txt_EndDate.SelectedDate == null)) { Includedates = new Microsoft.Reporting.WebForms.ReportParameter("Includedates", "YES"); StartDate = new Microsoft.Reporting.WebForms.ReportParameter("StartDate", txt_StartDate.SelectedDate.Value.ToShortDateString()); EndDate = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", DateTime.Now.ToShortDateString()); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { BusinessGroup, Employee, Includedates, StartDate, EndDate }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_ExpenseReport.Visible = true; } else { Includedates = new Microsoft.Reporting.WebForms.ReportParameter("INCLUDEDATES", "NO"); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { BusinessGroup, Employee, Includedates }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_ExpenseReport.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Expense_Report", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { rv_payslip.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = rv_payslip.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter Department; Microsoft.Reporting.WebForms.ReportParameter Employee; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "Pay_Slip"; if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("PERIOD", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("PERIOD", "-1"); } if (Convert.ToString(Request.QueryString["EMP"]) != "") { Employee = new Microsoft.Reporting.WebForms.ReportParameter("EMPLOYEE", Convert.ToString(Request.QueryString["EMP"])); } else { Employee = new Microsoft.Reporting.WebForms.ReportParameter("EMPLOYEE", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BUSINESSUNIT", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BUSINESSUNIT", "-1"); } if (Convert.ToString(Request.QueryString["DEPT"]) != "") { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); } else { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organization", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Period, Employee, BusinessGroup, Department, Organisation }; serverReport.SetParameters(parameters); serverReport.Refresh(); rv_payslip.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Employee_PaySlipReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { RPT_Cecd.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_Cecd.ServerReport; Microsoft.Reporting.WebForms.ReportParameter ORGANISATION; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; //Microsoft.Reporting.WebForms.ReportParameter Department; Microsoft.Reporting.WebForms.ReportParameter Employee; Microsoft.Reporting.WebForms.ReportParameter Status; string sDomain = ConfigurationSettings.AppSettings["MyReportViewerDomain"]; string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; WebClient wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); serverReport.ReportPath = MyReportPath + "RptCurrentEmployeeContract"; if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BUSINESSUNIT", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BUSINESSUNIT", "-1"); } if (Convert.ToString(Request.QueryString["EMP"]) != "") { Employee = new Microsoft.Reporting.WebForms.ReportParameter("EMPLOYEE", Convert.ToString(Request.QueryString["EMP"])); } else { Employee = new Microsoft.Reporting.WebForms.ReportParameter("EMPLOYEE", "-1"); } if (Convert.ToString(Request.QueryString["ORG"]) != "") { ORGANISATION = new Microsoft.Reporting.WebForms.ReportParameter("ORGANISATION", Convert.ToString(Request.QueryString["ORG"])); } else { ORGANISATION = new Microsoft.Reporting.WebForms.ReportParameter("ORGANISATION", "-1"); } /// Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); if (Convert.ToString(Request.QueryString["sts"]) != "") { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", Convert.ToString(Request.QueryString["sts"])); } else { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", "-1"); } Microsoft.Reporting.WebForms.ReportParameter[] parameters = { ORGANISATION, BusinessGroup, Employee, Status }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_Cecd.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "CurrentEmpContractdetailsReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_Nhif.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessUnit; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter Department; Microsoft.Reporting.WebForms.ReportParameter Directorate; Microsoft.Reporting.WebForms.ReportParameter PeriodDetail; Microsoft.Reporting.WebForms.ReportParameter SubDepartment; Microsoft.Reporting.WebForms.ReportParameter Status; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "NHIF Report"; //"NHIF_Report11"; if (Request.QueryString["BU"] != "") { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Request.QueryString["DIR"] != "") { Directorate = new Microsoft.Reporting.WebForms.ReportParameter("Directorate", Convert.ToString(Request.QueryString["DIR"])); } else { Directorate = new Microsoft.Reporting.WebForms.ReportParameter("Directorate", "-1"); } if (Request.QueryString["DEPT"] != "") { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); } else { Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); } if (Request.QueryString["PRD"] != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } if (Request.QueryString["PE"] != "") { PeriodDetail = new Microsoft.Reporting.WebForms.ReportParameter("PeriodDetail", Convert.ToString(Request.QueryString["PE"])); } else { PeriodDetail = new Microsoft.Reporting.WebForms.ReportParameter("PeriodDetail", "-1"); } if (Convert.ToString(Request.QueryString["Sts"]) != "") { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", Convert.ToString(Request.QueryString["Sts"])); } else { Status = new Microsoft.Reporting.WebForms.ReportParameter("Status", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); SubDepartment = new Microsoft.Reporting.WebForms.ReportParameter("SubDepartment", "-1"); //Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, Period, BusinessUnit, Department }; Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, BusinessUnit, Directorate, Department, SubDepartment, Period, PeriodDetail, Status }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_Nhif.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Nhif_report", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { RPT_AppraisalDoneReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_AppraisalDoneReport.ServerReport; Microsoft.Reporting.WebForms.ReportParameter Organisation; Microsoft.Reporting.WebForms.ReportParameter BusinessUnit; Microsoft.Reporting.WebForms.ReportParameter AppraisalCycle; Microsoft.Reporting.WebForms.ReportParameter RptMgr; string sDomain = ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "Appraisal Done"; if (Convert.ToString(Request.QueryString["ORG_ID"]) != "") { Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Request.QueryString["ORG_ID"])); } else { Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", "-1"); } if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessUnit = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["AppCycle"]) != "") { AppraisalCycle = new Microsoft.Reporting.WebForms.ReportParameter("AppraisalCycle", Convert.ToString(Request.QueryString["AppCycle"])); } else { AppraisalCycle = new Microsoft.Reporting.WebForms.ReportParameter("AppraisalCycle", "-1"); } if (Convert.ToString(Request.QueryString["RptMgr"]) != "") { RptMgr = new Microsoft.Reporting.WebForms.ReportParameter("RptMgr", Convert.ToString(Request.QueryString["RptMgr"])); } else { RptMgr = new Microsoft.Reporting.WebForms.ReportParameter("RptMgr", "-1"); } Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, BusinessUnit, AppraisalCycle, RptMgr }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_AppraisalDoneReport.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Pms_AppraisalDoneReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { RPT_PayRoll.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_PayRoll.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; Microsoft.Reporting.WebForms.ReportParameter Period; Microsoft.Reporting.WebForms.ReportParameter Organisation; //Microsoft.Reporting.WebForms.ReportParameter Department; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string Report_Name = string.Empty; string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; if (Convert.ToString(Request.QueryString["Localisation"]).ToUpper() == "KENYA") { Report_Name = "PayRollSummary_Kenya"; } else { Report_Name = "PayRollSummary"; } serverReport.ReportPath = MyReportPath + Report_Name; //if (Convert.ToString(Request.QueryString["DEPT"]) != "") //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); //} //else //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); //} if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } if (Convert.ToString(Request.QueryString["PRD"]) != "") { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); } else { Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); } Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, Period, BusinessGroup }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_PayRoll.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "PayrollSummaryReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { RPT_ResignationReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; Microsoft.Reporting.WebForms.ServerReport serverReport = default(Microsoft.Reporting.WebForms.ServerReport); serverReport = RPT_ResignationReport.ServerReport; Microsoft.Reporting.WebForms.ReportParameter BusinessGroup; //Microsoft.Reporting.WebForms.ReportParameter StartDate; //Microsoft.Reporting.WebForms.ReportParameter EndDate; Microsoft.Reporting.WebForms.ReportParameter Organisation; //Microsoft.Reporting.WebForms.ReportParameter Department; Microsoft.Reporting.WebForms.ReportParameter StartDate; Microsoft.Reporting.WebForms.ReportParameter EndDate; Microsoft.Reporting.WebForms.ReportParameter Checked; //Microsoft.Reporting.WebForms.ReportParameter Period; string sDomain = System.Configuration.ConfigurationSettings.AppSettings["MyReportViewerDomain"]; WebClient Wc = new WebClient(); Reports.ReportServerNetworkCredentials _ObjNC = new Reports.ReportServerNetworkCredentials(); serverReport.ReportServerCredentials = _ObjNC; serverReport.ReportServerUrl = new Uri(sDomain); string MyReportPath = System.Configuration.ConfigurationSettings.AppSettings["MyReportPath"]; serverReport.ReportPath = MyReportPath + "ResignedEmployees"; //if (Convert.ToString(Request.QueryString["DEPT"]) != null) //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); //} //else //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); //} if (Convert.ToString(Request.QueryString["BU"]) != "") { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", Convert.ToString(Request.QueryString["BU"])); } else { BusinessGroup = new Microsoft.Reporting.WebForms.ReportParameter("BusinessUnit", "-1"); } //if (Convert.ToString(Request.QueryString["DEPT"]) != "") //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", Convert.ToString(Request.QueryString["DEPT"])); //} //else //{ // Department = new Microsoft.Reporting.WebForms.ReportParameter("Department", "-1"); //} if (Convert.ToString(Request.QueryString["From"]) != "") { StartDate = new Microsoft.Reporting.WebForms.ReportParameter("StartDate", Convert.ToString(Request.QueryString["From"])); Checked = new Microsoft.Reporting.WebForms.ReportParameter("IncludeDate", Convert.ToString(1)); } else { StartDate = new Microsoft.Reporting.WebForms.ReportParameter("StartDate", "01/01/2010"); Checked = new Microsoft.Reporting.WebForms.ReportParameter("IncludeDate", Convert.ToString(0)); } if (Convert.ToString(Request.QueryString["To"]) != "") { EndDate = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", Convert.ToString(Request.QueryString["To"])); Checked = new Microsoft.Reporting.WebForms.ReportParameter("IncludeDate", Convert.ToString(1)); } else { EndDate = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", "01/01/2010"); Checked = new Microsoft.Reporting.WebForms.ReportParameter("IncludeDate", Convert.ToString(0)); } //if (Convert.ToString(Request.QueryString["PRD"]) != "") //{ // Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", Convert.ToString(Request.QueryString["PRD"])); //} //else //{ // Period = new Microsoft.Reporting.WebForms.ReportParameter("Period", "-1"); //} //if (Convert.ToString(Request.QueryString["PRD"]) != "") //{ // StartDate = new Microsoft.Reporting.WebForms.ReportParameter("StartDate", Convert.ToString(Request.QueryString["PRD"])); //} //else //{ // StartDate = new Microsoft.Reporting.WebForms.ReportParameter("StartDate", "-1"); //} //if (Convert.ToString(Request.QueryString["PRD1"]) != "") //{ // EndDate = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", Convert.ToString(Request.QueryString["PRD"])); //} //else //{ // EndDate = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", "-1"); //} Organisation = new Microsoft.Reporting.WebForms.ReportParameter("Organisation", Convert.ToString(Session["ORG_ID"])); Microsoft.Reporting.WebForms.ReportParameter[] parameters = { Organisation, BusinessGroup, StartDate, EndDate, Checked }; serverReport.SetParameters(parameters); serverReport.Refresh(); RPT_ResignationReport.Visible = true; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "ResignationReport", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }