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