protected void Page_Load(object sender, EventArgs e)
{
MasterPage.RequiredPermission = 4200;
MasterPage.IsSecure = true;
if (!IsPostBack)
{
MasterPage.PageTitle = string.Format("{0}", "Physical Prizes Report");
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
}
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage.RequiredPermission = 4200;
MasterPage.IsSecure = true;
MasterPage.PageTitle = "Program By Branch Report";
AlertPanel.Visible = !string.IsNullOrEmpty(AlertMessage.Text);
if (!IsPostBack)
{
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
}
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage.RequiredPermission = 4200;
MasterPage.IsSecure = true;
if (!IsPostBack)
{
MasterPage.PageTitle = string.Format("{0}", "At-a-glance Report - Items Earned by Patrons");
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
var tenant = GRA.SRP.Core.Utilities.Tenant.FetchObject((int)CRTenantID);
OrganizationName.Text = tenant.LandingName;
}
UpdateReport();
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage.PageTitle = string.Format("{0} Report", ReportName);
MasterPage.RequiredPermission = 4200;
MasterPage.IsSecure = true;
AlertPanel.Visible = false;
if (!IsPostBack)
{
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
ReportPanel.Visible = false;
}
else
{
ReportPanel.Visible = EventRepeater.Items.Count > 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage.PageTitle = "Event Codes Report";
MasterPage.RequiredPermission = 4200;
MasterPage.IsSecure = true;
AlertPanel.Visible = false;
if (!IsPostBack)
{
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
ReportPanel.Visible = false;
}
else
{
if (EventRepeater.Items.Count == 0)
{
ReportPanel.Visible = false;
}
else
{
ReportPanel.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MasterPage.IsSecure = true;
MasterPage.PageTitle = string.Format("{0}", "Statistics Dashboard");
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
var ds = SqlHelper.ExecuteDataset(conn, CommandType.StoredProcedure, "rpt_DashboardStats");
GetRegByProg(ds.Tables[0]);
GetFinisherByProg(ds.Tables[1]);
GetRegAgeByProgLabels(ds.Tables[2]);
GetRegAgeByProg(ds.Tables[3]);
GetFinisherAgeByProgLabels(ds.Tables[4]);
GetFinisherAgeByProg(ds.Tables[5]);
GetRegGenderByProg(ds.Tables[6]);
GetFinisherGenderByProg(ds.Tables[7]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
MasterPage.RequiredPermission = 4200;
MasterPage.IsSecure = true;
AlertPanel.Visible = false;
if (!IsPostBack)
{
SetPageRibbon(StandardModuleRibbons.ReportsRibbon());
}
string tenantName = "Summary";
var tenant = GRA.SRP.Core.Utilities.Tenant.FetchObject((int)CRTenantID);
if (tenant != null)
{
tenantName = tenant.LandingName;
}
var ds = SqlHelper.ExecuteDataset(conn,
CommandType.StoredProcedure,
"rpt_ProgramByBranch",
new SqlParameter[]
{
new SqlParameter("@TenID", CRTenantID == null ? -1 : CRTenantID)
}
);
// fix table names
if (ds.Tables != null && ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count != 0)
{
ds.Tables[0].TableName = tenantName;
int count = 1;
foreach (DataRow row in ds.Tables[0].Rows)
{
if (ds.Tables.Count > count - 1 && ds.Tables[count] != null)
{
ds.Tables[count].TableName = row["Program"].ToString();
}
count++;
}
// add total rows
count = 0;
foreach (DataTable table in ds.Tables)
{
var signupTotal = table.Compute("Sum(Signups)", "");
var achieverTotal = table.Compute("Sum(Achievers)", "");
var totalRow = table.NewRow();
int field = 0;
totalRow[field] = "Total";
if (count > 0)
{
field++;
}
totalRow[++field] = signupTotal;
totalRow[++field] = achieverTotal;
table.Rows.Add(totalRow);
string completionRate = string.Empty;
if ((long)signupTotal > 0)
{
completionRate = string.Format("{0:N2}%",
Convert.ToDouble(achieverTotal) * 100 / Convert.ToDouble(signupTotal));
}
var completionRow = table.NewRow();
completionRow[0] = string.Format("Completion rate: {0}", completionRate);
table.Rows.Add(completionRow);
count++;
}
CreateExcelFile.CreateExcelDocument(
ds,
string.Format("{0}-ProgramByBranch.xlsx", DateTime.Now.ToString("yyyyMMdd")),
Response);
}
else
{
AlertPanel.Visible = true;
AlertMessage.Text = "Could not find any report data.";
}
}