protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckSchoolAdminSession();
#endregion Check Login
// Unmapped transcripts
var sql = new System.Text.StringBuilder();
if (Request.ServerVariables["REQUEST_METHOD"] == "POST")
{
string strFormType = CCLib.Common.Strings.GetFormString("formType");
switch (strFormType)
{
case "1":
string strTID = CCLib.Common.Strings.GetFormString("delTID");
string strSID = CCLib.Common.DataAccess.GetValue(@"SELECT p.StudentID FROM dbo.Portfolio p JOIN dbo.Transcript_Transcripts t
ON p.PortfolioID = t.PortfolioID WHERE t.TranscriptID=" + strTID).ToString();
var safe = new ScripSafe();
string del = safe.DeleteTranscriptRequest(AdminInfo["SchoolID"].ToString(),strSID,strTID);
if (del == "Confirmation Request Recieved")
{
sql.Clear();
sql.Append("DELETE from Transcript_Transcripts where TranscriptID=" + strTID);
CCLib.Common.DataAccess.ExecuteDb(sql.ToString());
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The transcript has been deleted."));
}
else
{
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The transcript could not be deleted at this time. Please try again later."));
}
break;
case "2":
sql.Clear();
for (int c = 0; c < Request.Form.Count; c++)
{
if (Request.Form.Keys[c].Contains("confirm"))
{
string transcriptID = Request.Form.Keys[c].Replace("confirm", "");
sql.Append(";Update Transcript_Transcripts set DateLinkApproved=GetDate(), AdminID=" + AdminInfo["AdminID"] + " where TranscriptID=" + transcriptID);
}
}
sql.Remove(0, 1);
CCLib.Common.DataAccess.ExecuteDb(sql.ToString());
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The transcript information has been updated."));
break;
}
}
string strType = (CCLib.Common.Strings.GetQueryString("T").Length > 0) ? CCLib.Common.Strings.GetQueryString("T") : "1";
switch (strType)
{
case "1":
sql.Append("SELECT TranscriptID, StudentName, DateOfBirth, StudentNumber, DateReceived FROM dbo.Transcript_Transcripts ");
sql.AppendFormat(" WHERE PortfolioID is null and SchoolID={0} AND (DateLinkApproved IS NULL or DateLinkApproved = '')", AdminInfo["SchoolID"].ToString());
pnlAll.Visible = false;
pnlConfirm.Visible = false;
pnlUnmapped.Visible = true;
break;
case "2":
sql.Append("SELECT TranscriptID, StudentName, StudentNumber, DateReceived, p.FirstName + ' ' + p.LastName AS 'ccName', p.StudentID as 'CCID', ");
sql.Append("t.DateOfBirth FROM dbo.Transcript_Transcripts t JOIN dbo.Portfolio p ON t.PortfolioID = p.PortfolioID ");
sql.AppendFormat(" WHERE t.SchoolID={0} AND (DateLinkApproved IS NULL or DateLinkApproved = '')", AdminInfo["SchoolID"].ToString());
pnlAll.Visible = false;
pnlConfirm.Visible = true;
pnlUnmapped.Visible = false;
break;
case "3":
sql.Append("SELECT TranscriptID, StudentName, StudentNumber, DateReceived, p.FirstName + ' ' + p.LastName AS 'ccName', t.PortfolioID as 'CCID' ");
sql.Append(" FROM dbo.Transcript_Transcripts t JOIN dbo.Portfolio p ON t.PortfolioID = p.PortfolioID ");
sql.AppendFormat(" WHERE t.SchoolID={0} AND DateLinkApproved is not null", AdminInfo["SchoolID"].ToString());
pnlAll.Visible = true;
pnlConfirm.Visible = false;
pnlUnmapped.Visible = false;
break;
}
string strHeaderSQL = @"SELECT (SELECT COUNT(TranscriptID) FROM dbo.Transcript_Transcripts WHERE PortfolioID IS NULL AND SchoolID=" + AdminInfo["SchoolID"] + @") AS 'Unmapped',
(SELECT COUNT(TranscriptID) FROM dbo.Transcript_Transcripts WHERE PortfolioID IS NOT NULL AND Schoolid=" + AdminInfo["SchoolID"] + @" AND AdminID IS NULL AND IsAutoLink=1) AS 'Mapped',
(SELECT COUNT(TranscriptID) FROM dbo.Transcript_Transcripts WHERE PortfolioID IS NOT NULL AND Schoolid="+ AdminInfo["SchoolID"] + @" AND AdminID IS NOT NULL AND DateLinkApproved IS NOT NULL) AS 'Confirmed'";
dtHeader = CCLib.Common.DataAccess.GetDataTable(strHeaderSQL);
dtTranscripts = CCLib.Common.DataAccess.GetDataTable(sql.ToString());
#region Properties For The School Base Class
TitleBar = "Application Planner";
SubTitleBar = "Transcript List";
#endregion Properties For The School Base Class
}
