public Shop GetShopByID(int shopid)
{
DbParameter shopIdParameter = _db.CreateParameter(DbNames.GETSHOPBYSHOPID_SHOPID_PARAMETER, shopid);
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETSHOPBYSHOPID_STOREDPROC, CommandType.StoredProcedure, shopIdParameter);
int ordinalShop_shopid = reader.GetOrdinal(DbNames.SHOP_SHOPID);
int ordinalShop_ownerid = reader.GetOrdinal(DbNames.SHOP_OWNERID);
int ordinalShop_name = reader.GetOrdinal(DbNames.SHOP_NAME);
int ordinalShop_description = reader.GetOrdinal(DbNames.SHOP_DESCRIPTION);
int ordinalShop_money = reader.GetOrdinal(DbNames.SHOP_MONEY);
Shop newShop = null;
int shopId = -1;
int ownerId = -1;
int totalMoney = -1;
string name = null;
string desc = null;
while (reader.Read())
{
shopId = reader.GetInt32(ordinalShop_shopid);
ownerId = reader.GetInt32(ordinalShop_ownerid);
totalMoney = reader.GetInt32(ordinalShop_money);
name = reader.GetString(ordinalShop_name);
desc = reader.GetString(ordinalShop_description);
}
reader.Close();
_db.Close();
// add new list creating thing to load shop items ^_ ^
List<BaseItem> items = itemDataManager.GetShopItemsByOwnerID(ownerId);
newShop = new Shop(name, desc, shopid, totalMoney, ownerId, items);
return newShop;
}
public static byte[] SendShopTaxesAmount(Shop shop)
{
Packet p = new Packet(50);
p.WriteInt(shop.TotalMoney);
p.WriteInt(0); // something
p.WriteInt(0); // something
p.WriteShort(4); // something ^_^
p.WriteInt(39); // something
return p.GetWrittenBuffer(PacketIds.SendShopTaxAmount);
}
public void UpdateShopByCharacterID(Shop shop)
{
DbParameter characterIdParameter = _db.CreateParameter(DbNames.UPDATESHOPBYCHARACTERID_CHARACTERID_PARAMETER, shop.OwnerID);
characterIdParameter.DbType = DbType.Int32;
DbParameter nameParameter = _db.CreateParameter(DbNames.UPDATESHOPBYCHARACTERID_NAME_PARAMETER, shop.ShopName);
nameParameter.DbType = DbType.String;
DbParameter descParameter = _db.CreateParameter(DbNames.UPDATESHOPBYCHARACTERID_DESC_PARAMETER, shop.ShopDesc);
descParameter.DbType = DbType.String;
DbParameter totalmoneyParameter = _db.CreateParameter(DbNames.UPDATESHOPBYCHARACTERID_TOTALMONEY_PARAMETER, shop.TotalMoney);
totalmoneyParameter.DbType = DbType.Int32;
_db.Open();
_db.ExecuteNonQuery(DbNames.UPDATESHOPBYCHARACTERID_STOREDPROC,
System.Data.CommandType.StoredProcedure,
characterIdParameter,
nameParameter,
descParameter,
totalmoneyParameter);
_db.Close();
}
public static byte[] SendChangeShopInfo(Shop shop)
{
Packet p = new Packet(50);
p.WriteByte(2); // no idea
p.WriteInt(shop.OwnerID);
p.WriteByte(Convert.ToByte(shop.Active));
p.WriteHexString("00 00 00 00 00 00 00 00 00 00 00");
if (shop.ShopName == "")
p.WriteString("Welcome Xiah GCF by xiahdev.org");
else
p.WriteString(shop.ShopName);
p.WriteString(shop.ShopDesc);
p.WriteHexString("02 00 00 00");
return p.GetWrittenBuffer(PacketIds.SendChangeShopInfo);
}
