public static void InsertNewRow(ItemGenerator itemGenerator)
{
OleDbCommand command = Connect();
StringBuilder query = new StringBuilder();
query.Append("INSERT INTO [ItemGenerator](");
for (int i = 1; i < typeof(ItemGenerator).GetProperties().Length - 1; i++)
{
query.Append(typeof(ItemGenerator).GetProperties()[i].Name + ",");
}
query.Append(typeof(ItemGenerator).GetProperties().Last().Name);
query.Append(") VALUES(");
foreach (PropertyInfo prop in itemGenerator.GetType().GetProperties())
{
if (itemGenerator.GetType().GetProperties().ToList().IndexOf(prop) == 0)
{
continue;
}
if (itemGenerator.GetType().GetProperties().ToList().IndexOf(prop) != itemGenerator.GetType().GetProperties().ToList().IndexOf(itemGenerator.GetType().GetProperties().ToList().Last()))
{
query.Append("'" + prop.GetValue(itemGenerator, null).ToString() + "', ");
}
else
{
query.Append("'" + prop.GetValue(itemGenerator, null).ToString() + "')");
}
}
command.CommandText = query.ToString();
command.ExecuteNonQuery();
command.Connection.Close();
}
//public static void UpdateRowAtId(string id, object inputObject)
//{
// OleDbCommand command = Connect();
// StringBuilder query = new StringBuilder();
// switch (inputObject.GetType().Name)
// {
// case "ColorSettings":
// ColorSettings colorSettings = (ColorSettings)inputObject;
// query.Append("UPDATE [Colors] SET ");
// query.Append("[" + typeof(ColorSettings).GetProperties()[1].Name + "] = " + "'" + colorSettings.color_name + "', ");
// query.Append("[" + typeof(ColorSettings).GetProperties()[2].Name + "] = " + "'" + colorSettings.color_window_background + "', ");
// query.Append("[" + typeof(ColorSettings).GetProperties()[3].Name + "] = " + "'" + colorSettings.color_subWindow_background + "', ");
// query.Append("[" + typeof(ColorSettings).GetProperties()[4].Name + "] = " + "'" + colorSettings.color_buttons_background + "', ");
// query.Append("[" + typeof(ColorSettings).GetProperties()[5].Name + "] = " + "'" + colorSettings.color_foreground + "', ");
// query.Append("[" + typeof(ColorSettings).GetProperties()[6].Name + "] = " + "'" + ((bool)colorSettings.color_isActive ? 1 : 0) + "'");
// query.Append(" WHERE color_id = " + id);
// command.CommandText = query.ToString();
// command.ExecuteNonQuery();
// command.Connection.Close();
// break;
// }
// command.Connection.Close();
//}
public static void DeleteRow(ItemGenerator selecetedItemGenerator)
{
OleDbCommand command = Connect();
command.CommandText = "DELETE FROM [ItemGenerator] WHERE item_id = " + selecetedItemGenerator.item_id;
command.ExecuteNonQuery();
command.Connection.Close();
}
private void dg_items_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ItemGenerator selectedItemGenerator = (ItemGenerator)dg_items.SelectedItem;
if (selectedItemGenerator != null)
{
im_selected.Source = new BitmapImage(new Uri(selectedItemGenerator.item_image));
tb_itemImage.Text = System.IO.Path.GetFileName(selectedItemGenerator.item_image);
tb_itemName.Text = selectedItemGenerator.item_name;
cb_itemType.SelectedIndex = selectedItemGenerator.item_type;
tb_item_primaryStat_damageMax_randomMin.Text = selectedItemGenerator.item_primaryStat_damageMax_randomMin.ToString();
tb_item_primaryStat_damageMax_randomMax.Text = selectedItemGenerator.item_primaryStat_damageMax_randomMax.ToString();
tb_item_primaryStat_defenseMax_randomMin.Text = selectedItemGenerator.item_primaryStat_defenseMax_randomMin.ToString();
tb_item_primaryStat_defenseMax_randomMax.Text = selectedItemGenerator.item_primaryStat_defenseMax_randomMax.ToString();
cb_itemRarity.SelectedIndex = selectedItemGenerator.item_rarity;
cb_itemPotionEffect.SelectedIndex = selectedItemGenerator.item_potionEffect;
tb_itemPotionEffectValue.Text = selectedItemGenerator.item_potionEffectValue.ToString();
tb_itemPotionEffectDuration.Text = selectedItemGenerator.item_potionEffectDuration.ToString();
cb_itemQualityFrom.SelectedIndex = selectedItemGenerator.item_qualityFrom;
cb_itemQualityTo.SelectedIndex = selectedItemGenerator.item_qualityTo;
cb_isStackable.IsChecked = (selectedItemGenerator.item_isStackable == 0 ? false : true);
tb_itemQuantityFrom.Text = selectedItemGenerator.item_quantityFrom.ToString();
tb_itemQuantityTo.Text = selectedItemGenerator.item_quantityTo.ToString();
tb_itemLevel.Text = selectedItemGenerator.item_level.ToString();
tb_itemRequiedLevel.Text = selectedItemGenerator.item_requiedHeroLevel.ToString();
tb_bonus1_min.Text = selectedItemGenerator.item_bonus1_min.ToString();
tb_bonus1_max.Text = selectedItemGenerator.item_bonus1_max.ToString();
tb_bonus2_min.Text = selectedItemGenerator.item_bonus2_min.ToString();
tb_bonus2_max.Text = selectedItemGenerator.item_bonus2_max.ToString();
tb_bonus3_min.Text = selectedItemGenerator.item_bonus3_min.ToString();
tb_bonus3_max.Text = selectedItemGenerator.item_bonus3_max.ToString();
tb_bonus4_min.Text = selectedItemGenerator.item_bonus4_min.ToString();
tb_bonus4_max.Text = selectedItemGenerator.item_bonus4_max.ToString();
tb_bonus5_min.Text = selectedItemGenerator.item_bonus5_min.ToString();
tb_bonus5_max.Text = selectedItemGenerator.item_bonus5_max.ToString();
tb_bonus6_min.Text = selectedItemGenerator.item_bonus6_min.ToString();
tb_bonus6_max.Text = selectedItemGenerator.item_bonus6_max.ToString();
tb_bonus7_min.Text = selectedItemGenerator.item_bonus7_min.ToString();
tb_bonus7_max.Text = selectedItemGenerator.item_bonus7_max.ToString();
tb_bonus8_min.Text = selectedItemGenerator.item_bonus8_min.ToString();
tb_bonus8_max.Text = selectedItemGenerator.item_bonus8_max.ToString();
tb_bonus9_min.Text = selectedItemGenerator.item_bonus9_min.ToString();
tb_bonus9_max.Text = selectedItemGenerator.item_bonus9_max.ToString();
tb_bonus10_min.Text = selectedItemGenerator.item_bonus10_min.ToString();
tb_bonus10_max.Text = selectedItemGenerator.item_bonus10_max.ToString();
tb_bonus11_min.Text = selectedItemGenerator.item_bonus11_min.ToString();
tb_bonus11_max.Text = selectedItemGenerator.item_bonus11_max.ToString();
tb_bonus12_min.Text = selectedItemGenerator.item_bonus12_min.ToString();
tb_bonus12_max.Text = selectedItemGenerator.item_bonus12_max.ToString();
tb_bonus13_min.Text = selectedItemGenerator.item_bonus13_min.ToString();
tb_bonus13_max.Text = selectedItemGenerator.item_bonus13_max.ToString();
tb_bonus14_min.Text = selectedItemGenerator.item_bonus14_min.ToString();
tb_bonus14_max.Text = selectedItemGenerator.item_bonus14_max.ToString();
tb_bonus15_min.Text = selectedItemGenerator.item_bonus15_min.ToString();
tb_bonus15_max.Text = selectedItemGenerator.item_bonus15_max.ToString();
tb_bonus16_min.Text = selectedItemGenerator.item_bonus16_min.ToString();
tb_bonus16_max.Text = selectedItemGenerator.item_bonus16_max.ToString();
tb_bonus17_min.Text = selectedItemGenerator.item_bonus17_min.ToString();
tb_bonus17_max.Text = selectedItemGenerator.item_bonus17_max.ToString();
tb_bonus18_min.Text = selectedItemGenerator.item_bonus18_min.ToString();
tb_bonus18_max.Text = selectedItemGenerator.item_bonus18_max.ToString();
tb_bonus19_min.Text = selectedItemGenerator.item_bonus19_min.ToString();
tb_bonus19_max.Text = selectedItemGenerator.item_bonus19_max.ToString();
tb_bonus20_min.Text = selectedItemGenerator.item_bonus20_min.ToString();
tb_bonus20_max.Text = selectedItemGenerator.item_bonus20_max.ToString();
tb_bonus21_min.Text = selectedItemGenerator.item_bonus21_min.ToString();
tb_bonus21_max.Text = selectedItemGenerator.item_bonus21_max.ToString();
tb_bonus22_min.Text = selectedItemGenerator.item_bonus22_min.ToString();
tb_bonus22_max.Text = selectedItemGenerator.item_bonus22_max.ToString();
}
}
private void bt_save_Click(object sender, RoutedEventArgs e)
{
ItemGenerator itemGenerator = new ItemGenerator();
itemGenerator.item_name = tb_itemName.Text.ToString();
itemGenerator.item_image = tb_itemImage.Text.ToString();
if (cb_itemType.SelectedItem != null)
{
itemGenerator.item_type = cb_itemType.SelectedIndex;
}
if (cb_itemRarity.SelectedItem != null)
{
itemGenerator.item_rarity = cb_itemRarity.SelectedIndex;
}
if (cb_itemPotionEffect.SelectedItem != null)
{
itemGenerator.item_potionEffect = cb_itemPotionEffect.SelectedIndex;
}
itemGenerator.item_potionEffectValue = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_itemPotionEffectValue.Text));
itemGenerator.item_potionEffectDuration = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_itemPotionEffectDuration.Text));
itemGenerator.item_primaryStat_damageMax_randomMin = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_item_primaryStat_damageMax_randomMin.Text));
itemGenerator.item_primaryStat_damageMax_randomMax = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_item_primaryStat_damageMax_randomMax.Text));
itemGenerator.item_primaryStat_defenseMax_randomMin = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_item_primaryStat_defenseMax_randomMin.Text));
itemGenerator.item_primaryStat_defenseMax_randomMax = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_item_primaryStat_defenseMax_randomMax.Text));
itemGenerator.item_level = Convert.ToInt32(tb_itemLevel.Text);
itemGenerator.item_requiedHeroLevel = Convert.ToInt32(tb_itemRequiedLevel.Text);
itemGenerator.item_quantityFrom = Convert.ToInt32(tb_itemQuantityFrom.Text);
itemGenerator.item_quantityTo = Convert.ToInt32(tb_itemQuantityTo.Text);
itemGenerator.item_isStackable = ((bool)cb_isStackable.IsChecked ? 1 : 0);
if (cb_itemQualityFrom.SelectedItem != null && cb_itemQualityTo.SelectedItem != null)
{
itemGenerator.item_qualityFrom = cb_itemQualityFrom.SelectedIndex;
itemGenerator.item_qualityTo = cb_itemQualityTo.SelectedIndex;
}
itemGenerator.item_bonus1_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus1_min.Text));
itemGenerator.item_bonus1_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus1_max.Text));
itemGenerator.item_bonus2_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus2_min.Text));
itemGenerator.item_bonus2_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus2_max.Text));
itemGenerator.item_bonus3_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus3_min.Text));
itemGenerator.item_bonus3_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus3_max.Text));
itemGenerator.item_bonus4_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus4_min.Text));
itemGenerator.item_bonus4_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus4_max.Text));
itemGenerator.item_bonus5_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus5_min.Text));
itemGenerator.item_bonus5_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus5_max.Text));
itemGenerator.item_bonus6_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus6_min.Text));
itemGenerator.item_bonus6_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus6_max.Text));
itemGenerator.item_bonus7_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus7_min.Text));
itemGenerator.item_bonus7_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus7_max.Text));
itemGenerator.item_bonus8_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus8_min.Text));
itemGenerator.item_bonus8_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus8_max.Text));
itemGenerator.item_bonus9_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus9_min.Text));
itemGenerator.item_bonus9_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus9_max.Text));
itemGenerator.item_bonus10_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus10_min.Text));
itemGenerator.item_bonus10_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus10_max.Text));
itemGenerator.item_bonus11_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus11_min.Text));
itemGenerator.item_bonus11_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus11_max.Text));
itemGenerator.item_bonus12_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus12_min.Text));
itemGenerator.item_bonus12_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus12_max.Text));
itemGenerator.item_bonus13_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus13_min.Text));
itemGenerator.item_bonus13_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus13_max.Text));
itemGenerator.item_bonus14_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus14_min.Text));
itemGenerator.item_bonus14_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus14_max.Text));
itemGenerator.item_bonus15_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus15_min.Text));
itemGenerator.item_bonus15_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus15_max.Text));
itemGenerator.item_bonus16_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus16_min.Text));
itemGenerator.item_bonus16_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus16_max.Text));
itemGenerator.item_bonus17_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus17_min.Text));
itemGenerator.item_bonus17_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus17_max.Text));
itemGenerator.item_bonus18_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus18_min.Text));
itemGenerator.item_bonus18_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus18_max.Text));
itemGenerator.item_bonus19_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus19_min.Text));
itemGenerator.item_bonus19_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus19_max.Text));
itemGenerator.item_bonus20_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus20_min.Text));
itemGenerator.item_bonus20_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus20_max.Text));
itemGenerator.item_bonus21_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus21_min.Text));
itemGenerator.item_bonus21_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus21_max.Text));
itemGenerator.item_bonus22_min = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus22_min.Text));
itemGenerator.item_bonus22_max = Convert.ToInt32(StaticHelper.ifStringEmpty(tb_bonus22_max.Text));
DatabaseContorller.InsertNewRow(itemGenerator);
bt_new_Click(null, null);
//bemásolja azt a képet amelyik ki lett választva
string from = debugFolder + "wowicons\\" + itemGenerator.item_image;
string to = from.Replace(" ItemCreator", "").Replace("wowicons\\", "Images\\");
File.Copy(from, to, true);
GetData();
}
public static List <ItemGenerator> GetAllData()
{
OleDbCommand command = Connect();
command.CommandText = "SELECT * FROM [ItemGenerator]";
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
adapter.Fill(dt);
string debugFolder = System.AppDomain.CurrentDomain.BaseDirectory;
List <ItemGenerator> ItemGenerators = new List <ItemGenerator>();
foreach (DataRow row in dt.Rows)
{
ItemGenerator itemGenerator = new ItemGenerator();
//foreach (PropertyInfo prop in itemGenerator.GetType().GetProperties())
//{
// int index = itemGenerator.GetType().GetProperties().ToList().IndexOf(prop);
// string rowString = row.ItemArray[index].ToString();
// var type = Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType;
// switch (type.Name)
// {
// case "Int32": prop.SetValue(itemGenerator,Convert.ToInt32(row.ItemArray[index]));
// break;
// case "String": prop.SetValue(itemGenerator, row.ItemArray[index].ToString());
// break;
// case "Boolean": prop.SetValue(itemGenerator,Convert.ToBoolean(row.ItemArray[index]));
// break;
// }
//}
//ItemGenerators.Add(itemGenerator);
itemGenerator.item_id = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(true)]);
itemGenerator.item_name = row.ItemArray[StaticHelper.IndexLine(false)].ToString();
itemGenerator.item_image = debugFolder + "wowicons\\" + row.ItemArray[StaticHelper.IndexLine(false)].ToString();
itemGenerator.item_type = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_rarity = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_potionEffect = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_potionEffectValue = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_potionEffectDuration = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_level = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_requiedHeroLevel = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_quantityFrom = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_quantityTo = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_isStackable = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_qualityFrom = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_qualityTo = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)].ToString());
itemGenerator.item_primaryStat_damageMax_randomMin = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_primaryStat_damageMax_randomMax = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_primaryStat_defenseMax_randomMin = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_primaryStat_defenseMax_randomMax = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus1_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus1_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus2_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus2_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus3_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus3_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus4_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus4_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus5_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus5_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus6_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus6_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus7_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus7_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus8_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus8_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus9_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus9_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus10_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus10_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus11_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus11_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus12_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus12_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus13_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus13_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus14_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus14_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus15_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus15_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus16_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus16_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus17_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus17_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus18_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus18_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus19_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus19_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus20_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus20_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus21_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus21_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus22_min = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
itemGenerator.item_bonus22_max = Convert.ToInt32(row.ItemArray[StaticHelper.IndexLine(false)]);
ItemGenerators.Add(itemGenerator);
}
adapter.Dispose();
command.Connection.Close();
return(ItemGenerators);
}
