C# (CSharp) _9th.Sacred.Data PowersData Examples

Example #1

File: PowersData.cs Project: Shadess/CharacterBuilder

        public List <Power> GetAll()
        {
            DataSet      data   = new DataSet();
            List <Power> powers = new List <Power>();

            using (SqlCommand command = new SqlCommand(SQL_GET_ALL))
            {
                data = ExecuteSqlQuery(command);
            }

            if (!DataSetIsEmpty(data) && data.Tables.Count > 1)
            {
                DataTable powerMapTable = data.Tables[1];

                foreach (DataRow row in data.Tables[0].Rows)
                {
                    Power power = PowersData.CreateObjectFromDataRow(row);

                    //foreach (DataRow mapRow in powerMapTable.Select("POWERID_FK = " + power.Id))
                    //{
                    //    power.CategoryMapIds.Add(Convert.ToInt32(mapRow["CATEGORYOBJECTID"]));
                    //}

                    powers.Add(power);
                }
            }

            return(powers);
        }