public Potion CreatePotionFromReader(SqlDataReader reader)
{
var type = Convert.ToInt32(reader["Type"]);
if (type != 3)
{
throw new Exception("Item isn't the correct type");
}
Potion p = new Potion(
Convert.ToInt32(reader["Id"]),
Convert.ToString(reader["Name"]),
Convert.ToString(reader["Description"]),
Convert.ToInt32(reader["GoldValue"]));
Stats s = new StatsSQLContext().CreateStatsFromReader(reader);
p.Stats = s;
return(p);
}
public Enemy CreateEnemyFromReader(SqlDataReader reader)
{
Gender g = (Gender)Enum.Parse(typeof(Gender), Convert.ToString(reader["Gender"]));
Race r = (Race)Enum.Parse(typeof(Race), Convert.ToString(reader["Race"]));
Enemy e = new Enemy(
Convert.ToInt32(reader["eId"]),
Convert.ToString(reader["Name"]),
g,
r,
Convert.ToInt32(reader["PhysDamage"]),
Convert.ToInt32(reader["ElemDamage"]),
Convert.ToInt32(reader["PhysReduction"]),
Convert.ToInt32(reader["ElemReduction"]));
if (reader["sId"] != DBNull.Value)
{
Stats s = new StatsSQLContext().GetById(Convert.ToInt32(reader["sId"]));
e.Stats = s;
}
return(e);
}
public Player CreatePlayerFromReader(SqlDataReader reader)
{
Gender g = (Gender)Enum.Parse(typeof(Gender), Convert.ToString(reader["Gender"]));
Race r = (Race)Enum.Parse(typeof(Race), Convert.ToString(reader["Race"]));
Player p = new Player(
Convert.ToInt32(reader["pId"]),
Convert.ToString(reader["Name"]),
g,
r,
Convert.ToInt32(reader["Gold"]),
Convert.ToInt32(reader["Deaths"]),
Convert.ToInt32(reader["HighestWave"]));
Stats s = new StatsSQLContext().GetById(Convert.ToInt32(reader["sId"]));
Class c = new ClassSQLContext().GetById(Convert.ToInt32(reader["cId"]));
p.Stats = s;
p.Class = c;
p.Inventory = new InventorySQLContext().GetInventory(p);
return(p);
}
