コード例 #1
0
    private void update()
    {
        string sUsername = Membership.GetUser().UserName;
        BLL.UserLib oUserLib = new BLL.UserLib();
        Entity.UserInfo oUserInfo = new Entity.UserInfo();
        SqlConnClass objSqlConnClass = new SqlConnClass();
        DDClass objDDClass = new DDClass(objSqlConnClass.OpenConnection());
        DataSet DS = objDDClass.GetwellnessDate(sUsername);
        if (DS.Tables[0].Rows.Count > 0)
        {
            DataTable dt = new DataTable();

            DS.AcceptChanges();
            dt = DS.Tables[0];

            string startMonth = ddlStartMonth.SelectedValue;
            string startDay = ddlStartDay.SelectedValue; ;
            string startYear = ddlStartYear.SelectedValue;
            string endMonth = ddlEndMonth.SelectedValue;
            string endDay = ddlEndDay.SelectedValue; ;
            string endYear = ddlEndYear.SelectedValue;
            string startDate = startMonth + "/" + startDay + "/" + startYear;
            string endDate = endMonth + "/" + endDay + "/" + endYear;

            // Sorting DataTable

            string expression = "Dates >= '" + startDate + "' and Dates <= '" + endDate + "'";

            // Sort descending by column named CompanyName.
            string sortOrder = "Dates ASC";

            DataRow[] dr = dt.Select(expression, sortOrder);

            int drLength = dr.Length;

            for (int i = 0; i <= drLength - 1; i++)
            {
                DateTime fulldate = Convert.ToDateTime(dr[i]["Dates"]);
                string dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[i]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[i]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[i]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[i]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[i]["Energy"]);

                chart1.Series["Sleep"].BorderWidth = 2;
                chart1.Series["Stress"].BorderWidth = 2;
                chart1.Series["Outlook"].BorderWidth = 2;
                chart1.Series["Engagement"].BorderWidth = 2;
                chart1.Series["Energy"].BorderWidth = 2;
            }

            DataView dataView = new DataView(dt);

            dataView.RowFilter = "Dates >= '" + startDate + "' and Dates <= '" + endDate + "'";
            dataView.Sort = "Dates ASC";

            GVdiary.DataSource = dataView;
            GVdiary.DataBind();
        }
    }
コード例 #2
0
    private void BindEvents()
    {
        string sUsername = Membership.GetUser().UserName;
        BLL.UserLib oUserLib = new BLL.UserLib();
        Entity.UserInfo oUserInfo = new Entity.UserInfo();
        SqlConnClass objSqlConnClass = new SqlConnClass();
        DDClass objDDClass = new DDClass(objSqlConnClass.OpenConnection());
        DataSet DS = objDDClass.GetwellnessDate(sUsername);
        if (DS.Tables[0].Rows.Count > 0)
        {
            DataTable dt = new DataTable();

            DS.AcceptChanges();

            dt = DS.Tables[0];

            int count = dt.Rows.Count;

            if (count > 7)
            {

                dt.DefaultView.Sort = "Dates DESC";
                dt = dt.DefaultView.ToTable();

                DataTable top7 = dt.Clone();
                for (int i = 0; i < 7; i++)
                {
                    top7.ImportRow(dt.Rows[i]);
                }

                DataView dataView = new DataView(top7);

                dataView.Sort = "Dates ASC";
                GVdiary.DataSource = dataView;
                GVdiary.DataBind();
            }
            else
            {

                // Sorting DataTable

                DataView dataView = new DataView(dt);

                dataView.Sort = "Dates ASC";
                GVdiary.DataSource = dataView;
                GVdiary.DataBind();
            }

        }
    }
