private void cbClub_SelectedIndexChanged(object sender, EventArgs e) { if (cbClubGroup.SelectedIndex >= 0) { cbMember.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { if (currentCompetition.GetType() == typeof(GroupCompetition)) { var group = context.Participants.Include("member").OfType <Group>().First(x => x.Id == ((Group)(cbClubGroup.SelectedItem)).Id); foreach (Member m in group.Member.OrderBy(x => x.Name)) { cbMember.Items.Add(m); } } else { foreach (Member m in context.Participants.OfType <Member>().Where(x => x.Club.Id == ((Club)(cbClubGroup.SelectedItem)).Id).OrderBy(x => x.Name)) { cbMember.Items.Add(m); } } } } }
private void btnEndCompetition_Click(object sender, EventArgs e) { if (MessageBox.Show("Willst du das Pokalschießen wirklich beenden? Ein weiteres fortführen ist nicht möglich.", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { bool allWinnersSet = true; foreach (Price p in currentCompetition.Prices) { frmDetermineWinner frmwinner = new frmDetermineWinner(p); frmwinner.ShowDialog(); Price price = context.Prices.Find(p.Id); allWinnersSet = allWinnersSet & (price.Winner != null); } foreach (Award a in currentCompetition.Awards) { frmChooseWinner frmWinner = new frmChooseWinner(a); frmWinner.ShowDialog(); Award award = context.Awards.Find(a.Id); allWinnersSet = allWinnersSet & (award.Winner != null); } if (allWinnersSet) { Competition comp = context.Competitions.Find(currentCompetition.Id); comp.Finished = true; context.SaveChanges(); currentCompetition = null; reload_Controls(); } } } }
private void btnStart_Click(object sender, EventArgs e) { if (cbMember.SelectedIndex >= 0 && cbClubGroup.SelectedIndex >= 0) { gbRead.Enabled = true; btnRead.Enabled = true; lblClub.Text = cbClubGroup.SelectedItem.ToString(); lblMember.Text = cbMember.SelectedItem.ToString(); cbPrice.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { foreach (var price in currentCompetition.Prices) { bool hasShotYet = false; var sequences = context.Prices.Include("Sequences").First(x => x.Id == price.Id).Sequences; foreach (var sequence in sequences) { if (sequence.Member.Id == ((Member)cbMember.SelectedItem).Id) { hasShotYet = true; } } if (!hasShotYet) { cbPrice.Items.Add(price); } } } if (cbPrice.Items.Count > 0) { cbPrice.SelectedIndex = 0; } } }
private void ProfileWizardNew_Load(object sender, EventArgs e) { try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbProfile.Items.Clear(); cbProfile.Items.AddRange(context.Profiles.ToArray()); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Laden der Profile\r\n{0}", ex.Message)); } cbSch.Items.AddRange(SCH_Values.ToArray()); cbSch.SelectedIndex = 0; cbRia.Items.AddRange(RIA_Values.ToArray()); cbRia.SelectedIndex = 0; cbKal.Items.AddRange(KAL_Values.ToArray()); cbKal.SelectedIndex = 0; cbRib.Items.AddRange(RIB_Values.ToArray()); cbRib.SelectedIndex = 0; cbTea.Items.AddRange(TEA_Values.ToArray()); cbTea.SelectedIndex = 0; }
private void btnSave_Click(object sender, EventArgs e) { try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { if (this.profile == null) { this.profile = new Profile(); this.profile.Name = txtProfileName.Text; this.profile.Value = getProfileString(); context.Profiles.Add(this.profile); } else { this.profile = context.Profiles.Find(this.profile.Id); this.profile.Value = getProfileString(); } context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Speichern des Profiles\r\n{0}", ex.Message)); } }
private void btnOk_Click(object sender, EventArgs e) { if (dvMember.Rows.Count == 0) { MessageBox.Show("Bitte Mitglieder zu der Gruppe hinzufügen!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { if (myGroup == null) { myGroup = new Group(); } myGroup.Name = txtGroupName.Text; myGroup.GroupCompetition = (GroupCompetition)currentCompetition; context.Participants.Add(myGroup); context.SaveChanges(); foreach (DataGridViewRow row in dvMember.Rows) { var member = context.Participants.OfType <Member>().Where(x => x.Id == (int)row.Tag).First(); myGroup.Member.Add(member); } context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Speichern der Gruppe\r\n{0}", ex.Message)); } this.Close(); }
private void AddGroupWizardNew_Load(object sender, EventArgs e) { reloadControls(); if (myGroup != null) { txtGroupName.Text = myGroup.Name; try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { foreach (Member member in myGroup.Member) { DataGridViewRow row = new DataGridViewRow(); row.Cells.Add(new DataGridViewTextBoxCell() { Value = member.ToString() }); row.Cells.Add(new DataGridViewTextBoxCell() { Value = member.Club.ToString() }); row.Tag = member.Id; dvMember.Rows.Add(row); } } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Laden der Gruppe\r\n{0}", ex.Message)); } } }
private void TabTraining_Load(object sender, EventArgs e) { reload_Controls(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { var sequences = context.Sequences.Include("Shots").Include("Profile").Include("Member"); foreach (var sequence in sequences) { if (sequence.Date.Date != DateTime.Today) { continue; } DataGridViewRow row = new DataGridViewRow(); row.Tag = sequence.Id; row.Cells.Add(new DataGridViewTextBoxCell() { Value = sequence.Member.ToString() }); row.Cells.Add(new DataGridViewTextBoxCell() { Value = sequence.Shots.Sum(s => s.Value) }); row.Cells.Add(new DataGridViewTextBoxCell() { Value = sequence.Profile.ToString() }); DataGridViewButtonCell button = new DataGridViewButtonCell() { UseColumnTextForButtonValue = true }; row.Cells.Add(button); dvResults.Rows.Add(row); } } }
private void btnOk_Click(object sender, EventArgs e) { if (txtClubName.TextLength <= 0) { MessageBox.Show("Bitte einen Namen eingeben!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { Club newClub = new Club(); newClub.Name = txtClubName.Text; context.Clubs.Add(newClub); context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Speichern des Mitglieds\r\n{0}", ex.Message)); } finally { this.Close(); } }
public void SetDisplaySetting(DisplaySetting setting) { this.DisplaySetting = setting; if (setting != DisplaySetting.Everything) { lbCurrentResult.Text = ""; rtResults.Text = ""; lbResults.Text = ""; dgResultList.Rows.Clear(); } dgResultList.Rows.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { foreach (Sequence result in sequenceList) { Sequence seq = context.Sequences.Find(result.Id); switch (DisplaySetting) { case DisplaySetting.Everything: dgResultList.Rows.Add(seq.Member.ToString(), seq.Shots.Sum(x => x.Value).ToString(), seq.Profile); break; case DisplaySetting.EverythingAnonym: dgResultList.Rows.Add(SVP.Properties.Settings.Default.DefaultName, seq.Shots.Sum(x => x.Value).ToString(), seq.Profile); break; } } } }
private void btnRead_Click(object sender, EventArgs e) { if (cbMember.SelectedIndex < 0) { return; } using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { Task <List <RMResult> > ta = Task.Factory.StartNew <List <RMResult> >(() => Common.readShots(profile.Value)); while (!ta.IsCompleted) { Application.DoEvents(); } if (ta.Result == null) { pBar.Visible = false; btnRead.Enabled = true; return; } Sequence sequence = new Sequence(); sequence.Date = DateTime.Now; sequence.Member = ((Member)cbMember.SelectedItem); sequence.Profile = this.profile; foreach (RMResult s in ta.Result) { Shot shot = new Shot(); shot.Angle = s.Angle; shot.FactorValue = s.FactorValue; shot.ShotNumber = (short)s.ShotNumber; shot.Valid = s.Validity == ValidFlag.Valid; shot.Value = s.Rings; sequence.Shots.Add(shot); } DataGridViewRow row = new DataGridViewRow(); row.Tag = sequence.Id; row.Cells.Add(new DataGridViewTextBoxCell() { Value = sequence.Member }); row.Cells.Add(new DataGridViewTextBoxCell() { Value = sequence.Shots.Sum(x => x.Value) }); dvResults.Rows.Add(row); context.Participants.Attach(sequence.Member); context.Profiles.Attach(sequence.Profile); foreach (Sequence s in sequences) { Sequence seq = context.Sequences.Find(s.Id); if (seq.Member.Id == sequence.Member.Id) { seq.NextSequence = sequence; } } context.SaveChanges(); } reloadMembers(); }
private void btnDisplayShot_Click(object sender, EventArgs e) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { var sequence = context.Sequences.Where(x => x.Id == ((Sequence)((Button)sender).Tag).Id).FirstOrDefault(); Monitor.GetMonitor().AddSequence(sequence); } }
private void frmChooseWinner_Load(object sender, EventArgs e) { lblName.Text = award.Name; using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbClub.Items.AddRange(context.Clubs.OrderBy(x => x.Name).ToArray()); } }
private void reloadContorls() { cbClub.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbClub.Items.AddRange(context.Clubs.ToArray()); } }
private void reloadContorls() { cbCompetitions.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbCompetitions.Items.AddRange(context.Competitions.Where(x => x.Finished == true).ToArray()); } }
private void btnOk_Click(object sender, EventArgs e) { if (txtMemberFirstname.TextLength <= 0) { MessageBox.Show("Bitte einen Vornamen eingeben!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtMemberName.TextLength <= 0) { MessageBox.Show("Bitte einen Nachnamen eingeben!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtMemberShortName.TextLength <= 0) { MessageBox.Show("Bitte einen Kruznamen eingeben!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cbMemberClub.SelectedIndex < 0) { MessageBox.Show("Bitte einen Verein auswählen!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { if (this.member == null) { this.member = new Member(); this.member.Firstname = txtMemberFirstname.Text; this.member.Name = txtMemberName.Text; this.member.Birthday = dtMemberBirthday.Value; this.member.Shortname = txtMemberShortName.Text; var club = context.Clubs.FirstOrDefault(x => x.Id == ((Club)cbMemberClub.SelectedItem).Id); club.Members.Add(this.member); } else { this.member = context.Participants.OfType <Member>().First(x => x.Id == this.member.Id); this.member.Firstname = txtMemberFirstname.Text; this.member.Name = txtMemberName.Text; this.member.Birthday = dtMemberBirthday.Value; this.member.Shortname = txtMemberShortName.Text; } context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Speichern des Mitglieds\r\n{0}", ex.Message)); } finally { this.Close(); } }
private void reloadControls() { cbProfile.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbProfile.Items.AddRange(context.Profiles.Where(x => x.Id != price.Profile.Id).ToArray()); } btnOk.Enabled = cbMember.Items.Count == 0; reloadMembers(); }
private void btnOk_Click(object sender, EventArgs e) { if (lbCompetitions.SelectedIndex >= 0) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { myCompetition = context.Competitions.Include("Prices.Sequences.Member").Include("Prices.Sequences.Shots").Include("Awards").Include("Prices.Profile").FirstOrDefault(x => x.Id == ((ComboboxItem)lbCompetitions.SelectedItem).Id); } } this.Close(); }
private void btnOk_Click(object sender, EventArgs e) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { var a = context.Awards.Find(this.award.Id); var winner = context.Participants.Find(((Member)cbMember.SelectedItem).Id); a.Winner = (Member)winner; context.SaveChanges(); } this.Close(); }
private void frmChooseCompetition_Load(object sender, EventArgs e) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { var competitions = context.Competitions.Where(x => x.Finished == false); foreach (Competition competition in competitions) { lbCompetitions.Items.Add(new ComboboxItem(competition.Name, competition.Id)); } } }
private void cbClub_SelectedIndexChanged(object sender, EventArgs e) { cbMember.Items.Clear(); cbMember.SelectedIndex = -1; int clubId = ((Club)cbClub.SelectedItem).Id; using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbMember.Items.AddRange(context.Participants.OfType <Member>().Where(x => x.Club.Id == clubId).ToArray()); } }
private void dvResults_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 3) { int sequence_id = (int)dvResults.Rows[e.RowIndex].Tag; using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { Sequence seq = context.Sequences.Include("Shots").Where(x => x.Id == sequence_id).FirstOrDefault(); Monitor.GetMonitor().DisplaySequence(seq); } } }
private void cbClub_SelectedIndexChanged(object sender, EventArgs e) { if (cbClub.SelectedIndex < 0) { return; } cbMember.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { var club = context.Clubs.Find(((Club)cbClub.SelectedItem).Id); cbMember.Items.AddRange(club.Members.OrderBy(x => x.Name).ThenBy(x => x.Firstname).ToArray()); } }
private void cbClub_SelectedIndexChanged(object sender, EventArgs e) { if (cbClub.SelectedIndex >= 0) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbMember.Items.Clear(); var club = context.Clubs.Include("Members").FirstOrDefault(x => x.Id == ((Club)(cbClub.SelectedItem)).Id); foreach (Member m in club.Members.OrderBy(x => x.Name)) { cbMember.Items.Add(m); } } } }
private void AddUserWizardNew_Load(object sender, EventArgs e) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbMemberClub.Items.AddRange(context.Clubs.ToArray()); if (this.member != null) { this.member = context.Participants.OfType <Member>().Where(x => x.Id == member.Id).First(); txtMemberFirstname.Text = this.member.Firstname; txtMemberName.Text = this.member.Name; dtMemberBirthday.Value = this.member.Birthday.Value; txtMemberShortName.Text = this.member.Shortname; cbMemberClub.SelectedIndex = cbMemberClub.FindStringExact(member.Club.ToString()); } } }
private void reload_Controls() { cbClub.Items.Clear(); cbProfile.Items.Clear(); using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbClub.Items.AddRange(context.Clubs.OrderBy(x => x.Name).ToArray()); if (!cbClub.Text.Equals("")) { cbClub.SelectedIndex = cbClub.FindStringExact(cbClub.Text); } foreach (var p in context.Profiles.OrderBy(x => x.Name)) { cbProfile.Items.Add(new ComboboxItem(p.Name, p.Id)); } } }
private void cbClub_SelectedIndexChanged(object sender, EventArgs e) { if (cbClub.SelectedIndex >= 0) { try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbMember.Items.Clear(); cbMember.Items.AddRange(context.Participants.Include("club").OfType <Member>().Where(x => x.Club.Id == ((Club)(cbClub.SelectedItem)).Id).ToArray()); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Laden der Mitglieder\r\n{0}", ex.Message)); } } }
void reloadMembers() { cbMember.Items.Clear(); cbMember.SelectedIndex = -1; cbMember.Text = null; using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { foreach (Sequence s in sequences) { Sequence seq = context.Sequences.Find(s.Id); if (seq.NextSequence == null) { var sequence = context.Sequences.Find(s.Id); cbMember.Items.Add(sequence.Member); } } } btnOk.Enabled = cbMember.Items.Count == 0; }
private void btnCreateCompetition_Click(object sender, EventArgs e) { AddCompetitionWizard wizard = new AddCompetitionWizard(); if (wizard.ShowDialog() == DialogResult.OK && wizard.Competition != null) { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { foreach (var price in wizard.Competition.Prices) { context.Profiles.Attach(price.Profile); } wizard.Competition.Date = DateTime.Now; context.Competitions.Add(wizard.Competition); context.SaveChanges(); currentCompetition = context.Competitions.Include("Prices.Profile").Where(x => x.Id == wizard.Competition.Id).FirstOrDefault(); } reload_Controls(); } }
private void AddCompetitionWizardNew_Load(object sender, EventArgs e) { if (myCompetition != null) { txtCompetitionName.Text = myCompetition.Name; rbGroupCompetition.Checked = myCompetition is GroupCompetition; rbGroupCompetition.Enabled = false; reloadControls(); } try { using (SVPEntitiesContainer context = new SVPEntitiesContainer()) { cbProfile.Items.AddRange(context.Profiles.ToArray()); } } catch (Exception ex) { MessageBox.Show(string.Format("Fehler beim Laden der Profile\r\n{0}", ex.Message)); } }