/// <summary>
/// Get areas to transfer irregular and sample pieces
/// </summary>
/// <param name="pieceFlag"></param>
/// <returns></returns>
public IEnumerable <SkuArea> GetTransferAreas(PiecesRemoveFlag pieceFlag)
{
const string QUERY =
@"
SELECT TIA.INVENTORY_STORAGE_AREA AS INVENTORY_STORAGE_AREA,
TIA.DESCRIPTION AS DESCRIPTION,
TIA.SHORT_NAME AS SHORT_NAME
FROM <proxy />TAB_INVENTORY_AREA TIA
WHERE TIA.STORES_WHAT = 'SKU'
<if c='$samples'>
AND TIA.UNUSABLE_INVENTORY='Y'
</if>
<if c='$irregular'>
AND TIA.CONSOLIDATED_UPC_CODE IS NOT NULL
</if>
ORDER BY TIA.INVENTORY_STORAGE_AREA
";
var binder = SqlBinder.Create(row => new SkuArea()
{
AreaId = row.GetString("INVENTORY_STORAGE_AREA"),
Description = row.GetString("DESCRIPTION"),
ShortName = row.GetString("SHORT_NAME")
});
binder.ParameterXPath("samples", pieceFlag == PiecesRemoveFlag.Samples);
binder.ParameterXPath("irregular", pieceFlag == PiecesRemoveFlag.Irregular);
return(_db.ExecuteReader(QUERY, binder));
}
public IEnumerable <SkuArea> GetTransferAreas(PiecesRemoveFlag pieceFlag)
{
return(_repos.GetTransferAreas(pieceFlag));
}
