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