コード例 #1
0
        public User conect([FromBody] Dictionary <string, string> con)
        {
            SystemDBservices dbs = new SystemDBservices();
            User             u   = dbs.conect(con);

            if (u is Student)
            {
                ((Student)u).updateINT();
            }
            return(u);
        }
コード例 #2
0
        private DataTable deleteIgradeSt(DataTable dt)
        {
            SystemDBservices dbs = new SystemDBservices();

            foreach (DataRow dr in dt.Rows)
            {
                string mail = dr["StudentEmail"].ToString();
                dbs.deleteSt(mail);
                dbs.deleteUser(mail);
            }

            return(dt);
        }
コード例 #3
0
        public int sysUpdates()
        {
            int grade = 10;

            while (grade >= 7)
            {
                SystemDBservices dbs1 = new SystemDBservices();
                SystemDBservices dbs2 = new SystemDBservices();
                SystemDBservices dbs3 = new SystemDBservices();
                SystemDBservices dbs4 = new SystemDBservices();
                dbs1 = dbs1.getAllClassesByGrade(grade);
                dbs4 = dbs4.getAllClassesByGrade(grade);
                dbs2 = dbs2.getAllTeamsByGrade(grade);
                dbs3 = dbs3.getAllStudentbyGrade(grade);

                if (grade == 10)
                {
                    dbs3.dt = deleteIgradeSt(dbs3.dt);
                    dbs2.dt = DeleteTeamsOrClass(dbs2.dt);
                    dbs1.dt = DeleteTeamsOrClass(dbs1.dt);

                    dbs2.update();
                    dbs1.update();
                }
                else
                {
                    createClasses(dbs1.dt, dbs1.dt);
                    DeleteTeamsOrClass(dbs4.dt);
                    raiseSt(dbs3.dt);
                    raiseTeams(dbs2.dt);
                    dbs1.update();
                    dbs3.update();
                    dbs4.update();
                    dbs2.update();
                }

                grade--;
            }

            return(1);
        }