protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["not"] != null)
{
switch (Convert.ToInt32(Request.QueryString["siteletID"]))
{
case 1:
dsReportTableAdapters.uspClubArtsNotLoginReportTableAdapter uspClubArtsNotTA = new dsReportTableAdapters.uspClubArtsNotLoginReportTableAdapter();
dsReport.uspClubArtsNotLoginReportDataTable uspClubArtsNotDT = uspClubArtsNotTA.GetUspClubArtsNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspClubArtsNotDT;
gvUsers.Columns[8].Visible = true;
break;
case 2:
dsReportTableAdapters.uspSpringNotLoginReportTableAdapter uspSpringNotTA = new dsReportTableAdapters.uspSpringNotLoginReportTableAdapter();
dsReport.uspSpringNotLoginReportDataTable uspSpringNotDT = uspSpringNotTA.GetUspSpringNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspSpringNotDT;
gvUsers.Columns[9].Visible = true;
break;
case 3:
dsReportTableAdapters.uspAllsNotLoginReportTableAdapter uspAllsNotTA = new dsReportTableAdapters.uspAllsNotLoginReportTableAdapter();
dsReport.uspAllsNotLoginReportDataTable uspAllsNotDT = uspAllsNotTA.GetUspAllsNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspAllsNotDT;
gvUsers.Columns[10].Visible = true;
break;
case 4:
dsReportTableAdapters.uspWorldNotLoginReportTableAdapter uspWorldNotTA = new dsReportTableAdapters.uspWorldNotLoginReportTableAdapter();
dsReport.uspWorldNotLoginReportDataTable uspWorldNotDT = uspWorldNotTA.GetUspWorldNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspWorldNotDT;
gvUsers.Columns[11].Visible = true;
break;
case 5:
dsReportTableAdapters.uspCoopNotLoginReportTableAdapter uspCoopNotTA = new dsReportTableAdapters.uspCoopNotLoginReportTableAdapter();
dsReport.uspCoopNotLoginReportDataTable uspCoopNotDT = uspCoopNotTA.GetUspCoopNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspCoopNotDT;
gvUsers.Columns[12].Visible = true;
break;
case 6:
dsReportTableAdapters.uspMascotNotLoginReportTableAdapter uspMascotNotTA = new dsReportTableAdapters.uspMascotNotLoginReportTableAdapter();
dsReport.uspMascotNotLoginReportDataTable uspMascotNotDT = uspMascotNotTA.GetUspMascotNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspMascotNotDT;
gvUsers.Columns[13].Visible = true;
break;
case 7:
dsReportTableAdapters.uspMinorNotLoginReportTableAdapter uspMinorNotTA = new dsReportTableAdapters.uspMinorNotLoginReportTableAdapter();
dsReport.uspMinorNotLoginReportDataTable uspMinorNotDT = uspMinorNotTA.GetUspMinorNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspMinorNotDT;
gvUsers.Columns[14].Visible = true;
break;
case 8:
dsReportTableAdapters.uspThemeArtNotLoginReportTableAdapter uspThemeArtNotTA = new dsReportTableAdapters.uspThemeArtNotLoginReportTableAdapter();
dsReport.uspThemeArtNotLoginReportDataTable uspThemeArtNotDT = uspThemeArtNotTA.GetUspThemeArtNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspThemeArtNotDT;
gvUsers.Columns[15].Visible = true;
break;
case 9:
dsReportTableAdapters.uspDesignNotLoginReportTableAdapter uspDesignNotTA = new dsReportTableAdapters.uspDesignNotLoginReportTableAdapter();
dsReport.uspDesignNotLoginReportDataTable uspDesignNotDT = uspDesignNotTA.GetUspDesignNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspDesignNotDT;
gvUsers.Columns[16].Visible = true;
break;
case 10:
//dsReportTableAdapters.uspCMCNotLoginReportByDatesTableAdapter uspCMCNotLoginReportByDatesTA = new dsReportTableAdapters.uspCMCNotLoginReportByDatesTableAdapter();
//dsReport.uspCMCNotLoginReportByDatesDataTable uspCMCNotLoginReportByDatesDT = uspCMCNotLoginReportByDatesTA.GetUspCMCNotLoginReportByDates(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
//gvUsers.DataSource = uspCMCNotLoginReportByDatesDT;
//gvUsers.Columns[17].Visible = false;
gvUsers.DataSource = Session["uspCMCPageNotLoginsDT"];
gvUsers.Columns[17].Visible = true;
gvUsers.Columns[18].HeaderText = "Page (not logged into)";
gvUsers.Columns[18].Visible = true;
break;
case 11:
dsReportTableAdapters.uspRestrictedNotLoginReportTableAdapter uspRestrictedNotTA = new dsReportTableAdapters.uspRestrictedNotLoginReportTableAdapter();
dsReport.uspRestrictedNotLoginReportDataTable uspRestrictedNotDT = uspRestrictedNotTA.GetUspRestrictedNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspRestrictedNotDT;
gvUsers.Columns[19].Visible = true;
break;
case 12:
dsReportTableAdapters.uspOpeningNotLoginReportTableAdapter uspOpeningNotTA = new dsReportTableAdapters.uspOpeningNotLoginReportTableAdapter();
dsReport.uspOpeningNotLoginReportDataTable uspOpeningNotDT = uspOpeningNotTA.GetUspOpeningNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspOpeningNotDT;
gvUsers.Columns[20].Visible = true;
break;
case 13:
dsReportTableAdapters.uspMascotBabiesNotLoginReportTableAdapter uspMascotBabiesNotTA = new dsReportTableAdapters.uspMascotBabiesNotLoginReportTableAdapter();
dsReport.uspMascotBabiesNotLoginReportDataTable uspMascotBabiesNotDT = uspMascotBabiesNotTA.GetUspMascotBabiesNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspMascotBabiesNotDT;
gvUsers.Columns[21].Visible = true;
break;
case 14:
dsReportTableAdapters.uspPressBoxNotLoginReportTableAdapter uspPressBoxNotLoginReportTA = new dsReportTableAdapters.uspPressBoxNotLoginReportTableAdapter();
dsReport.uspPressBoxNotLoginReportDataTable uspPressBoxNotLoginReportDT = uspPressBoxNotLoginReportTA.GetUspPressBoxNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspPressBoxNotLoginReportDT;
gvUsers.Columns[22].Visible = true;
break;
case 15:
dsReportTableAdapters.uspPlayballNotLoginReportTableAdapter uspPlayballNotLoginReportTA = new dsReportTableAdapters.uspPlayballNotLoginReportTableAdapter();
dsReport.uspPlayballNotLoginReportDataTable uspPlayballNotLoginReportDT = uspPlayballNotLoginReportTA.GetUspPlayballNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspPlayballNotLoginReportDT;
gvUsers.Columns[23].Visible = true;
break;
case 16:
dsReportTableAdapters.uspSponsorsNotLoginReportTableAdapter uspSponsorsNotLoginReportTA = new dsReportTableAdapters.uspSponsorsNotLoginReportTableAdapter();
dsReport.uspSponsorsNotLoginReportDataTable uspSponsorsNotLoginReportDT = uspSponsorsNotLoginReportTA.GetUspSponsorsNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspSponsorsNotLoginReportDT;
gvUsers.Columns[24].Visible = true;
break;
case 17:
dsReportTableAdapters.uspLondonNotLoginReportTableAdapter uspLondonNotLoginReportTA = new dsReportTableAdapters.uspLondonNotLoginReportTableAdapter();
dsReport.uspLondonNotLoginReportDataTable uspLondonNotLoginReportDT = uspLondonNotLoginReportTA.GetUspLondonNotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspLondonNotLoginReportDT;
gvUsers.Columns[25].Visible = true;
break;
case 18:
dsReportTableAdapters.uspRestricted2NotLoginReportTableAdapter uspRestricted2NotLoginReportTA = new dsReportTableAdapters.uspRestricted2NotLoginReportTableAdapter();
dsReport.uspRestricted2NotLoginReportDataTable uspRestricted2NotLoginReportDT = uspRestricted2NotLoginReportTA.GetUspRestricted2NotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
gvUsers.DataSource = uspRestricted2NotLoginReportDT;
gvUsers.Columns[26].Visible = true;
break;
case 19:
dsReportTableAdapters.uspRestricted3NotLoginReportTableAdapter uspRestricted3NotLoginReportTA = new dsReportTableAdapters.uspRestricted3NotLoginReportTableAdapter();
dsReport.uspRestricted3NotLoginReportDataTable uspRestricted3NotLoginReportDT = uspRestricted3NotLoginReportTA.GetUspRestricted3NotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
gvUsers.DataSource = uspRestricted3NotLoginReportDT;
gvUsers.Columns[27].Visible = true;
break;
case 20:
dsReportTableAdapters.uspMLBLogoVaultNotLoginReportTableAdapter uspMLBLogoVaultNotLoginReportTA = new dsReportTableAdapters.uspMLBLogoVaultNotLoginReportTableAdapter();
dsReport.uspMLBLogoVaultNotLoginReportDataTable uspMLBLogoVaultNotLoginReportDT = uspMLBLogoVaultNotLoginReportTA.GetUspMLBLogoVaultNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
gvUsers.DataSource = uspMLBLogoVaultNotLoginReportDT;
gvUsers.Columns[28].Visible = true;
break;
}
//dsReportTableAdapters.uspCMCNotLoginReportByDatesTableAdapter uspCMCNotLoginReportByDatesTA = new dsReportTableAdapters.uspCMCNotLoginReportByDatesTableAdapter();
//dsReport.uspCMCNotLoginReportByDatesDataTable uspCMCNotLoginReportByDatesDT = uspCMCNotLoginReportByDatesTA.GetUspCMCNotLoginReportByDates(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
//gvUsers.DataSource = uspCMCNotLoginReportByDatesDT;
gvUsers.Caption = "Traffic Report (Users Not Logged In) :: " + Request.QueryString["sitelet"] + " :: From " + Request.QueryString["from"].ToString() + " To " + Request.QueryString["to"].ToString();
}
else
{
switch (Convert.ToInt32(Request.QueryString["siteletID"]))
{
case 1:
dsReportTableAdapters.uspClubArtsLoginReportTableAdapter uspClubArtsLoginReportTA = new dsReportTableAdapters.uspClubArtsLoginReportTableAdapter();
dsReport.uspClubArtsLoginReportDataTable uspClubArtsLoginReportDT = uspClubArtsLoginReportTA.GetUspClubArtsLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspClubArtsLoginReportDT;
gvUsers.Columns[8].Visible = true;
break;
case 2:
dsReportTableAdapters.uspSpringLoginReportTableAdapter uspSpringLoginReportTA = new dsReportTableAdapters.uspSpringLoginReportTableAdapter();
dsReport.uspSpringLoginReportDataTable uspSpringLoginReportDT = uspSpringLoginReportTA.GetUspSpringLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspSpringLoginReportDT;
gvUsers.Columns[9].Visible = true;
break;
case 3:
dsReportTableAdapters.uspAllsLoginReportTableAdapter uspAllsLoginReportTA = new dsReportTableAdapters.uspAllsLoginReportTableAdapter();
dsReport.uspAllsLoginReportDataTable uspAllsLoginReportDT = uspAllsLoginReportTA.GetUspAllsLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspAllsLoginReportDT;
gvUsers.Columns[10].Visible = true;
break;
case 4:
dsReportTableAdapters.uspWorldLoginReportTableAdapter uspWorldLoginReportTA = new dsReportTableAdapters.uspWorldLoginReportTableAdapter();
dsReport.uspWorldLoginReportDataTable uspWorldLoginReportDT = uspWorldLoginReportTA.GetUspWorldLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspWorldLoginReportDT;
gvUsers.Columns[11].Visible = true;
break;
case 5:
dsReportTableAdapters.uspCoopLoginReportTableAdapter uspCoopLoginReportTA = new dsReportTableAdapters.uspCoopLoginReportTableAdapter();
dsReport.uspCoopLoginReportDataTable uspCoopLoginReportDT = uspCoopLoginReportTA.GetUspCoopLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspCoopLoginReportDT;
gvUsers.Columns[12].Visible = true;
break;
case 6:
dsReportTableAdapters.uspMascotLoginReportTableAdapter uspMascotLoginReportTA = new dsReportTableAdapters.uspMascotLoginReportTableAdapter();
dsReport.uspMascotLoginReportDataTable uspMascotLoginReportDT = uspMascotLoginReportTA.GetUspMascotLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspMascotLoginReportDT;
gvUsers.Columns[13].Visible = true;
break;
case 7:
dsReportTableAdapters.uspMinorLoginReportTableAdapter uspMinorLoginReportTA = new dsReportTableAdapters.uspMinorLoginReportTableAdapter();
dsReport.uspMinorLoginReportDataTable uspMinorLoginReportDT = uspMinorLoginReportTA.GetMinorLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspMinorLoginReportDT;
gvUsers.Columns[14].Visible = true;
break;
case 8:
dsReportTableAdapters.uspThemeArtLoginReportTableAdapter uspThemeArtLoginReportTA = new dsReportTableAdapters.uspThemeArtLoginReportTableAdapter();
dsReport.uspThemeArtLoginReportDataTable uspThemeArtLoginReportDT = uspThemeArtLoginReportTA.GetUspThemeArtLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspThemeArtLoginReportDT;
gvUsers.Columns[15].Visible = true;
break;
case 9:
dsReportTableAdapters.uspDesignLoginReportTableAdapter uspDesignLoginReportTA = new dsReportTableAdapters.uspDesignLoginReportTableAdapter();
dsReport.uspDesignLoginReportDataTable uspDesignLoginReportDT = uspDesignLoginReportTA.GetUspDesignLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));;
gvUsers.DataSource = uspDesignLoginReportDT;
gvUsers.Columns[16].Visible = true;
break;
case 10:
//dsReportTableAdapters.uspCMCLoginReportByDatesTableAdapter uspCMCLoginReportByDatesTA = new dsReportTableAdapters.uspCMCLoginReportByDatesTableAdapter();
//dsReport.uspCMCLoginReportByDatesDataTable uspCMCLoginReportByDatesDT = uspCMCLoginReportByDatesTA.GetUspCMCLoginReportByDates(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
//gvUsers.DataSource = uspCMCLoginReportByDatesDT;
//gvUsers.Columns[17].Visible = true;
gvUsers.DataSource = Session["uspCMCPageLoginsDT"];
gvUsers.Columns[17].Visible = true;
gvUsers.Columns[18].HeaderText = "Page (logged into)";
gvUsers.Columns[18].Visible = true;
break;
case 11:
dsReportTableAdapters.uspRestrictedLoginReportTableAdapter uspRestrictedLoginReportTA = new dsReportTableAdapters.uspRestrictedLoginReportTableAdapter();
dsReport.uspRestrictedLoginReportDataTable uspRestriectedLoginReportDT = uspRestrictedLoginReportTA.GetUspRestrictedLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspRestriectedLoginReportDT;
gvUsers.Columns[19].Visible = true;
break;
case 12:
dsReportTableAdapters.uspOpeningLoginReportTableAdapter uspOpeningLoginReportTA = new dsReportTableAdapters.uspOpeningLoginReportTableAdapter();
dsReport.uspOpeningLoginReportDataTable uspOpeningLoginReportDT = uspOpeningLoginReportTA.GetUspOpeningLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspOpeningLoginReportDT;
gvUsers.Columns[20].Visible = true;
break;
case 13:
dsReportTableAdapters.uspMascotBabiesLoginReportTableAdapter uspMascotBabiesLoginReportTA = new dsReportTableAdapters.uspMascotBabiesLoginReportTableAdapter();
dsReport.uspMascotBabiesLoginReportDataTable uspMascotBabiesLoginReportDT = uspMascotBabiesLoginReportTA.GetUspMascotBabiesLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspMascotBabiesLoginReportDT;
gvUsers.Columns[21].Visible = true;
break;
case 14:
dsReportTableAdapters.uspPressBoxLoginReportTableAdapter uspPressBoxLoginReportTA = new dsReportTableAdapters.uspPressBoxLoginReportTableAdapter();
dsReport.uspPressBoxLoginReportDataTable uspPressBoxLoginReportDT = uspPressBoxLoginReportTA.GetUspPressBoxLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspPressBoxLoginReportDT;
gvUsers.Columns[22].Visible = true;
break;
case 15:
dsReportTableAdapters.uspPlayballLoginReportTableAdapter uspPlayballLoginReportTA = new dsReportTableAdapters.uspPlayballLoginReportTableAdapter();
dsReport.uspPlayballLoginReportDataTable uspPlayballLoginReportDT = uspPlayballLoginReportTA.GetUspPlayballLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspPlayballLoginReportDT;
gvUsers.Columns[23].Visible = true;
break;
case 16:
dsReportTableAdapters.uspSponsorsLoginReportTableAdapter uspSponsorsLoginReportTA = new dsReportTableAdapters.uspSponsorsLoginReportTableAdapter();
dsReport.uspSponsorsLoginReportDataTable uspSponsorsLoginReportDT = uspSponsorsLoginReportTA.GetUspSponsorsLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspSponsorsLoginReportDT;
gvUsers.Columns[24].Visible = true;
break;
case 17:
dsReportTableAdapters.uspLondonLoginReportTableAdapter uspLondonLoginReportTA = new dsReportTableAdapters.uspLondonLoginReportTableAdapter();
dsReport.uspLondonLoginReportDataTable uspLondonLoginReportDT = uspLondonLoginReportTA.GetUspLondonLoginReport(Convert.ToDateTime(Request.QueryString["from"].ToString()), Convert.ToDateTime(Request.QueryString["to"].ToString()));
gvUsers.DataSource = uspLondonLoginReportDT;
gvUsers.Columns[25].Visible = true;
break;
case 18:
dsReportTableAdapters.uspRestricted2LoginReportTableAdapter uspRestricted2LoginReportTA = new dsReportTableAdapters.uspRestricted2LoginReportTableAdapter();
dsReport.uspRestricted2LoginReportDataTable uspRestricted2LoginReportDT = uspRestricted2LoginReportTA.GetUspRestricted2LoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
gvUsers.DataSource = uspRestricted2LoginReportDT;
gvUsers.Columns[26].Visible = true;
break;
case 19:
dsReportTableAdapters.uspRestricted3LoginReportTableAdapter uspRestricted3LoginReportTA = new dsReportTableAdapters.uspRestricted3LoginReportTableAdapter();
dsReport.uspRestricted3LoginReportDataTable uspRestricted3LoginReportDT = uspRestricted3LoginReportTA.GetUspRestricted3LoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
gvUsers.DataSource = uspRestricted3LoginReportDT;
gvUsers.Columns[27].Visible = true;
break;
case 20:
dsReportTableAdapters.uspMLBLogoVaultLoginReportTableAdapter uspMLBLogoVaultLoginReportTA = new dsReportTableAdapters.uspMLBLogoVaultLoginReportTableAdapter();
dsReport.uspMLBLogoVaultLoginReportDataTable uspMLBLogoVaultLoginReportDT = uspMLBLogoVaultLoginReportTA.GetUspMLBLogoVaultLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
gvUsers.DataSource = uspMLBLogoVaultLoginReportDT;
gvUsers.Columns[28].Visible = true;
break;
}
gvUsers.Caption = "Traffic Report (Users Logged In) :: " + Request.QueryString["sitelet"] + " :: From " + Request.QueryString["from"].ToString() + " To " + Request.QueryString["to"].ToString();
}
gvUsers.DataBind();
Response.Clear();
Response.ClearHeaders(); //For HTTPS
Response.Cache.SetCacheability(HttpCacheability.Private); //For HTTPS
//Response.AddHeader("content-disposition", "attachment; filename=SpifeAssociates"+Convert.ToDateTime(AssociatesDT.Rows[0]["downloaddate"].ToString()).ToShortDateString()+".xls");
if (Request.QueryString["not"] != null)
{
Response.AddHeader("content-disposition", "attachment; filename=UsersNotLoggedIn_" + Request.QueryString["sitelet"] + ".xls");
}
else
{
Response.AddHeader("content-disposition", "attachment; filename=UsersLoggedIn_" + Request.QueryString["sitelet"] + ".xls");
}
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvUsers.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
//Take care of the calendar
cbLastMonth.Attributes.Add("onclick", "SetLastMonth()");
strToday = DateTime.Now.ToShortDateString();
strOneMonthAgo = DateTime.Now.AddMonths(-1).ToShortDateString();
strTheLastDay = GetLastDayOfMonth(DateTime.Now.AddMonths(-1)).ToShortDateString();
strTheFirstDay = GetFirstDayOfMonth(DateTime.Now.AddMonths(-1)).ToShortDateString();
//bodyID.Attributes.Add("onload", "CheckCMC()");
ddlSitelet.Attributes.Add("onChange", "CheckCMC()");
string strTemp = string.Empty;
if (!Page.IsPostBack)
{
calendarPopup1.SelectedDate = Convert.ToDateTime(calendarPopup1.SelectedDate.ToShortDateString()).AddMonths(-1);
if (Request.QueryString.ToString() == "not")
{
ltrBreadCrumb.Text = " :: Traffic Report (Users Not Logged In)";
}
else
{
ltrBreadCrumb.Text = " :: Traffic Report (Users Logged In)";
}
}
else
{
Page.Validate();
if (Page.IsValid)
{
if (Request.Form["calendarPopup1$textBox"] != null)
{
Session["from"] = Request.Form["calendarPopup1$textBox"];
}
if (Request.Form["calendarPopup2$textBox"] != null)
{
Session["to"] = Request.Form["calendarPopup2$textBox"];
}
if (ddlSitelet.SelectedItem.Text != null)
{
Session["sitelet"] = ddlSitelet.SelectedItem.Text;
}
if (Request.QueryString.ToString() == "not")//Users not logged in
{
switch (Convert.ToInt32(ddlSitelet.SelectedItem.Value))
{
case 1:
dsReportTableAdapters.uspClubArtsNotLoginReportTableAdapter uspClubArtsNotTA = new dsReportTableAdapters.uspClubArtsNotLoginReportTableAdapter();
dsReport.uspClubArtsNotLoginReportDataTable uspClubArtsNotDT = uspClubArtsNotTA.GetUspClubArtsNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspClubArtsNotDT.Count;
gvUsers.DataSource = uspClubArtsNotDT;
gvUsers.Columns[8].Visible = true;
break;
case 2:
dsReportTableAdapters.uspSpringNotLoginReportTableAdapter uspSpringNotTA = new dsReportTableAdapters.uspSpringNotLoginReportTableAdapter();
dsReport.uspSpringNotLoginReportDataTable uspSpringNotDT = uspSpringNotTA.GetUspSpringNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspSpringNotDT.Count;
gvUsers.DataSource = uspSpringNotDT;
gvUsers.Columns[9].Visible = true;
break;
case 3:
dsReportTableAdapters.uspAllsNotLoginReportTableAdapter uspAllsNotTA = new dsReportTableAdapters.uspAllsNotLoginReportTableAdapter();
dsReport.uspAllsNotLoginReportDataTable uspAllsNotDT = uspAllsNotTA.GetUspAllsNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspAllsNotDT.Count;
gvUsers.DataSource = uspAllsNotDT;
gvUsers.Columns[10].Visible = true;
break;
case 4:
dsReportTableAdapters.uspWorldNotLoginReportTableAdapter uspWorldNotTA = new dsReportTableAdapters.uspWorldNotLoginReportTableAdapter();
dsReport.uspWorldNotLoginReportDataTable uspWorldNotDT = uspWorldNotTA.GetUspWorldNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspWorldNotDT.Count;
gvUsers.DataSource = uspWorldNotDT;
gvUsers.Columns[11].Visible = true;
break;
case 5:
dsReportTableAdapters.uspCoopNotLoginReportTableAdapter uspCoopNotTA = new dsReportTableAdapters.uspCoopNotLoginReportTableAdapter();
dsReport.uspCoopNotLoginReportDataTable uspCoopNotDT = uspCoopNotTA.GetUspCoopNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspCoopNotDT.Count;
gvUsers.DataSource = uspCoopNotDT;
gvUsers.Columns[12].Visible = true;
break;
case 6:
dsReportTableAdapters.uspMascotNotLoginReportTableAdapter uspMascotNotTA = new dsReportTableAdapters.uspMascotNotLoginReportTableAdapter();
dsReport.uspMascotNotLoginReportDataTable uspMascotNotDT = uspMascotNotTA.GetUspMascotNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspMascotNotDT.Count;
gvUsers.DataSource = uspMascotNotDT;
gvUsers.Columns[13].Visible = true;
break;
case 7:
dsReportTableAdapters.uspMinorNotLoginReportTableAdapter uspMinorNotTA = new dsReportTableAdapters.uspMinorNotLoginReportTableAdapter();
dsReport.uspMinorNotLoginReportDataTable uspMinorNotDT = uspMinorNotTA.GetUspMinorNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspMinorNotDT.Count;
gvUsers.DataSource = uspMinorNotDT;
gvUsers.Columns[14].Visible = true;
break;
case 8:
dsReportTableAdapters.uspThemeArtNotLoginReportTableAdapter uspThemeArtNotTA = new dsReportTableAdapters.uspThemeArtNotLoginReportTableAdapter();
dsReport.uspThemeArtNotLoginReportDataTable uspThemeArtNotDT = uspThemeArtNotTA.GetUspThemeArtNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspThemeArtNotDT.Count;
gvUsers.DataSource = uspThemeArtNotDT;
gvUsers.Columns[15].Visible = true;
break;
case 9:
dsReportTableAdapters.uspDesignNotLoginReportTableAdapter uspDesignNotTA = new dsReportTableAdapters.uspDesignNotLoginReportTableAdapter();
dsReport.uspDesignNotLoginReportDataTable uspDesignNotDT = uspDesignNotTA.GetUspDesignNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspDesignNotDT.Count;
gvUsers.DataSource = uspDesignNotDT;
gvUsers.Columns[16].Visible = true;
break;
case 10:
//dsReportTableAdapters.uspCMCNotLoginReportByDatesTableAdapter uspCMCNotLoginReportByDatesTA = new dsReportTableAdapters.uspCMCNotLoginReportByDatesTableAdapter();
//dsReport.uspCMCNotLoginReportByDatesDataTable uspCMCNotLoginReportByDatesDT = uspCMCNotLoginReportByDatesTA.GetUspCMCNotLoginReportByDates(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
//iCount = uspCMCNotLoginReportByDatesDT.Rows.Count;
//gvUsers.DataSource = uspCMCNotLoginReportByDatesDT;
//gvUsers.Columns[17].Visible = true;
//break;
dsReportTableAdapters.uspCMCPageNotLoginsTableAdapter uspCMCPageNotLoginsTA = new dsReportTableAdapters.uspCMCPageNotLoginsTableAdapter();
dsReport.uspCMCPageNotLoginsDataTable uspCMCPageNotLoginsDT = new dsReport.uspCMCPageNotLoginsDataTable();
//dsReport.uspCMCPageNotLoginsDataTable uspCMCPageNotLoginsDT = uspCMCPageNotLoginsTA.GetUspCMCPageNotLogins(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]), 6);
for (int i = 0; i < cblPages.Items.Count; i++)
{
if (cblPages.Items[i].Selected)
{
dsReport.uspCMCPageNotLoginsDataTable thisDT = uspCMCPageNotLoginsTA.GetUspCMCPageNotLogins(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1), Convert.ToInt32(cblPages.Items[i].Value));
foreach (DataRow dr in thisDT.Rows)
{
uspCMCPageNotLoginsDT.ImportRow(dr);
}
}
}
//dsReportTableAdapters.uspCMCPageNotLoginsTableAdapter uspCMCPageNotLoginsTA = new dsReportTableAdapters.uspCMCPageNotLoginsTableAdapter();
//dsReport.uspCMCPageNotLoginsDataTable uspCMCPageNotLoginsDT = uspCMCPageNotLoginsTA.GetUspCMCPageNotLogins(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]), 6);
iCount = uspCMCPageNotLoginsDT.Count;
Session["uspCMCPageNotLoginsDT"] = uspCMCPageNotLoginsDT;
gvUsers.DataSource = uspCMCPageNotLoginsDT;
gvUsers.Columns[17].Visible = true;
gvUsers.Columns[18].HeaderText = "Page (not logged into)";
gvUsers.Columns[18].Visible = true;
break;
case 11:
dsReportTableAdapters.uspRestrictedNotLoginReportTableAdapter uspRestrictedNotLoginReportTA = new dsReportTableAdapters.uspRestrictedNotLoginReportTableAdapter();
dsReport.uspRestrictedNotLoginReportDataTable uspRestrictedNotLoginReportDT = uspRestrictedNotLoginReportTA.GetUspRestrictedNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspRestrictedNotLoginReportDT.Count;
gvUsers.DataSource = uspRestrictedNotLoginReportDT;
gvUsers.Columns[19].Visible = true;
break;
case 12:
dsReportTableAdapters.uspOpeningNotLoginReportTableAdapter uspOpeningNotLoginReportTA = new dsReportTableAdapters.uspOpeningNotLoginReportTableAdapter();
dsReport.uspOpeningNotLoginReportDataTable uspOpeningNotLoginReportDT = uspOpeningNotLoginReportTA.GetUspOpeningNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspOpeningNotLoginReportDT.Count;
gvUsers.DataSource = uspOpeningNotLoginReportDT;
gvUsers.Columns[20].Visible = true;
break;
case 13:
dsReportTableAdapters.uspMascotBabiesNotLoginReportTableAdapter uspMascotBabiesNotLoginReportTA = new dsReportTableAdapters.uspMascotBabiesNotLoginReportTableAdapter();
dsReport.uspMascotBabiesNotLoginReportDataTable uspMascotBabiesNotLoginReportDT = uspMascotBabiesNotLoginReportTA.GetUspMascotBabiesNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspMascotBabiesNotLoginReportDT.Count;
gvUsers.DataSource = uspMascotBabiesNotLoginReportDT;
gvUsers.Columns[21].Visible = true;
break;
case 14:
dsReportTableAdapters.uspPressBoxNotLoginReportTableAdapter uspPressBoxNotLoginReportTA = new dsReportTableAdapters.uspPressBoxNotLoginReportTableAdapter();
dsReport.uspPressBoxNotLoginReportDataTable uspPressBoxNotLoginReportDT = uspPressBoxNotLoginReportTA.GetUspPressBoxNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspPressBoxNotLoginReportDT.Count;
gvUsers.DataSource = uspPressBoxNotLoginReportDT;
gvUsers.Columns[22].Visible = true;
break;
case 15:
dsReportTableAdapters.uspPlayballNotLoginReportTableAdapter uspPlayballNotLoginReportTA = new dsReportTableAdapters.uspPlayballNotLoginReportTableAdapter();
dsReport.uspPlayballNotLoginReportDataTable uspPlayballNotLoginReportDT = uspPlayballNotLoginReportTA.GetUspPlayballNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspPlayballNotLoginReportDT.Count;
gvUsers.DataSource = uspPlayballNotLoginReportDT;
gvUsers.Columns[23].Visible = true;
break;
case 16:
dsReportTableAdapters.uspSponsorsNotLoginReportTableAdapter uspSponsorsNotLoginReportTA = new dsReportTableAdapters.uspSponsorsNotLoginReportTableAdapter();
dsReport.uspSponsorsNotLoginReportDataTable uspSponsorsNotLoginReportDT = uspSponsorsNotLoginReportTA.GetUspSponsorsNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspSponsorsNotLoginReportDT.Count;
gvUsers.DataSource = uspSponsorsNotLoginReportDT;
gvUsers.Columns[24].Visible = true;
break;
case 17:
dsReportTableAdapters.uspLondonNotLoginReportTableAdapter uspLondonNotLoginReportTA = new dsReportTableAdapters.uspLondonNotLoginReportTableAdapter();
dsReport.uspLondonNotLoginReportDataTable uspLondonNotLoginReportDT = uspLondonNotLoginReportTA.GetUspLondonNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspLondonNotLoginReportDT.Count;
gvUsers.DataSource = uspLondonNotLoginReportDT;
gvUsers.Columns[25].Visible = true;
break;
case 18:
dsReportTableAdapters.uspRestricted2NotLoginReportTableAdapter uspRestricted2NotLoginReportTA = new dsReportTableAdapters.uspRestricted2NotLoginReportTableAdapter();
dsReport.uspRestricted2NotLoginReportDataTable uspRestricted2NotLoginReportDT = uspRestricted2NotLoginReportTA.GetUspRestricted2NotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspRestricted2NotLoginReportDT.Count;
gvUsers.DataSource = uspRestricted2NotLoginReportDT;
gvUsers.Columns[26].Visible = true;
break;
case 19:
dsReportTableAdapters.uspRestricted3NotLoginReportTableAdapter uspRestricted3NotLoginReportTA = new dsReportTableAdapters.uspRestricted3NotLoginReportTableAdapter();
dsReport.uspRestricted3NotLoginReportDataTable uspRestricted3NotLoginReportDT = uspRestricted3NotLoginReportTA.GetUspRestricted3NotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspRestricted3NotLoginReportDT.Count;
gvUsers.DataSource = uspRestricted3NotLoginReportDT;
gvUsers.Columns[27].Visible = true;
break;
case 20:
dsReportTableAdapters.uspMLBLogoVaultNotLoginReportTableAdapter uspMLBLogoVaultNotLoginReportTA = new dsReportTableAdapters.uspMLBLogoVaultNotLoginReportTableAdapter();
dsReport.uspMLBLogoVaultNotLoginReportDataTable uspMLBLogoVaultNotLoginReportDT = uspMLBLogoVaultNotLoginReportTA.GetUspMLBLogoVaultNotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspMLBLogoVaultNotLoginReportDT.Count;
gvUsers.DataSource = uspMLBLogoVaultNotLoginReportDT;
gvUsers.Columns[28].Visible = true;
break;
}
}
else
{
switch (Convert.ToInt32(ddlSitelet.SelectedItem.Value))
{
case 1:
dsReportTableAdapters.uspClubArtsLoginReportTableAdapter uspClubArtsLoginReportTA = new dsReportTableAdapters.uspClubArtsLoginReportTableAdapter();
dsReport.uspClubArtsLoginReportDataTable uspClubArtsLoginReportDT = uspClubArtsLoginReportTA.GetUspClubArtsLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspClubArtsLoginReportDT.Count;
gvUsers.DataSource = uspClubArtsLoginReportDT;
gvUsers.Columns[8].Visible = true;
break;
case 2:
dsReportTableAdapters.uspSpringLoginReportTableAdapter uspSpringLoginReportTA = new dsReportTableAdapters.uspSpringLoginReportTableAdapter();
dsReport.uspSpringLoginReportDataTable uspSpringLoginReportDT = uspSpringLoginReportTA.GetUspSpringLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspSpringLoginReportDT.Count;
gvUsers.DataSource = uspSpringLoginReportDT;
gvUsers.Columns[9].Visible = true;
break;
case 3:
dsReportTableAdapters.uspAllsLoginReportTableAdapter uspAllsLoginReportTA = new dsReportTableAdapters.uspAllsLoginReportTableAdapter();
dsReport.uspAllsLoginReportDataTable uspAllsLoginReportDT = uspAllsLoginReportTA.GetUspAllsLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspAllsLoginReportDT.Count;
gvUsers.DataSource = uspAllsLoginReportDT;
gvUsers.Columns[10].Visible = true;
break;
case 4:
dsReportTableAdapters.uspWorldLoginReportTableAdapter uspWorldLoginReportTA = new dsReportTableAdapters.uspWorldLoginReportTableAdapter();
dsReport.uspWorldLoginReportDataTable uspWorldLoginReportDT = uspWorldLoginReportTA.GetUspWorldLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspWorldLoginReportDT.Count;
gvUsers.DataSource = uspWorldLoginReportDT;
gvUsers.Columns[11].Visible = true;
break;
case 5:
dsReportTableAdapters.uspCoopLoginReportTableAdapter uspCoopLoginReportTA = new dsReportTableAdapters.uspCoopLoginReportTableAdapter();
dsReport.uspCoopLoginReportDataTable uspCoopLoginReportDT = uspCoopLoginReportTA.GetUspCoopLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspCoopLoginReportDT.Count;
gvUsers.DataSource = uspCoopLoginReportDT;
gvUsers.Columns[12].Visible = true;
break;
case 6:
dsReportTableAdapters.uspMascotLoginReportTableAdapter uspMascotLoginReportTA = new dsReportTableAdapters.uspMascotLoginReportTableAdapter();
dsReport.uspMascotLoginReportDataTable uspMascotLoginReportDT = uspMascotLoginReportTA.GetUspMascotLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspMascotLoginReportDT.Count;
gvUsers.DataSource = uspMascotLoginReportDT;
gvUsers.Columns[13].Visible = true;
break;
case 7:
dsReportTableAdapters.uspMinorLoginReportTableAdapter uspMinorLoginReportTA = new dsReportTableAdapters.uspMinorLoginReportTableAdapter();
dsReport.uspMinorLoginReportDataTable uspMinorLoginReportDT = uspMinorLoginReportTA.GetMinorLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspMinorLoginReportDT.Count;
gvUsers.DataSource = uspMinorLoginReportDT;
gvUsers.Columns[14].Visible = true;
break;
case 8:
dsReportTableAdapters.uspThemeArtLoginReportTableAdapter uspThemeArtLoginReportTA = new dsReportTableAdapters.uspThemeArtLoginReportTableAdapter();
dsReport.uspThemeArtLoginReportDataTable uspThemeArtLoginReportDT = uspThemeArtLoginReportTA.GetUspThemeArtLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspThemeArtLoginReportDT.Count;
gvUsers.DataSource = uspThemeArtLoginReportDT;
gvUsers.Columns[15].Visible = true;
break;
case 9:
dsReportTableAdapters.uspDesignLoginReportTableAdapter uspDesignLoginReportTA = new dsReportTableAdapters.uspDesignLoginReportTableAdapter();
dsReport.uspDesignLoginReportDataTable uspDesignLoginReportDT = uspDesignLoginReportTA.GetUspDesignLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspDesignLoginReportDT.Count;
gvUsers.DataSource = uspDesignLoginReportDT;
gvUsers.Columns[16].Visible = true;
break;
case 10:
//dsReportTableAdapters.uspCMCLoginReportByDatesTableAdapter uspCMCLoginReportByDatesTA = new dsReportTableAdapters.uspCMCLoginReportByDatesTableAdapter();
//dsReport.uspCMCLoginReportByDatesDataTable uspCMCLoginReportByDatesDT = uspCMCLoginReportByDatesTA.GetUspCMCLoginReportByDates(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
//iCount = uspCMCLoginReportByDatesDT.Rows.Count;
//gvUsers.DataSource = uspCMCLoginReportByDatesDT;
dsReportTableAdapters.uspCMCPageLoginsTableAdapter uspCMCPageLoginsTA = new dsReportTableAdapters.uspCMCPageLoginsTableAdapter();
dsReport.uspCMCPageLoginsDataTable uspCMCPageLoginsDT = new dsReport.uspCMCPageLoginsDataTable();
string strPageIDs = string.Empty;
for (int i = 0; i < cblPages.Items.Count; i++)
{
if (cblPages.Items[i].Selected)
{
dsReport.uspCMCPageLoginsDataTable thisDT = uspCMCPageLoginsTA.GetUspCMCPageLogins(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1), Convert.ToInt32(cblPages.Items[i].Value));
foreach (DataRow dr in thisDT.Rows)
{
uspCMCPageLoginsDT.ImportRow(dr);
}
}
}
iCount = uspCMCPageLoginsDT.Count;
Session["uspCMCPageLoginsDT"] = uspCMCPageLoginsDT;
gvUsers.DataSource = uspCMCPageLoginsDT;
gvUsers.Columns[17].Visible = true;
gvUsers.Columns[18].HeaderText = "Page (logged into)";
gvUsers.Columns[18].Visible = true;
break;
case 11:
dsReportTableAdapters.uspRestrictedLoginReportTableAdapter uspRestrictedLoginReportTA = new dsReportTableAdapters.uspRestrictedLoginReportTableAdapter();
dsReport.uspRestrictedLoginReportDataTable uspRestrictedLoginReportDT = uspRestrictedLoginReportTA.GetUspRestrictedLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspRestrictedLoginReportDT.Count;
gvUsers.DataSource = uspRestrictedLoginReportDT;
gvUsers.Columns[19].Visible = true;
break;
case 12:
dsReportTableAdapters.uspOpeningLoginReportTableAdapter uspOpeningLoginReportTA = new dsReportTableAdapters.uspOpeningLoginReportTableAdapter();
dsReport.uspOpeningLoginReportDataTable uspOpeningLoginReportDT = uspOpeningLoginReportTA.GetUspOpeningLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspOpeningLoginReportDT.Count;
gvUsers.DataSource = uspOpeningLoginReportDT;
gvUsers.Columns[20].Visible = true;
break;
case 13:
dsReportTableAdapters.uspMascotBabiesLoginReportTableAdapter uspMascotBabiesLoginReportTA = new dsReportTableAdapters.uspMascotBabiesLoginReportTableAdapter();
dsReport.uspMascotBabiesLoginReportDataTable uspMascotBabiesLoginReportDT = uspMascotBabiesLoginReportTA.GetUspMascotBabiesLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));;
iCount = uspMascotBabiesLoginReportDT.Count;
gvUsers.DataSource = uspMascotBabiesLoginReportDT;
gvUsers.Columns[21].Visible = true;
break;
case 14:
dsReportTableAdapters.uspPressBoxLoginReportTableAdapter uspPressBoxLoginReportTA = new dsReportTableAdapters.uspPressBoxLoginReportTableAdapter();
dsReport.uspPressBoxLoginReportDataTable uspPressBoxLoginReportDT = uspPressBoxLoginReportTA.GetUspPressBoxLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspPressBoxLoginReportDT.Count;
gvUsers.DataSource = uspPressBoxLoginReportDT;
gvUsers.Columns[22].Visible = true;
break;
case 15:
dsReportTableAdapters.uspPlayballLoginReportTableAdapter uspPlayballLoginReportTA = new dsReportTableAdapters.uspPlayballLoginReportTableAdapter();
dsReport.uspPlayballLoginReportDataTable uspPlayballLoginReportDT = uspPlayballLoginReportTA.GetUspPlayballLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspPlayballLoginReportDT.Count;
gvUsers.DataSource = uspPlayballLoginReportDT;
gvUsers.Columns[23].Visible = true;
break;
case 16:
dsReportTableAdapters.uspSponsorsLoginReportTableAdapter uspSponsorsLoginReportTA = new dsReportTableAdapters.uspSponsorsLoginReportTableAdapter();
dsReport.uspSponsorsLoginReportDataTable uspSponsorsLoginReportDT = uspSponsorsLoginReportTA.GetUspSponsorsLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspSponsorsLoginReportDT.Count;
gvUsers.DataSource = uspSponsorsLoginReportDT;
gvUsers.Columns[24].Visible = true;
break;
case 17:
dsReportTableAdapters.uspLondonLoginReportTableAdapter uspLondonLoginReportTA = new dsReportTableAdapters.uspLondonLoginReportTableAdapter();
dsReport.uspLondonLoginReportDataTable uspLondonLoginReportDT = uspLondonLoginReportTA.GetUspLondonLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspLondonLoginReportDT.Count;
gvUsers.DataSource = uspLondonLoginReportDT;
gvUsers.Columns[25].Visible = true;
break;
case 18:
dsReportTableAdapters.uspRestricted2LoginReportTableAdapter uspRestricted2LoginReportTA = new dsReportTableAdapters.uspRestricted2LoginReportTableAdapter();
dsReport.uspRestricted2LoginReportDataTable uspRestricted2LoginReportDT = uspRestricted2LoginReportTA.GetUspRestricted2LoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspRestricted2LoginReportDT.Count;
gvUsers.DataSource = uspRestricted2LoginReportDT;
gvUsers.Columns[26].Visible = true;
break;
case 19:
dsReportTableAdapters.uspRestricted3LoginReportTableAdapter uspRestricted3LoginReportTA = new dsReportTableAdapters.uspRestricted3LoginReportTableAdapter();
dsReport.uspRestricted3LoginReportDataTable uspRestricted3LoginReportDT = uspRestricted3LoginReportTA.GetUspRestricted3LoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspRestricted3LoginReportDT.Count;
gvUsers.DataSource = uspRestricted3LoginReportDT;
gvUsers.Columns[27].Visible = true;
break;
case 20:
dsReportTableAdapters.uspMLBLogoVaultLoginReportTableAdapter uspMLBLogoVaultLoginReportTA = new dsReportTableAdapters.uspMLBLogoVaultLoginReportTableAdapter();
dsReport.uspMLBLogoVaultLoginReportDataTable uspMLBLogoVaultLoginReportDT = uspMLBLogoVaultLoginReportTA.GetUspMLBLogoVaultLoginReport(Convert.ToDateTime(Session["from"]), Convert.ToDateTime(Session["to"]).AddDays(1));
iCount = uspMLBLogoVaultLoginReportDT.Count;
gvUsers.DataSource = uspMLBLogoVaultLoginReportDT;
gvUsers.Columns[28].Visible = true;
break;
}
}
gvUsers.DataBind();
lblResult.Text = "Number of users: <b>" + iCount + "</b>";
ltrBreadCrumb2.Text = " :: " + Session["sitelet"] + " - From " + Session["from"] + " To " + Session["to"];
siteletTable.Visible = false;
resultDiv.Visible = true;
}
if (Request.QueryString.ToString() == "not")
{
ltrBreadCrumb.Text = " :: <a href=\"UsersLoggedIn.aspx?not\">Traffic Report (Users Not Logged In)</a>";
}
else
{
ltrBreadCrumb.Text = " :: <a href=\"UsersLoggedIn.aspx\">Traffic Report (Users Logged In)</a>";
}
iSiteletID = Convert.ToInt32(ddlSitelet.SelectedItem.Value);
}
}