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