public string Post(String username) { return(SQLAssisants.Query_manual("score", "SELECT course_id FROM score WHERE no='" + username + "'")); }
public string GetNo(string name) { return(SQLAssisants.Query_manual("users", "SELECT username FROM users WHERE name='" + name + "'")); }
public string Post([FromForm] UserObject userObject) { return(SQLAssisants.Query("users", "username='******' And password='******' And type='" + userObject.type + "'")); }
public string Get() { return(SQLAssisants.Query("users", "")); }
public string Get(int id) { return(SQLAssisants.Query_manual("users", "SELECT name FROM users WHERE username='******'")); }
public string UpdateSource([FromForm] UserObject userObject) { return(SQLAssisants.Update("users", "password='******' , class_id='" + userObject.classid + "' , name='" + userObject.name + "'", "username='******'")); }
public string DeleteSource([FromForm] UserObject userObject) { return(SQLAssisants.Delete("users", "username=" + userObject.username)); }
public string DeleteSource([FromForm] SourceObject sourceObject) { return(SQLAssisants.Delete("score", "no=" + sourceObject.username + "AND course_id=" + sourceObject.course)); }
public string InsertSource([FromForm] UserObject userObject) { return(SQLAssisants.Insert("users", userObject.username + "," + userObject.password + ",1," + userObject.classid + "," + userObject.name)); }
public string InsertSource([FromForm] SourceObject sourceObject) { return(SQLAssisants.Insert("score", sourceObject.username + "," + sourceObject.score + "," + sourceObject.course)); }
public string PostSourceAVG(CourseObject courseObject) { return(SQLAssisants.Query_manual("score", "SELECT AVG(score) score,(SELECT course_name from course where course_id='" + courseObject.course_id + "') course_name FROM score INNER JOIN users ON (users.username = no) where course_id='" + courseObject.course_id + "' AND class_id='" + courseObject.class_id + "'")); }
public string PostSourceByClassID(CourseObject courseObject) { return(SQLAssisants.Query_manual("score", "SELECT rank() over (order by score desc) rank,name,score,(SELECT course_name from course where course_id='" + courseObject.course_id + "') course_name from score INNER JOIN users ON (users.username = no) where course_id='" + courseObject.course_id + "' AND class_id='" + courseObject.class_id + "'")); }
public string PostSourceByCourse(string course_id) { return(SQLAssisants.Query_manual("score", "SELECT users.username,users.class_id,users.name,score,(SELECT count(DISTINCT score) FROM score AS b WHERE course_id='" + course_id + "' AND a.score<b.score)+1 AS rank,(SELECT course_name FROM course WHERE course_id='" + course_id + "') AS course_name FROM score AS a INNER JOIN users ON (users.username = no) WHERE course_id='" + course_id + "'")); }
public string PostSource([FromForm] SourceObject sourceObject) { return(SQLAssisants.Query_manual("score", "SELECT no,score,(SELECT count(DISTINCT score) FROM score AS b WHERE course_id='" + sourceObject.course + "' AND a.score<b.score)+1 AS rank,(SELECT course_name FROM course WHERE course_id='" + sourceObject.course + "') AS course_name FROM score AS a WHERE course_id='" + sourceObject.course + "' AND no='" + sourceObject.username + "'")); }