/// <summary> /// Determines the children entities belonging to an entity /// </summary> /// <param name="EntityToLoad">The EntityType - Category|Manufacturer|Section|Distribotur|Genre|Vector - to find children of</param> /// <param name="ParentEntityID">The ID of the entity to retrieve children for</param> /// <returns>A GridEntity List containing the immediate children of an entity</returns> public static List <GridEntity> GetChildrenEntities(String EntityToLoad, int ParentEntityID) { String EntityType = LoadEntityType(EntityToLoad); List <GridEntity> eiList = new List <GridEntity>(); using (SqlConnection conn = new SqlConnection(DB.GetDBConn())) { conn.Open(); using (IDataReader rs = DB.GetRS("select * from dbo.{0} with(NOLOCK) where Parent{0}ID=".FormatWith(EntityType) + ParentEntityID.ToString(), conn)) { while (rs.Read()) { GridEntity e = new GridEntity(rs, EntityType); eiList.Add(e); } } } return(eiList); }
/// <summary> /// Loads all entities of a given entity type /// </summary> /// <param name="EntityToLoad">The EntityType - Category|Manufacturer|Section|Distributor - to load</param> /// <returns>An Entity List containing all root-level entities</returns> public static List <GridEntity> GetAllEntitiesOfType(String EntityToLoad) { String EntityType = LoadEntityType(EntityToLoad); List <GridEntity> eiList = new List <GridEntity>(); using (SqlConnection conn = new SqlConnection(DB.GetDBConn())) { conn.Open(); using (IDataReader rs = DB.GetRS("select * from dbo.{0} with(NOLOCK) where Deleted=0".FormatWith(EntityType), conn)) { while (rs.Read()) { GridEntity e = new GridEntity(rs, EntityType); eiList.Add(e); } } } return(eiList); }