public static weapon_skins GetWeaponSkins(string weaponSkinName) { string query = "SELECT name, IF(is_New = 0, 'Old', 'New') AS status, IF(is_Available = 1, 'Purchasable', 'Not Purchasable') AS availability, collection_set AS collection, price FROM weapon_skins WHERE name = (@WeaponSkinName) limit 1"; cmd = DBHelper.GetWeaponSkinQuery(query, weaponSkinName); weapon_skins aUser = null; if (cmd != null) { dt = new DataTable(); sda = new MySqlDataAdapter(cmd); sda.Fill(dt); foreach (DataRow dr in dt.Rows) { string uWeaponSkinName = dr["name"].ToString(); string uIsWeaponNew = dr["status"].ToString(); string uIsWeaponAvailable = dr["availability"].ToString(); string uWeaponSkinPrice = dr["price"].ToString(); string uWeaponSkinSet = dr["collection"].ToString(); aUser = new weapon_skins(uWeaponSkinName, uIsWeaponNew, uIsWeaponAvailable, uWeaponSkinPrice, uWeaponSkinSet); } } return(aUser); }
private void FindWeaponSkin(string name) { weapon_skins WeaponSkin = weapon_skinsDA.GetWeaponSkins(name); if (WeaponSkin != null) { avail.Text = "Availability: "; price_w.Text = "Price: "; new_.Text = "Status: "; cs.Text = "Collection: "; weapon_name.Text = name; isNew.Text = WeaponSkin.IsWeaponNew; available.Text = WeaponSkin.IsWeaponAvailable; price.Text = WeaponSkin.WeaponSkinPrice.ToString(); collection.Text = WeaponSkin.WeaponSkinSet; } else { MessageBox.Show($"Invalid Weapon Skin! Try Again!"); } }