private void AddAuthorBtn_Click(object sender, RoutedEventArgs e)
{
if (CheckAuthorField())
{
return;
}
Authors a = new Authors()
{
Author = AName.Text
};
DbDataAccess.SaveAuthor(a);
ListOfAutors.ItemsSource = DbDataAccess.GetAuthors();
AName.Clear();
}
void getAddressID()
{
string addressID = "select ADD_ID from ADDRESS ORDER BY ADD_ID";
string AName;
int AID;
string format = "0000000";
SqlDataAdapter ad = new SqlDataAdapter(addressID, consql);
DataSet ds = new DataSet();
ad.Fill(ds, "ADDRESS");
if (ds.Tables["ADDRESS"].Rows.Count > 0)
{
AName = ds.Tables["ADDRESS"].Rows[ds.Tables["ADDRESS"].Rows.Count - 1][0].ToString();
AID = int.Parse(AName.Substring(1, (AName.Length - 1)));
addID = "A" + ((AID + 1).ToString(format));
}
else
{
addID = "A0000001";
}
}
public void RefreshTheList()
{
foreach (string AName in MagicNamesGS)
{
Item item = ScriptableObject.CreateInstance <Item>(); //new Item();
item.Price = DataController.GetValue <int>(AName + "Price");
if (DataController.GetValue <int>(AName + "ammount") == 0)
{
item.ammount = 0;
}
else
{
item.ammount = 1;
}
}
foreach (string AName in NewNamesGS)
{
item = (Equipment)ScriptableObject.CreateInstance(typeof(Equipment));
item.name = AName;
item.icon = Resources.Load <Sprite>("Pic" + AName); // add sprites in the Resources folder with names same as NewName variables here
item.Price = DataController.GetValue <int>(AName + "Price");
item.SellPrice = DataController.GetValue <int>(AName + "SellPrice");
item.ModifierArmor = DataController.GetValue <int>(AName + "ModifierArmor");
item.ModifierDamage = DataController.GetValue <int>(AName + "ModifierDamage");
item.ModifierMissChance = DataController.GetValue <int>(AName + "ModifierMissChance");
item.ModifierCriticalChance = DataController.GetValue <int>(AName + "ModifierCriticalChance");
item.ModifierBashChance = DataController.GetValue <int>(AName + "ModifierBashChance");
item.ModifierStunChance = DataController.GetValue <int>(AName + "ModifierStunChance");
item.ModifierBlockChance = DataController.GetValue <int>(AName + "ModifierBlockChance");
item.ModifierMagic = DataController.GetValue <int>(AName + "ModifierMagic");
if (DataController.GetValue <int>(AName + "ammount") == 0)
{
item.ammount = 0;
}
else
{
item.ammount = 1;
}
if (AName.Contains("LongSword"))
{
item.equipSlot = EquipmentSlot.BothHands;
LongSwords.instance.Add(item);
}
else
if (AName.Contains("Sword"))
{
item.equipSlot = EquipmentSlot.RightHand;
Swords.instance.Add(item);
}
else
if (AName.Contains("Axe"))
{
item.equipSlot = EquipmentSlot.RightHand;
Axes.instance.Add(item);
}
else
if (AName.Contains("Spear"))
{
item.equipSlot = EquipmentSlot.RightHand;
Spears.instance.Add(item);
}
else
if (AName.Contains("Hammer"))
{
item.equipSlot = EquipmentSlot.BothHands;
Hammers.instance.Add(item);
}
else
if (AName.Contains("Daggers"))
{
item.equipSlot = EquipmentSlot.BothHands;
Daggers.instance.Add(item);
}
if (AName.Contains("Helmet"))
{
item.equipSlot = EquipmentSlot.Head;
Head.instance.Add(item);
}
else
if (AName.Contains("BreastPlate"))
{
item.equipSlot = EquipmentSlot.Chest;
Chest.instance.Add(item);
}
else
if (AName.Contains("Sleeves"))
{
item.equipSlot = EquipmentSlot.Arms;
Arms.instance.Add(item);
}
else
if (AName.Contains("Pants"))
{
item.equipSlot = EquipmentSlot.Legs;
Legs.instance.Add(item);
}
else
if (AName.Contains("Boots"))
{
item.equipSlot = EquipmentSlot.Feet;
Feet.instance.Add(item);
}
else
if (AName.Contains("Shield"))
{
item.equipSlot = EquipmentSlot.LeftHand;
Shields.instance.Add(item);
}
DataController.SaveValue(item.name + "equipSlot", Equipment.PossibleSlots[(int)item.equipSlot]);
if (item.ammount > 0)
{
ItemPickup.PickUpToInv(item);
}
}
}
