private void LoadNorthSydneyReport()
{
bizReport biz = new bizReport();
List <proc_rpt_DashboardNorthSydneyResult> rs = biz.GetNorthSydneyReportData(
DateTime.Parse(this.txtFrom.Text),
DateTime.Parse(this.txtTo.Text),
this.ddlTeam.SelectedValue);
this.ucMessanger1.ProcessMessages(biz.MSGS, true);
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
//this.ReportViewer1.LocalReport.ReportEmbeddedResource = "enGage.Web.Reports.NorthSydneyReport.rdlc";
//this.ReportViewer1.LocalReport.ReportPath = MapPath("Reports/NorthSydneyReport.rdlc");
ReportParameter p1 = new ReportParameter("parDateFrom", this.txtFrom.Text);
ReportParameter p2 = new ReportParameter("parDateTo", this.txtTo.Text);
ReportParameter p3 = new ReportParameter("parTeamName", this.ddlTeam.SelectedValue);
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3 });
ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardNorthSydneyResult", rs);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(myRDS);
this.ReportViewer1.LocalReport.Refresh();
this.ReportViewer1.Visible = true;
}
private void LoadDasboardTotalsReport()
{
this.ucMessanger1.ClearMessages();
this.ucMessanger1.UnmarkControls();
SearchOptions so = this.ucSearchOptions1.GetSearchOptions();
if (so == null)
{
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizReport biz = new bizReport();
List <proc_rpt_DashboardTotalsResult> rs = biz.GetDashboardTotalsData(
so.DateFrom,
so.DateTo,
so.Region,
so.Branch,
so.Classification,
so.BusinessType,
so.Industries,
so.Sources,
so.Opportunities);
this.ucMessanger1.ProcessMessages(biz.MSGS, true);
this.ReportViewer1.Reset();
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
this.ReportViewer1.LocalReport.EnableHyperlinks = true;
this.ReportViewer1.LocalReport.ReportPath = "Reports//DashboardTotals.rdlc";
ReportParameter p1 = new ReportParameter("parDateFrom", so.DateFrom.ToString());
ReportParameter p2 = new ReportParameter("parDateTo", so.DateTo.ToString());
ReportParameter p3 = new ReportParameter("parRegion", so.Region);
ReportParameter p4 = new ReportParameter("parBranch", so.Branch);
ReportParameter p5 = new ReportParameter("parClassification", so.Classification.ToString());
ReportParameter p6 = new ReportParameter("parBusinessType", so.BusinessType.ToString());
ReportParameter p7 = new ReportParameter("parIndustries", so.Industries == null ? "" : so.Industries);
ReportParameter p8 = new ReportParameter("parSources", so.Sources == null ? "" : so.Sources);
ReportParameter p9 = new ReportParameter("parOpportunities", so.Opportunities == null ? "" : so.Opportunities);
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9 });
ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardTotalsResult", rs);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(myRDS);
this.ReportViewer1.LocalReport.Refresh();
this.ReportViewer1.Height = Unit.Point(740);
this.ReportViewer1.Visible = true;
this.pnlResults_CollapsiblePanelExtender.ClientState = "false";
this.pnlResults_CollapsiblePanelExtender.Collapsed = false;
}
private void PopulateTeams()
{
bizReport biz = new bizReport();
List <String> teams = biz.GetNorthSydneyTeams();
this.ddlTeam.Items.Clear();
this.ddlTeam.Items.Add("(All)");
foreach (String team in teams)
{
this.ddlTeam.Items.Add(team);
}
}
private void LoadTallyboardReport()
{
this.ucMessanger1.ClearMessages();
this.ucMessanger1.UnmarkControls();
SearchOptions so = this.ucSearchOptions1.GetSearchOptions();
if (so == null)
{
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizMessage bizM = new bizMessage();
if (Session["USER"] == null)
{
this.ucMessanger1.ProcessMessage("Session: " + bizM.GetMessageText("SessionMissing"), Enums.enMsgType.Err, "", null, true);
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizUser.enGageUser user = (bizUser.enGageUser)Session["USER"];
bizReport biz = new bizReport();
List <proc_rpt_TallyboardResult> rs = biz.GetTallyBoardData(
so.DateFrom,
so.DateTo,
so.Region,
so.Branch,
so.Executive,
so.BusinessType,
so.Classification,
so.Sources,
so.Industries,
so.Opportunities);
CalculateTotal(rs);
rptTallyboard.DataSource = rs;
rptTallyboard.DataBind();
this.pnlResults_CollapsiblePanelExtender.ClientState = "false";
this.pnlResults_CollapsiblePanelExtender.Collapsed = false;
}
private void LoadDashboardReport()
{
using (Timeline.Capture("Dashboard.aspx: LoadDashboardReport", "ASP.NET"))
{
this.ucMessanger1.ClearMessages();
this.ucMessanger1.UnmarkControls();
SearchOptions so = this.ucSearchOptions1.GetSearchOptions();
if (so == null)
{
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizMessage bizM = new bizMessage();
if (Session["USER"] == null)
{
this.ucMessanger1.ProcessMessage("Session: " + bizM.GetMessageText("SessionMissing"), Enums.enMsgType.Err, "", null, true);
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizUser.enGageUser user = (bizUser.enGageUser)Session["USER"];
bizReport biz = new bizReport();
List <proc_rpt_DashboardResult> rs = biz.GetDashboardData(
so.DateFrom,
so.DateTo,
so.Region,
so.Branch,
so.Executive,
so.Classification,
so.BusinessType,
so.Industries,
so.Sources,
so.Opportunities);
this.ucMessanger1.ProcessMessages(biz.MSGS, true);
if (rs == null)
{
return;
}
this.ReportViewer1.Reset();
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
string ssrsURL = ConfigurationSettings.AppSettings["SSRS_URL"];
if (string.IsNullOrEmpty(ssrsURL))
{
throw new Exception("Error: Please set the SSRS_URL in the AppSetting in web.config");
}
this.ReportViewer1.ServerReport.ReportServerUrl = new Uri(ssrsURL);
this.ReportViewer1.ServerReport.ReportPath = "/enGage/Dashboard";
using (Timeline.Capture("ServerReport.Refresh()", "Reports"))
{
this.ReportViewer1.ServerReport.Refresh();
}
this.ReportViewer1.Height = Unit.Point(480);
this.ReportViewer1.Visible = true;
/* Start */
/*
* ReportParameter p1 = new ReportParameter("ReportStart", so.DateFrom.ToString("dd MMM yyyy"));
* ReportParameter p2 = new ReportParameter("ReportEnd", so.DateTo.ToString("dd MMM yyyy"));
* ReportParameter p3 = new ReportParameter("Region", so.Region);
* ReportParameter p4 = new ReportParameter("Branch", so.Branch);
* ReportParameter p5 = new ReportParameter("AccountExecutiveID", so.Executive);
* ReportParameter p6 = new ReportParameter("ClassificationID", so.Classification.ToString());
* ReportParameter p7 = new ReportParameter("BusinessTypeID", so.BusinessType.ToString());
* ReportParameter p8 = new ReportParameter("ANZSICDelimitedList", so.Industries == null ? "" : so.Industries);
* ReportParameter p9 = new ReportParameter("SourceDelimitedList", so.Sources == null ? "" : so.Sources);
* string ExecutiveName = this.ucSearchOptions1.GetExecutiveName(so.Executive);
* string label = so.Executive != "(All)" ? ExecutiveName : so.Branch != "(All)" && so.Executive == "(All)" ? so.Region + " (" + so.Branch + ")" : so.Region != "(All)" && so.Branch == "(All)" ? so.Region : so.Region == "(All)" ? "OAMPS Insurance Brokers Ltd" : "";
* ReportParameter p10 = new ReportParameter("OpportunitiesDelimitedList", label);
*/
/* End */
ReportParameter p11 = new ReportParameter("parDateFrom", so.DateFrom.ToString("dd MMM yyyy"));
ReportParameter p12 = new ReportParameter("parDateTo", so.DateTo.ToString("dd MMM yyyy"));
ReportParameter p13 = new ReportParameter("parRegion", so.Region);
ReportParameter p14 = new ReportParameter("parBranch", so.Branch);
ReportParameter p15 = new ReportParameter("parExecutive", so.Executive);
//Uncommented after the fix up of the NULL values.
ReportParameter p16 = new ReportParameter("parClassification",
so.Classification.ToString() == string.Empty || so.Classification.ToString() == "0"
? null
: so.Classification.ToString());
ReportParameter p17 = new ReportParameter("parBusinessType",
so.BusinessType.ToString() == string.Empty || so.BusinessType.ToString() == "0"
? null
: so.BusinessType.ToString());
ReportParameter p18 = new ReportParameter("parIndustries",
string.IsNullOrEmpty(so.Industries) ? null : so.Industries);
ReportParameter p19 = new ReportParameter("parSources",
string.IsNullOrEmpty(so.Sources) ? null : so.Sources);
string ExecutiveName = this.ucSearchOptions1.GetExecutiveName(so.Executive);
string label = so.Executive != "(All)"
? ExecutiveName
: so.Branch != "(All)" && so.Executive == "(All)"
? so.Region + " (" + so.Branch + ")"
: so.Region != "(All)" && so.Branch == "(All)"
? so.Region
: so.Region == "(All)" ? "OAMPS Insurance Brokers Ltd" : "";
ReportParameter p20 = new ReportParameter("parReportLabel", label);
//ReportParameter p21 = new ReportParameter("parURL", HttpContext.Current.Request.Url.Authority);
ReportParameter p22 = new ReportParameter("parOpportunities", so.Opportunities);
this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[]
{ p11, p12, p13, p14, p15, p16, p17, p18, p19, p20, p22 });
using (Timeline.Capture("ServerReport.Refresh()", "Reports"))
{
this.ReportViewer1.ServerReport.Refresh();
}
this.ReportViewer1.Height = Unit.Point(480);
this.ReportViewer1.Visible = true;
/*
* this.ReportViewer1.LocalReport.EnableHyperlinks = true;
* this.ReportViewer1.LocalReport.ReportPath = "Reports//Dashboard.rdlc";
* ReportParameter p1 = new ReportParameter("parDateFrom", so.DateFrom.ToString());
* ReportParameter p2 = new ReportParameter("parDateTo", so.DateTo.ToString());
* ReportParameter p3 = new ReportParameter("parRegion", so.Region);
* ReportParameter p4 = new ReportParameter("parBranch", so.Branch);
* ReportParameter p5 = new ReportParameter("parExecutive", so.Executive);
* ReportParameter p6 = new ReportParameter("parClassification", so.Classification.ToString());
* ReportParameter p7 = new ReportParameter("parBusinessType", so.BusinessType.ToString());
* ReportParameter p8 = new ReportParameter("parIndustries", so.Industries == null ? "" : so.Industries);
* ReportParameter p9 = new ReportParameter("parSources", so.Sources == null ? "" : so.Sources);
* string ExecutiveName = this.ucSearchOptions1.GetExecutiveName(so.Executive);
* string label = so.Executive != "(All)" ? ExecutiveName : so.Branch != "(All)" && so.Executive == "(All)" ? so.Region + " (" + so.Branch + ")" : so.Region != "(All)" && so.Branch == "(All)" ? so.Region : so.Region == "(All)" ? "OAMPS Insurance Brokers Ltd" : "";
* ReportParameter p10 = new ReportParameter("parReportLabel", label);
* this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10 });
* ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardResult", rs);
* this.ReportViewer1.LocalReport.DataSources.Clear();
* this.ReportViewer1.LocalReport.DataSources.Add(myRDS);
* this.ReportViewer1.LocalReport.Refresh();
* this.ReportViewer1.Height = Unit.Point(480);
* this.ReportViewer1.Visible = true;
*/
this.pnlResults_CollapsiblePanelExtender.ClientState = "false";
this.pnlResults_CollapsiblePanelExtender.Collapsed = false;
}
}
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
LocalReport lr = (LocalReport)e.Report;
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
//if (lr.ReportPath.Contains("DashboardTotals") == true)
//{
// ReportParameterInfoCollection pars = e.Report.GetParameters();
// bizReport biz = new bizReport();
// List<proc_rpt_DashboardTotalsResult> rs = biz.GetDashboardTotalsData(
// DateTime.Parse(pars[0].Values[0]),
// DateTime.Parse(pars[1].Values[0]),
// pars[2].Values[0],
// pars[3].Values[0],
// int.Parse(pars[4].Values[0]),
// int.Parse(pars[5].Values[0]),
// pars[6].Values[0] == "" ? null : pars[6].Values[0],
// pars[7].Values[0] == "" ? null : pars[7].Values[0]);
// this.ucMessanger1.ProcessMessages(biz.MSGS, true);
// ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardTotalsResult", rs);
// lr.DataSources.Clear();
// lr.DataSources.Add(myRDS);
// lr.Refresh();
// this.ReportViewer1.Height = Unit.Point(740);
// this.ReportViewer1.Visible = true;
//}
if (lr.ReportPath.Contains("DashboardDetails") == true)
{
SearchOptions so = this.ucSearchOptions1.GetSearchOptions();
ReportParameterInfoCollection pars = e.Report.GetParameters();
bizReport biz = new bizReport();
List <proc_rpt_DashboardDetailResult> rs = biz.GetDashboardDetailData(
DateTime.Parse(pars[0].Values[0]),
DateTime.Parse(pars[1].Values[0]),
pars[2].Values[0],
int.Parse(pars[3].Values[0]),
int.Parse(pars[4].Values[0]),
pars[5].Values[0],
pars[6].Values[0],
pars[7].Values[0] == "" ? null : pars[7].Values[0],
pars[8].Values[0] == "" ? null : pars[8].Values[0],
so.Opportunities == ""? null : so.Opportunities
);
this.ucMessanger1.ProcessMessages(biz.MSGS, true);
ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardDetailResult", rs);
lr.DataSources.Clear();
lr.DataSources.Add(myRDS);
lr.Refresh();
this.ReportViewer1.Height = Unit.Point(800);
this.ReportViewer1.Visible = true;
}
}
catch (Exception ex)
{
bizLog.InsertExceptionLog(ex);
Response.Redirect("~/ErrorPage.aspx", false);
}
}
private void LoadDashboardReport()
{
this.ucMessanger1.ClearMessages();
this.ucMessanger1.UnmarkControls();
SearchOptions so = this.ucSearchOptions1.GetSearchOptions();
if (so == null)
{
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizMessage bizM = new bizMessage();
if (Session["USER"] == null)
{
this.ucMessanger1.ProcessMessage("Session: " + bizM.GetMessageText("SessionMissing"), Enums.enMsgType.Err, "", null, true);
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
bizUser.enGageUser user = (bizUser.enGageUser)Session["USER"];
bizReport biz = new bizReport();
List <proc_rpt_DashboardResult> rs = biz.GetDashboardData(
so.DateFrom,
so.DateTo,
so.Region,
so.Branch,
so.Executive,
so.Classification,
so.BusinessType,
so.Industries,
so.Sources,
so.Opportunities);
this.ucMessanger1.ProcessMessages(biz.MSGS, true);
if (rs == null)
{
return;
}
StringBuilder sb = new StringBuilder();
rptDashboard.DataSource = rs;
rptDashboard.DataBind();
//Do the sums for the other fields.
Decimal sumActivitiesQuoted = 0;
Decimal sumActivitiesActual = 0;
Decimal sumFollowUpsQuoted = 0;
Decimal sumFollowUpsActual = 0;
Decimal sumPipelineQuoted = 0;
Decimal sumPipelineActual = 0;
Decimal sumToWinQuoted = 0;
Decimal sumWonActual = 0;
Decimal sumLostQuoted = 0;
Decimal sumDueQuoted = 0;
Decimal sumDueActual = 0;
foreach (proc_rpt_DashboardResult r in rs)
{
sumActivitiesQuoted += r.ActivitiesQuoted != null ? (decimal)r.ActivitiesQuoted : 0;
sumActivitiesActual += r.ActivitiesActual != null ? (decimal)r.ActivitiesActual : 0;
sumFollowUpsQuoted += r.FollowUpsQuoted != null ? (decimal)r.FollowUpsQuoted : 0;
sumFollowUpsActual += r.FollowUpsActual != null ? (decimal)r.FollowUpsActual : 0;
sumPipelineQuoted += r.PipelineQuoted != null ? (decimal)r.PipelineQuoted : 0;
sumPipelineActual += r.PipelineActual != null ? (decimal)r.PipelineActual : 0;
sumToWinQuoted += r.ToWinQuoted != null ? (decimal)r.ToWinQuoted : 0;
sumWonActual += r.WonActual != null ? (decimal)r.WonActual : 0;
sumLostQuoted += r.LostQuoted != null ? (decimal)r.LostQuoted : 0;
sumDueQuoted += r.DueQuoted != null ? (decimal)r.DueQuoted : 0;
sumDueActual += r.DueActual != null ? (decimal)r.DueActual : 0;
//sb.AppendLine(r.Action + " "+r.Activities+" "+r.ActivitiesActual+" "+r.ActivitiesQuoted+" "+r.CompleteOutcomes+" "+r.DueActual+" "+r.DueOutcomes+" "+r.DueQuoted+" "+r.FollowUps+" "+r.FollowUpsActual+" "+r.FollowUpsQuoted+" "+r.LostQuoted+" "+r.PipelineActual+" "+r.PipelineOutcomes+" "+r.PipelineQuoted+" "+r.PreviousStatusID+" "+r.SuccessOutcomes+" "+r.ToWinQuoted+" "+r.WonActual+"<br/>");
}
/*
* foreach(proc_rpt_DashboardResult r in rs)
* {
* sb.AppendLine(r.Action + " "+r.Activities+" "+r.ActivitiesActual+" "+r.ActivitiesQuoted+" "+r.CompleteOutcomes+" "+r.DueActual+" "+r.DueOutcomes+" "+r.DueQuoted+" "+r.FollowUps+" "+r.FollowUpsActual+" "+r.FollowUpsQuoted+" "+r.LostQuoted+" "+r.PipelineActual+" "+r.PipelineOutcomes+" "+r.PipelineQuoted+" "+r.PreviousStatusID+" "+r.SuccessOutcomes+" "+r.ToWinQuoted+" "+r.WonActual+"<br/>");
* }
* ltrText.Text = sb.ToString();
*/
/*
* this.ReportViewer1.Reset();
* this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
* this.ReportViewer1.LocalReport.EnableHyperlinks = true;
* this.ReportViewer1.LocalReport.ReportPath = "Reports//Dashboard.rdlc";
* ReportParameter p1 = new ReportParameter("parDateFrom", so.DateFrom.ToString());
* ReportParameter p2 = new ReportParameter("parDateTo", so.DateTo.ToString());
* ReportParameter p3 = new ReportParameter("parRegion", so.Region);
* ReportParameter p4 = new ReportParameter("parBranch", so.Branch);
* ReportParameter p5 = new ReportParameter("parExecutive", so.Executive);
* ReportParameter p6 = new ReportParameter("parClassification", so.Classification.ToString());
* ReportParameter p7 = new ReportParameter("parBusinessType", so.BusinessType.ToString());
* ReportParameter p8 = new ReportParameter("parIndustries", so.Industries == null ? "" : so.Industries);
* ReportParameter p9 = new ReportParameter("parSources", so.Sources == null ? "" : so.Sources);
* string ExecutiveName = this.ucSearchOptions1.GetExecutiveName(so.Executive);
* string label = so.Executive != "(All)" ? ExecutiveName : so.Branch != "(All)" && so.Executive == "(All)" ? so.Region + " (" + so.Branch + ")" : so.Region != "(All)" && so.Branch == "(All)" ? so.Region : so.Region == "(All)" ? "OAMPS Insurance Brokers Ltd" : "";
* ReportParameter p10 = new ReportParameter("parReportLabel", label);
* this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10 });
* ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardResult", rs);
* this.ReportViewer1.LocalReport.DataSources.Clear();
* this.ReportViewer1.LocalReport.DataSources.Add(myRDS);
* this.ReportViewer1.LocalReport.Refresh();
* this.ReportViewer1.Height = Unit.Point(480);
* this.ReportViewer1.Visible = true;
*
* this.pnlResults_CollapsiblePanelExtender.ClientState = "false";
* this.pnlResults_CollapsiblePanelExtender.Collapsed = false;
* */
}
