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