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