public override void AddResult(SubmissionResult r, int sid) { if (r.TestNumber < 0) { r.TestNumber = 0; } r.Info = r.Info.Trim(); string update = "UPDATE Submissions SET Code=?code,Test=?test,Info=?info,[Memory Used]=?mem,[Time Worked]=?time WHERE SID=?sid"; /*r.Code.ToString(),r.TestNumber,r.Info,r.MemoryUsed, * r.TimeWorked.,sid);*/ MySqlCommand comm = new MySqlCommand(update, (MySqlConnection)conn); comm.Parameters.Add("?code", r.Code.ToString()); comm.Parameters.Add("?test", r.TestNumber); comm.Parameters.Add("?info", r.Info); comm.Parameters.Add("?mem", r.MemoryUsed); comm.Parameters.Add("?time", r.TimeWorked.ToString(CultureInfo.InvariantCulture)); comm.Parameters.Add("?sid", sid); MySqlTransaction trans = ((MySqlConnection)conn).BeginTransaction(IsolationLevel.ReadCommitted); comm.Transaction = trans; try { comm.ExecuteNonQuery(); trans.Commit(); } catch (MySqlException) { trans.Rollback(); } }
public Submission(int sid, int pid, int uid, int tid, DateTime time, Language lang, SubmissionResult r) : this(sid, pid, uid, tid, time, lang) { this.r = r; }
public abstract void AddResult(SubmissionResult s, int sid);