public AttributeTypeCollection Read(EntityType entityType, IEntityTypeRepository entityTypeRepository) { var attributes = new AttributeTypeCollection(); using (SqlConnection sqlConnection = _connectionProvider.GetConnection()) { using (SqlCommand sqlCommand = sqlConnection.CreateCommand()) { sqlCommand.CommandText = string.Format("SELECT * FROM hsck.AttributeTypes WHERE EntityTypeId='{0}'", entityType.Id); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { var dataType = (DataType) Enum.Parse(typeof (DataType), (string) reader["DataType"]); var attributeType = new AttributeType { Id = (int) reader["Id"], Name = (string) reader["Name"], DataType = dataType }; attributes.Add(attributeType); } } } } attributes.Add(_entityAttributeTypeRepository.Read(entityType, entityTypeRepository)); return attributes; }
public AttributeTypeCollection Read(EntityType entityType, IEntityTypeRepository entityTypeRepository) { var attributes = new AttributeTypeCollection(); using (SqlConnection sqlConnection = _connectionProvider.GetConnection()) { using (SqlCommand sqlCommand = sqlConnection.CreateCommand()) { sqlCommand.CommandText = string.Format( "SELECT * FROM hsck.EntityAttributeTypes WHERE ParentEntityTypeName='{0}'", entityType.Name); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { var entityTypeName = (string) reader["ChildEntityTypeName"]; var attributeName = (string) reader["Name"]; EntityType ofType = entityTypeName == entityType.Name ? entityType : entityTypeRepository.Read(entityTypeName); var entityAttributeType = new EntityAttributeType { Id = (int) reader["Id"], Name = attributeName, OfType = ofType }; attributes.Add(entityAttributeType); } } } } return attributes; }
public AttributeTypeCollection FetchAll() { AttributeTypeCollection coll = new AttributeTypeCollection(); Query qry = new Query(AttributeType.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public void AddAttributes(AttributeTypeCollection collection) { foreach (AttributeType attributeType in collection) { Attributes.Add(attributeType); } }
public void Create(AttributeTypeCollection attributeTypeCollection, EntityType onEntity) { foreach (AttributeType attributeType in attributeTypeCollection) { if (attributeType is EntityAttributeType) { Create(attributeType as EntityAttributeType, onEntity); } } }
public ValueList GetColumn(string column) { if (column.StartsWith("&")) { throw new NoSuchAttributeException(column); } if (!_headersMap.TryGetValue(column, out var position)) { throw new NoSuchAttributeException(column); } var result = _rows.Select(row => row[position]).ToList(); var elementType = AttributeTypeCollection.ComputeElementType(result); return(new ValueList(result, elementType)); }
private static AttributeTypeCollection ConvertAttributeArray(AttributeTypeCollection from) { AttributeTypeCollection toAttrs = new AttributeTypeCollection(); foreach (AttributeType fromA in from) { AttributeType toA = new AttributeType(); toA.Any = fromA.Any; toA.attributeID = fromA.attributeID; toA.attributeIDSpecified = fromA.attributeIDSpecified; toA.Value = ConvertValTypeCollection(fromA.Value); toAttrs.Add(toA); } return(toAttrs); }
/// <summary> /// get all attributes from the charactersic with which the specific category is mapping /// </summary> /// <param name="categoryId"></param> /// <param name="apiContext"></param> /// <returns></returns> private static AttributeSetTypeCollection GetAttributeSetCol(int categoryId,ApiContext apiContext) { IAttributesMaster attributesMaster=new AttributesMaster(); AttributeSetTypeCollection attributeSTC=new AttributeSetTypeCollection(); attributesMaster.CategoryCSProvider=new CategoryCSDownloader(apiContext); attributesMaster.XmlProvider=new AttributesXmlDownloader(apiContext); //get the characteristic set id of the specified category IAttributeSetCollection attributeSetCol=attributesMaster.GetItemSpecificAttributeSetsForCategories(new Int32Collection(new int[]{categoryId})); Assert.IsNotNull(attributeSetCol); IAttributesXmlProvider iaxp=attributesMaster.XmlProvider; //download all attributes from ebay XmlDocument document=iaxp.DownloadXml(); //write the memory xml to disk WriteXMLToDisk(document); AttributeSetTypeCollection attributeSetTypeCol=new AttributeSetTypeCollection(); //get Required Item specifics by call getAttributesCS foreach(AttributeSet attributeSet in attributeSetCol) { AttributeSetType attributeST=new AttributeSetType(); attributeST.attributeSetID=attributeSet.attributeSetID; String xpath="//Characteristics/CharacteristicsSet[@id='"+attributeSet.attributeSetID.ToString()+"']//CharacteristicsList//Initial//Attribute"; XmlNodeList nodeList; XmlNode root = document.DocumentElement; nodeList=root.SelectNodes(xpath); AttributeTypeCollection attributeTypeCol=new AttributeTypeCollection(); foreach (XmlNode node in nodeList) { AttributeType attributeT=new AttributeType(); XmlAttributeCollection attributes=node.Attributes; Assert.IsNotNull(attributes); XmlNode idNode = attributes.GetNamedItem("id"); attributeT.attributeID=int.Parse(idNode.Value); ValTypeCollection valTypeCol=getValue(node); if(valTypeCol==null) { System.Console.WriteLine("can not find any specific value!"); } attributeT.Value=valTypeCol; attributeTypeCol.Add(attributeT); } attributeST.Attribute=attributeTypeCol; attributeSTC.Add(attributeST); } return attributeSTC; }
public void Create(AttributeTypeCollection attributeTypeCollection, EntityType entityType) { foreach (AttributeType attributeType in attributeTypeCollection) { Create(attributeType, entityType); } }
private static AttributeTypeCollection ConvertAttributeArray(AttributeTypeCollection from) { AttributeTypeCollection toAttrs = new AttributeTypeCollection(); foreach(AttributeType fromA in from) { AttributeType toA = new AttributeType(); toA.Any = fromA.Any; toA.attributeID = fromA.attributeID; toA.attributeIDSpecified = fromA.attributeIDSpecified; toA.Value = ConvertValTypeCollection(fromA.Value); toAttrs.Add(toA); } return toAttrs; }
public AttributeTypeCollection FetchByQuery(Query qry) { AttributeTypeCollection coll = new AttributeTypeCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public AttributeTypeCollection FetchByID(object AttributeTypeId) { AttributeTypeCollection coll = new AttributeTypeCollection().Where("AttributeTypeId", AttributeTypeId).Load(); return coll; }
public EntityType() { Attributes = new AttributeTypeCollection(); }