Beispiel #1
0
        public static List <Hero> getAllAvailableHeroes()
        {
            List <Hero> heroes = new List <Hero>();
            DataTable   table  = StoredProcedures.getRowsFromSproc("GetAllAvailableHeroes");

            foreach (DataRow row in table.Rows)
            {
                int    id          = Convert.ToInt32(row["id"]);
                string name        = row["name"].ToString();
                int    hp          = Convert.ToInt32(row["hp"]);
                int    damage      = Convert.ToInt32(row["damage"]);
                string combatClass = row["class"].ToString();

                heroes.Add(new Hero(id, hp, damage, name, combatClass));
            }
            return(heroes);
        }
Beispiel #2
0
        public static void addLeague(string leagueName)
        {
            SqlParameter[] param = { new SqlParameter("leagueName", leagueName) };

            StoredProcedures.callNonQuerySproc("addLeague", param);
        }