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