コード例 #3
0
    private void BindEvents()
    {
        string sUsername = "";
        try
        {
            sUsername = Membership.GetUser().UserName;
        }
        catch
        {
        }
        if (sUsername == "")
        {
            Response.Redirect("../Main_Frame.aspx");
        }
        else
        {

            BLL.UserLib oUserLib = new BLL.UserLib();
            Entity.UserInfo oUserInfo = new Entity.UserInfo();
            SqlConnClass objSqlConnClass = new SqlConnClass();
            DDClass objDDClass = new DDClass(objSqlConnClass.OpenConnection());
            DataSet DS = objDDClass.GetwellnessDate(sUsername);
            if (DS.Tables[0].Rows.Count > 0)
            {
                DataTable dt = new DataTable();
                DateTime datee = DateTime.Now;
                DateTime dl = datee.AddDays(-6);

                string[] dateArr = new string[DS.Tables[0].Rows.Count];
                for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
                {
                    dateArr[i] = DS.Tables[0].Rows[i]["Dates"].ToString();
                }

                DateTime maxdate = Convert.ToDateTime(DS.Tables[0].Rows[0]["Dates"]);
                DateTime mindate = Convert.ToDateTime(DS.Tables[0].Rows[DS.Tables[0].Rows.Count - 1]["Dates"]);
                for (int i = 0, k = 0; i < dateArr.Length; i++, k++, maxdate.AddDays(-k))
                {
                    if (Convert.ToDateTime(dateArr[i]) != maxdate.AddDays(-k))
                    {

                        for (int j = 0; Convert.ToDateTime(dateArr[i]) < maxdate.AddDays(-k); j++)
                        {
                            if (DS.Tables[0].Rows.Count < 7)
                            {
                                DS.Tables[0].Rows.Add(100, oCompanyInfo.StrUserName, -1, -1, -1, -1, -1, maxdate.AddDays(-k).ToString("dddd"), maxdate.AddDays(-k), mindate.AddDays(-k).DayOfWeek);
                                k = k + j + 1;
                            }
                        }

                    }

                }

                int rcount = DS.Tables[0].Rows.Count;

                if (rcount < 7)
                {

                    for (int j = 0; j < 7 - rcount; j++)
                    {
                        int x = j + 1;
                        if (j == 0)
                        {

                            DS.Tables[0].Rows.Add(100, oCompanyInfo.StrUserName, -1, -1, -1, -1, -1, mindate.AddDays(-1).ToString("dddd"), mindate.AddDays(-1), mindate.AddDays(-1).DayOfWeek);
                        }
                        else
                        {
                            DS.Tables[0].Rows.Add(100, oCompanyInfo.StrUserName, -1, -1, -1, -1, -1, mindate.AddDays(-x).ToString("dddd"), mindate.AddDays(-x), mindate.AddDays(-x).DayOfWeek);
                        }

                    }

                }

                DS.AcceptChanges();

                dt = DS.Tables[0];

                // Sorting DataTable

                DataView dataView = new DataView(dt);

                dataView.Sort = " DayOfWeeks ASC";

                string expression = "Dates > '1/1/00'";

                // Sort descending by column named CompanyName.
                string sortOrder = "DayOfWeeks ASC";
                DataRow[] dr = dt.Select(expression, sortOrder);

                DateTime date = Convert.ToDateTime(dt.Rows[0]["Dates"]);

                GVdiary.DataSource = dataView;
                GVdiary.DataBind();

            }

        }
    }
