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