public BalanceAdjustmentReasonRow[] GetByType(BalanceAdjustmentReasonType pBalanceAdjustmentReasonType)
{
#region sql
/*
* SELECT *
* FROM BalanceAdjustmentReasonType
* WHERE
* balance_adjustment_reason_id = 1
*/
#endregion sql
string _where = BalanceAdjustmentReasonRow.type_DbName + " = " + (byte)pBalanceAdjustmentReasonType;
IDbCommand _cmd = CreateGetCommand(_where, BalanceAdjustmentReasonRow.description_DbName);
using (IDataReader _reader = _cmd.ExecuteReader()) {
return(MapRecords(_reader));
}
}
internal static BalanceAdjustmentReasonDto[] GetByType(Rbr_Db pDb, BalanceAdjustmentReasonType pBalanceAdjustmentReasonType)
{
var _balanceAdjustmentReasonRows = pDb.BalanceAdjustmentReasonCollection.GetByType(pBalanceAdjustmentReasonType);
return(mapToBalanceAdjustmentReasons(_balanceAdjustmentReasonRows));
}