protected void Page_Load(object sender, EventArgs e)
{
try {
string checkrole = (string)(Session["role"]);
string account = (string)(Session["account"]);
lbUserName.Text = account;
if (account == null)
{
Response.Redirect("~/UI/Login.aspx");
}
if (checkrole == "HeadStaff")
{
divide.Visible = true;
logCare.Visible = true;
control.Visible = true;
}
else
{
divide.Visible = false;
logCare.Visible = false;
control.Visible = false;
}
Business.ScsBO sbo = new Business.ScsBO();
DataTable dt = sbo.updateNotes();;
StringBuilder html = new StringBuilder();
//Table start.
html.Append("<table id='example' class='table table-striped table-bordered table-list'>");
//Building the Header row.
html.Append("<thead>");
html.Append("<tr class='info'>");
foreach (DataColumn column in dt.Columns)
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
html.Append("</thead>");
//Building the Data rows.
html.Append("<tbody>");
foreach (DataRow row in dt.Rows)
{
html.Append("<tr>");
string url = "";
html.Append("<td align='left' valign='top'><a href=" + url + "Profile.aspx?studentID=" + row[0] + ">" + row[0] + "</a></td>");
for (int i = 1; i < dt.Columns.Count; i++)
{
List <Entity.StatusCheck> stl = new List <Entity.StatusCheck>();
stl = sbo.loadCheck();
if (i == 1)
{
html.Append("<td>");
html.Append(row[i]);
foreach (Entity.StatusCheck sc in stl)
{
if (sc.attention == true && sc.studentID.Equals(row[0].ToString()))
{
html.Append(" <span style='color: red; ' class='glyphicon'></span>");
break;
}
}
html.Append("</td>");
}
else
{
html.Append("<td>");
html.Append(row[i]);
html.Append("</td>");
}
}
html.Append("</tr>");
}
//Table end.
html.Append("</table>");
html.Append("</tbody");
//Append the HTML string to Placeholder.
Panel3.Controls.Add(new Literal {
Text = html.ToString()
});
}catch (Exception ee)
{
Response.Redirect("~/UI/Error.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if ((Session["account"]) == null || (Session["role"]) == null || (Session["accountID"]) == null)
{
Response.Redirect("~/UI/Login.aspx");
}
if (this.IsPostBack)
{
return;
}
Business.ScsBO sbo = new Business.ScsBO();
int accountID = (int)(Session["accountID"]);
string checkrole = (string)(Session["role"]);
string account = (string)(Session["account"]);
lbUserName.Text = account;
if (checkrole.Equals("HeadStaff"))
{
divide.Visible = true;
logCare.Visible = true;
control.Visible = true;
}
else
{
divide.Visible = false;
logCare.Visible = false;
control.Visible = false;
}
//**********************
List <StatusCheck> stl = new List <StatusCheck>();
stl = sbo.loadCheck();
if (checkrole.Equals("CareStaff"))
{
DataTable dt = sbo.myStudent(accountID);
//Building an HTML string.
System.Text.StringBuilder html = new System.Text.StringBuilder();
//Table start.
html.Append("<table id='overview' class='table table-striped table-bordered table-list'>");
html.Append("<thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dt.Columns)
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody>");
//Building the Data rows.
int gpaFlag = 0;
int behaviorFlag = 0;
int attenFalg = 0;
int failFlag = 0;
//int checkFlag = 0;
List <Compare> cp = new List <Compare>();
cp = sbo.takeDataCompare(accountID.ToString());
foreach (DataRow row in dt.Rows)
{
html.Append("<tr>");
string url = "";
html.Append("<td align='left' valign='top'><a href=" + url + "Profile.aspx?studentID=" + row[0] + ">" + row[0] + "</a></td>");
for (int i = 1; i < dt.Columns.Count; i++)
{
//Rank r =sbo.GetDataToCompare(semester,row[0].ToString());
//stl = sbo.loadCheck();
if (i == 1)
{
html.Append("<td>");
html.Append(row[i]);
foreach (StatusCheck sc in stl)
{
if (sc.attention == true && sc.studentID.Equals(row[0].ToString()))
{
html.Append(" <span style='color: red; ' class='glyphicon'></span>");
break;
}
}
html.Append("</td>");
}
else if (i == 2)
{
for (int j = gpaFlag; j < cp.Count; j++)
{
html.Append("<td>");
html.Append(row[i]);
if ((double)cp[j].gpa > (double)cp[j].gpa2)
{
html.Append("<span style='color:green;' class='glyphicon'></span>");
}
else if ((double)cp[j].gpa == (double)cp[j].gpa2 || (double)cp[j].gpa2 == 0)
{
}
else
{
html.Append("<span style='color:red;' class='glyphicon'></span>");
}
html.Append("</td>");
gpaFlag++;
break;
}
}
else if (i == 3)
{
for (int j = behaviorFlag; j < cp.Count; j++)
{
html.Append("<td>");
html.Append(row[i]);
if ((double)cp[j].behavior > (double)cp[j].behavior2)
{
html.Append("<span style='color:green;' class='glyphicon'></span>");
}
else if ((double)cp[j].behavior == (double)cp[j].behavior2 || (double)cp[j].behavior2 == 0)
{
}
else
{
html.Append("<span style='color:red;' class='glyphicon'></span>");
}
html.Append("</td>");
behaviorFlag++;
break;
}
}
else if (i == 4)
{
for (int j = attenFalg; j < cp.Count; j++)
{
html.Append("<td>");
html.Append(row[i]);
if ((double)cp[j].atten > (double)cp[j].atten2)
{
html.Append("<span style='color:green;' class='glyphicon'></span>");
}
else if ((double)cp[j].atten == (double)cp[j].atten2 || (double)cp[j].atten2 == 0)
{
}
else
{
html.Append("<span style='color:red;' class='glyphicon'></span>");
}
html.Append("</td>");
attenFalg++;
break;
}
}
else if (i == 5)
{
//for (int j = failFlag; j < cp.Count; j++)
//{
html.Append("<td>");
html.Append(row[i]);
//if ((double)cp[j].failcourse < (double)cp[j].failcourse2)
//{
// html.Append("<span style='color:green;' class='glyphicon'></span>");
//}
//else if ((double)cp[j].failcourse == (double)cp[j].failcourse2)
//{
//}
//else
//{
// html.Append("<span style='color:red;' class='glyphicon'></span>");
//}
html.Append("</td>");
// failFlag++;
// break;
//}
}
else
{
html.Append("<td>");
html.Append(row[i]);
html.Append("</td>");
}
}
html.Append("</tr>");
}
//Table end.
html.Append("</table>");
html.Append("<tbody>");
//Append the HTML string to Placeholder.
Panel1.Controls.Add(new Literal {
Text = html.ToString()
});
}
else
{
DataTable dt2 = sbo.myStudentForHead();
//Building an HTML string.
System.Text.StringBuilder html2 = new System.Text.StringBuilder();
//Table start.
html2.Append("<table id='overview' class='table table-striped table-bordered table-list'>");
html2.Append("<thead>");
//Building the Header row.
html2.Append("<tr>");
foreach (DataColumn column2 in dt2.Columns)
{
html2.Append("<th>");
html2.Append(column2.ColumnName);
html2.Append("</th>");
}
html2.Append("</tr>");
html2.Append("</thead>");
html2.Append("<tbody>");
//Building the Data rows.
int gpaFlag = 0;
int behaviorFlag = 0;
int attenFalg = 0;
////int failFlag = 0;
//int checkFlag = 0;
List <Compare> cp = new List <Compare>();
cp = sbo.takeDataCompareForHead();
foreach (DataRow row2 in dt2.Rows)
{
html2.Append("<tr>");
string url = "";
html2.Append("<td align='left' valign='top'><a href=" + url + "Profile.aspx?studentID=" + row2[0] + ">" + row2[0] + "</a></td>");
for (int i = 1; i < dt2.Columns.Count; i++)
{
//Rank r =sbo.GetDataToCompare(semester,row[0].ToString());
//stl = sbo.loadCheck();
if (i == 1)
{
html2.Append("<td>");
html2.Append(row2[i]);
foreach (StatusCheck sc in stl)
{
if (sc.attention == true && sc.studentID.Equals(row2[0].ToString()))
{
html2.Append(" <span style='color: red; ' class='glyphicon'></span>");
break;
}
}
html2.Append("</td>");
}
else if (i == 2)
{
for (int j = gpaFlag; j < cp.Count; j++)
{
html2.Append("<td>");
html2.Append(row2[i]);
if ((double)cp[j].gpa > (double)cp[j].gpa2)
{
html2.Append("<span style='color:green;' class='glyphicon'></span>");
}
else
{
html2.Append("<span style='color:red;' class='glyphicon'></span>");
}
html2.Append("</td>");
gpaFlag++;
break;
}
}
else if (i == 3)
{
for (int j = behaviorFlag; j < cp.Count; j++)
{
html2.Append("<td>");
html2.Append(row2[i]);
if ((double)cp[j].behavior > (double)cp[j].behavior2)
{
html2.Append("<span style='color:green;' class='glyphicon'></span>");
}
else
{
html2.Append("<span style='color:red;' class='glyphicon'></span>");
}
html2.Append("</td>");
behaviorFlag++;
break;
}
}
else if (i == 4)
{
for (int j = attenFalg; j < cp.Count; j++)
{
html2.Append("<td>");
html2.Append(row2[i]);
if ((double)cp[j].atten > (double)cp[j].atten2)
{
html2.Append("<span style='color:green;' class='glyphicon'></span>");
}
else
{
html2.Append("<span style='color:red;' class='glyphicon'></span>");
}
html2.Append("</td>");
attenFalg++;
break;
}
}
else if (i == 5)
{
//for (int j = failFlag; j < cp.Count; j++)
//{
html2.Append("<td>");
html2.Append(row2[i]);
//if ((double)cp[j].failcourse < (double)cp[j].failcourse2)
//{
// html2.Append("<span style='color:green;' class='glyphicon'></span>");
//}
//else if ((double)cp[j].failcourse == (double)cp[j].failcourse2)
//{
//}
//else
//{
// html2.Append("<span style='color:red;' class='glyphicon'></span>");
//}
html2.Append("</td>");
//failFlag++;
//break;
//}
}
else
{
html2.Append("<td>");
html2.Append(row2[i]);
html2.Append("</td>");
}
}
html2.Append("</tr>");
}
//Table end.
html2.Append("</table>");
html2.Append("<tbody>");
//Append the HTML string to Placeholder.
Panel1.Controls.Add(new Literal {
Text = html2.ToString()
});
}
}
catch (Exception ee)
{
Response.Redirect("~/UI/Error.aspx");
}
//******************
}