public AddContestForm(Contest contest = null)
{
InitializeComponent();
db = new DatabaseEntities();
_contest = contest;
FillFields();
}
protected void ShowUsers()
{
using (var db = new DatabaseEntities())
{
listBoxUsers.Items.Clear();
foreach (var item in db.Users)
{
listBoxUsers.Items.Add(item);
}
}
}
public AddUserForm(User user = null)
{
InitializeComponent();
db = new DatabaseEntities();
this._user = user;
if (this._user != null)
{
textBoxUsername.Text = this._user.Username;
richTextBoxDetails.Text = this._user.Details;
}
}
protected void ShowContests()
{
using (var db = new DatabaseEntities())
{
listBoxContests.Items.Clear();
foreach (var item in db.Contests)
{
listBoxContests.Items.Add(item);
}
}
}
protected void LoadContests()
{
using (var db = new DatabaseEntities())
{
listBoxContests.Items.Clear();
foreach (var item in db.UsersContests.Where(t => t.UserId == this._user.Id).ToList())
{
listBoxContests.Items.Add(item.Contest);
}
}
}
public SelectContestToResultForm()
{
InitializeComponent();
using (var db = new DatabaseEntities())
{
foreach (var item in db.Contests)
{
listBoxContests.Items.Add(item);
}
}
}
public AddTestForm(Task task, Test test = null)
{
InitializeComponent();
db = new DatabaseEntities();
this._task = task;
this._test = test;
this.Text = String.Format("{0} '{1}' task.", this.Text, this._task.Title);
if (this._test != null)
{
richTextBoxInputData.Text = this._test.InputData;
richTextBoxOutputData.Text = this._test.OutputData;
}
}
public AddTaskForm(Contest contest, Task task = null)
{
InitializeComponent();
db = new DatabaseEntities();
this._contest = contest;
this._task = task;
if (this._task != null)
{
textBoxTitle.Text = this._task.Title;
richTextBoxDescription.Text = this._task.Description;
textBoxMark.Text = this._task.Mark.ToString();
}
}
private void loginButton_Click(object sender, EventArgs e)
{
using (var db = new DatabaseEntities())
{
String username = textBoxUsername.Text;
String password = Utils.GetMD5Hash(textBoxPassword.Text);
String message = String.Empty;
Boolean isGood = true;
var result = db.Users.FirstOrDefault(t => t.Username == username);
if (result == null)
{
message = String.Format("There is no user with username {0}!", username);
isGood = false;
}
else
{
if (result.Password != password)
{
message = "Password is wrong!";
isGood = false;
}
}
if (!isGood)
{
MessageBox.Show(message);
return;
}
Form form = null;
switch (result.Access)
{
case 0:
form = new AdminForm();
break;
case 1:
form = new ClientForm(result);
break;
default:
break;
}
if (form != null)
{
this.Hide();
form.ShowDialog();
this.Show();
}
}
}
private void buttonAddUser_Click(object sender, EventArgs e)
{
if (listBoxUsers.SelectedItem == null)
return;
UsersContest uc = new UsersContest();
uc.UserId = ((User)listBoxUsers.SelectedItem).Id;
uc.ContestId = this._contest.Id;
using (var db = new DatabaseEntities())
{
db.UsersContests.Add(uc);
db.SaveChanges();
}
ShowUsers();
}
public void MakeTabs()
{
using (var db = new DatabaseEntities())
{
char tabName = 'A';
foreach (var item in db.Tasks.Where(t => t.ContestId == this._contest.Id))
{
TabPage tabPage = new TabPage();
MyTabPage page = new MyTabPage(user: this._user, task: item);
tabPage.Controls.Add(page);
var res = db.Results.FirstOrDefault(t=>t.TaskId == item.Id);
if (res != null)
page.labelTime.Text = (res.IsPassed == 1 ? res.PassingTime.ToString() : String.Empty);
else
page.labelTime.Text = String.Empty;
tabPage.Text = tabName.ToString() + (res != null ? (res.IsPassed==1 ? ": PASSED":String.Empty):String.Empty);
tabName++;
tabControlTasks.TabPages.Add(tabPage);
}
}
}
private void ShowResults(Contest contest)
{
using (var db = new DatabaseEntities())
{
var tasks = db.Tasks.Where(t => t.ContestId == this._contest.Id);
if (tasks == null)
{
MessageBox.Show("There are no result by this contest.");
return;
}
var Tasks = tasks.Select(t => t.Id).ToList();
var tests = db.Tests.Where(t => Tasks.Contains(t.TaskId)).Select(t=>t.Id).ToList();
var results = db.Results.Where(t => tests.Contains(t.TaskId)).ToList();
foreach (var item in results)
{
}
}
}
private void buttonRemove_Click(object sender, EventArgs e)
{
if (listBoxUsers.SelectedItem == null)
{
MessageBox.Show("You need to select contest!");
return;
}
DialogResult dialogResult = MessageBox.Show("Do you really want to delete current record?", "Deleting", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
using (var db = new DatabaseEntities())
{
User contest = (User)listBoxUsers.SelectedItem;
var item = db.Users.FirstOrDefault(t => t.Id == contest.Id);
if (item != null)
{
db.Users.Remove(item);
db.SaveChanges();
}
}
}
ShowUsers();
}
private void ShowTests()
{
using (var db = new DatabaseEntities())
{
listBoxTests.Items.Clear();
var result = db.Tests.Where(t => t.TaskId == CurrentTask.Id);
if (result != null)
foreach (var item in result.ToList())
{
listBoxTests.Items.Add(item);
}
}
}
private void ShowTasks()
{
using (var db = new DatabaseEntities())
{
listBoxTasks.Items.Clear();
foreach (var item in db.Tasks.Where(t => t.ContestId == this._contest.Id).ToList())
{
listBoxTasks.Items.Add(item);
}
}
}
private void buttonRemoveUser_Click(object sender, EventArgs e)
{
if (listBoxUsersInCompetition.SelectedItem == null)
return;
User user = (User)listBoxUsersInCompetition.SelectedItem;
using (var db = new DatabaseEntities())
{
UsersContest uc = db.UsersContests.FirstOrDefault(t => t.ContestId == this._contest.Id && t.UserId == user.Id);
if (uc != null)
{
db.UsersContests.Remove(uc);
db.SaveChanges();
}
}
ShowUsers();
}
private void ShowUsers()
{
using (var db = new DatabaseEntities())
{
listBoxUsersInCompetition.Items.Clear();
foreach (var item in db.UsersContests.Where(t=>t.ContestId == this._contest.Id).ToList())
{
listBoxUsersInCompetition.Items.Add(item.User);
}
listBoxUsers.Items.Clear();
foreach (var item in db.Users.Where(t=>t.UsersContests.Count==0).ToList())
{
listBoxUsers.Items.Add(item);
}
}
}
