Пример #1
0
        public List<Race> GetRaces()
        {
            SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString);
            SqlCommand command = new SqlCommand();
            command.Connection = connection;
            command.CommandText = "GetRaces";
            command.CommandType = CommandType.StoredProcedure;

            connection.Open();
            SqlDataReader dr;
            dr = command.ExecuteReader();

            var raceList = new List<Race>();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    var race = new Race();
                    race.Id = dr.GetInt32(0);
                    race.Name = dr.GetString(1);
                    race.Description = dr.GetString(2);
                    race.ImgSrc = dr.GetString(3);

                    raceList.Add(race);
                }
            }
            connection.Close();
            dr.Close();
            return raceList;
        }
Пример #2
0
        public Race GetPlayerRace(int id)
        {
            SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString);
            SqlCommand command = new SqlCommand();
            command.Connection = connection;
            command.CommandText = "GetRaceByPlayerID";
            command.CommandType = CommandType.StoredProcedure;

            SqlParameter playerID = new SqlParameter("@PlayerID", SqlDbType.Int);

            playerID.Value = id;
            command.Parameters.Add(playerID);

            connection.Open();
            SqlDataReader dr;
            dr = command.ExecuteReader();

            var race = new Race();

            if (dr.HasRows)
            {
                dr.Read();
                race.Name = dr.GetString(0);
                if (dr.IsDBNull(1)) {
                    race.ImgSrc = "DefaultClass.png";
                }
                else {
                    race.ImgSrc = dr.GetString(1);
                }
                race.Description = dr.GetString(2);
            }
            connection.Close();
            dr.Close();

            return race;
        }