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 + "'"));
}
