public void testPreviousSemesterEmpty()
{
ScsBO sbo = new ScsBO();
string result = sbo.previousTerm("");;
Assert.AreEqual("Fall2017", result);
}
public void testPreviousSemesterInputNumberNagative()
{
ScsBO sbo = new ScsBO();
string result = sbo.previousTerm("-9");;
Assert.AreEqual("Fall2017", result);
}
public void testPreviousSemesterMisstakeSemester()
{
ScsBO sbo = new ScsBO();
string result = sbo.previousTerm("Spr2018");;
Assert.AreEqual("Fall2017", result);
}
public void testPreviousSemesterIsNull()
{
ScsBO sbo = new ScsBO();
string result = sbo.previousTerm(null);;
Assert.IsNull(result);
}
public void testPreviousSemesterOneYear()
{
ScsBO sbo = new ScsBO();
string result = sbo.previousTerm("Fall2018");;
Assert.AreEqual("Summer2018", result);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
ScsBO sbo = new ScsBO();
DataTable dt = new DataTable();
dt = sbo.Search(tbSearch.Text);
GridView1.DataSourceID = null;
GridView1.DataSource = dt;
GridView1.DataBind();
lbResult.Text = dt.Rows.Count + " " + "Kết Quả Tìm Kiếm";
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
ScsBO sbo = new ScsBO();
DataTable dt = new DataTable();
dt = sbo.Search(tbSearch.Text);
GridView1.DataSourceID = null;
GridView1.DataSource = dt;
GridView1.PageIndex = e.NewPageIndex;
int page = e.NewPageIndex;
int numLine = GridView1.PageSize;
stt = page * numLine + 1;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if ((Session["account"]) == null)
{
Response.Redirect("~/UI/Login.aspx");
}
string checkrole = (string)(Session["role"]);
string account = (string)(Session["account"]);
lbUserName.Text = account;
if (checkrole == "HeadStaff")
{
divide.Visible = true;
logCare.Visible = true;
control.Visible = true;
}
else
{
divide.Visible = false;
logCare.Visible = false;
control.Visible = false;
}
string search = Request.QueryString["result"];
if (!IsPostBack)
{
if (search != null)
{
ScsBO sbo = new ScsBO();
DataTable dt = new DataTable();
dt = sbo.Search(search);
GridView1.DataSourceID = null;
GridView1.DataSource = dt;
GridView1.DataBind();
tbSearch.Text = search;
lbResult.Text = dt.Rows.Count + " " + "Kết Quả Tìm Kiếm";
}
}
}catch (Exception ee)
{
Response.Redirect("~/UI/Error.aspx");
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
ScsBO sbo = new ScsBO();
int accountID = (int)(Session["accountID"]);
string checkrole = (string)(Session["role"]);
if (checkrole.Equals("CareStaff"))
{
DataTable dt = sbo.todayReport(accountID.ToString(), Calendar1.SelectedDate);
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>");
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 <StatusCheck> stl = new List <StatusCheck>();
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
{
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 dt = sbo.todayReportForHead(Calendar1.SelectedDate);
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 <StatusCheck> stl = new List <StatusCheck>();
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
{
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()
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.redirection_url = Request.Url.GetLeftPart(UriPartial.Authority) + "/UI/Homepage.aspx";
ScsBO sbo = new ScsBO();
StaffDAL stdal = new StaffDAL();
if (!IsPostBack)
{
if (Request.QueryString["code"] != null)
{
GetToken(Request.QueryString["code"].ToString());
}
}
if ((string)(Session["role"]) == null)
{
Response.Redirect("~/UI/Login.aspx");
}
string staffName = (string)(Session["account"]);
string usermail = (string)(Session["usermail"]);
string checkrole = (string)(Session["role"]);
string account = (string)(Session["account"]);
if (checkrole == "HeadStaff")
{
divide.Visible = true;
logCare.Visible = true;
control.Visible = true;
}
else
{
divide.Visible = false;
logCare.Visible = false;
control.Visible = false;
}
int accountID = (int)(Session["accountID"]);
//DateTime tm;
DateTime today = DateTime.Now;/*DateTime.ParseExact("10/06/2018", "dd/MM/yyyy", CultureInfo.InvariantCulture); //Convert.ToDateTime("10/06/2018");*/
//if (!Page.IsPostBack)
//{
// for (int td = 0; td < 7; td++)
// {
// tm = today.AddDays(-td);
// DropDownList1.Items.Add(tm.ToString("dd/MM/yyyy"));
// }
//}
if (!IsPostBack)
{
if (checkrole.Equals("CareStaff"))
{
DataTable dt = sbo.todayReport(accountID.ToString(), today);
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>");
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 <StatusCheck> stl = new List <StatusCheck>();
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
{
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 dt = sbo.todayReportForHead(today);
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 <StatusCheck> stl = new List <StatusCheck>();
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
{
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()
});
}
}
string name = (string)(Session["account"]);
lbUserName.Text = name;
}
