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