Exemplo n.º 1
0
        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'>&#xe086;</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'>&#xe086;</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()
                });
            }
        }
Exemplo n.º 2
0
        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'>&#xe086;</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'>&#xe086;</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;
        }