public bool deleteItemsInventory(int[] itemIDs, string username) { //deletes a list of items from inventory try { //loop through the list of itemIDs for (int x = 0; x < itemIDs.Length; x++) { // This uses a lambda expression query to create a inventory table object that corresponds to the current item id InventoryTable deleteitem = DataContextInv.InventoryTables.FirstOrDefault(e => e.ItemID.Equals(itemIDs[x])); //delete the item DataContextInv.InventoryTables.DeleteOnSubmit(deleteitem); //generate a log message string message = username + " has removed " + deleteitem.ItemName + " from inventory "; AddLogEntry(username, message); DataContextInv.SubmitChanges(); } return(true); } catch (Exception e) { Console.WriteLine(e.ToString()); return(false); } }
public bool addNewItemInventory(string _itemName, int _quantity, string Category, string username) { try { InventoryTable newItem = new InventoryTable(); newItem.ItemName = _itemName; newItem.Quantity = _quantity; newItem.CategoryName = Category; DataContextInv.InventoryTables.InsertOnSubmit(newItem); DataContextInv.SubmitChanges(); string message = username + " Has added " + _itemName + " to inventory," + " quantity " + _quantity + " category " + Category; AddLogEntry(username, message); return(true); } catch (Exception e) { Console.WriteLine(e.ToString()); return(false); } }
public void TransferItemsToForWITHsellByDate(InventoryTable itemToTransfer, DateTime sellbydate, string username) { //get the transferred item from inventory first var oldItem = DataContextInv.InventoryTables.Single(x => x.ItemID == itemToTransfer.ItemID); Console.WriteLine("is " + itemToTransfer.Quantity + " < " + oldItem.Quantity); if (itemToTransfer.Quantity < oldItem.Quantity) { //update the quantity of the item in inventory oldItem.Quantity = oldItem.Quantity - itemToTransfer.Quantity; ForSaleTable transitem = new ForSaleTable(); transitem.ItemName = itemToTransfer.ItemName; transitem.Quantity = itemToTransfer.Quantity; transitem.SellByDate = sellbydate; transitem.CategoryName = itemToTransfer.CategoryName; DataContextInv.ForSaleTables.InsertOnSubmit(transitem); DataContextInv.SubmitChanges(); GeneratePerformanceLog(transitem); string message = username + " has made " + transitem.Quantity + " " + transitem.ItemName + " available for sale and added the sell by date of " + transitem.SellByDate; AddLogEntry(username, message); } else { ForSaleTable transitem = new ForSaleTable(); transitem.ItemName = itemToTransfer.ItemName; transitem.Quantity = itemToTransfer.Quantity; transitem.SellByDate = sellbydate; transitem.CategoryName = itemToTransfer.CategoryName; DataContextInv.InventoryTables.DeleteOnSubmit(oldItem); DataContextInv.ForSaleTables.InsertOnSubmit(transitem); DataContextInv.SubmitChanges(); GeneratePerformanceLog(transitem); string message = username + " has made " + transitem.ItemName + " available for sale and added the sell by date of " + transitem.SellByDate; AddLogEntry(username, message); } }
public transferItemWindow(InventoryTable item) { InitializeComponent(); itemname_textBox.Text = item.ItemName; globItem = item; }
partial void DeleteInventoryTable(InventoryTable instance);
partial void UpdateInventoryTable(InventoryTable instance);
partial void InsertInventoryTable(InventoryTable instance);
private void detach_InventoryTables(InventoryTable entity) { this.SendPropertyChanging(); entity.CategoryTable = null; }