public static SlotItem[] GetItemsForCharacter(CharacterManager.ItemType type, int?characterId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.SelectFrom(TableName, new string[] { "*" },
new WhereFilter(ColumnNames.TypeId, (int)type),
new WhereFilter(ColumnNames.CharacterId, characterId)
);
return(Storage.ExecuteArray <SlotItem>(bl));
}
}
public static int GetItem(CharacterManager.ItemType type, int slot, int?characterId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.SelectFrom(TableName, new string[] { ColumnNames.Id },
new WhereFilter(ColumnNames.TypeId, (int)type),
new WhereFilter(ColumnNames.Slot, slot),
new WhereFilter(ColumnNames.CharacterId, characterId)
);
return((int)Storage.ExecuteScalar <Int32>(bl));
}
}
public static int NewItem(CharacterManager.ItemType type, int netId, int stack, int prefix, int slot, int?userId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.InsertInto(TableName,
new DataParameter(ColumnNames.TypeId, (int)type),
new DataParameter(ColumnNames.NetId, netId),
new DataParameter(ColumnNames.Stack, stack),
new DataParameter(ColumnNames.Prefix, prefix),
new DataParameter(ColumnNames.Slot, slot),
new DataParameter(ColumnNames.UserId, userId)
);
return((int)Storage.ExecuteInsert(bl)); //Get the new ID
}
}
public static bool UpdateItem(CharacterManager.ItemType type, int netId, int prefix, int stack, bool favorite, int slot, int?characterId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.Update(TableName, new DataParameter[]
{
new DataParameter(ColumnNames.NetId, netId),
new DataParameter(ColumnNames.Prefix, prefix),
new DataParameter(ColumnNames.Stack, stack),
new DataParameter(ColumnNames.Favorite, favorite)
},
new WhereFilter(ColumnNames.TypeId, (int)type),
new WhereFilter(ColumnNames.Slot, slot),
new WhereFilter(ColumnNames.CharacterId, characterId)
);
return(Storage.ExecuteNonQuery(bl) > 0);
}
}
