public static DbDataReader Select(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectUserAttributeItems";
KandaDbDataMapper.MapToParameters(reader, entity);
reader.ExecuteReader();
return reader;
}
public static DbDataReader Select(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectUserAttributeItems";
KandaDbDataMapper.MapToParameters(reader, entity);
reader.ExecuteReader();
return(reader);
}
public static int Insert(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var command = KandaTableDataGateway._factory.CreateCommand(connection, transaction);
command.CommandText = @"usp_InsertUserAttributeItems";
KandaDbDataMapper.MapToParameters(command, entity);
var result = KandaTableDataGateway._factory.CreateParameter(KandaTableDataGateway.RETURN_VALUE, DbType.Int32, sizeof(int), ParameterDirection.ReturnValue, DBNull.Value);
command.Parameters.Add(result);
command.ExecuteNonQuery();
return (int)result.Value;
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public static int Update(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var command = KandaTableDataGateway._factory.CreateCommand(connection, transaction);
command.CommandText = @"usp_UpdateUserAttributeItems";
KandaDbDataMapper.MapToParameters(command, entity);
var result = KandaTableDataGateway._factory.CreateParameter(KandaTableDataGateway.RETURN_VALUE, DbType.Int32, sizeof(int), ParameterDirection.ReturnValue, DBNull.Value);
command.Parameters.Add(result);
command.ExecuteNonQuery();
return((int)result.Value);
}
public IEnumerable<UserAttributeItemEntity> Get(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var reader = default(DbDataReader);
try
{
reader = UserAttributeItemsGateway.Select(entity, connection, transaction);
var entities = KandaDbDataMapper.MapToEnumerable<UserAttributeItemEntity>(reader);
return entities;
}
finally
{
if (reader != null) { reader.Close(); }
}
}
public IEnumerable <UserAttributeItemEntity> Get(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var reader = default(DbDataReader);
try
{
reader = UserAttributeItemsGateway.Select(entity, connection, transaction);
var entities = KandaDbDataMapper.MapToEnumerable <UserAttributeItemEntity>(reader);
return(entities);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public bool Create(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var count = UserAttributeItemsGateway.Insert(entity, connection, transaction);
return (count == 1);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Update(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var updated = UserAttributeItemsGateway.Update(entity, connection, transaction);
return(updated == 1);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Create(UserAttributeItemEntity entity, DbConnection connection, DbTransaction transaction)
{
var created = UserAttributeItemsGateway.Insert(entity, connection, transaction);
return(created == 1);
}
