/* problems */
/// <summary>
/// Get all problems' AC status.
/// </summary>
/// <returns></returns>
public static List <ProblemSolved> GetsProblemSolved()
{
// list
List <ProblemSolved> ret = new List <ProblemSolved>();
string sql =
"SELECT team_id, num, NULL FROM problem_saved " +
"UNION " +
"SELECT team_id, num, sender FROM sending " +
"UNION " +
"SELECT team_id, num, sender FROM sent";
var ds = MySQLHelper.ExecuteDataSet(sql);
foreach (DataRow row in ds.Tables[0].Rows)
{
var ps = new ProblemSolved()
{
team_id = row.ItemArray[0].ToString(),
num = int.Parse(row.ItemArray[1].ToString())
};
if (!string.IsNullOrEmpty(row.ItemArray[2].ToString()))
{
ps.sender = row.ItemArray[2].ToString();
}
ret.Add(ps);
}
// return the list
return(ret);
}
public IActionResult Resolve([FromBody] ProblemSolved solution)
{
return(NoContent());
}
