protected void Button_test3_Click(object sender, EventArgs e)
        {
            //remake 9year or whatever
            string YearGroup = TextBox_YearGroup.Text;
            string GroupName = YearGroup + "Year";

            int year = DateTime.Now.Year; int month = DateTime.Now.Month;

            if (month > 8)
            {
                year++;           //so
            }
            DateTime EndDate   = new DateTime(year, 7, 31);
            DateTime StartDate = new DateTime(year - 1, 9, 4);

            GroupList gl1 = new GroupList();
            Utility   u   = new Utility();
            Group     g2  = new Group(); g2.Load(GroupName, DateTime.Now);

            if (!g2._valid)
            {
                g2._GroupCode = GroupName; g2._StartDate = StartDate; g2._EndDate = EndDate; g2._GroupName = GroupName;
                g2._CourseID  = new Guid("f0e6828f-c6e1-4105-988c-83e350a39cc4"); g2._GroupRegistrationType = 3; g2._GroupRegistrationYear = System.Convert.ToInt32(YearGroup);
                g2._GroupPrimaryAdministrative = false; g2._GroupManagedBy = Guid.Empty;
                g2.Save();
            }
            gl1.LoadList(DateTime.Now, GroupList.GroupListOrder.GroupName);
            foreach (Group g in gl1._groups)
            {
                if (g._GroupCode.ToUpper().Trim() == GroupName.ToUpper())
                {
                    //going to delete all gm here
                    StudentGroupMembershipList sgml0 = new StudentGroupMembershipList();
                    sgml0.LoadList_Group(g._GroupID, DateTime.Now);
                    foreach (StudentGroupMembership sg in sgml0.m_list)
                    {
                        sg.Delete();
                    }

                    foreach (Group g1 in gl1._groups)
                    {
                        if (g1._GroupCode.Contains("RG") && (g1._GroupCode.StartsWith(YearGroup)))
                        {
                            StudentGroupMembershipList sgml1 = new StudentGroupMembershipList();
                            sgml1.LoadList_Group(g1._GroupID, DateTime.Now);
                            foreach (StudentGroupMembership sg in sgml1.m_list)
                            {
                                StudentGroupMembership sm1 = new StudentGroupMembership();
                                sm1.m_Groupid   = g._GroupID;
                                sm1.m_Studentid = sg.m_Studentid;
                                sm1.m_ValidFrom = StartDate;
                                sm1.m_ValidTo   = EndDate;
                                sm1.Save();
                            }
                        }
                    }
                    break;
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                VAResultsList va1 = new VAResultsList();
                va1.LoadCourse(new Guid("cf07a783-1a83-49cd-af92-4623c88c15eb"));

                //va1.LoadGroup(new Guid("cf07a783-1a83-49cd-af92-4623c88c15eb"), new Guid("1904046f-4532-4a82-9091-1ce43c2c6489"));
                CourseList cl1 = new CourseList(0);
                GroupList  gl1 = new GroupList(); gl1.LoadList(new DateTime(2018, 4, 1), GroupList.GroupListOrder.GroupName);
                Chart8.Titles.Add("A-level VA from Alis model");
                Chart8.Titles[0].Font = new Font("Verdana", 16, System.Drawing.FontStyle.Bold);
                Chart8.ChartAreas["ChartArea1"].AxisX.Interval = 1;
                LabelStyle ls1 = new LabelStyle();
                ls1.Font = new Font("Verdana", 16, System.Drawing.FontStyle.Bold); ls1.Angle = 90;
                Chart8.ChartAreas["ChartArea1"].AxisX.LabelAutoFitStyle = LabelAutoFitStyles.None;
                // Chart8.ChartAreas["ChartArea1"].AxisX.TextOrientation = TextOrientation.Rotated90;
                ls1.ForeColor = Color.Red;
                Chart8.ChartAreas["ChartArea1"].AxisX.LabelStyle = ls1;

                Series s1 = new Series("test");
                s1.XValueType = ChartValueType.String;
                s1.ChartType  = System.Web.UI.DataVisualization.Charting.SeriesChartType.Column;
                s1.YValueType = new ChartValueType();
                s1.YValueType = System.Web.UI.DataVisualization.Charting.ChartValueType.Int32;
                Chart8.Series.Add(s1);
                Chart8.Series["test"]["PixelPointWidth"] = "40";
                Chart8.Series["test"].IsXValueIndexed    = true;

                Chart8.Series["test"].Font = new Font("Arial", 12, System.Drawing.FontStyle.Bold);
                int i = 0;
                foreach (ValueAddedResult r in va1.m_list)
                {
                    if (r.DateOutpuResult.Year == 2018)
                    {
                        string s = "X";
                        //find course
                        foreach (Course c in cl1._courses)
                        {
                            if (c._CourseID == r.CourseId)
                            {
                                s = c.CourseName; break;
                            }
                        }

                        //fid Group
                        //foreach(Group g in gl1._groups)
                        //{
                        //    if (g._GroupID == r.GroupId) { s = g._GroupName; break; }

                        //  }
                        DataPoint d = new DataPoint();

                        d.AxisLabel = s;
                        d.SetValueY(r.OutputResultValue - r.VAResultValue);
                        d.Label = "#VALY";
                        s1.Points.Add(d);
                    }
                    i++;
                }


                // s1.MarkerSize = 30;
                // s1.MarkerStyle = System.Web.UI.DataVisualization.Charting.MarkerStyle.Cross;
                // s1.BorderWidth = 5;
            }
        }