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); } } }