コード例 #1
0
        /// <summary>
        /// Next button validates data and moves to create pools
        /// </summary>
        private void btnNext_Click(object sender, EventArgs e)
        {
            //
            //Make sure all values are entered into datagrid view &
            //populate list of fencers
            //

            //clean & reset list
            listOfFencers = new List <Fencer>();

            //Loop through each row
            for (int j = 0; j < dgvFencers.Rows.Count - 1; j++)
            {
                //Loop through each column
                for (int i = 0; i < dgvFencers.Rows[j].Cells.Count; i++)
                {
                    //if one is null then report
                    if (dgvFencers.Rows[j].Cells[i].Value == null || String.IsNullOrEmpty(dgvFencers.Rows[j].Cells[i].Value.ToString()))
                    {
                        //If not new row, report null data
                        MessageBox.Show("Missing " + dgvFencers.Columns[i].HeaderText + " in ID #" + (dgvFencers.Rows[j].Index + 1));
                        return;
                    }
                }


                //create new fencer
                Fencer tempFencer = new Fencer();

                //populate values
                tempFencer.ID        = Convert.ToInt32(dgvFencers.Rows[j].Cells["ID"].Value);
                tempFencer.FirstName = dgvFencers.Rows[j].Cells["FirstName"].Value.ToString();
                tempFencer.LastName  = dgvFencers.Rows[j].Cells["LastName"].Value.ToString();


                //Add to list
                listOfFencers.Add(tempFencer);
            }


            //Go to next thing
            PoolSheet form = new PoolSheet();

            form.Show();
        }
コード例 #2
0
        private void btnCalculate_Click(object sender, EventArgs e)
        {
            //Grab Data
            System.Data.DataTable dataT = (System.Data.DataTable)(dgvPoolTable.DataSource);

            //get indexes
            int col1Index = dgvPoolTable.Columns["1"].Index;
            int colVIndex = dgvPoolTable.Columns["V"].Index;


            ///////////////////////
            //
            // Validate Input
            //
            ///////////////////////

            //
            // Make sure all the values are filled in
            // and are all integer values
            //

            //loop through columns
            for (int i = col1Index; i < colVIndex; i++)
            {
                //loop through rows
                for (int r = 0; r < dataT.Rows.Count; r++)
                {
                    //get header number
                    int hdrNumber   = Convert.ToInt32(dataT.Columns[i].ColumnName.ToString());
                    int rowIDNumber = Convert.ToInt32(dataT.Rows[r]["#"].ToString());

                    //if row ID and i are equal, skip
                    //i.e. black square
                    if (hdrNumber == rowIDNumber)
                    {
                        continue;
                    }

                    //back sure it is numeric and not empty
                    string val = dataT.Rows[r][i].ToString();
                    int    n;

                    //if nothing, stop
                    if (val == null || string.IsNullOrEmpty(val))
                    {
                        MessageBox.Show("Missing data");
                        return;
                    }

                    //if not an integer, stop
                    else if (!int.TryParse(val, out n))
                    {
                        MessageBox.Show("Invalid input");
                        return;
                    }
                }
            }


            ///////////////////////
            //
            // Calculate results
            //
            ///////////////////////


            //
            //Touches Scored and Victories
            //

            //loop through rows
            for (int r = 0; r < dataT.Rows.Count; r++)
            {
                //reset & clear current values of Victories and Touches Scored
                int i_currentV  = 0;
                int i_currentTS = 0;


                //loop through columns
                for (int i = col1Index; i < colVIndex; i++)
                {
                    //get score
                    string s_score = dataT.Rows[r][i].ToString();

                    //If victory, add to V column
                    if (s_score == "V" || s_score == "5" || s_score == "V5")
                    {
                        //increase count by 1
                        i_currentV = 1 + i_currentV;

                        //add to touches scored
                        i_currentTS = 5 + i_currentTS;
                    }

                    //can't fence self
                    else if (s_score == "")
                    {
                        continue;
                    }

                    //didn't win, under 5 points
                    else
                    {
                        //get score
                        int i_score = Convert.ToInt32(dataT.Rows[r][i]);

                        //increase touches scored
                        i_currentTS = i_score + i_currentTS;
                    }
                }

                //set values in datatable
                dataT.Rows[r]["TS"] = i_currentTS;
                dataT.Rows[r]["V"]  = i_currentV;


                //
                //Calculate touches Received
                //

                int    i_currentTR = 0;
                string s_currentID = dataT.Rows[r]["#"].ToString();
                int    i_currentID = Convert.ToInt32(s_currentID);

                //Sum all the touches in the corresponding column
                for (int s_rw = 0; s_rw < dataT.Rows.Count; s_rw++)
                {
                    //if not blank
                    if (dataT.Rows[s_rw][s_currentID].ToString() != "")
                    {
                        //add to i_currentTR
                        i_currentTR = i_currentTR + Convert.ToInt32(dataT.Rows[s_rw][s_currentID]);
                    }
                }


                //set to final value
                dataT.Rows[r]["TR"] = i_currentTR;

                //
                //Calculate Indicator
                //

                int i_currentInd = i_currentTS - i_currentTR;
                dataT.Rows[r]["Ind"] = i_currentInd;

                //save values on Master List
                Fencer myFencer = listOfFencers.Find(x => x.ID == i_currentID);
                myFencer.pVictories     = i_currentV;
                myFencer.pIndicator     = i_currentInd;
                myFencer.pTouchesRec    = i_currentTR;
                myFencer.pTouchesScored = i_currentTS;
            }


            ////////////////////////////
            // Calculate Current Places
            ////////////////////////////

            //Sort a list based on number of Victories
            List <Fencer> tempList = listOfFencers.OrderByDescending(o => o.pVictories)
                                     .ThenByDescending(p => p.pIndicator).ToList();


            //loop through sorted list
            for (int j = 0; j < dataT.Rows.Count; j++)
            {
                //find the ID #
                int ID = Convert.ToInt32(dataT.Rows[j]["#"]);

                //find the matching place value
                //after sorting, if in place 0, then got 1st place
                int placeValue = tempList.IndexOf(tempList.Find(x => x.ID == ID)) + 1;

                //set value on DataTable
                dataT.Rows[j]["Pl"] = placeValue;
            }
        }