/// <summary>
/// This method is used to update area information.
/// </summary>
/// <param name="model"></param>
/// <remarks>
/// Updates the passed model with updated properties
/// </remarks>
public void UpdateArea(CartonArea model)
{
const string QUERY = @"
BEGIN
UPDATE <proxy />TAB_INVENTORY_AREA TIA
SET TIA.LOCATION_NUMBERING_FLAG = :LOCATION_NUMBERING_FLAG,
TIA.IS_PALLET_REQUIRED = :IS_PALLET_REQUIRED,
TIA.DESCRIPTION = :DESCRIPTION,
TIA.UNUSABLE_INVENTORY = :UNUSABLE_INVENTORY
WHERE TIA.INVENTORY_STORAGE_AREA =:INVENTORY_STORAGE_AREA
RETURNING TIA.SHORT_NAME, TIA.WAREHOUSE_LOCATION_ID INTO :LSHORT_NAME, :LWAREHOUSE_LOCATION_ID;
END;
";
var binder = SqlBinder.Create()
.Parameter("INVENTORY_STORAGE_AREA", model.AreaId)
.Parameter("LOCATION_NUMBERING_FLAG", model.LocationNumberingFlag ? "Y" : string.Empty)
.Parameter("IS_PALLET_REQUIRED", model.IsPalletRequired ? "Y" : string.Empty)
.Parameter("UNUSABLE_INVENTORY", model.UnusableInventory ? "Y" : string.Empty)
.Parameter("DESCRIPTION", model.Description)
.OutParameter("LSHORT_NAME", p => model.ShortName = p)
.OutParameter("LWAREHOUSE_LOCATION_ID", p => model.BuildingId = p);
_db.ExecuteNonQuery(QUERY, binder);
}
/// <summary>
/// This method is used to update area information.
/// </summary>
/// <param name="model"></param>
public void UpdateArea(CartonArea model)
{
_repos.UpdateArea(model);
}
