internal List <StaticContent> InternalLoadByParentInstanceId(int parentId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByParentInstanceIdCommandText; readerAction.AddParameter("@ParentInstanceId", parentId, DbType.Int32); this.ExecuteCommand(readerAction); List <StaticContent> rootContList = new List <StaticContent>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetRootContFieldOrdinals(dataReader); while (dataReader.Read()) { StaticContent p = new StaticContent(); TranslateToRootCont(dataReader, p, ordinals[0], ordinals[1], ordinals[2], ordinals[3]); rootContList.Add(p); } } finally { dataReader.Close(); } return(rootContList); }
internal List <PlugFile> InternalLoadByDestinationLocationId(int destLocId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByDestLocIdCommandText; readerAction.AddParameter("@DestinationLocationId", destLocId, DbType.Int32); this.ExecuteCommand(readerAction); List <PlugFile> plugFileList = new List <PlugFile>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetPlugFileFieldOrdinals(dataReader); while (dataReader.Read()) { PlugFile res = new PlugFile(); TranslateToPlugFile(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4]); plugFileList.Add(res); } } finally { dataReader.Close(); } return(plugFileList); }
internal List <StaticContent> InternalLoadAll() { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadAllCommandText; this.ExecuteCommand(readerAction); List <StaticContent> rootContList = new List <StaticContent>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetRootContFieldOrdinals(dataReader); while (dataReader.Read()) { StaticContent p = new StaticContent(); TranslateToRootCont(dataReader, p, ordinals[0], ordinals[1], ordinals[2], ordinals[3]); rootContList.Add(p); } } finally { dataReader.Close(); } return(rootContList); }
internal List <ClassDefinition> InternalLoadByPlugIdName(int plugId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByPlugIdCommandText; readerAction.AddParameter("@PlugId", plugId, DbType.Int32); this.ExecuteCommand(readerAction); List <ClassDefinition> classDefList = new List <ClassDefinition>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetClassDefinitionFieldOrdinals(dataReader); while (dataReader.Read()) { ClassDefinition res = new ClassDefinition(); TranslateToClassDefinition(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4], ordinals[5]); classDefList.Add(res); } } finally { dataReader.Close(); } return(classDefList); }
public List <Binding> LoadByImplementationId(int implementationId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByImplementationIdCommandText; readerAction.AddParameter("@ImplementationId", implementationId, DbType.Int32); this.ExecuteCommand(readerAction); List <Binding> bindingList = new List <Binding>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetBindingFieldOrdinals(dataReader); while (dataReader.Read()) { Binding res = new Binding(); TranslateToBinding(dataReader, res, ordinals[0], ordinals[1], ordinals[2]); bindingList.Add(res); } } finally { dataReader.Close(); } return(bindingList); }
internal List <Instance> InternalLoadAll() { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadAllCommandText; this.ExecuteCommand(readerAction); List <Instance> instanceList = new List <Instance>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetInstanceFieldOrdinals(dataReader); while (dataReader.Read()) { Instance p = new Instance(); TranslateToInstance(dataReader, p, ordinals[0], ordinals[1], ordinals[2]); instanceList.Add(p); } } finally { dataReader.Close(); } return(instanceList); }
internal List <PlugLocation> InternalLoadAll() { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadAllCommandText; this.ExecuteCommand(readerAction); List <PlugLocation> plugLocList = new List <PlugLocation>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetPlugLocationFieldOrdinals(dataReader); while (dataReader.Read()) { PlugLocation res = new PlugLocation(); TranslateToPlugLocation(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4]); plugLocList.Add(res); } } finally { dataReader.Close(); } return(plugLocList); }
internal List <Binding> InternalLoadAll() { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadAllCommandText; this.ExecuteCommand(readerAction); List <Binding> bindingList = new List <Binding>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetBindingFieldOrdinals(dataReader); while (dataReader.Read()) { Binding res = new Binding(); TranslateToBinding(dataReader, res, ordinals[0], ordinals[1], ordinals[2]); bindingList.Add(res); } } finally { dataReader.Close(); } return(bindingList); }
internal List <Instance> InternalLoadByClassDefinitionId(int classDefId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByClassDefinitionIdCommandText; readerAction.AddParameter("@ClassDefinitionId", classDefId, DbType.Int32); this.ExecuteCommand(readerAction); List <Instance> instanceList = new List <Instance>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetInstanceFieldOrdinals(dataReader); while (dataReader.Read()) { Instance p = new Instance(); TranslateToInstance(dataReader, p, ordinals[0], ordinals[1], ordinals[2]); instanceList.Add(p); } } finally { dataReader.Close(); } return(instanceList); }
internal List <BindablePointDefinition> InternalLoadByInterfaceId(string interfaceId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByInterfaceCommandText; readerAction.AddParameter("@InterfaceId", interfaceId, DbType.Int32); this.ExecuteCommand(readerAction); List <BindablePointDefinition> bindPointDefList = new List <BindablePointDefinition>(); IDataReader dataReader = readerAction.DataReader; try { int[] ordinals = GetBindablePointDefinitionFieldOrdinals(dataReader); while (dataReader.Read()) { BindablePointDefinition res = new BindablePointDefinition(); TranslateToBindablePointDefinition(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4], ordinals[5]); bindPointDefList.Add(res); } } finally { dataReader.Close(); } return(bindPointDefList); }
internal BindablePointDefinition InternalLoadByName(string bindPointName) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByNameCommandText; readerAction.AddParameter("@BindablePointName", bindPointName, DbType.String); BindablePointDefinition bindPointDef = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); bindPointDef = TranslateToBindablePointDefinition(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(bindPointDef); }
internal BindablePointDefinition InternalLoadByPrimaryKey(int bindPointDefId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByIdCommandText; readerAction.AddParameter("@BindablePointDefinitionId", bindPointDefId, DbType.Int32); BindablePointDefinition bindPointDef = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); bindPointDef = TranslateToBindablePointDefinition(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(bindPointDef); }
internal PlugLocation InternalLoadByName(string plugLocName) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByNameCommandText; readerAction.AddParameter("@PlugLocationName", plugLocName, DbType.String); PlugLocation plugLoc = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); plugLoc = TranslateToPlugLocation(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(plugLoc); }
internal PlugLocation InternalLoadByPrimaryKey(int plugLocId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByIdCommandText; readerAction.AddParameter("@PlugLocationId", plugLocId, DbType.Int32); PlugLocation plugLoc = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); plugLoc = TranslateToPlugLocation(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(plugLoc); }
internal ClassDefinition InternalLoadByClassName(string className) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByNameCommandText; readerAction.AddParameter("@ClassName", className, DbType.String); ClassDefinition classDef = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); classDef = TranslateToClassDefinition(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(classDef); }
internal ClassDefinition InternalLoadByPrimaryKey(int classDefId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByIdCommandText; readerAction.AddParameter("@ClassDefinitionId", classDefId, DbType.Int32); ClassDefinition classDef = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); classDef = TranslateToClassDefinition(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(classDef); }
internal Instance InternalLoadByPrimaryKey(int instanceId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByIdCommandText; readerAction.AddParameter("@InstanceId", instanceId, DbType.Int32); Instance instance = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); instance = TranslateToInstance(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(instance); }
internal StaticContent InternalLoadByPrimaryKey(int instanceId) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByIdCommandText; readerAction.AddParameter("@InstanceId", instanceId, DbType.Int32); StaticContent rootCont = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); rootCont = TranslateToRootCont(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(rootCont); }
internal StaticContent InternalLoadByFriendlyName(string instanceName) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByInstanceNameCommandText; readerAction.AddParameter("@ContentFriendlyName", instanceName, DbType.String); StaticContent rootCont = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); rootCont = TranslateToRootCont(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(rootCont); }
internal Instance InternalLoadByName(string instanceName) { RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction(); readerAction.CommandText = _loadByNameCommandText; readerAction.AddParameter("@InstanceName", instanceName, DbType.String); Instance instance = null; this.ExecuteCommand(readerAction); try { readerAction.DataReader.Read(); instance = TranslateToInstance(readerAction.DataReader); } finally { readerAction.DataReader.Close(); } return(instance); }