コード例 #4
0
    private void bindChart()
    {
        string sUsername = Membership.GetUser().UserName;
        BLL.UserLib oUserLib = new BLL.UserLib();
        Entity.UserInfo oUserInfo = new Entity.UserInfo();
        SqlConnClass objSqlConnClass = new SqlConnClass();
        DDClass objDDClass = new DDClass(objSqlConnClass.OpenConnection());
        DataSet DS = objDDClass.GetwellnessDate(sUsername);
        if (DS.Tables[0].Rows.Count > 0)
        {
            DataTable dt = new DataTable();

            DS.AcceptChanges();
            dt = DS.Tables[0];

            int noRecords = dt.Rows.Count;

            if (noRecords > 7)
            {
                DataView dataView = new DataView(dt);

                //dataView.Sort = "Dates DESC";

                string expression = "Dates > '1/1/00'";

                // Sort descending by column named CompanyName.
                string sortOrder = "Dates DESC";

                DataRow[] dr = dt.Select(expression, sortOrder);

                double sleep = new double(); ;
                double stress = new double(); ;
                double outlook = new double();
                double engagement = new double();
                double energy = new double();

                DateTime fulldate = Convert.ToDateTime(dr[6]["Dates"]);
                string dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[6]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[6]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[6]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[6]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[6]["Energy"]);

                fulldate = Convert.ToDateTime(dr[5]["Dates"]);
                dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[5]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[5]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[5]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[5]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[5]["Energy"]);

                fulldate = Convert.ToDateTime(dr[4]["Dates"]);
                dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[4]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[4]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[4]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[4]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[4]["Energy"]);

                fulldate = Convert.ToDateTime(dr[3]["Dates"]);
                dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[3]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[3]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[3]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[3]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[3]["Energy"]);

                fulldate = Convert.ToDateTime(dr[2]["Dates"]);
                dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[2]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[2]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[2]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[2]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[2]["Energy"]);

                fulldate = Convert.ToDateTime(dr[1]["Dates"]);
                dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[1]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[1]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[1]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[1]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[1]["Energy"]);

                fulldate = Convert.ToDateTime(dr[0]["Dates"]);
                dates = fulldate.Date.ToShortDateString();
                chart1.Series["Sleep"].Points.AddXY(dates, dr[0]["Sleep"]);
                chart1.Series["Stress"].Points.AddXY(dates, dr[0]["Stress"]);
                chart1.Series["Outlook"].Points.AddXY(dates, dr[0]["Outlook"]);
                chart1.Series["Engagement"].Points.AddXY(dates, dr[0]["Engagement"]);
                chart1.Series["Energy"].Points.AddXY(dates, dr[0]["Energy"]);

                chart1.Series["Sleep"].BorderWidth = 2;
                chart1.Series["Stress"].BorderWidth = 2;
                chart1.Series["Outlook"].BorderWidth = 2;
                chart1.Series["Engagement"].BorderWidth = 2;
                chart1.Series["Energy"].BorderWidth = 2;

            }

            else
            {

                foreach (DataRow dr in dt.Rows)
                {
                    double sleep = new double(); ;
                    double stress = new double(); ;
                    double outlook = new double();
                    double engagement = new double();
                    double energy = new double();
                    sleep = Convert.ToInt16(dr["Sleep"].ToString());
                    stress = Convert.ToInt16(dr["Stress"].ToString());
                    outlook = Convert.ToInt16(dr["Outlook"].ToString());
                    engagement = Convert.ToInt16(dr["Engagement"].ToString());
                    energy = Convert.ToInt16(dr["Energy"].ToString());

                    string dates = dr["Dates"].ToString();
                    chart1.Series["Sleep"].Points.AddXY(dates, sleep);//(dates, sleep[0]);
                    chart1.Series["Stress"].Points.AddXY(dates, stress);
                    chart1.Series["Outlook"].Points.AddXY(dates, outlook);
                    chart1.Series["Engagement"].Points.AddXY(dates, engagement);
                    chart1.Series["Energy"].Points.AddXY(dates, energy);

                    chart1.Series["Sleep"].BorderWidth = 2;
                    chart1.Series["Stress"].BorderWidth = 2;
                    chart1.Series["Outlook"].BorderWidth = 2;
                    chart1.Series["Engagement"].BorderWidth = 2;
                    chart1.Series["Energy"].BorderWidth = 2;
                }
            }
        }
    }
