private BindablePointDefinition TranslateToBindablePointDefinition(IDataReader dataReader) { BindablePointDefinition bindPointDef = new BindablePointDefinition(); TranslateToBindablePointDefinition(dataReader, bindPointDef); return(bindPointDef); }
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); }
protected void Delete(BindablePointDefinition bindPointDef) { RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction(); deleteAction.CommandText = _deleteCommandText; deleteAction.AddParameter("@BindablePointDefinitionId", bindPointDef.BindablePointDefinitionId, DbType.Int32); this.ExecuteCommand(deleteAction); }
protected void Insert(BindablePointDefinition bindPointDef) { RawSqlInsertAction insertAction = new RawSqlInsertAction(); insertAction.CommandText = _insertCommandText; insertAction.AddParameter("@ClassDefinitionId", bindPointDef.ClassDefinitionId, DbType.Int32); insertAction.AddParameter("@BindablePointName", bindPointDef.BindablePointName, DbType.String); insertAction.AddParameter("@BindablePointFriendlyName", bindPointDef.BindablePointFriendlyName, DbType.String); insertAction.AddParameter("@BindablePointDescription", bindPointDef.BindablePointDescription, DbType.String); insertAction.AddParameter("@InterfaceId", bindPointDef.InterfaceId, DbType.Int32); this.ExecuteCommand(insertAction); bindPointDef.BindablePointDefinitionId = insertAction.InsertedIdentity; }
protected void TranslateToBindablePointDefinition(IDataReader dataReader, BindablePointDefinition bindPointDef, int idIndex, int classDefIdIndex, int nameIndex, int friendlyNameIndex, int descrIndex, int interfIndex) { bindPointDef.BindablePointDefinitionId = dataReader.GetInt32(idIndex); bindPointDef.ClassDefinitionId = dataReader.GetInt32(classDefIdIndex); bindPointDef.BindablePointName = dataReader.GetString(nameIndex); bindPointDef.BindablePointFriendlyName = dataReader.GetString(friendlyNameIndex); if (!dataReader.IsDBNull(descrIndex)) { bindPointDef.BindablePointDescription = dataReader.GetString(descrIndex); } if (!dataReader.IsDBNull(interfIndex)) { bindPointDef.InterfaceId = dataReader.GetInt32(interfIndex); } }
protected void Update(BindablePointDefinition bindPointDef) { RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction(); updateAction.CommandText = _updateCommandText; updateAction.AddParameter("@BindablePointDefinitionId", bindPointDef.BindablePointDefinitionId, DbType.Int32); updateAction.AddParameter("@ClassDefinitionId", bindPointDef.ClassDefinitionId, DbType.Int32); updateAction.AddParameter("@BindablePointName", bindPointDef.BindablePointName, DbType.String); updateAction.AddParameter("@BindablePointFriendlyName", bindPointDef.BindablePointFriendlyName, DbType.String); updateAction.AddParameter("@BindablePointDescription", bindPointDef.BindablePointDescription, DbType.String); updateAction.AddParameter("@InterfaceId", bindPointDef.InterfaceId, DbType.Int32); this.ExecuteCommand(updateAction); }
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 void InternalInsert(BindablePointDefinition bindPointDef) { Insert(bindPointDef); }
protected void TranslateToBindablePointDefinition(IDataReader dataReader, BindablePointDefinition bindPointDef) { int[] indexes = GetBindablePointDefinitionFieldOrdinals(dataReader); TranslateToBindablePointDefinition(dataReader, bindPointDef, indexes[0], indexes[1], indexes[2], indexes[3], indexes[4], indexes[5]); }
internal void InternalDelete(BindablePointDefinition bindPointDef) { this.Delete(bindPointDef); }
internal void InternalUpdate(BindablePointDefinition bindPointDef) { this.Update(bindPointDef); }