protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckSchoolAdminSession();
#endregion Check Login
//add your value retrieve and form post code below
#region Initialize Values and Form Execution
#region Customize and Exporting
strExpType = (CCLib.Common.Strings.GetFormString("exporttype") == "") ? "" : CCLib.Common.Strings.GetFormString("exporttype");
if (CCLib.Common.Strings.GetQueryString("View") != "")
Session["ReportSavedCriteriaID"] = CCLib.Common.Strings.GetQueryString("View");
StringBuilder sbSQL = new StringBuilder();
if (Session["ReportTempCriteriaID"] != null || Session["ReportSavedCriteriaID"] != null)
{
if (Session["ReportTempCriteriaID"] != null)
hTable = CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedSnap", Session["ReportTempCriteriaID"].ToString(), 1);
if (Session["ReportSavedCriteriaID"] != null)
hTable = CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedSchool", Session["ReportSavedCriteriaID"].ToString(), 2);
#region Get Customization criteria
string strGradeID = hTable["GradeID"].ToString();
string strGenderID = hTable["GenderID"].ToString();
string strAdvisorID = hTable["AdvisorID"].ToString();
string strEthnicityID = hTable["EthnicityID"].ToString();
string strDatabaseName = "careerdb" + hTable["AcademicYear"].ToString() + ".dbo.";
//Delaware criteria
string strSPED = hTable["SpecialDE"].ToString();
string sCTE = hTable["CTE_DE"].ToString().ToUpper();
string sESL = hTable["LEP_DE"].ToString().ToUpper();
if (sESL != "") sESL = sESL.Substring(0, 1);
if (sCTE != "") sCTE = sCTE.Substring(0, 1);
string strEthnicityDE = hTable["EthnicityDE"].ToString();
#endregion Get Customization criteria
sbSQL.Append(" SELECT DISTINCT p.PortfolioID,");
sbSQL.Append(" cast(p.lastName as varchar) + N', ' + cast(p.firstName as varchar) as Name,");
sbSQL.Append(" count(*) as AppTotal,");
sbSQL.Append(" count(case when app.ScholStatusID = 4 then 1 when app.ScholStatusID = 6 then 1 when app.ScholStatusID = 7 then 1 else null end) as AppSubmitted,");
sbSQL.Append(" count(case when app.ScholStatusID = 6 then 1 else null end) as AwardsReceived,");
sbSQL.Append(" sum(app.AmountAwarded) as AmountAwarded");
// From
sbSQL.Append(" FROM " + strDatabaseName + "App_Scholprograms as app");
sbSQL.Append(" JOIN " + strDatabaseName + "Portfolio as p on app.PortfolioID = p.PortfolioID");
#region Specipic tables: PortTypeElements / Customization criteria
// 1. Delaware criteria: PortTypeID == "3"
if (PortTypeID == "3")
{
sbSQL.Append(" JOIN " + strDatabaseName + "Port_Student_DE as t ON p.PortfolioID = t.PortfolioID ");
if (strEthnicityDE != "")
{
sbSQL.Append(" and t.Ethnic_Code=" + strEthnicityDE);
}
if (sESL == "Y") { sbSQL.Append(" and t.ESL like '%" + sESL + "%'"); }
if (sESL == "N") { sbSQL.Append(" and t.ESL not like '%Y%'"); }
if (sCTE == "Y") { sbSQL.Append(" and t.CTE like '%" + sCTE + "%'"); }
if (sCTE == "N") { sbSQL.Append(" and t.CTE not like '%Y%'"); }
if ((strSPED.ToUpper() != "NO") && (strSPED != "")) { sbSQL.Append(" and t.SPED not like '%NO%'"); }
if (strSPED.ToUpper() == "NO") { sbSQL.Append(" and t.SPED like '%NO%'"); }
}
// 2. Customization criteria: EthnicityID
if (strEthnicityID != "")
{
sbSQL.Append(" join " + strDatabaseName + "Port_Student_KY as s on s.PortfolioID = p.PortfolioID");
sbSQL.Append(" and s.Ethnicity = " + strEthnicityID);
}
// 3. Customization criteria: Advisor
if (strAdvisorID != "")
sbSQL.Append(" join " + strDatabaseName + "PortfolioAdvisorAssignments as a on a.PortfolioID = p.PortfolioID and a.AdminID = " + strAdvisorID);
#endregion Specipic tables: PortTypeElements / Customization criteria
// Where
#region Specipic conditions: PortTypeElements / Customization criteria
// 1. Students at that CAMS user's school, students who are active and we only keep scholarships which are active
sbSQL.Append(" WHERE p.SchoolID=" + AdminInfo["SchoolID"].ToString() + " and p.Active=1 and app.ScholActive=1");
// 2. Students assigned to
if (Convert.ToBoolean(PortTypeElements["App_AssignedOnly"]))
sbSQL.Append(" AND p.PortfolioID IN (select PortfolioID from PortfolioAdvisorAssignments where AdminID = " + AdminInfo["AdminID"].ToString() + " and AssignmentApproved=1)");
// 3. Customization criteria: Grade Level
if (strGradeID != "")
sbSQL.Append(" and p.GradeNumber = " + strGradeID);
// 4. Customization criteria: Gender
if (strGenderID != "")
{
strGenderID = (strGenderID == "True") ? "1" : "0";
sbSQL.Append(" and p.GenderID = " + strGenderID);
}
#endregion Specipic conditions: PortTypeElements / Customization criteria
sbSQL.Append(" GROUP BY p.PortfolioID, p.lastName, p.firstName");
// sbSQL.Append(" ORDER BY " + RepeaterSortExpression + ASCENDING);
}
else
{
sbSQL.Append(" SELECT DISTINCT p.PortfolioID,");
sbSQL.Append(" cast(p.lastName as varchar) + N', ' + cast(p.firstName as varchar) as Name,");
sbSQL.Append(" count(*) as AppTotal,");
sbSQL.Append(" count(case when ScholStatusID = 4 then 1 when ScholStatusID = 6 then 1 when ScholStatusID = 7 then 1 else null end) as AppSubmitted,");
sbSQL.Append(" count(case when ScholStatusID =6 then 1 else null end) as AwardsReceived,");
sbSQL.Append(" sum(AmountAwarded) as AmountAwarded");
sbSQL.Append(" FROM App_Scholprograms AS app");
sbSQL.Append(" JOIN Portfolio as p on app.PortfolioID = p.PortfolioID");
// WHERE
// 1. Students at that CAMS user's school, students who are active and we only keep scholarships which are active
sbSQL.Append(" WHERE p.SchoolID=" + AdminInfo["SchoolID"].ToString() + " and p.Active=1 and app.ScholActive=1");
// 2. Students assigned to
if (Convert.ToBoolean(PortTypeElements["App_AssignedOnly"]))
sbSQL.Append(" AND p.PortfolioID in (select PortfolioID from PortfolioAdvisorAssignments where AdminID = " + AdminInfo["AdminID"].ToString() + " and AssignmentApproved=1)");
sbSQL.Append(" GROUP BY p.PortfolioID, p.lastName, p.firstName");
// sbSQL.Append(" ORDER BY " + RepeaterSortExpression + ASCENDING);
}
dtTables = CCLib.Common.DataAccess.GetDataTables(sbSQL.ToString());
//Response.Write(sbSQL.ToString());
sbSQL = null;
#endregion Customize and Exporting
#region Paging.
DelMethodReloadChart delReloadChart = new DelMethodReloadChart(ReloadChart);
this.pc1.PageMethodReloadChart = this.pc2.PageMethodReloadChart = delReloadChart;
this.pc1.MaxRecordsPage = this.pc2.MaxRecordsPage = MAX_RECORDS_BY_PAGE;
this.pc1.DisplayTotalItems = this.pc2.DisplayTotalItems = false;
#endregion Paging.
PopulateRptStud();
#endregion Initialize Values and Form Execution
#region Customize Export User Control
UC.BaseReportID = "77";
UC.PortTypeID = PortTypeID;
UC.ToolTypeID = ToolTypeID;
if (hTable != null)
{
UC.CriteriaHashtable = hTable;
if (hTable["ReportName"] != null)
UC.ReportName = hTable["ReportName"].ToString();
}
UC.ReportData = dtTables;
UC.ReportTitles = TextCode(10662);
UC.ReportDataColumnNames = TextCode(8905) + "," + TextCode(10667) + "," + TextCode(10617) + "," + TextCode(10668) + "," + TextCode(10463);
UC.ReportDataFieldNames = "Name,AppTotal,AppSubmitted,AwardsReceived,AmountAwarded";
#endregion Customize Export User Control
#region Properties For The School Base Class
TitleBar = "Application Planner Reports";
SubTitleBar = TextCode(10662);
StrictNoCache = false;
#endregion Properties For The School Base Class
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckSchoolAdminSession();
#endregion Check Login
#region Init Paging user control.
DelMethodReloadChart delReloadChart = new DelMethodReloadChart(ReloadChart);
this.pc1.PageMethodReloadChart = this.pc2.PageMethodReloadChart = delReloadChart;
this.pc1.MaxRecordsPage = this.pc2.MaxRecordsPage = MAX_RECORDS_BY_PAGE;
this.pc1.DisplayTotalItems = this.pc2.DisplayTotalItems = false;
#endregion Init Paging user control.
//add your value retrieve and form post code below
#region Initialize Values and Form Execution
strExpType = (CCLib.Common.Strings.GetFormString("exporttype") == "") ? "" : CCLib.Common.Strings.GetFormString("exporttype");
if (CCLib.Common.Strings.GetQueryString("View") != "")
Session["ReportSavedCriteriaID"] = CCLib.Common.Strings.GetQueryString("View");
if (Session["ReportTempCriteriaID"] != null || Session["ReportSavedCriteriaID"] != null)
{
if (Session["ReportTempCriteriaID"] != null)
hTable = CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedSnap", Session["ReportTempCriteriaID"].ToString(), 1);
if (Session["ReportSavedCriteriaID"] != null)
hTable = CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedSchool", Session["ReportSavedCriteriaID"].ToString(), 2);
}
bindData();
#endregion Initialize Values and Form Execution
#region Customize Export User Control
UC.BaseReportID = "83";
UC.PortTypeID = PortTypeID;
UC.ToolTypeID = ToolTypeID;
if (hTable != null)
{
UC.CriteriaHashtable = hTable;
if (hTable["ReportName"] != null)
UC.ReportName = hTable["ReportName"].ToString();
}
UC.ReportData = dtTables;
UC.ReportTitles = "Personal College Profiles";
UC.ReportDataColumnNames = "Student Name,Grade,Questions Answered";
UC.ReportDataFieldNames = "Name,Grade,QuesAnswered";
#endregion Customize Export User Control
#region Properties For The School Base Class
TitleBar = "Application Planner Reports";
SubTitleBar = "Personal College Profiles";
StrictNoCache = false;
#endregion Properties For The School Base Class
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region Check Login
CheckRegionAdminSession();
#endregion Check Login
// Allow users to use the "Back Button" in the browser to come back to this page
StrictNoCache = false;
#region Paging.
DelMethodReloadChart delReloadChart = new DelMethodReloadChart(ReloadChart);
this.pc1.PageMethodReloadChart = this.pc2.PageMethodReloadChart = delReloadChart;
this.pc1.MaxRecordsPage = this.pc2.MaxRecordsPage = MAX_RECORDS_BY_PAGE;
this.pc1.DisplayTotalItems = this.pc2.DisplayTotalItems = true;
#endregion Paging.
//add your value retrieve and form post code below
#region Initialize Values and Form Execution
strExpType = CareerCruisingWeb.CCLib.Common.Strings.GetFormString("exporttype");
if (!IsPostBack)
{
// User comes from the search page: search criteria retrieve (7)
// or from the details page: keep the previous search criteria
// http://msdn.microsoft.com/en-us/library/ms178139.aspx#Y684
if (Page.PreviousPage != null)
{
if (Page.PreviousPage.ToString().EndsWith("studentssearch_aspx"))
{
if (CCLib.Common.Strings.GetFormString("ddlSchool") != "")
strSearchCriteria += " AND p.SchoolID=" + CCLib.Common.Strings.GetFormString("ddlSchool");
if (CCLib.Common.Strings.GetFormString("ddlGrade") != "")
{
if (CCLib.Common.Strings.GetFormString("ddlGrade") != "13")
strSearchCriteria += " and p.GradeNumber=" + CCLib.Common.Strings.GetFormString("ddlGrade");
else
strSearchCriteria += " and p.GradeNumber not in (6,7,8,9,10,11,12)";
}
if (CCLib.Common.Strings.GetFormString("txtUsername") != "")
strSearchCriteria += " AND p.Username like '" + CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("txtUsername"), false) + "%'";
if (CCLib.Common.Strings.GetFormString("txtFirstName") != "")
strSearchCriteria += " AND p.FirstName like '" + CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("txtFirstName"), false) + "%'";
if (CCLib.Common.Strings.GetFormString("txtLastName") != "")
strSearchCriteria += " AND p.LastName like '" + CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("txtLastName"), false) + "%'";
if (CCLib.Common.Strings.GetFormString("rdGender") != "")
strSearchCriteria += " AND p.Gender='" + CCLib.Common.Strings.GetFormString("rdGender") + "'";
Session["CurrentSearchCriteria"] = strSearchCriteria;
}
}
// User comes from left menu
else
Session["CurrentSearchCriteria"] = "";
PopulateRptSchol(RepeaterSortExpression, ASCENDING);
}
#endregion Initialize Values and Form Execution
#region Properties For The Region Base Class
TitleBar = TextCode(10543);
HasLeftButtons = false;
HasRightMenuCorner = false;
HasSubTitleBar = false;
#endregion Properties For The Region Base Class
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckRegionAdminSession();
#endregion Check Login
#region Initialize Paging
DelMethodReloadChart delReloadChart = new DelMethodReloadChart(ReloadChart);
this.pagingControlTop.PageMethodReloadChart = this.pagingControlBottom.PageMethodReloadChart = delReloadChart;
this.pagingControlTop.MaxRecordsPage = this.pagingControlBottom.MaxRecordsPage = intPageSize;
this.pagingControlTop.DisplayTotalItems = this.pagingControlBottom.DisplayTotalItems = true;
#endregion Initialize Paging.
#region Initialize Values and Form Execution
strExpType = CCLib.Common.Strings.GetFormString("exporttype");
if (!Page.IsPostBack)
{
ViewState["sortExp"] = "StudentName, CollegeName";
ViewState["sortOrder"] = "desc";
ViewState["pageNumner"] = "1";
// per requested, same search criteria section as it's in the Scholarship Tracker Overview page
if (Page.PreviousPage != null)
{
if (Page.PreviousPage.ToString().EndsWith("studentssearch_aspx"))
{
string strSearchCriteria = "";
if (CCLib.Common.Strings.GetFormString("ddlGrade") != "")
{
if (CCLib.Common.Strings.GetFormString("ddlGrade") != "13")
strSearchCriteria += " and p.GradeNumber=" + CCLib.Common.Strings.GetFormString("ddlGrade");
else
strSearchCriteria += " and p.GradeNumber not in (6,7,8,9,10,11,12)";
}
if (CCLib.Common.Strings.GetFormString("txtUsername") != "")
strSearchCriteria += " and p.Username like '" + CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("txtUsername"), false) + "%'";
if (CCLib.Common.Strings.GetFormString("txtFirstName") != "")
strSearchCriteria += " and p.FirstName like '" + CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("txtFirstName"), false) + "%'";
if (CCLib.Common.Strings.GetFormString("txtLastName") != "")
strSearchCriteria += " and p.LastName like '" + CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("txtLastName"), false) + "%'";
if (CCLib.Common.Strings.GetFormString("ddlAdvisor") != "")
strSearchCriteria += " and p.PortfolioID in (select portfolioid from PortfolioAdvisorAssignmentView where Adminid=" + CCLib.Common.Strings.GetFormString("ddlAdvisor") + ")";
if (CCLib.Common.Strings.GetFormString("rdGender") != "")
strSearchCriteria += " and p.Gender='" + CCLib.Common.Strings.GetFormString("rdGender") + "'";
if (CCLib.Common.Strings.GetFormString("ddlGroup") != "")
{
ViewState["InGroup"] = true;
strSearchCriteria += " and g.GroupID=" + CCLib.Common.Strings.GetFormString("ddlGroup");
}
else ViewState["InGroup"] = false;
ViewState["SearchCriteria"] = strSearchCriteria;
}
}
else ViewState["SearchCriteria"] = "";
bindData(ViewState["sortExp"].ToString(), ViewState["sortOrder"].ToString());
}
#endregion Initialize Values and Form Execution
#region Properties For The Region Base Class
TitleBar = "College Application Status";
HasSubTitleBar = false;
HasLeftButtons = false;
HasRightMenuCorner = false;
StrictNoCache = false;
#endregion Properties For The Region Base Class
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckRegionAdminSession();
#endregion Check Login
#region Init Paging user control.
DelMethodReloadChart delReloadChart = new DelMethodReloadChart(ReloadChart);
this.pc1.PageMethodReloadChart = this.pc2.PageMethodReloadChart = delReloadChart;
this.pc1.MaxRecordsPage = this.pc2.MaxRecordsPage = MAX_RECORDS_BY_PAGE;
this.pc1.DisplayTotalItems = this.pc2.DisplayTotalItems = false;
#endregion Init Paging user control.
//add your value retrieve and form post code below
#region Initialize Values and Form Execution
strExpType = (CCLib.Common.Strings.GetFormString("exporttype") == "") ? "" : CCLib.Common.Strings.GetFormString("exporttype");
dtStatus = CCLib.Common.DataAccess.GetDataTable("SELECT * FROM App_ChecklistStatus_Lookup WHERE ItemTypeID=" + strItemTypeID);
if (CCLib.Common.Strings.GetQueryString("View") != "")
Session["ReportSavedCriteriaID"] = CCLib.Common.Strings.GetQueryString("View");
if (Session["ReportTempCriteriaID"] != null || Session["ReportSavedCriteriaID"] != null)
{
if (Session["ReportTempCriteriaID"] != null)
hTable = CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedSnap", Session["ReportTempCriteriaID"].ToString(), 1);
if (Session["ReportSavedCriteriaID"] != null)
hTable = CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedRegion", Session["ReportSavedCriteriaID"].ToString(), 2);
}
bindData();
#endregion Initialize Values and Form Execution
#region Customize Export User Control
UC.BaseReportID = "92";
UC.PortTypeID = PortTypeID;
UC.ToolTypeID = ToolTypeID;
if (hTable != null)
{
UC.CriteriaHashtable = hTable;
if (hTable["ReportName"] != null)
UC.ReportName = hTable["ReportName"].ToString();
}
UC.ReportData = dtTables;
UC.ReportTitles = "CSS PROFILE Planning by Student";
UC.ReportDataColumnNames = "School Name,Student Name,Grade,Applying,Status";
UC.ReportDataFieldNames = "InstitutionName,Name,Grade,Applying,Status";
#endregion Customize Export User Control
#region Properties For The Region Base Class
TitleBar = "Application Planner Reports";
SubTitleBar = "CSS PROFILE Planning by Student";
StrictNoCache = false;
#endregion Properties For The Region Base Class
}
