Beispiel #1
0
        public List <Tee> GetTees()
        {
            List <Tee> tees = new List <Tee>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    SqlCommand    cmd = new SqlCommand(SQL_GET_TEES, conn);
                    SqlDataReader rdr = cmd.ExecuteReader();

                    while (rdr.Read())
                    {
                        Tee    tee    = RowToObject(rdr);
                        Course course = CourseSqlDAO.RowToObject(rdr);
                        tee.Course = course;

                        tees.Add(tee);
                    }
                }

                return(tees);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
        public List <GolfRound> GetGolfRoundsByPlayerId(int playerId)
        {
            List <GolfRound> golfRounds = new List <GolfRound>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    SqlCommand cmd = new SqlCommand(SQL_GET_GOLF_ROUNDS_BY_PLAYERID, conn);
                    cmd.Parameters.AddWithValue("@playerId", playerId);
                    SqlDataReader rdr = cmd.ExecuteReader();

                    while (rdr.Read())
                    {
                        GolfRound golfRound = RowToObject(rdr);
                        Course    course    = CourseSqlDAO.RowToObject(rdr);
                        Tee       tee       = TeeSqlDAO.RowToObject(rdr);
                        tee.Course    = course;
                        golfRound.Tee = tee;
                        golfRounds.Add(golfRound);
                    }
                }

                return(golfRounds);
            }
            catch (SqlException ex)
            {
                throw;
            }
        }
        public GolfRound CreateGolfRound(GolfRound round)
        {
            GolfRound createdRound = null;

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    SqlCommand cmd = new SqlCommand(SQL_CREATE_GOLF_ROUND, conn);
                    cmd.Parameters.AddWithValue("@playerId", round.PlayerId);
                    cmd.Parameters.AddWithValue("@teeId", round.Tee.TeeId);
                    cmd.Parameters.AddWithValue("@datePlayed", round.DatePlayed);
                    cmd.Parameters.AddWithValue("@score", round.Score);


                    SqlDataReader rdr = cmd.ExecuteReader();

                    if (rdr.Read())
                    {
                        Tee    tee    = TeeSqlDAO.RowToObject(rdr);
                        Course course = CourseSqlDAO.RowToObject(rdr);
                        createdRound     = RowToObject(rdr);
                        tee.Course       = course;
                        createdRound.Tee = tee;
                    }

                    rdr.Close();


                    if (round.HoleResults.Count > 0)
                    {
                        CreateHoleResults(conn, round, createdRound.GolfRoundId);
                    }

                    return(createdRound);
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Beispiel #4
0
        public Tee GetTeeWithHolesById(int teeId)
        {
            Tee    tee    = null;
            Course course = null;

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    SqlCommand cmd = new SqlCommand(SQL_GET_TEE_WITH_HOLES_BY_ID, conn);
                    cmd.Parameters.AddWithValue("@teeId", teeId);
                    SqlDataReader rdr = cmd.ExecuteReader();

                    if (rdr.Read())
                    {
                        tee        = TeeSqlDAO.RowToObject(rdr);
                        course     = CourseSqlDAO.RowToObject(rdr);
                        tee.Course = course;
                    }

                    if (rdr.NextResult())
                    {
                        while (rdr.Read())
                        {
                            Hole hole = HoleSqlDAO.RowToObject(rdr);
                            //hole.Course = course;
                            course.Holes.Add(hole);
                        }
                    }
                }

                return(tee);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
        public Player GetPlayerById(int playerId)
        {
            Player player = null;

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    SqlCommand cmd = new SqlCommand(SQL_GET_PLAYER_BY_ID, conn);
                    cmd.Parameters.AddWithValue("@playerId", playerId);
                    SqlDataReader rdr = cmd.ExecuteReader();

                    if (rdr.Read())
                    {
                        player = RowToObject(rdr);
                    }

                    if (rdr.NextResult())
                    {
                        while (rdr.Read())
                        {
                            GolfRound golfRound = GolfRoundSqlDAO.RowToObject(rdr);
                            Tee       tee       = TeeSqlDAO.RowToObject(rdr);
                            Course    course    = CourseSqlDAO.RowToObject(rdr);
                            tee.Course    = course;
                            golfRound.Tee = tee;
                            player.GolfRounds.Add(golfRound);
                        }
                    }

                    return(player);
                }
            }
            catch (SqlException ex)
            {
                throw;
            }
        }