protected void Page_Load(object sender, EventArgs e)
{
String institutionName = Request.QueryString["i"] as String;
if (institutionName == null) institutionName = "";
String m = Request.QueryString["m"] as String;
if (m == null) m = "False";
if (m != "True" && m != "False") m = "False";
bool showMonthly = (m == "True" ? true : false);
Response.Clear();
Response.AppendHeader("Content-Type", "application/vnd.ms-excel");
Response.AppendHeader("Content-Disposition", "attachment; filename=BHLExpandedStats.xls");
BHLProvider provider = new BHLProvider();
gvProductionTitles.Columns[1].Visible = showMonthly;
gvProductionTitles.Columns[2].Visible = showMonthly;
gvProductionItems.Columns[1].Visible = showMonthly;
gvProductionItems.Columns[2].Visible = showMonthly;
gvScannedItems.Columns[1].Visible = showMonthly;
gvScannedItems.Columns[2].Visible = showMonthly;
gvProductionPages.Columns[1].Visible = showMonthly;
gvProductionPages.Columns[2].Visible = showMonthly;
gvProductionNames.Columns[1].Visible = showMonthly;
gvProductionNames.Columns[2].Visible = showMonthly;
gvProductionTitles.DataSource = provider.MonthlyStatsSelectByStatType("Titles Created", institutionName, showMonthly);
gvProductionItems.DataSource = provider.MonthlyStatsSelectByStatType("Items Created", institutionName, showMonthly);
gvScannedItems.DataSource = provider.MonthlyStatsSelectByStatType("Items Scanned", institutionName, showMonthly);
gvProductionPages.DataSource = provider.MonthlyStatsSelectByStatType("Pages Created", institutionName, showMonthly);
gvProductionNames.DataSource = provider.MonthlyStatsSelectByStatType("PageNames Created", institutionName, showMonthly);
gvProductionTitles.DataBind();
gvProductionItems.DataBind();
gvScannedItems.DataBind();
gvProductionPages.DataBind();
gvProductionNames.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string institutionName = String.Empty;
bool showMonthly = false;
BHLProvider provider = new BHLProvider();
if (!this.IsPostBack)
{
CustomGenericList<Institution> institutions = provider.InstituationSelectAll();
foreach (Institution institution in institutions)
{
ddlInstitutions.Items.Add(new ListItem(institution.InstitutionName, institution.InstitutionName));
}
}
institutionName = ddlInstitutions.SelectedValue;
showMonthly = chkShowMonthly.Checked;
if (showMonthly)
{
gvProductionTitlesByMonth.DataSource = provider.MonthlyStatsSelectByStatType("Titles Created", institutionName, showMonthly);
gvProductionItemsByMonth.DataSource = provider.MonthlyStatsSelectByStatType("Items Created", institutionName, showMonthly);
gvScannedItemsByMonth.DataSource = provider.MonthlyStatsSelectByStatType("Items Scanned", institutionName, showMonthly);
gvProductionPagesByMonth.DataSource = provider.MonthlyStatsSelectByStatType("Pages Created", institutionName, showMonthly);
gvProductionNamesByMonth.DataSource = provider.MonthlyStatsSelectByStatType("PageNames Created", institutionName, showMonthly);
gvProductionTitlesByMonth.DataBind();
gvProductionItemsByMonth.DataBind();
gvScannedItemsByMonth.DataBind();
gvProductionPagesByMonth.DataBind();
gvProductionNamesByMonth.DataBind();
}
else
{
gvProductionTitles.DataSource = provider.MonthlyStatsSelectByStatType("Titles Created", institutionName, showMonthly);
gvProductionItems.DataSource = provider.MonthlyStatsSelectByStatType("Items Created", institutionName, showMonthly);
gvScannedItems.DataSource = provider.MonthlyStatsSelectByStatType("Items Scanned", institutionName, showMonthly);
gvProductionPages.DataSource = provider.MonthlyStatsSelectByStatType("Pages Created", institutionName, showMonthly);
gvProductionNames.DataSource = provider.MonthlyStatsSelectByStatType("PageNames Created", institutionName, showMonthly);
gvProductionTitles.DataBind();
gvProductionItems.DataBind();
gvScannedItems.DataBind();
gvProductionPages.DataBind();
gvProductionNames.DataBind();
}
}