Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using Microsoft.Reporting.WebForms;
- using SalesReport.Models;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Net;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- namespace SalesReport.Report
- {
- public partial class SalesReport : System.Web.UI.Page
- {
- private void ViewReport()
- {
- if (hdnConcern.Value == "0") return;
- string sessionSerial = hdnSessionSerial.Value;
- string userSerial = hdnUserial.Value;
- rptViewer.ShowParameterPrompts = false;
- rptViewer.ProcessingMode = ProcessingMode.Remote;
- IReportServerCredentials myCred = new SalesReport.CustomReportCredentials("repoviewer", "csldeveloper@007", "");
- rptViewer.ServerReport.ReportServerCredentials = myCred;
- rptViewer.ServerReport.ReportServerUrl = new Uri("http://45.115.115.154/ReportServer");
- List<Microsoft.Reporting.WebForms.ReportParameter> parameters = new List<Microsoft.Reporting.WebForms.ReportParameter>();
- switch (hdnReportType.Value)
- {
- //case "Customer":
- // rptViewer.ServerReport.ReportPath = "/CSLCHEM/RPTCustomer";
- // parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rCustomerSerial", hdnCustomer.Value));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", "1"));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- // break;
- case "BarCode":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTProd";
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- break;
- case "Supplier":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTSupplier";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSupplierSerial", hdnSupplier.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "Customer":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTCustomer";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rCustomerSerial", hdnCustomer.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "PeriodicSale":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTPeriodicSale";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPeriodFrom", hdnFromDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPeriodTo", hdnToDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "CustomerLedger":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTCustomLedger";
- //rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTCustomerLedger";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rCustomerSerial", hdnCustomer.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rLedgerFrom", hdnFromDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rLedgerTo", hdnToDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "ProdFile":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTProd";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnProducTabGenre.Value.Trim()) && !(hdnProducTabGenre.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProducTabGenre", hdnProducTabGenre.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProducTabGenre"));
- }
- if (!String.IsNullOrEmpty(hdnPublisherSerial.Value.Trim()) && !(hdnPublisherSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPublisherSerial", hdnPublisherSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPublisherSerial"));
- }
- if (!String.IsNullOrEmpty(hdnLiteratureGenuSerial.Value.Trim()) && !(hdnLiteratureGenuSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rLiteratureGenuSerial", hdnLiteratureGenuSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rLiteratureGenuSerial"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPublishFrom", hdnFromDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPublishTo", hdnToDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "Invoice":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTInvoice";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rInvoiceSerial", InvoiceSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- //case "ProdReserve":
- // rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTProdReserve";
- // parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSourceSerial", hdnWarehouseSerial.Value));
- // if (!String.IsNullOrEmpty(hdnProdSerial.Value.Trim()) && !(hdnProdSerial.Value == "null"))
- // {
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial", hdnProdSerial.Value));
- // }
- // else
- // {
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial"));
- // }
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- // break;
- case "ProdReserve":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTProdReserve";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSourceSerial", hdnSourceSerial.Value));
- if (!String.IsNullOrEmpty(hdnProdSerial.Value.Trim()) && !(hdnProdSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial", hdnProdSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "SaleScope":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTSaleScope";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- if (!String.IsNullOrEmpty(hdnFromDate.Value.Trim()) && !(hdnFromDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleFrom", hdnFromDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleFrom"));
- }
- if (!String.IsNullOrEmpty(hdnToDate.Value.Trim()) && !(hdnToDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleTo", hdnToDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleTo"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rScopeGenre", hdnScopeGenre.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "CustomerScope":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTCustomerScope";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- if (!String.IsNullOrEmpty(hdnFromDate.Value.Trim()) && !(hdnFromDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleFrom", hdnFromDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleFrom"));
- }
- if (!String.IsNullOrEmpty(hdnToDate.Value.Trim()) && !(hdnToDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleTo", hdnToDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleTo"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rScopeGenre", hdnScopeGenre.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "SalesCompass":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTSalesCompass";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSalesPeriod", hdnFromDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "FinancialRecordBench":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTransactionBench";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- //parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- if (!String.IsNullOrEmpty(hdnFromDate.Value.Trim()) && !(hdnFromDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateFrom", hdnFromDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateFrom"));
- }
- if (!String.IsNullOrEmpty(hdnToDate.Value.Trim()) && !(hdnToDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateTo", hdnToDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateTo"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "FinancialRecord":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTFinancialRecord";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rPersonnelSerial", hdnPersonnelSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- if (!String.IsNullOrEmpty(hdnFromDate.Value.Trim()) && !(hdnFromDate.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateFrom", hdnFromDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateFrom"));
- }
- if (!String.IsNullOrEmpty(hdnToDate.Value.Trim()) && !(hdnToDate.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateTo", hdnToDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateTo"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "SupplierLedger":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTSupplierLedger";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSupplierSerial", hdnSupplier.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rLedgerFrom", hdnFromDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rLedgerTo", hdnToDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "SaleFrequency":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTSaleFrequency";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- //if (!String.IsNullOrEmpty(hdnWarehouseGenre.Value.Trim()) && !(hdnWarehouseGenre.Value == "0"))
- //{
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseGenre", hdnWarehouseGenre.Value));
- //}
- //else
- //{
- // parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseGenre"));
- //}
- if (!String.IsNullOrEmpty(hdnSourceSerial.Value.Trim()) && !(hdnSourceSerial.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnSourceSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSourceSerial"));
- }
- if (!String.IsNullOrEmpty(hdnProducTabGenre.Value.Trim()) && !(hdnProducTabGenre.Value == "0"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProducTabGenre", hdnProducTabGenre.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProducTabGenre"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleDateFrom", hdnFromDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rSaleDateTo", hdnToDate.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "ProdMovemenTab":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTProdMovemenTab";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- if (!String.IsNullOrEmpty(hdnProdSerial.Value.Trim()) && !(hdnProdSerial.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial", hdnProdSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial"));
- }
- if (!String.IsNullOrEmpty(hdnFromDate.Value.Trim()) && !(hdnFromDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateFrom", hdnFromDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateFrom"));
- }
- if (!String.IsNullOrEmpty(hdnToDate.Value.Trim()) && !(hdnToDate.Value == "undefined"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateTo", hdnToDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rDateTo"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "SalesComparison":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTLiteSalesComparison";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- if (!String.IsNullOrEmpty(hdnWarehouseSerial.Value.Trim()) && !(hdnWarehouseSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial", hdnWarehouseSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSerial"));
- }
- if (!String.IsNullOrEmpty(hdnProdSerial.Value.Trim()) && !(hdnProdSerial.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial", hdnProdSerial.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rProdSerial"));
- }
- if (!String.IsNullOrEmpty(hdnFromDate.Value.Trim()) && !(hdnFromDate.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rComparisonFrom", hdnFromDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rComparisonFrom"));
- }
- if (!String.IsNullOrEmpty(hdnToDate.Value.Trim()) && !(hdnToDate.Value == "null"))
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rComparisonTo", hdnToDate.Value));
- }
- else
- {
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rComparisonTo"));
- }
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "Challan":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTChallan";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rChallanSerial", hdnChallanSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- case "WarehouseSlip":
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTWarehouseSlip";
- parameters.Add(new ReportParameter("rSessionSerial", sessionSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rWarehouseSlipSerial", hdnWarehouseSlipSerial.Value));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rUserSerial", userSerial));
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rErr", "0"));
- break;
- default:
- rptViewer.ServerReport.ReportPath = ReportPath.ReportPathUrl + "RPTProd";
- parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("rConcernSerial", hdnConcern.Value));
- break;
- }
- try
- {
- rptViewer.ServerReport.SetParameters(parameters);
- this.rptViewer.ShowReportBody = true;
- rptViewer.ServerReport.Refresh();
- }
- catch (Exception ex)
- {
- string s = ex.Message;
- }
- rptViewer.ShowPrintButton = true;
- }
- protected void Page_Load(object sender, EventArgs e)
- {
- //Is the user logged in?
- //if (!Models.PermissionHelper.IsAuthenticated())
- //{
- // Response.Redirect("/Home", true);
- //}
- //if (Request["reportType"] == null)
- //{
- // Response.Redirect("/Home", true);
- //}
- if (IsPostBack)
- {
- pnlScript.Visible = false;
- btnView.Visible = false;
- }
- else
- {
- //run first time.
- hdnReportType.Value = Request["reportType"].ToString();
- switch (hdnReportType.Value)
- {
- case "BarCode":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "Supplier":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnSupplier.Value = (Request["supplierSerial"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "Customer":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnCustomer.Value = (Request["customerSerial"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "PeriodicSale":
- hdnWarehouseSerial.Value = (Request["warehouseSerial"]);
- hdnFromDate.Value = (Request["fromDate"]);
- hdnToDate.Value = (Request["toDate"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "CustomerLedger":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnCustomer.Value = (Request["customerSerial"]);
- hdnFromDate.Value = (Request["fromDate"]);
- hdnToDate.Value = (Request["toDate"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "Invoice":
- InvoiceSerial.Value = (Request["invoiceSerial"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- //case "ProdReserve":
- // hdnPersonnelSerial.Value = (Request["personnelSerial"]);
- // hdnConcern.Value = (Request["concernSerial"]);
- // hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- // hdnSourceSerial.Value = (Request["sourceSerial"]) == null ? "0" : Request["sourceSerial"];
- // hdnProdSerial.Value = (Request["prodSerial"]) == null ? "0" : Request["prodSerial"];
- // hdnSessionSerial.Value = (Request["sessionSerial"]);
- // hdnUserial.Value = (Request["userSerial"]);
- // hdnApiKey.Value = (Request["apiKey"]);
- // break;
- case "ProdReserve":
- hdnPersonnelSerial.Value = (Request["personnelSerial"]);
- hdnConcern.Value = (Request["concernSerial"]);
- hdnSourceSerial.Value = (Request["sourceSerial"]) == null ? "0" : Request["sourceSerial"];
- hdnProdSerial.Value = (Request["prodSerial"]) == null ? "0" : Request["prodSerial"];
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "SaleScope":
- hdnPersonnelSerial.Value = (Request["userSerial"]);
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnScopeGenre.Value = (Request["scopeGenre"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "CustomerScope":
- hdnPersonnelSerial.Value = (Request["personnelSerial"]);
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnScopeGenre.Value = (Request["scopeGenre"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "SalesCompass":
- hdnPersonnelSerial.Value = (Request["userSerial"]);
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- hdnFromDate.Value = (Request["fromDate"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "FinancialRecord":
- hdnPersonnelSerial.Value = (Request["personnelSerial"]);
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "FinancialRecordBench":
- hdnPersonnelSerial.Value = (Request["userSerial"]);
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "SupplierLedger":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- hdnSupplier.Value = (Request["supplierSerial"]);
- hdnShopSerial.Value = (Request["shopSerial"] == null) ? "0" : Request["shopSerial"];
- hdnFromDate.Value = (Request["fromDate"]);
- hdnToDate.Value = (Request["toDate"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "SaleFrequency":
- hdnWarehouseGenre.Value = (Request["warehouseGenre"] == "null") ? "0" : Request["warehouseGenre"];
- hdnSourceSerial.Value = (Request["sourceSerial"]) == null ? "0" : Request["sourceSerial"];
- hdnProducTabGenre.Value = (Request["producTabGenre"] == "null") ? "0" : Request["producTabGenre"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "ProdMovemenTab":
- hdnWarehouseSerial.Value = (Request["warehouseSerial"]);
- hdnProdSerial.Value = (Request["prodSerial"]) == null ? "0" : Request["prodSerial"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "SalesComparison":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnWarehouseSerial.Value = (Request["warehouseSerial"] == null) ? "0" : Request["warehouseSerial"];
- //hdnProdSerial.Value = (Request["prodSerial"]) == "0" ? null : Request["prodSerial"];
- hdnProdSerial.Value = (Request["prodSerial"]) == null ? "0" : Request["prodSerial"];
- hdnFromDate.Value = (Request["fromDate"]) == null ? "0" : Request["fromDate"];
- hdnToDate.Value = (Request["toDate"]) == null ? "0" : Request["toDate"];
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "Challan":
- hdnConcern.Value = (Request["concernSerial"]);
- hdnChallanSerial.Value = (Request["challanSerial"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- case "WarehouseSlip":
- hdnWarehouseSlipSerial.Value = (Request["warehouseSlipSerial"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- default:
- hdnConcern.Value = (Request["concernSerial"]);
- hdnDistributor.Value = (Request["distributorSerial"]);
- hdnFromDate.Value = (Request["fromDate"]);
- hdnToDate.Value = (Request["toDate"]);
- hdnSessionSerial.Value = (Request["sessionSerial"]);
- hdnUserial.Value = (Request["userSerial"]);
- hdnApiKey.Value = (Request["apiKey"]);
- break;
- }
- }
- }
- protected void btnView_Click(object sender, EventArgs e)
- {
- ViewReport();
- }
- private class CustomReportCredentials : IReportServerCredentials
- {
- private string _UserName;
- private string _PassWord;
- private string _DomainName;
- public CustomReportCredentials(string UserName, string PassWord, string DomainName)
- {
- _UserName = UserName;
- _PassWord = PassWord;
- _DomainName = DomainName;
- }
- public System.Security.Principal.WindowsIdentity ImpersonationUser
- {
- get { return null; }
- }
- public ICredentials NetworkCredentials
- {
- get { return new NetworkCredential(_UserName, _PassWord, _DomainName); }
- }
- public bool GetFormsCredentials(out Cookie authCookie, out string user,
- out string password, out string authority)
- {
- authCookie = null;
- user = password = authority = null;
- return false;
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement