public IActionResult Create(int?warehouseId, int?employeeId) { inventoryItems inventory = new inventoryItems(); if (warehouseId != null) { inventory.WarehouseId = (int)warehouseId; } if (employeeId != null) { inventory.EmployeeId = (int)employeeId; } var InventoryVM = new InventoryViewModel { Employee = _employeeRepository.GetAll(), Warehouses = _warehouseRepository.GetAll(), Inventory = inventory }; return(View(InventoryVM)); }
public IActionResult Update(int id) { inventoryItems inventory = _repository.FindWithWarehouse(a => a.inventoryItemsId == id).FirstOrDefault(); inventoryItems inventory1 = _repository.FindWithEmployee(a => a.inventoryItemsId == id).FirstOrDefault(); if (inventory == null) { return(NotFound()); } if (inventory1 == null) { return(NotFound()); } var InventoryVM = new InventoryViewModel { Inventory = inventory, Warehouses = _warehouseRepository.GetAll(), Employee = _employeeRepository.GetAll() }; return(View(InventoryVM)); }
public bool Add(Resources item, int num) { reader = GetComponent <inventoryReaderV2>(); inventoryItems resurce = new inventoryItems(); resurce.item = item; resurce.amount += num; if (Bag.Count <= 0) { Bag.Add(resurce); reader.currentWeight += resurce.item.weight; return(true); } if (Bag.Count > 0) { for (int i = 0; i < Bag.Count; i++) { if (Bag[i].item.typeOfResource == resurce.item.typeOfResource) { Bag[i].amount += num; reader.currentWeight += resurce.item.weight; return(true); } if (i == Bag.Count - 1 && Bag[i].item.typeOfResource != resurce.item.typeOfResource) { Bag.Add(resurce); reader.currentWeight += resurce.item.weight; return(true); } } } return(false); }
partial void DeleteinventoryItems(inventoryItems instance);
partial void UpdateinventoryItems(inventoryItems instance);
partial void InsertinventoryItems(inventoryItems instance);
public frmInventory(string charID, string charName, MySqlConnection conn) { InitializeComponent(); this.Text = "Inventory of: " + charName; connection = conn; connection2 = conn.Clone(); connection3 = conn.Clone(); connection2.Open(); connection3.Open(); chId = charID; // connection.Close(); // connection.Open(); ArrayList tables = new ArrayList(); tables.AddRange(new object[] { "item_armor", "item_basic", "item_furnishing", "item_usable", "item_weapon" }); int iTables = tables.Count; if (connection.State == ConnectionState.Closed) { connection.Open(); } inventoryItems colItems = new inventoryItems(); string sqlCharItems = "select itemid, location, quantity, bazaar from char_inventory where charid=" + charID + ";"; MySqlCommand myCmd = new MySqlCommand(sqlCharItems, connection); MySqlDataReader myReader = myCmd.ExecuteReader(); while (myReader.Read()) { inventoryItem iItem = new inventoryItem(); iItem.id = Int32.Parse((myReader[0].ToString()), System.Globalization.NumberStyles.Integer); iItem.location = Int32.Parse((myReader[1].ToString()), System.Globalization.NumberStyles.Integer); // iItem.item = (int)myReader[2]; iItem.quantity = Int32.Parse((myReader[2].ToString()), System.Globalization.NumberStyles.Integer); if (myReader[3].ToString() == "1") { iItem.bazaar = true; } else { iItem.bazaar = false; } // myReader.Close(); // myReader.Dispose(); // Determine what the item is and get it's info. // There are 5 tables that hold item information // and we have to find the table and then get the info // item_armor, item_basic, item_furnishing, item_usable, item_weapon // We want itemID, name // I don't care about any other stats, characters can have stuff they can't equip or use, etc // 12/18/11 -- I'm feeling lazy and going to do this the hard way (try each table) string inventoryTable = ""; int curtable = 0; if (iItem.id == 65535) // Gil is 65535 { iItem.description = "Gil"; } else { foreach (string iTable in tables) { string sqlInventoryItem = "select itemid from " + iTable + " where itemid=" + iItem.id + ";"; MySqlCommand myInventoryCmd = new MySqlCommand(sqlInventoryItem, connection2); MySqlDataReader myInventoryReader = myInventoryCmd.ExecuteReader(); if (myInventoryReader.HasRows) { inventoryTable = iTable; myInventoryReader.Close(); myInventoryReader.Dispose(); myInventoryCmd.Dispose(); break; } curtable++; myInventoryReader.Close(); myInventoryReader.Dispose(); myInventoryCmd.Dispose(); } // We found the table, now get the information string sqlItemLookup = ""; switch (inventoryTable) { case "item_armor": sqlItemLookup = "select name, level from item_armor where itemID=" + iItem.id + ";"; break; case "item_basic": sqlItemLookup = "select name from item_basic where itemID=" + iItem.id + ";"; break; case "item_furnishing": sqlItemLookup = "select name from item_furnishing where itemID=" + iItem.id + ";"; break; case "item_usable": sqlItemLookup = "select name from item_usable where itemID=" + iItem.id + ";"; break; case "item_weapon": sqlItemLookup = "select name from item_weapon where itemID=" + iItem.id + ";"; break; } MySqlCommand myItemCmd = new MySqlCommand(sqlItemLookup, connection3); MySqlDataReader myItemReader = myItemCmd.ExecuteReader(); while (myItemReader.Read()) { iItem.description = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myItemReader[0].ToString().Replace('_', ' ')); } myItemReader.Close(); myItemReader.Dispose(); myItemCmd.Dispose(); } colItems.add(iItem); } myReader.Close(); myReader.Dispose(); connection2.Close(); connection3.Close(); connection2.Dispose(); connection3.Dispose(); foreach (inventoryItem item in colItems) { dgvCharInventory.Rows.Add(false, item.id, item.description, item.quantity); } //connection2.Open(); //MySqlCommand allItemsCmd = new MySqlCommand("Select name from item_armor, item_basic, item_furnishing, item_usable, item_weapon;", connection2); //MySqlDataReader myAllItemsReader = allItemsCmd.ExecuteReader(); //ArrayList allItems = new ArrayList(); //while (myAllItemsReader.Read()) //{ // allItems.Add(myAllItemsReader["name"].ToString()); //} //myAllItemsReader.Close(); //myAllItemsReader.Dispose(); //allItems.Sort(); //foreach (string allitem in allItems) //{ // lbAllItems.Items.Add(allitem); //} }