protected void Page_Load(object sender, EventArgs e) { string sAgentNo = ""; string sAgentName = ""; string sError; string sFN = WebConfigurationManager.AppSettings["SavePDFPath"].ToString() + "AgentDashboard.pdf"; string sYearFrom = Request.QueryString["YearFrom"].ToString(); string sYearTo = Request.QueryString["YearTo"].ToString(); if (Convert.ToInt32(Session["Internal"]) != 1) { sAgentNo = Agent.GetAgentCode(Agent.GetMGMAgentNo(Session["RepName"].ToString()), Session["RepName"].ToString()); sAgentName = Session["RepName"].ToString(); } else { sAgentNo = Request.QueryString["AgentNo"].ToString(); sAgentName = Request.QueryString["AgentName"].ToString().Replace("88", "&"); } string sAgentCode = Agent.GetAgentCode(Convert.ToInt32(sAgentNo), sAgentName); AgentDashboardPDF adPDF = new AgentDashboardPDF(new DateTime(Convert.ToInt32(sYearFrom), 1, 1), new DateTime(Convert.ToInt32(sYearTo), 12, 31), sAgentName == "All Agents" ? "All Agents" : sAgentCode, sAgentName, sAgentNo, sFN); if (!adPDF.CreatePDF(out sError)) { System.Web.HttpContext.Current.Response.Write("<h1>No Data Found</h1>"); } else { System.Web.HttpContext.Current.Response.ClearContent(); System.Web.HttpContext.Current.Response.ClearHeaders(); System.Web.HttpContext.Current.Response.ContentType = "application/pdf"; System.Web.HttpContext.Current.Response.WriteFile(sFN); } }
/// <summary> /// Preview the selected report with the selected options. /// </summary> /// <param name="sTarget"></param> protected void Preview(string sTarget) { string sRptName = ""; string sUserName = Session["UserName"].ToString(); string sAgentName = ""; int iInternal = Convert.ToInt32(Session["Internal"]); string sAgent = ""; string sAgentCode = ""; string sError; if (sTarget == "Performance") { sRptName = "PerformancePDF"; } else if (sTarget == "Gift Card") { sRptName = "GiftCardPromotionPDF"; } else if (sTarget == "Agent Stock Prices") { sRptName = "AgentStockPricesPDF"; } else if (sTarget == "Pending Approvals") { sRptName = "AdminPendingApprovals"; } else if (sTarget == "M1 Customer Sales") { sRptName = "M1CustSales"; } else if (sTarget == "Quote Status") { sRptName = "QuoteStatusPDF"; } else if (sTarget == "Inventory") { sRptName = "InventoryPDF"; } else if (sTarget == "Agent Dashboard") { sRptName = "AgentDashboard"; } else { return; } string sRedirect = ""; if (pnlCriteria.Visible == true) { if (ValidateDateRange() == true) { string sRepID = ""; // 0 = Current Rep - Always this choice if not Admin. if (rblAll.SelectedValue == "0" || rblAll.Visible == false) { sRepID = Session["RepID"].ToString(); } // 1 = All Reps. else { sRepID = "0"; } string sDateFrom = txtFrom.Text.ToString(); string sDateTo = txtTo.Text.ToString(); if (sTarget == "M1 Customer Sales") { string sProductCat = rblProductCat.SelectedValue; if (ddlAgents.Visible == true) { sRepID = ddlAgents.SelectedValue; } else { sRepID = Session["MGMAgentNo"].ToString(); } sRepID = string.IsNullOrEmpty(sRepID) ? "-1" : sRepID; lblAgentReqd.Visible = false; // If no rep selected, show Agent required and exit. if (sRepID == "-1") { lblAgentReqd.Visible = true; return; } sRedirect = "~/" + sRptName + ".aspx?AgentNo=" + sRepID + "&DateFrom=" + sDateFrom + "&DateTo=" + sDateTo + "&ProductCat=" + sProductCat; } else if (sTarget == "Performance") { sRedirect = "~/" + sRptName + ".aspx?DateFrom=" + sDateFrom + "&DateTo=" + sDateTo + "&RepID=" + sRepID + "&UserName="******"Quote Status") { sRedirect = "~/" + sRptName + ".aspx?DateFrom=" + sDateFrom + "&DateTo=" + sDateTo + "&UserName="******"Inventory") { if (ddlAgentsWithWarehouse.Visible == true) { sRepID = ddlAgentsWithWarehouse.SelectedValue; } else { sRepID = "-1";// Session["MGMAgentNo"].ToString(); } if (rbSelectAgentInventory.Checked) { sRepID = string.IsNullOrEmpty(sRepID) ? "-1" : sRepID; lblAgentReqd.Visible = false; // If no rep selected, show Agent required and exit. if (sRepID == "-1") { lblAgentReqd.Visible = true; return; } } sAgentName = ddlAgentsWithWarehouse.Items[ddlAgentsWithWarehouse.SelectedIndex].ToString(); sRedirect = "~/" + sRptName + ".aspx?Agent=" + sRepID + "&Name=" + Server.UrlEncode(sAgentName) + "&All=" + (rbAllAgentInventory.Checked ? "true" : "false") + "&KVA=0&VoltageCat=ALL&VoltageDisp=&Windings=&Searching=false"; if (rbSearchAvailability.Checked) { sRedirect = "~/" + sRptName + ".aspx?Agent=" + sRepID + "&Name=" + Server.UrlEncode(sAgentName) + "&All=true&KVA=" + (ddKVA.SelectedItem.Text == "ALL" ? "0" : ddKVA.SelectedItem.Text) + "&VoltageCat=" + StockVoltages.GetCategory(ddVoltage.SelectedItem.Text, rblWindings.SelectedItem.Text) + "&VoltageDisp=" + ddVoltage.SelectedItem.Text + "&Windings=" + (rblWindings.SelectedItem.Text == "Aluminum" ? "Al" : "Cu") + "&Searching=true"; } } else if (sTarget == "Agent Dashboard") { int _iStartDate = Convert.ToInt32(ddlDistributorDashboardFromYear.SelectedItem.ToString()); int _iEndDate = Convert.ToInt32(ddlDistributorDashboardToYear.SelectedItem.ToString()); if (_iEndDate - _iStartDate + 1 > 6) { lblNotEnoughDataDashboard.Text = "Maximum 6 Years Time Span."; return; } if (Convert.ToInt32(Session["Internal"]) == 1) { sAgent = Agent.GetAgentCode(Convert.ToInt32(ddlAgents.SelectedItem.Value), ddlAgents.SelectedItem.Text); } else { sAgent = Agent.GetAgentCode(Agent.GetMGMAgentNo(Session["RepName"].ToString()), Session["RepName"].ToString()); } if (sAgent == "") { lblNotEnoughDataDashboard.Text = "Agent information not found."; return; } sAgentName = Session["RepName"].ToString(); if (ddlAgents.Visible) { if ((ddlAgents.SelectedItem.Value == "-1") && (iInternal == 1)) { lblInventoryExternal.ForeColor = System.Drawing.Color.Red; lblInventoryExternal.Text = "Agent Required"; lblInventoryExternal.Visible = true; return; } sAgent = ddlAgents.SelectedItem.Value; sAgentName = ddlAgents.SelectedItem.Text; } if (Convert.ToInt32(Session["Internal"]) == 1) { sAgentCode = Agent.GetAgentCode(Convert.ToInt32(sAgent), ddlAgents.SelectedItem.Text); } else { sAgentCode = Agent.GetAgentCode(Convert.ToInt32(sAgent), sAgentName); } AgentDashboardPDF adPDF = new AgentDashboardPDF(new DateTime(Convert.ToInt32(ddlDistributorDashboardFromYear.SelectedItem.ToString()), 1, 1), new DateTime(Convert.ToInt32(ddlDistributorDashboardToYear.SelectedItem.ToString()), 12, 31), sAgentName == "All Agents" ? "All Agents" : sAgentCode, sAgentName, sAgent, ""); if (!adPDF.IsThereData) { lblNotEnoughDataDashboard.Text = "Not enough Data to generate Dashboard"; return; } else { if (WebConfigurationManager.AppSettings["SaveAgentDashboard"] != null && WebConfigurationManager.AppSettings["SaveAgentDashboard"].ToString() == "1") { string sURL = "Agent Dashboard - [" + sAgentName.Replace("&", "and") + "," + ddlDistributorDashboardFromYear.SelectedItem.ToString() + "," + ddlDistributorDashboardToYear.SelectedItem.ToString() + "]" + ".pdf"; sURL = sURL.Replace("&", "and"); if (WebConfigurationManager.AppSettings["LocalMachine"] != null && Convert.ToBoolean(WebConfigurationManager.AppSettings["LocalMachine"]) == true) { if (WebConfigurationManager.AppSettings["LocalMachinePath"] == null) { lblDSRNoResults.Text = "No Path Setting"; return; } adPDF.FileName = WebConfigurationManager.AppSettings["LocalMachinePath"] + sURL; adPDF.CreatePDF(out sError); if (WebConfigurationManager.AppSettings["LocalWebSiteURL"] == null) { lblDSRNoResults.Text = "Redirect Failed."; return; } ResponseHelper.Redirect(WebConfigurationManager.AppSettings["LocalWebSiteURL"] + sURL, "_blank", ""); } else { adPDF.FileName = "C:\\MGMQuotation\\pdfs\\" + sURL; adPDF.CreatePDF(out sError); ResponseHelper.Redirect("https://MGMQuotation.MGMTransformer.com//MGMQuotation//pdfs//" + sURL, "_blank", ""); } } else { sRedirect = "~/" + sRptName + ".aspx?YearFrom=" + ddlDistributorDashboardFromYear.SelectedItem.ToString() + "&YearTo=" + ddlDistributorDashboardToYear.SelectedItem.ToString() + "&AgentNo=" + sAgent + "&AgentName=" + sAgentName.Replace("&", "88"); } } } else { sRedirect = "~/" + sRptName + ".aspx?DateFrom=" + sDateFrom + "&DateTo=" + sDateTo + "&RepID=" + sRepID; } } } else { sRedirect = "~/" + sRptName + ".aspx"; } // open PDF. ResponseHelper.Redirect(sRedirect, "_blank", ""); }