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);
}
