public static ArrayList GetDonationGiftList(string username) { //get a list of item from redeemable_gift table ArrayList redeemableGifts = new ArrayList(); IDbConnection connection = null; IDbCommand command = null; IDataReader reader = null; try { connection = new OdbcConnection(ConnectionString); connection.Open( ); command = connection.CreateCommand( ); command.CommandText = String.Format("SELECT redeemable_gift.id AS id, redeemable_gift.type_id AS type, gift_type.type_name AS name FROM redeemable_gift INNER JOIN gift_type ON redeemable_gift.type_id=gift_type.type_id WHERE redeemable_gift.account_name='{0}' ORDER BY redeemable_gift.id ASC", username); reader = command.ExecuteReader(); while (reader.Read()) { int giftId = System.Convert.ToInt32(reader["id"]); int giftTypeId = System.Convert.ToInt32(reader["type"]); string giftName = (string)reader["name"]; DonationGift gift = new DonationGift(giftId, giftTypeId, giftName); redeemableGifts.Add(gift); } reader.Close(); } catch (Exception e) { Console.WriteLine("[Retrieve Donation Gift List] Error..."); Console.WriteLine(e); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } if (command != null && connection != null) { command.Dispose(); connection.Close(); connection.Dispose(); } } return(redeemableGifts); }
public static ArrayList GetDonationGiftList(string username) { //get a list of item from redeemable_gift table ArrayList redeemableGifts = new ArrayList(); IDbConnection connection = null; IDbCommand command = null; IDataReader reader = null; try { connection = new OdbcConnection( ConnectionString ); connection.Open( ); command = connection.CreateCommand( ); command.CommandText = String.Format("SELECT redeemable_gift.id AS id, redeemable_gift.type_id AS type, gift_type.type_name AS name FROM redeemable_gift INNER JOIN gift_type ON redeemable_gift.type_id=gift_type.type_id WHERE redeemable_gift.account_name='{0}' ORDER BY redeemable_gift.id ASC", username); reader = command.ExecuteReader(); while (reader.Read()) { int giftId = System.Convert.ToInt32(reader["id"]); int giftTypeId = System.Convert.ToInt32(reader["type"]); string giftName = (string)reader["name"]; DonationGift gift = new DonationGift(giftId, giftTypeId, giftName); redeemableGifts.Add(gift); } reader.Close(); } catch( Exception e ) { Console.WriteLine( "[Retrieve Donation Gift List] Error..." ); Console.WriteLine( e ); } finally { if (reader != null && !reader.IsClosed) reader.Close(); if (command != null && connection != null) { command.Dispose(); connection.Close(); } } return redeemableGifts; }
public static void ClaimAllDonationItems_OnCommand(CommandEventArgs e) { PlayerMobile pm = (PlayerMobile)e.Mobile; BankBox box = pm.FindBankNoCreate(); ArrayList itemList = GetDonationGiftList(pm.Account.Username); for (int i = 0; i < itemList.Count; i++) { DonationGift giftInfo = (DonationGift)itemList[i]; Item gift = RedeemGift(giftInfo.Id, pm.Account.Username) as Item; if (!box.TryDropItem(pm, gift, false)) { pm.AddToBackpack(gift); } } pm.SendMessage("{0} items has been placed in your bank box. Thank you for your donation!", itemList.Count); }