public Returns Go(Course course, List <Player> players) { PrintPlayer(players); CalculatePlayerPoints(course, players); Returns ret = new Returns(); ret.standsStrokeplayNetto = players.OrderBy(x => x.FinalScoreStrokePlaynetto).ToArray(); ret.standsStrokeplayBrutto = players.OrderBy(x => x.FinalScoreStrokePlayBrutto).ToArray(); ret.standsStablefordNetto = players.OrderByDescending(x => x.finalScoreStableFordNetto).ToArray(); ret.standsStablefordBrutto = players.OrderByDescending(x => x.finalScoreStableFordBrutto).ToArray(); return(ret); }
public Returns Go(Course course, List<Player> players) { PrintPlayer(players); CalculatePlayerPoints(course, players); Returns ret = new Returns(); ret.standsStrokeplayNetto = players.OrderBy(x => x.FinalScoreStrokePlaynetto).ToArray(); ret.standsStrokeplayBrutto = players.OrderBy(x => x.FinalScoreStrokePlayBrutto).ToArray(); ret.standsStablefordNetto = players.OrderByDescending(x => x.finalScoreStableFordNetto).ToArray(); ret.standsStablefordBrutto = players.OrderByDescending(x => x.finalScoreStableFordBrutto).ToArray(); return ret; }
private void Button_Click(object sender, EventArgs e) { string path = ""; DialogResult fileToOpenDialog = openFileDialog1.ShowDialog(); if (fileToOpenDialog == DialogResult.OK) // Test result. { path = openFileDialog1.FileName; } textBox1.Text = path; List <Player> players = new List <Player>(); string pathToExcelFile = textBox1.Text; string sheetName = "Arkusz1"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var playersInExcel = from a in excelFile.Worksheet(sheetName) select a; foreach (var a in playersInExcel) { players.Add( new Player() { name = a["Name"], handicap = Convert.ToInt32(a["handicap"]), card = new Card() { scores = new int[] { Convert.ToInt32(a["h1"]), Convert.ToInt32(a["h2"]), Convert.ToInt32(a["h3"]), Convert.ToInt32(a["h4"]), Convert.ToInt32(a["h5"]), Convert.ToInt32(a["h6"]), Convert.ToInt32(a["h7"]), Convert.ToInt32(a["h8"]), Convert.ToInt32(a["h9"]), Convert.ToInt32(a["h10"]), Convert.ToInt32(a["h11"]), Convert.ToInt32(a["h12"]), Convert.ToInt32(a["h13"]), Convert.ToInt32(a["h14"]), Convert.ToInt32(a["h15"]), Convert.ToInt32(a["h16"]), Convert.ToInt32(a["h17"]), Convert.ToInt32(a["h18"]) } } } ); } Course course = new Course(); Init(course); var prog = new Calculate(); result = prog.Go(course, players); }
private void Button_Click(object sender, EventArgs e) { string path = ""; DialogResult fileToOpenDialog = openFileDialog1.ShowDialog(); if (fileToOpenDialog == DialogResult.OK) // Test result. { path = openFileDialog1.FileName; } textBox1.Text = path; List<Player> players = new List<Player>(); string pathToExcelFile = textBox1.Text; string sheetName = "Arkusz1"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var playersInExcel = from a in excelFile.Worksheet(sheetName) select a; foreach (var a in playersInExcel) { players.Add( new Player() { name = a["Name"], handicap = Convert.ToInt32(a["handicap"]), card = new Card() { scores = new int[] { Convert.ToInt32(a["h1"]), Convert.ToInt32(a["h2"]), Convert.ToInt32(a["h3"]), Convert.ToInt32(a["h4"]), Convert.ToInt32(a["h5"]), Convert.ToInt32(a["h6"]), Convert.ToInt32(a["h7"]), Convert.ToInt32(a["h8"]), Convert.ToInt32(a["h9"]), Convert.ToInt32(a["h10"]), Convert.ToInt32(a["h11"]), Convert.ToInt32(a["h12"]), Convert.ToInt32(a["h13"]), Convert.ToInt32(a["h14"]), Convert.ToInt32(a["h15"]), Convert.ToInt32(a["h16"]), Convert.ToInt32(a["h17"]), Convert.ToInt32(a["h18"]) } } } ); } Course course = new Course(); Init(course); var prog = new Calculate(); result = prog.Go(course, players); }