private void btnDeletePlayer_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show(("Är du säker på att du vill ta bort spelare " + selectedPlayer.firstName + " " + selectedPlayer.lastName + "?"), "Ta bort medlem?", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
selectedPlayer = (Player)lbPlayerChart.SelectedItem;
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
string sql = "DELETE FROM player WHERE golfid = '" + selectedPlayer.golfId + "'";
conn.Open();
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayerChart.DataSource = Methods.GetPlayers();
}
else if (dr == DialogResult.No)
{
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
string chosenStatus = cbMembershipStatus.GetItemText(cbMembershipStatus.SelectedItem); //hämtar info av valt item i comboboxen
int playerStatus = 1;
if (chosenStatus.Equals("Aktiv"))
{ playerStatus = 1; }
else if (chosenStatus.Equals("Vilande"))
{ playerStatus = 2; }
else if (chosenStatus.Equals("Junior"))
{ playerStatus = 3; }
else if (chosenStatus.Equals("Greenfee"))
{ playerStatus = 4; }
else if (chosenStatus.Equals("Gäst"))
{ playerStatus = 5; }
// else if(status.Equals(null))
// { playerStatus = selectedPlayer.membershipStatus; }
//liknande kod för att registrera om spelaren betalt avgift
string payedFee = cbMembershipFee.GetItemText(cbMembershipFee.SelectedItem);
bool memberFee = true;
if (payedFee.Equals("Betald"))
{ memberFee = true; }
else
{
memberFee = false;
}
bool sex = true;
if (payedFee.Equals("Man"))
{ memberFee = true; }
else
{
memberFee = false;
}
if (txtGolfId.Text.Trim().Length != 6)
{
MessageBox.Show("Var vänlig ange de 6 första siffrorna i personnumret.");
return;
}
int num;
if (!int.TryParse(txtHandicap.Text, out num) || int.Parse(txtHandicap.Text) >= 37)
{
MessageBox.Show("Du kan endast fylla i att medlemmar har mellan 1-36 i handicap");
}
else
{
//Skapa GolfID
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
selectedPlayer = (Player)lbPlayerChart.SelectedItem;
string stringGolfId = txtGolfId.Text + "001"; //Här har du golfID + 001
int golfId = Convert.ToInt32(stringGolfId); //här får du ut det som int = 851217001
conn.Open();
string query = "SELECT max(golfid) FROM player WHERE golfid >= " + txtGolfId.Text + "001" + "AND golfid <= " + txtGolfId.Text + "999";
NpgsqlCommand command1 = new NpgsqlCommand(query, conn);
object objHighestGolfId = command1.ExecuteScalar(); //Tar ut högsta värdet i [valtpersonummer] + [xxx]
if (!string.IsNullOrEmpty("" + objHighestGolfId)) //Om värdet inte är null, utför detta:
{
int highestGolfId = Convert.ToInt32(objHighestGolfId); //gör om object till typ int 851212003
while (golfId <= highestGolfId) //medan [personummer] + [xxx] är under valt värde:
{
golfId++; //lägg till ett nummer till på slutet
}
}
try
{
NpgsqlCommand command2 = new NpgsqlCommand("INSERT INTO player (golfid, playerstatus_id, firstname, lastname, address, streetnumber, zipcode, mobile, email, membershipfee, handicap, sex) VALUES (" + golfId + " , " + playerStatus + " , '" + txtFirstName.Text + "' , '" + txtLastName.Text + "' , '" + txtAddress.Text + "' , '" + txtStreetNumber.Text + "' , " + Convert.ToInt32(txtZipCode.Text) + " , '" + txtMobile.Text + "' , '" + txtEmail.Text + "' , '" + memberFee + "' ," + Convert.ToDouble(txtHandicap.Text) + " , " + sex + " )", conn);
int antal2 = command2.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Vänligen fyll i samtliga fält korrekt");
// MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayerChart.DataSource = Methods.GetPlayers();
// lbMainPagePlayers.DataSource = Methods.GetPlayers();
// label1.Text = ((Form1)frm1).textBox1.Text;
//Här bör även kod för att uppdatera mainsidan läggas in
// MainPage.lbMainPagePlayers.DataSource = l
}
}
private void btnAddPlayerToCouple_Click(object sender, EventArgs e)
{
selectedPlayer = (Player)lbPlayers2.SelectedItem;
selectedCouple = (Couple)lbCoupleChart.SelectedItem;
for (int x = 0; x < lbPlayerInCouple.Items.Count; x++) //ser till så att inte fler än 4 kan vara med i samma grupp
{
lbPlayerInCouple.SetSelected(x, true);
}
if (lbPlayerInCouple.Items.Count >= 2)
{
MessageBox.Show("Du kan inte lägga till fler spelare");
}
else
{
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
conn.Open();
NpgsqlCommand command = new NpgsqlCommand("UPDATE player SET couple_id = " + selectedCouple.coupleId + " WHERE golfid = (" + selectedPlayer.golfId + " )", conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayerInCouple.DataSource = Methods.GetPlayerInCouple(selectedCouple.coupleId);
lbPlayers2.DataSource = Methods.GetAvailablePlayersToCouple();
lbPlayers.DataSource = Methods.GetAvailablePlayers();
}
}
private void lbPlayerChart_SelectedIndexChanged(object sender, EventArgs e)
{
selectedPlayer = (Player)lbPlayerChart.SelectedItem;
if (selectedPlayer == null)
{
txtFirstName.Clear();
txtLastName.Clear();
txtGolfId.Clear();
txtMobile.Clear();
txtStreetNumber.Clear();
txtZipCode.Clear();
txtEmail.Clear();
txtAddress.Clear();
txtHandicap.Clear();
}
else
{
txtFirstName.Text = selectedPlayer.firstName;
txtLastName.Text = selectedPlayer.lastName;
txtGolfId.Text = selectedPlayer.golfId.ToString().Substring(0,6);
txtGolfIdEnding.Text = selectedPlayer.golfId.ToString().Substring(6,3);
txtMobile.Text = selectedPlayer.mobilePhone;
txtStreetNumber.Text = selectedPlayer.streetNumber;
txtZipCode.Text = selectedPlayer.zipCode.ToString();
txtEmail.Text = selectedPlayer.eMail;
txtAddress.Text = selectedPlayer.address;
txtHandicap.Text = selectedPlayer.handicap.ToString();
//Kön
if (Convert.ToString(selectedPlayer.sex) == "True")
{
cbSex.Text = "Man";
}
else
{
cbSex.Text = "Kvinna";
}
//Medlemasavgift
if (Convert.ToString(selectedPlayer.membershipFee) == "True")
{
cbMembershipFee.Text = "Betald";
}
else
{
cbMembershipFee.Text = "Ej betald";
}
//Medlemstatus
if (Convert.ToString(selectedPlayer.membershipStatus) == "1")
{
cbMembershipStatus.Text = "Aktiv";
}
else if (Convert.ToString(selectedPlayer.membershipStatus) == "2")
{
cbMembershipStatus.Text = "Vilande";
}
else if (Convert.ToString(selectedPlayer.membershipStatus) == "3")
{
cbMembershipStatus.Text = "Junior";
}
else if (Convert.ToString(selectedPlayer.membershipStatus) == "4")
{
cbMembershipStatus.Text = "Greenfee";
}
else if (Convert.ToString(selectedPlayer.membershipStatus) == "5")
{
cbMembershipStatus.Text = "Gäst";
}
}
}
private void btnDropPlayerFromComp_Click(object sender, EventArgs e)
{
selectedPlayer = (Player)lbPlayersInCompetition.SelectedItem;
selectedCompetition = (Competition)lbCompetitionChart.SelectedItem;
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
string sql = "DELETE FROM player_competition WHERE competition_id = " + selectedCompetition.Id + " AND player_id = " + selectedPlayer.golfId + "";
conn.Open();
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
MessageBox.Show("Du har nu avbokat spelaren från tävlingen.");
lbPlayersInCompetition.DataSource = Methods.GetPlayersInCompetition(selectedCompetition.Id);
conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
selectedCompetition = (Competition)lbCompetitionChart.SelectedItem;
selectedPlayer = (Player)lbSinglePlayers.SelectedItem;
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
conn.Open();
NpgsqlCommand command = new NpgsqlCommand("INSERT INTO player_competition (competition_id, player_id) VALUES (" + selectedCompetition.Id + "," + selectedPlayer.golfId + ")", conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayersInCompetition.DataSource = Methods.GetPlayersInCompetition(selectedCompetition.Id);
}
//Denna kod låg här tidigare, den fungerar och därför kommenterar jag endast bort den istället för att radera
/* selectedPlayer = (Player)lbPlayers.SelectedItem;
selectedTeam = (Team)lbTeamChart.SelectedItem;
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
conn.Open();
NpgsqlCommand command = new NpgsqlCommand("UPDATE player SET team_id = " + selectedTeam.teamId + " WHERE golfid = (" + selectedPlayer.golfId + " )", conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayerInTeam.DataSource = Methods.GetPlayerInTeam(selectedTeam.teamId);
lbPlayers.DataSource = Methods.GetAvailablePlayers();
}*/
private void btnDeletePlayerFromTeam_Click(object sender, EventArgs e)
{
selectedPlayer = (Player)lbPlayerInTeam.SelectedItem;
selectedTeam = (Team)lbTeamChart.SelectedItem;
DialogResult dropPlayerFromTeam = MessageBox.Show("Vill du verkligen ta bort den markerade spelaren från laget?", "Ta bort spelare", MessageBoxButtons.OKCancel);
if (dropPlayerFromTeam == DialogResult.OK)
{
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
string sql = "UPDATE player SET team_id = null WHERE team_id = " + selectedTeam.teamId + " AND golfid = " + selectedPlayer.golfId + "";
conn.Open();
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayerInTeam.DataSource = Methods.GetPlayerInTeam(selectedTeam.teamId);
lbPlayers.DataSource = Methods.GetAvailablePlayers();
MessageBox.Show("Spelaren är nu borttagen från laget.");
}
else if (dropPlayerFromTeam == DialogResult.Cancel)
{ }
}
private void btnDeletePlayerFromCouple_Click(object sender, EventArgs e)
{
selectedPlayer = (Player)lbPlayerInCouple.SelectedItem;
selectedCouple = (Couple)lbCoupleChart.SelectedItem;
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
string sql = "UPDATE player SET couple_id = null WHERE couple_id = " + selectedCouple.coupleId + " AND golfid = " + selectedPlayer.golfId + "";
conn.Open();
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbPlayerInCouple.DataSource = Methods.GetPlayerInCouple(selectedCouple.coupleId);
lbPlayers2.DataSource = Methods.GetAvailablePlayersToCouple();
}
private void btnAddResult_Click(object sender, EventArgs e)
{
int result = Convert.ToInt32(txtAddResult.Text);
selectedPlayer = (Player)lbGolfPlayers.SelectedItem;
selectedCompetition = (Competition)lbPassedCompetitionChart.SelectedItem;
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
string sql = "UPDATE player_competition SET result = " + result + " WHERE player_id = " + selectedPlayer.golfId + " AND competition_id = " + selectedCompetition.Id + "";
conn.Open();
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
txtAddResult.Clear();
}
}
private void txtDropPlayer_Click(object sender, EventArgs e)
{
selectedPlayer = (Player)lbBookedPlayers.SelectedItem;
DateTime pickedDate = monthCalendar1.SelectionStart;
string pickedTime = lbTimes.SelectedItem.ToString();
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
string sql = "UPDATE golfround SET player = null WHERE date = '" + pickedDate + "' AND startingtime = '" + pickedTime + "' AND player = " + selectedPlayer.golfId + "";
conn.Open();
NpgsqlCommand command = new NpgsqlCommand(sql, conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
lbBookedPlayers.DataSource = Methods.GetBookedPlayers(pickedDate, pickedTime);
lbMainPagePlayers.DataSource = Methods.GetUnbookedPlayers(pickedDate, pickedTime);
}
private void txtBooking_Click(object sender, EventArgs e)
{
DateTime pickedDate = monthCalendar1.SelectionStart; //vald i kalender
string convPickedDate = pickedDate.ToShortDateString(); //konvert till endast datum
string chosenDate = getCompetitionDate(); //hämtar tävlingsdatum
string pickedTime = lbTimes.SelectedItem.ToString(); //hämtar klockslag
string maintenanceStartTime = getMaintenanceStartTime(); //hämtar starttid för banunderhåll
string maintenanceEndTime = getMaintenanceEndTime();
DateTime startDateAndTime = Convert.ToDateTime(convPickedDate + " " + maintenanceStartTime); //datum och starttid för banunderhåll
DateTime endDateAndTime = Convert.ToDateTime(convPickedDate + " " + maintenanceEndTime); //datum och sluttid för banunderhåll
DateTime playerPickedDateAndTime = Convert.ToDateTime(convPickedDate + " " + pickedTime); //Datum och tid som spelare vill boka in golfrunda på
if (playerPickedDateAndTime > startDateAndTime && playerPickedDateAndTime < endDateAndTime)
{
MessageBox.Show("Ett underhåll av banan kommer att ske på vald tid och det går inte att boka en golfrunda förrän klockan" + " " + maintenanceEndTime);
return;
}
else
{ }
if (convPickedDate == chosenDate)
{
MessageBox.Show("En tävling finns bokad på valt datum. Det går inte att boka en golfrunda på detta datum");
return;
}
for (int x = 0; x < lbBookedPlayers.Items.Count; x++) //ser till så att inte fler än 4 kan vara med i samma grupp
{
lbBookedPlayers.SetSelected(x, true);
}
if (lbBookedPlayers.Items.Count >= 4)
{
MessageBox.Show("Du kan inte lägga till fler spelare");
}
selectedPlayer = (Player)lbMainPagePlayers.SelectedItem;
double teamTotalHp = getTotalHandicap();
double playerHp = selectedPlayer.handicap;
if (teamTotalHp + playerHp > 100)
{
MessageBox.Show("Om du lägger till denna spelare kommer det totala handikapsvärdet överstiga 100.\nDu kan ej lägga till fler spelare");
}
else
{
NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true");
try
{
conn.Open();
NpgsqlCommand command = new NpgsqlCommand("INSERT INTO golfround (date, startingtime, player) VALUES ('" + pickedDate + "' , '" + pickedTime + "', '" + selectedPlayer.golfId + "')", conn);
int antal = command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
// lbBookedPlayers.ClearSelected();
lbBookedPlayers.DataSource = Methods.GetBookedPlayers(pickedDate, pickedTime);
lbMainPagePlayers.DataSource = Methods.GetUnbookedPlayers(pickedDate, pickedTime);
MessageBox.Show("En bokningsbekräftelse har skickats till spelaren.");
}
}
