//
public List<Skill> GetSkills()
{
SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "GetSkills";
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader dr;
dr = command.ExecuteReader();
var skillList = new List<Skill>();
if (dr.HasRows)
{
while (dr.Read())
{
var skill = new Skill();
skill.Id = dr.GetInt32(0);
skill.Name = dr.GetString(1);
skill.Description = dr.GetString(2);
skill.ImgSrc = dr.GetString(3);
skill.KeyStatID = dr.GetInt32(4);
skill.Trained = dr.GetInt32(5);
skill.ACPenalty = dr.GetInt32(6);
skill.Retry = dr.GetInt32(7);
skill.OpposingSkillID = dr.GetInt32(8);
skill.Special = dr.GetString(9);
skillList.Add(skill);
}
}
connection.Close();
dr.Close();
return skillList;
}
public List<Skill> GetSkillsByPlayerID(int id)
{
SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "GetSkillsByPlayerID";
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 skillList = new List<Skill>();
if (dr.HasRows)
{
while (dr.Read())
{
var skill = new Skill();
skill.Id = dr.GetInt32(0);
skill.Name = dr.GetString(1);
skill.Description = dr.GetString(2);
skill.Value = dr.GetDecimal(3);
skillList.Add(skill);
}
}
connection.Close();
dr.Close();
return skillList;
}