public int WaypointItemInsert(WaypointItemPickupRequest model, int?jobId, int waypointId)
{
int waypointItemId = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Jobs_WaypointItemsInsert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@JobId", jobId);
paramCollection.AddWithValue("@WaypointId", waypointId);
paramCollection.AddWithValue("@ItemTypeId", model.ItemTypeId);
paramCollection.AddWithValue("@ItemNote", model.ItemNote);
paramCollection.AddWithValue("@Quantity", model.Quantity);
paramCollection.AddWithValue("@MediaId", model.MediaId);
paramCollection.AddWithValue("@Operation", model.Operation);
paramCollection.AddWithValue("@ParentItemId", model.ParentItemId);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@Id"].Value.ToString(), out waypointItemId);
});
return(waypointItemId);
}
public void WaypointItemUpdate(WaypointItemPickupRequest model, int?jobId, int id)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Jobs_WaypointItemsUpdate"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", model.Id);
paramCollection.AddWithValue("@JobId", jobId);
paramCollection.AddWithValue("@WaypointId", id);
paramCollection.AddWithValue("@ItemTypeId", model.ItemTypeId);
paramCollection.AddWithValue("@ItemNote", model.ItemNote);
paramCollection.AddWithValue("@Quantity", model.Quantity);
paramCollection.AddWithValue("@MediaId", model.MediaId);
paramCollection.AddWithValue("@Operation", model.Operation);
});
}
