private bool CheckItem(ItemWithCategory item) { if (Global.Database.Select <Stock>("stock", new Dictionary <string, object>() { { "ItemID", item.ID } }).Count > 0) { return(false); } if (Global.Database.Select <Shipment>("shipment", new Dictionary <string, object>() { { "ItemID", item.ID } }).Count > 0) { return(false); } if (Global.Database.Select <PartnerShipment>("partnershipment", new Dictionary <string, object>() { { "ItemID", item.ID } }).Count > 0) { return(false); } return(true); }
public ItemEditForm(ItemWithCategory edit) : this() { _edit = edit; tbName.Text = edit.Name; tbDescription.Text = edit.Description; tbPrice.Text = edit.Price.ToString(); }
private void btnNewItem_Click(object sender, System.EventArgs e) { using (ItemEditForm edit = new ItemEditForm()) { if (edit.ShowDialog(this) == DialogResult.OK) { ItemWithCategory newItem = edit.EditedItem; if (Global.Database.InsertInto <Item>("item", newItem)) { DataGridManager.AddDataGridEntry <ItemWithCategory>(gridItems, newItem); } else { Error("Hiba a(z) \"" + edit.EditedItem.Name + "\" hozzáadása közben!", "Hiba!"); } } } }
private void LoadItemsTab() { int selectedEntryID = -1; if (gridItems.SelectedRows.Count > 0) { selectedEntryID = ((ItemWithCategory)gridItems.SelectedRows[0].Tag).ID; } DataGridManager.AddDataGridEntries <ItemWithCategory>(gridItems, ComplexQueries.GetItemsWithCategories(), true, new Action <DataGridViewRow>( (DataGridViewRow row) => { ItemWithCategory sum = (ItemWithCategory)row.Tag; if (selectedEntryID != -1 && sum.ID == selectedEntryID) { row.Selected = true; } } )); }
private void btnDeleteItem_Click(object sender, System.EventArgs e) { DataGridViewRow[] selected = new DataGridViewRow[gridItems.SelectedRows.Count]; gridItems.SelectedRows.CopyTo(selected, 0); foreach (DataGridViewRow row in selected) { ItemWithCategory item = (ItemWithCategory)row.Tag; if (!CheckItem(item)) { Warning("A \"" + item.Name + "\" nem törölhető mert 1 vagy több helyen is használva van!", "Hiba"); continue; } if (!Global.Database.DeleteFrom <Item>("item", item)) { Error("Hiba a sor törlése közben! \"" + item.Name + "\"", "Hiba!"); return; } gridItems.Rows.Remove(row); } }
//GET - INVENTORY public IActionResult Inventory(int?id) { if (id == null || id == 0) { return(NotFound()); } ItemWithCategory _headItem = new ItemWithCategory(); ItemWithCategory _chestItem = new ItemWithCategory(); ItemWithCategory _handItem = new ItemWithCategory(); ItemWithCategory _feetItem = new ItemWithCategory(); ItemWithCategory _ringItem = new ItemWithCategory(); ItemWithCategory _necklaceItem = new ItemWithCategory(); List <Ninja> ninjas = _db.Ninjas.Include("itemOfNinjas").ToList(); Ninja myNinja = ninjas.Where(n => n.Id == id).First(); if (myNinja == null) { return(NotFound()); } if (myNinja.ownerId != _userManager.GetUserId(HttpContext.User)) { return(NotFound()); } int supInt = 0; int supStr = 0; int supDex = 0; int value = 0; foreach (var item in myNinja.itemOfNinjas) { var tempItem = _db.Items.Find(item.ItemId); switch (tempItem.CategoryId) { case 1: _headItem.item = tempItem; _headItem.category = _db.Categories.Find(tempItem.CategoryId); break; case 2: _chestItem.item = tempItem; _chestItem.category = _db.Categories.Find(tempItem.CategoryId); break; case 3: _handItem.item = tempItem; _handItem.category = _db.Categories.Find(tempItem.CategoryId); break; case 4: _feetItem.item = tempItem; _feetItem.category = _db.Categories.Find(tempItem.CategoryId); break; case 5: _ringItem.item = tempItem; _ringItem.category = _db.Categories.Find(tempItem.CategoryId); break; case 6: _necklaceItem.item = tempItem; _necklaceItem.category = _db.Categories.Find(tempItem.CategoryId); break; default: break; } supInt = supInt + tempItem.Intelligence; supStr = supStr + tempItem.Strenght; supDex = supDex + tempItem.Dexterity; value = value + tempItem.Value; } NinjaInventory inv = new NinjaInventory(); inv.Ninja = myNinja; inv.headItem = _headItem; inv.chestItem = _chestItem; inv.handItem = _handItem; inv.feetItem = _feetItem; inv.ringItem = _ringItem; inv.necklaceItem = _necklaceItem; inv.totalInt = supInt; inv.totalStr = supStr; inv.totalDex = supDex; inv.totalItemValue = value; return(View(inv)); }