/// <summary>
/// Update the info for the passed process
/// </summary>
/// <param name="info"></param>
public void UpdateProcess(ReceivingProcess info)
{
const string QUERY = @"
UPDATE <proxy />SRC_CARTON_PROCESS SCP
SET
SCP.PRO_NUMBER= :PRO_NUMBER,
SCP.EXPECTED_CARTON = :EXPECTED_CARTON,
SCP.PRO_DATE= :PRO_DATE,
SCP.PALLET_LIMIT = :PALLET_LIMIT,
SCP.CARRIER_ID= :CARRIER_ID,
SCP.PRICE_SEASON_CODE = :PRICE_SEASON_CODE,
SCP.RECEIVING_AREA_ID = :RECEIVING_AREA_ID,
SCP.SPOT_CHECK_AREA_ID = :SPOT_CHECK_AREA_ID
WHERE SCP.PROCESS_ID= :PROCESS_ID
";
var binder = SqlBinder.Create()
.Parameter("PRO_NUMBER", info.ProNumber)
.Parameter("PROCESS_ID", info.ProcessId)
.Parameter("EXPECTED_CARTON", info.ExpectedCartons)
.Parameter("PALLET_LIMIT", info.PalletLimit)
.Parameter("PRO_DATE", info.ProDate)
.Parameter("CARRIER_ID", info.CarrierId)
.Parameter("PRICE_SEASON_CODE", info.PriceSeasonCode)
.Parameter("RECEIVING_AREA_ID", info.ReceivingAreaId)
.Parameter("SPOT_CHECK_AREA_ID", info.SpotCheckAreaId);
_db.ExecuteNonQuery(QUERY, binder);
}
/// <summary>
/// Pass new values in processModel
/// </summary>
public void UpdateProcess(ReceivingProcess processModel)
{
if (processModel.ProcessId <= 0)
{
throw new ArgumentOutOfRangeException("processModel.ProcessId", "Process Id must be positive");
}
_repos.UpdateProcess(processModel);
ProcessCache.Remove(processModel.ProcessId);
}
public int InsertProcess(ReceivingProcess processModel)
{
if (processModel.ProcessId != 0)
{
throw new ArgumentOutOfRangeException("processModel.ProcessId", "Process Id cannot be specified");
}
var processId = _repos.InsertProcess(processModel);
processModel.ProcessId = processId;
return(processId);
}
/// <summary>
/// create new process for the receiving.
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertProcess(ReceivingProcess info)
{
const string QUERY = @"
BEGIN
INSERT INTO <proxy />SRC_CARTON_PROCESS
(PROCESS_ID,
MODULE_CODE,
PRO_NUMBER,
CARRIER_ID,
PRO_DATE,
EXPECTED_CARTON,
PALLET_LIMIT,
RECEIVING_AREA_ID,
SPOT_CHECK_AREA_ID,
PRICE_SEASON_CODE )
VALUES
(Process_Sequence.Nextval,
:amodule_code,
:aprono,
:acarrier,
:aprodate,
:expectedcarton,
:pallet_limit,
:receivingArea,
:spotCheckArea,
:priceSeasonCode
)
RETURNING PROCESS_ID INTO :process_id;
END;
";
int processId = 0;
var binder = SqlBinder.Create().Parameter("aprono", info.ProNumber)
.Parameter("acarrier", info.CarrierId)
.Parameter("aprodate", info.ProDate)
.Parameter("amodule_code", MODULE_NAME)
.Parameter("expectedcarton", info.ExpectedCartons)
.Parameter("pallet_limit", info.PalletLimit)
.Parameter("receivingArea", info.ReceivingAreaId)
.Parameter("spotCheckArea", info.SpotCheckAreaId)
.Parameter("priceSeasonCode", info.PriceSeasonCode)
.OutParameter("process_id", val => processId = val.Value);
_db.ExecuteNonQuery(QUERY, binder);
return(processId);
}
