public List<Hero> LoadHeroes() { List<Hero> heroes = new List<Hero>(); try { conn.Open(); SqlCommand sqlcmd = new SqlCommand("LoadHeroes", conn); sqlcmd.CommandType = CommandType.StoredProcedure; DataTable table = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(sqlcmd); adapter.Fill(table); SqlDataReader reader = sqlcmd.ExecuteReader(); reader.Read(); foreach (DataRow row in table.Rows) { Hero hero = new Hero(); hero.Name = row["Name"].ToString(); hero.CurrentHealth = int.Parse(row["CurrentHealth"].ToString()); hero.MaxHealth = int.Parse(row["MaxHealth"].ToString()); hero.MinDamage = int.Parse(row["MinDamage"].ToString()); hero.MaxDamage = int.Parse(row["MaxDamage"].ToString()); hero.Level = byte.Parse(row["Level"].ToString()); hero.Experience = int.Parse(row["Experience"].ToString()); hero.Coins = int.Parse(row["Coins"].ToString()); heroes.Add(hero); } conn.Close(); return heroes; } catch (Exception) { throw new ArgumentException("LoadHeroes failed"); } }
public void DeleteHero(Hero hero) { try { SqlCommand sqlcmd = new SqlCommand("DeleteHero", conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(new SqlParameter("@name", hero.Name)); conn.Open(); sqlcmd.ExecuteNonQuery(); conn.Close(); } catch (Exception) { throw new ArgumentException("DeleteHero failed"); } }
public void CreateHero(Hero hero) { try { SqlCommand sqlcmd = new SqlCommand("CreateHero", conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(new SqlParameter("@name", hero.Name)); sqlcmd.Parameters.Add(new SqlParameter("@currenthealth", hero.CurrentHealth)); sqlcmd.Parameters.Add(new SqlParameter("@maxhealth", hero.MaxHealth)); sqlcmd.Parameters.Add(new SqlParameter("@mindamage", hero.MinDamage)); sqlcmd.Parameters.Add(new SqlParameter("@maxdamage", hero.MaxDamage)); sqlcmd.Parameters.Add(new SqlParameter("@level", hero.Level)); sqlcmd.Parameters.Add(new SqlParameter("@experience", hero.Experience)); sqlcmd.Parameters.Add(new SqlParameter("@coins", hero.Coins)); conn.Open(); sqlcmd.ExecuteNonQuery(); conn.Close(); } catch (Exception) { throw new ArgumentException("CreateHero failed"); } }
public void SaveHero(Hero hero) { SqlCommand sqlcmd = new SqlCommand("SaveHero", conn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(new SqlParameter("@name", hero.Name)); sqlcmd.Parameters.Add(new SqlParameter("@currenthealth", hero.CurrentHealth)); sqlcmd.Parameters.Add(new SqlParameter("@maxhealth", hero.MaxHealth)); sqlcmd.Parameters.Add(new SqlParameter("@mindamage", hero.MinDamage)); sqlcmd.Parameters.Add(new SqlParameter("@maxdamage", hero.MaxDamage)); sqlcmd.Parameters.Add(new SqlParameter("@level", hero.Level)); sqlcmd.Parameters.Add(new SqlParameter("@experience", hero.Experience)); sqlcmd.Parameters.Add(new SqlParameter("@coins", hero.Coins)); conn.Open(); sqlcmd.ExecuteNonQuery(); conn.Close(); }