コード例 #5
0
    private void bindChart()
    {
        double[] avg = new double[1];
        avg[0] = valsleep;
        double[] avgstress = new double[1];
        avgstress[0] = valstres;
        double[] avgoutlook = new double[1];
        avgoutlook[0] = valoutlook;
        double[] avgengagement = new double[1];
        avgengagement[0] = valengagement;
        double[] avgenergy = new double[1];
        avgenergy[0] = valenergy;
        chart1.Series["Average"].Points[0].YValues = avg;
        chart1.Series["Average"].Points[1].YValues = avgstress;
        chart1.Series["Average"].Points[2].YValues = avgoutlook;
        chart1.Series["Average"].Points[3].YValues = avgengagement;
        chart1.Series["Average"].Points[4].YValues = avgenergy;

        string sUsername = Membership.GetUser().UserName;
        BLL.UserLib oUserLib = new BLL.UserLib();
        Entity.UserInfo oUserInfo = new Entity.UserInfo();
        SqlConnClass objSqlConnClass = new SqlConnClass();
        DDClass objDDClass = new DDClass(objSqlConnClass.OpenConnection());
        DataSet DS = objDDClass.GetwellnessDate(sUsername);
        if (DS.Tables[0].Rows.Count > 0)
        {
            DataTable dt = new DataTable();
            DateTime datee = DateTime.Now;
            DateTime dl = datee.AddDays(-6);

            string[] dateArr = new string[DS.Tables[0].Rows.Count];
            for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
            {
                dateArr[i] = DS.Tables[0].Rows[i]["Dates"].ToString();
            }

            DateTime maxdate = Convert.ToDateTime(DS.Tables[0].Rows[0]["Dates"]);
            DateTime mindate = Convert.ToDateTime(DS.Tables[0].Rows[DS.Tables[0].Rows.Count - 1]["Dates"]);
            for (int i = 0, k = 0; i < dateArr.Length; i++, k++, maxdate.AddDays(-k))
            {
                if (Convert.ToDateTime(dateArr[i]) != maxdate.AddDays(-k))
                {

                    for (int j = 0; Convert.ToDateTime(dateArr[i]) < maxdate.AddDays(-k); j++)
                    {
                        if (DS.Tables[0].Rows.Count < 7)
                        {
                            DS.Tables[0].Rows.Add(100, oCompanyInfo.StrUserName, -1, -1, -1, -1, -1, maxdate.AddDays(-k).ToString("dddd"), maxdate.AddDays(-k));
                            k = k + j + 1;
                        }
                    }

                }

            }

            int rcount = DS.Tables[0].Rows.Count;

            if (rcount < 7)
            {

                for (int j = 0; j < 7 - rcount; j++)
                {
                    int x = j + 1;
                    if (j == 0)
                    {

                        DS.Tables[0].Rows.Add(100, oCompanyInfo.StrUserName, -1, -1, -1, -1, -1, mindate.AddDays(-1).ToString("dddd"), mindate.AddDays(-1), mindate.AddDays(-1).DayOfWeek);
                    }
                    else
                    {
                        DS.Tables[0].Rows.Add(100, oCompanyInfo.StrUserName, -1, -1, -1, -1, -1, mindate.AddDays(-x).ToString("dddd"), mindate.AddDays(-x), mindate.AddDays(-x).DayOfWeek);
                    }

                }

            }

            DS.AcceptChanges();
            dt = DS.Tables[0];

            foreach (DataRow dr in dt.Rows)
            {
                string day = dr["Day"].ToString().Trim().ToLower();
                switch (day)
                {
                    case "monday":
                        double[] mon = new double[1];
                        double[] monstress = new double[1];
                        double[] outlook = new double[1];
                        double[] engagement = new double[1];
                        double[] energy = new double[1];
                        mon[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        monstress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        outlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        engagement[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        energy[0] = Convert.ToInt16(dr["Energy"].ToString());

                        if (mon[0] == -1 || monstress[0] == -1 || outlook[0] == -1 || engagement[0] == -1 || energy[0] == -1)
                        {
                            mon[0] = 0;
                            monstress[0] = 0;
                            outlook[0] = 0;
                            engagement[0] = 0;
                            energy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Monday"].Points[0].YValues = mon;
                            chart1.Series["Monday"].Points[1].YValues = monstress;
                            chart1.Series["Monday"].Points[2].YValues = outlook;
                            chart1.Series["Monday"].Points[3].YValues = engagement;
                            chart1.Series["Monday"].Points[4].YValues = energy;

                        }

                        break;
                    case "tuesday":
                        double[] tues = new double[1];
                        double[] tuestress = new double[1];
                        double[] tuesoutlook = new double[1];
                        double[] tuesengament = new double[1];
                        double[] tuesenergy = new double[1];

                        tues[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        tuestress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        tuesoutlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        tuesengament[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        tuesenergy[0] = Convert.ToInt16(dr["Energy"].ToString());
                        if (tues[0] == -1 || tuestress[0] == -1 || tuesoutlook[0] == -1 || tuesengament[0] == -1 || tuesenergy[0] == -1)
                        {
                            tues[0] = 0;
                            tuestress[0] = 0;
                            tuesoutlook[0] = 0;
                            tuesengament[0] = 0;
                            tuesenergy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Tuesday"].Points[0].YValues = tues;
                            chart1.Series["Tuesday"].Points[1].YValues = tuestress;
                            chart1.Series["Tuesday"].Points[2].YValues = tuesoutlook;
                            chart1.Series["Tuesday"].Points[3].YValues = tuesengament;
                            chart1.Series["Tuesday"].Points[4].YValues = tuesenergy;

                        }
                        break;
                    case "wednesday":
                        double[] wed = new double[1];
                        double[] wedstress = new double[1];
                        double[] wedoutlook = new double[1];
                        double[] wedengage = new double[1];
                        double[] wedenergy = new double[1];
                        wed[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        wedstress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        wedoutlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        wedengage[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        wedenergy[0] = Convert.ToInt16(dr["Energy"].ToString());

                        if (wed[0] == -1 || wedstress[0] == -1 || wedoutlook[0] == -1 || wedengage[0] == -1 || wedenergy[0] == -1)
                        {
                            wed[0] = 0;
                            wedstress[0] = 0;
                            wedoutlook[0] = 0;
                            wedengage[0] = 0;
                            wedenergy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Wednesday"].Points[0].YValues = wed;
                            chart1.Series["Wednesday"].Points[1].YValues = wedstress;
                            chart1.Series["Wednesday"].Points[2].YValues = wedoutlook;
                            chart1.Series["Wednesday"].Points[3].YValues = wedengage;
                            chart1.Series["Wednesday"].Points[4].YValues = wedenergy;
                        }
                        break;
                    case "thursday":
                        double[] turs = new double[1];
                        double[] turstress = new double[1];
                        double[] tursoutlook = new double[1];
                        double[] tursengage = new double[1];
                        double[] tursenergy = new double[1];

                        turs[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        turstress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        tursoutlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        tursengage[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        tursenergy[0] = Convert.ToInt16(dr["Energy"].ToString());
                        if (turs[0] == -1 || turstress[0] == -1 || tursoutlook[0] == -1 || tursengage[0] == -1 || tursenergy[0] == -1)
                        {
                            turs[0] = 0;
                            turstress[0] = 0;
                            tursoutlook[0] = 0;
                            tursengage[0] = 0;
                            tursenergy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Thursday"].Points[0].YValues = turs;
                            chart1.Series["Thursday"].Points[1].YValues = turstress;
                            chart1.Series["Thursday"].Points[2].YValues = tursoutlook;
                            chart1.Series["Thursday"].Points[3].YValues = tursengage;
                            chart1.Series["Thursday"].Points[4].YValues = tursenergy;
                        }
                        break;
                    case "friday":
                        double[] xpoint = new double[1];
                        double[] xpointstress = new double[1];
                        double[] xpointoutlook = new double[1];
                        double[] xpointengage = new double[1];
                        double[] xpointenergy = new double[1];

                        xpoint[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        xpointstress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        xpointoutlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        xpointengage[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        xpointenergy[0] = Convert.ToInt16(dr["Energy"].ToString());
                        if (xpoint[0] == -1 || xpointstress[0] == -1 || xpointoutlook[0] == -1 || xpointengage[0] == -1 || xpointenergy[0] == -1)
                        {
                            xpoint[0] = 0;
                            xpointstress[0] = 0;
                            xpointoutlook[0] = 0;
                            xpointengage[0] = 0;
                            xpointenergy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Friday"].Points[0].YValues = xpoint;
                            chart1.Series["Friday"].Points[1].YValues = xpointstress;
                            chart1.Series["Friday"].Points[2].YValues = xpointoutlook;
                            chart1.Series["Friday"].Points[3].YValues = xpointengage;
                            chart1.Series["Friday"].Points[4].YValues = xpointenergy;
                        }
                        break;
                    case "saturday":
                        double[] sat = new double[1];
                        double[] satress = new double[1];
                        double[] satoutlook = new double[1];
                        double[] satengagement = new double[1];
                        double[] satenergy = new double[1];
                        sat[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        satress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        satoutlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        satengagement[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        satenergy[0] = Convert.ToInt16(dr["Energy"].ToString());

                        if (sat[0] == -1 || satress[0] == -1 || satoutlook[0] == -1 || satengagement[0] == -1 || satenergy[0] == -1)
                        {
                            sat[0] = 0;
                            satress[0] = 0;
                            satoutlook[0] = 0;
                            satengagement[0] = 0;
                            satenergy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Saturday"].Points[0].YValues = sat;
                            chart1.Series["Saturday"].Points[1].YValues = satress;
                            chart1.Series["Saturday"].Points[2].YValues = satoutlook;
                            chart1.Series["Saturday"].Points[3].YValues = satengagement;
                            chart1.Series["Saturday"].Points[4].YValues = satenergy;
                        }
                        break;
                    case "sunday":
                        double[] sun = new double[1];
                        double[] sunstress = new double[1];
                        double[] sunoutlook = new double[1];
                        double[] sunengage = new double[1];
                        double[] sunenergy = new double[1];
                        sun[0] = Convert.ToInt16(dr["Sleep"].ToString());
                        sunstress[0] = Convert.ToInt16(dr["Stress"].ToString());
                        sunoutlook[0] = Convert.ToInt16(dr["Outlook"].ToString());
                        sunengage[0] = Convert.ToInt16(dr["Engagement"].ToString());
                        sunenergy[0] = Convert.ToInt16(dr["Energy"].ToString());
                        if (sun[0] == -1 || sunstress[0] == -1 || sunoutlook[0] == -1 || sunengage[0] == -1 || sunenergy[0] == -1)
                        {
                            sun[0] = 0;
                            sunstress[0] = 0;
                            sunoutlook[0] = 0;
                            sunengage[0] = 0;
                            sunenergy[0] = 0;
                        }
                        else
                        {

                            chart1.Series["Sunday"].Points[0].YValues = sun;
                            chart1.Series["Sunday"].Points[1].YValues = sunstress;
                            chart1.Series["Sunday"].Points[2].YValues = sunoutlook;
                            chart1.Series["Sunday"].Points[3].YValues = sunengage;
                            chart1.Series["Sunday"].Points[4].YValues = sunenergy;
                        }
                        break;
                }

            }

        }
    }