private void Bind()
{
DataTable dt = new DataTable();
dt.Columns.Add("QID", typeof(int));
dt.Columns.Add("PID", typeof(int));
dt.Columns.Add("Question");
dt.Columns.Add("Answer");
DataRow dr;
int uid = 0;
ArrayList qs = null;
using (BaseDb db = DbFactory.ConstructDatabase())
{
if (!BaseDb.IsAdmin(Page.User) && !BaseDb.IsAnonymous(Page.User))
{
uid = db.GetUid(Page.User.Identity.Name);
}
qs = db.GetQuestions(tid);
}
if (BaseDb.IsAdmin(Page.User))
{
foreach (Question q in qs)
{
if (!q.Answered)
{
dr = dt.NewRow();
dr[0] = q.Qid;
dr[1] = q.Pid;
dr[2] = q.QuestioN;
dr[3] = q.Answer;
dt.Rows.Add(dr);
}
}
}
else
{
foreach (Question q in qs)
{
if (q.Uid == uid || q.Uid == 0)
{
dr = dt.NewRow();
dr[0] = q.Qid;
dr[1] = q.Pid;
dr[2] = q.QuestioN;
dr[3] = q.Answer;
dt.Rows.Add(dr);
}
}
}
questionsGrid.DataSource = dt;
questionsGrid.DataBind();
HtmlFunctions.BeautifyDataGrid(questionsGrid);
if (dt.Rows.Count == 0)
{
Hide("ѕо этому соревнованию нет вопросов");
}
}
private void Page_Load(object sender, EventArgs e)
{
if (BaseDb.IsAnonymous(Page.User))
{
throw new NeJudgeSecurityException("User, Administrator, Judge");
}
if (!IsPostBack)
{
Page.Response.AddHeader("Refresh", "90");
ArrayList sids = new ArrayList();
int page = 0;
#region параметры
_rp = new RequirementsProcessor(this.GetType(), Context);
_rp.ProcessRequirements();
if (Page.Request.QueryString["sname"] != null)
{
problem = Page.Request.QueryString["sname"];
}
if (Page.Request.QueryString["result"] != null)
{
result = Page.Request.QueryString["result"];
}
try
{
page = int.Parse(Page.Request.QueryString["page"]);
}
catch
{
page = 0;
}
using (BaseDb db = DbFactory.ConstructDatabase())
{
if (_rp.UidDefined)
{
if (BaseDb.IsJudge(Page.User))
{
filter.UserID = _rp.UserID;
}
else
{
throw new NeJudgeSecurityException("Judge");
}
}
if (_rp.TidDefined)
{
//filter.ContestID = _rp.ContestID;
if (db.GetContest(_rp.ContestID).Future)
{
Hide("Невозможно просмотреть submissions будущего соревнования");
}
else
{
int pid = -1;
if (problem != "")
{
pid = db.GetPidByShortName(_rp.ContestID, problem);
if (pid == -1)
{
throw new NeJudgeInvalidParametersException("sname");
}
else
{
if (!Page.IsPostBack)
{
filter.ProblemID = problem[0];
}
}
}
if (result != "")
{
try
{
Result r = (Result)Enum.Parse
(typeof(Result), result);
if (!Page.IsPostBack)
{
filter.Result = r;
}
}
catch (ArgumentException)
{
throw new NeJudgeInvalidParametersException("result");
}
}
#endregion
foreach (Submission s in db.GetSubmissions(_rp.ContestID,
_rp.UidDefined ? _rp.UserID : 0,
(problem == "") ? 0 : pid, result))
{
sids.Add(s.SID);
}
if (sids.Count == 0)
{
//Hide("В этом соревновании нет ни одного submission");
}
sids.Reverse();
statusGrid.VirtualItemCount = sids.Count;
if (sids.Count - page * statusGrid.PageSize < 0)
{
page = sids.Count / statusGrid.PageSize;
}
statusGrid.CurrentPageIndex = page;
ArrayList arr = new ArrayList();
int l;
if (sids.Count - page * statusGrid.PageSize < statusGrid.PageSize)
{
l = sids.Count;
}
else
{
l = page * statusGrid.PageSize + statusGrid.PageSize;
}
for (int i = page * statusGrid.PageSize; i < l; i++)
{
arr.Add(sids[i]);
}
Bind(arr);
HtmlFunctions.BeautifyDataGrid(statusGrid);
}
}
else
{
Hide(null);
}
}
}
}
