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); }
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); }
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); }