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); }