public List<Stat> GetStats() { SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "GetStats"; command.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader dr; dr = command.ExecuteReader(); var statList = new List<Stat>(); if (dr.HasRows) { while (dr.Read()) { var stat = new Stat(); stat.Id = dr.GetInt32(0); stat.Name = dr.GetString(1); stat.Description = dr.GetString(2); statList.Add(stat); } } connection.Close(); dr.Close(); return statList; }
// public List<Stat> GetStatsByPlayerID(int id) { SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "GetStatsByPlayerID"; 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 statList = new List<Stat>(); if (dr.HasRows) { while (dr.Read()) { var stat = new Stat(); stat.Id = dr.GetInt32(0); stat.Name = dr.GetString(1); stat.Description = dr.GetString(2); stat.Value = dr.GetDecimal(3); statList.Add(stat); } } connection.Close(); dr.Close(); return statList; }