private void UpdateTeamOfficial() { int si = 0; TeamOfficial temp = null; try { si = lsvTeamOfficial.SelectedItems[0].Index; temp = teamOfficialByTeam[si]; } catch { MessageBox.Show("Please select you wish to update"); return; } Team team = Team.GetTeam(listOfTeam, (int)cmbTeam.SelectedValue); using (Form f = new frmSaveTeamOfficial(team, teamOfficialByTeam, temp)) { if (DialogResult.OK == f.ShowDialog()) { MessageBox.Show("Sucessfully updated team official"); listOfTeamOfficial = TeamOfficialHelper.GetAllOfficial(tournament); GetAllTeamOfficial(); } } }
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { Image image = Image.FromFile(@"F:\Generic Basketball Score Sheet-1.png"); List <Player> listPlayer = PlayerHelper.GetPlayer(tournament); List <Player> playerByTeam = Player.PlayerByTeam(listPlayer, match.homeTeam.teamID); List <TeamOfficial> listOfficial = TeamOfficialHelper.GetAllOfficial(tournament); var official = TeamOfficial.ShowByTeam(listOfficial, match.homeTeam.teamID); //HEADER GAMESCORESHEET e.Graphics.DrawImage(image, e.PageBounds); e.Graphics.DrawString("Abella Vs Tinago", new Font("Courier New", 24, FontStyle.Bold), Brushes.Black, new Point(250, 25)); e.Graphics.DrawString(match.venue.venueName, new Font("Courier New", 11, FontStyle.Regular), Brushes.Black, new Point(700, 85)); //TEAM 1 int counter = 250; e.Graphics.DrawString(match.homeTeam.teamName, new Font("Courier New", 14, FontStyle.Bold), Brushes.Black, new Point(90, 80)); e.Graphics.DrawString(official.firstName + " " + official.lastName, new Font("Courier New", 14, FontStyle.Bold), Brushes.Black, new Point(80, 215)); foreach (var pl in playerByTeam) { e.Graphics.DrawString(pl.firstName + " " + pl.lastName, new Font("Courier New", 11, FontStyle.Bold), Brushes.Black, new Point(25, counter)); e.Graphics.DrawString(pl.jerseyNO.ToString(), new Font("Courier New", 11, FontStyle.Bold), Brushes.Black, new Point(290, counter)); counter += 20; } //TEAM 2 counter = 725; playerByTeam = Player.PlayerByTeam(listPlayer, match.guestTeam.teamID); foreach (var pl in playerByTeam) { e.Graphics.DrawString(pl.firstName + " " + pl.lastName, new Font("Courier New", 10, FontStyle.Bold), Brushes.Black, new Point(25, counter)); e.Graphics.DrawString(pl.jerseyNO.ToString(), new Font("Courier New", 11, FontStyle.Bold), Brushes.Black, new Point(290, counter)); counter += 18; } }
private void DeleteTeamOfficial() { int si = 0; TeamOfficial temp = null; try { si = lsvTeamOfficial.SelectedItems[0].Index; temp = teamOfficialByTeam[si]; } catch { MessageBox.Show("Please select you wish to delete"); return; } if (DialogResult.Yes == MessageBox.Show("Do you really wish to delete[" + temp.firstName + " " + temp.lastName + "]", "System", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)) { if (TeamOfficialHelper.DeleteTeamOfficial(temp) == 1) { MessageBox.Show("Sucessfully deleted team official"); listOfTeamOfficial = TeamOfficialHelper.GetAllOfficial(tournament); GetAllTeamOfficial(); } else { MessageBox.Show("Error Deleting team official"); } } }
private void AddTeamOfficial() { Team team = Team.GetTeam(listOfTeam, (int)cmbTeam.SelectedValue); if (teamOfficialByTeam.Count >= 3) { MessageBox.Show("There's no available slot for team official [" + team.teamName + "]"); return; } using (Form f = new frmSaveTeamOfficial(team, teamOfficialByTeam)) { if (DialogResult.OK == f.ShowDialog()) { MessageBox.Show("Sucessfully added team official"); listOfTeamOfficial = TeamOfficialHelper.GetAllOfficial(tournament); GetAllTeamOfficial(); } } }
private void SaveTeamOfficial(TeamOfficial official, int position) { TeamOfficial official1 = new TeamOfficial() { id = (official == null) ? 0 : official.id, firstName = txtFirstName1.Text, lastName = txtLastName1.Text, position = new StaffPosition() { positionID = (short)position, }, team = team }; if (TeamOfficialHelper.SaveTeamOfficial(official1) == 0) { MessageBox.Show("Error Saving Team Official"); return; } this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void btnSave_Click(object sender, EventArgs e) { TeamOfficial official1 = new TeamOfficial() { id = (official == null) ? 0 : official.id, firstName = txtFirstName1.Text, lastName = txtLastName1.Text, position = new StaffPosition() { positionID = (short)cmbPosition.SelectedValue, positionDetail = cmbPosition.SelectedItem.ToString(), }, team = team }; if (TeamOfficialHelper.SaveTeamOfficial(official1) == 0) { MessageBox.Show("Error Saving Team Official"); return; } this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void ShowByTeam() { List <TeamOfficial> listTeamOfficial = TeamOfficialHelper.GetAllOfficial(tournament); if (listTeamOfficial == null) { return; } int ci = (team == null)?0:team.teamID; var data = from st in listTeamOfficial where st.team.teamID == ci select st; teamOfficialByTeam = new List <TeamOfficial>(); foreach (var dr in data.AsEnumerable()) { TeamOfficial official = new TeamOfficial() { id = dr.id, firstName = dr.firstName, lastName = dr.lastName, position = new StaffPosition() { positionID = dr.position.positionID, positionDetail = dr.position.positionDetail, }, team = new Team() { teamID = dr.team.teamID, teamLogo = dr.team.teamName } }; teamOfficialByTeam.Add(official); } }
private void frmVIewTeamOfficial_Load(object sender, EventArgs e) { FillCombobox(); listOfTeamOfficial = TeamOfficialHelper.GetAllOfficial(tournament); GetAllTeamOfficial(); }
private void ExportTeamRooster() { var tournament = new Tournament(); int si = 0; try { si = lvwTournaments.SelectedItems[0].Index; } catch { return; } tournament = list[si]; List <Team> team = TeamHelper.GetTeam(tournament); List <Player> player = PlayerHelper.GetPlayer(tournament); List <TeamOfficial> official = TeamOfficialHelper.GetAllOfficial(tournament); ExcelPackage ExcelPkg = new ExcelPackage(); ExcelWorksheet wsSheet1 = ExcelPkg.Workbook.Worksheets.Add("Sheet1"); wsSheet1.Cells.Style.Font.Name = "Arial Narrow"; wsSheet1.Cells.Style.Font.Size = 11; //Title Of tournament wsSheet1.Cells["G" + 3].Value = "Basketball Tournament 2018"; //Date of tournament wsSheet1.Cells["G" + 4].Value = "April 15, 2018 - April 25, 2018"; wsSheet1.Cells["G9"].Value = "Official Team Rooster"; wsSheet1.Cells["G9"].Style.Font.Name = "Times New Roman"; wsSheet1.Cells["G9"].Style.Font.Size = 14; //Header of Tournament wsSheet1.Cells["A11"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; wsSheet1.Cells["A11"].Value = "NO.1"; wsSheet1.Cells["C11"].Value = "Team name"; wsSheet1.Cells["G11"].Value = "Head Coach"; wsSheet1.Cells["K11"].Value = "Jersey No."; wsSheet1.Cells["N11"].Value = "Players"; int rowIndex = 0; int colIndex = 1; int Height = 220; int Width = 120; Image img = Image.FromFile(@"C:\Users\JOSHUA\Documents\Visual Studio 2015\Projects\BATMAN\Images\seal.jpg"); ExcelPicture pic = wsSheet1.Drawings.AddPicture("Sample", img); pic.SetPosition(rowIndex, 0, colIndex, 0); //pic.SetPosition(PixelTop, PixelLeft); pic.SetSize(Height, Width); string fileName = @"C:\Users\JOSHUA\Documents\Visual Studio 2015\Projects\BATMAN\" + wsSheet1.Cells["G" + 3].Value.ToString() + ".xls"; //INITIALIZING COUNTER FOR CELL int NoCounter = 12; int numberCounter = 1; int ctr = 12; foreach (var t in team) { var playerByTeam = BATMAN.Classes.Player.PlayerByTeam(player, t.teamID); var officialByTeam = TeamOfficial.ShowByTeam(official, t.teamID); wsSheet1.Cells["C" + NoCounter].Value = t.teamName; wsSheet1.Cells["G" + NoCounter].Value = officialByTeam.firstName + " " + officialByTeam.lastName; wsSheet1.Cells["A" + NoCounter].Value = numberCounter++; wsSheet1.Cells["A" + NoCounter].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; foreach (var p in playerByTeam) { wsSheet1.Cells["K" + ctr].Value = p.jerseyNO.ToString(); wsSheet1.Cells["N" + ctr++].Value = p.firstName + " " + p.lastName; NoCounter++; } ctr++; NoCounter++; } wsSheet1.Protection.IsProtected = false; wsSheet1.Protection.AllowSelectLockedCells = false; ExcelPkg.SaveAs(new FileInfo(fileName)); FileInfo fi = new FileInfo(fileName); if (fi.Exists) { System.Diagnostics.Process.Start(fileName); } else { MessageBox.Show("Theres a problem while opening excel,Go to " + fileName + "Manual Open"); } }
private void btnSave_Click(object sender, EventArgs e) { if (txtFirstName1.Text == "" || txtFirstName2.Text == "" || txtFirstName3.Text == "" || txtLastName1.Text == "" || txtLastName2.Text == "" || txtLastName3.Text == "") { MessageBox.Show("Fill up the empty blank"); return; } if (!SaveTeam()) { return; } team = Team.GetTeamByName(tournament, txtName.Text); int id1 = 0; int id2 = 0; int id3 = 0; if (!(teamOfficialByTeam.Count <= 0)) { id1 = (teamOfficialByTeam[0] == null) ? 0 : teamOfficialByTeam[0].id; id2 = (teamOfficialByTeam[1] == null) ? 0 : teamOfficialByTeam[1].id; id3 = (teamOfficialByTeam[2] == null) ? 0 : teamOfficialByTeam[2].id; } TeamOfficial coach = new TeamOfficial() { id = id1, firstName = txtFirstName1.Text, lastName = txtLastName1.Text, position = new StaffPosition() { positionID = 1, positionDetail = "Coach", }, team = new Team() { teamID = team.teamID } }; TeamOfficial assistant_coach = new TeamOfficial() { id = id2, firstName = txtFirstName2.Text, lastName = txtLastName2.Text, position = new StaffPosition() { positionID = 2, positionDetail = "Assistant Coach" }, team = new Team() { teamID = team.teamID } }; TeamOfficial manager = new TeamOfficial() { id = id3, firstName = txtFirstName3.Text, lastName = txtLastName3.Text, position = new StaffPosition() { positionID = 3, positionDetail = "Manager" }, team = new Team() { teamID = team.teamID } }; TeamOfficialHelper.SaveTeamOfficial(coach); TeamOfficialHelper.SaveTeamOfficial(assistant_coach); TeamOfficialHelper.SaveTeamOfficial(manager); }