/// <summary> /// /// </summary> /// <param name="criteria"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public static KandaDbDataReader Select(UserHistoriesCriteria criteria, DbConnection connection, DbTransaction transaction) { var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction); reader.CommandText = @"usp_SelectUserHistories"; KandaDbDataMapper.MapToParameters(reader, criteria); reader.ExecuteReader(); return(reader); }
/// <summary> /// /// </summary> /// <param name="criteria"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public static int Delete(UserHistoriesCriteria criteria, DbConnection connection, DbTransaction transaction) { var command = KandaTableDataGateway._factory.CreateCommand(connection, transaction); command.CommandText = @"usp_DeleteUserHistories"; KandaDbDataMapper.MapToParameters(command, criteria); 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); //return (int)command.Parameters[KandaTableDataGateway.RETURN_VALUE].Value; }
/// <summary> /// /// </summary> /// <param name="criteria"></param> /// <param name="connection"></param> /// <param name="transaction"></param> /// <returns></returns> public UserHistoryEntity Find(UserHistoriesCriteria criteria, DbConnection connection, DbTransaction transaction) { var reader = default(KandaDbDataReader); try { reader = UserHistoriesGateway.Select(criteria, connection, transaction); var found = reader.Read() ? KandaDbDataMapper.MapToObject <UserHistoryEntity>(reader) : UserHistoryEntity.Empty; return(found); } finally { if (reader != null) { reader.Close(); } } }