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