/// <summary>
/// Store the specified reprocess job result.
/// Note that this method will ALWAYS try to create a new row. If one already exists in
/// the database with the same job and item IDs then an EMMADataException is thrown.
/// </summary>
/// <param name="itemData">The result data to be stored</param>
/// <exception cref="EMMADataException"></exception>
private static void StoreResult(ReprocessResult resultData, DateTime jobDate)
{
EMMADataSet.ReprocessResultDataTable table = new EMMADataSet.ReprocessResultDataTable();
EMMADataSet.ReprocessResultRow row = table.NewReprocessResultRow();
row.JobID = resultData.JobID;
row.ItemID = resultData.ItemID;
row.Quantity = resultData.Quantity;
row.EffectiveBuyPrice = resultData.EffectiveBuyPrice;
row.EstSellPrice = resultData.EstSellPrice;
row.JobDate = jobDate;
table.AddReprocessResultRow(row);
try
{
lock (resultTableAdapter)
{
resultTableAdapter.Update(table);
}
}
catch (Exception ex)
{
throw new EMMADataException(ExceptionSeverity.Error, "Problem adding reprocess result data " +
"to the database.", ex);
}
}
