public void SaveItem(InventoryItem item)
{
var statement = FOLDER_ITEM_UPDATE_STMT.Bind(item.Name, item.AssetId, item.AssetType, item.BasePermissions, item.CreationDate, item.CreatorId,
item.CurrentPermissions, item.Description, item.EveryonePermissions, item.Flags, item.GroupId, item.GroupOwned, item.GroupPermissions,
item.InventoryType, item.NextPermissions, item.SaleType, item.FolderId, item.ItemId);
_session.Execute(statement);
VersionInc(item.OwnerId, item.FolderId);
}
public void MoveItem(InventoryItem item, InventoryFolder parentFolder)
{
var insert = FOLDER_ITEM_INSERT_STMT.Bind(parentFolder.FolderId, item.ItemId, item.Name, item.AssetId, item.AssetType,
item.BasePermissions, item.CreationDate, item.CreatorId, item.CurrentPermissions, item.Description, item.EveryonePermissions,
item.Flags, item.GroupId, item.GroupOwned, item.GroupPermissions, item.InventoryType, item.NextPermissions,
item.OwnerId, item.SaleType);
var removeOld = FOLDER_ITEM_REMOVE_STMT.Bind(item.FolderId, item.ItemId);
var ownershipUpdate = ITEM_OWNERSHIP_UPDATE.Bind(parentFolder.FolderId, item.ItemId);
var batch = new BatchStatement()
.Add(insert)
.Add(ownershipUpdate)
.Add(removeOld);
_session.Execute(batch);
VersionInc(item.OwnerId, item.FolderId);
VersionInc(item.OwnerId, parentFolder.FolderId);
}
public void PurgeItem(InventoryItem item)
{
var removeItem = FOLDER_ITEM_REMOVE_STMT.Bind(item.FolderId, item.ItemId);
var removeOwnership = ITEM_OWNERSHIP_REMOVE.Bind(item.ItemId);
var batch = new BatchStatement()
.Add(removeItem)
.Add(removeOwnership);
_session.Execute(batch);
VersionInc(item.OwnerId, item.FolderId);
}
public void CreateItem(InventoryItem item)
{
var folderInsert = FOLDER_ITEM_INSERT_STMT.Bind(item.FolderId, item.ItemId, item.Name, item.AssetId, item.AssetType,
item.BasePermissions, item.CreationDate, item.CreatorId, item.CurrentPermissions, item.Description, item.EveryonePermissions,
item.Flags, item.GroupId, item.GroupOwned, item.GroupPermissions, item.InventoryType, item.NextPermissions,
item.OwnerId, item.SaleType);
var itemOwnership = ITEM_OWNERSHIP_INSERT.Bind(item.ItemId, item.FolderId);
var batch = new BatchStatement()
.Add(folderInsert)
.Add(itemOwnership);
_session.Execute(batch);
VersionInc(item.OwnerId, item.FolderId);
}