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