public string GetNo(string name)
{
return(SQLAssisants.Query_manual("users", "SELECT username FROM users WHERE name='" + name + "'"));
}
public string Post(String username)
{
return(SQLAssisants.Query_manual("score", "SELECT course_id FROM score WHERE no='" + username + "'"));
}
public string Get(int id)
{
return(SQLAssisants.Query_manual("users", "SELECT name FROM users WHERE username='******'"));
}
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 + "'"));
}