public void StockToEditWithLog(int barcode, int location, int quantity, string totalcost, DateTime date)
{
var query = from stock in db.TInStocks
where stock.BarcodeID == barcode && stock.LocationID == location
select stock;
List <int> oldQuantity = (from stock in db.TInStocks
where stock.BarcodeID == barcode && stock.LocationID == location
select stock.Quantity).ToList();
int difference = Math.Abs(quantity - oldQuantity[0]);
MessageBox.Show(difference.ToString());
foreach (TInStock stock in query)
{
stock.Quantity = quantity;
}
TPurchaseLog newLog = new TPurchaseLog
{
BarcodeID = barcode,
LocationID = location,
Date = date,
Quantity = difference,
TotalCost = Convert.ToDecimal(totalcost)
};
// Add the new object to the Orders collection.
db.TPurchaseLogs.InsertOnSubmit(newLog);
//submit changes
try
{
db.SubmitChanges();
MessageBox.Show("Item edited successfully.");
}
catch (Exception e)
{
MessageBox.Show("An error has occured trying to edit this stock item");
MessageBox.Show(e.ToString());
}
}
//new stock item
public void NewStockItem(int barcode, int location, int quantity, string totalcost, DateTime date)
{
DataLinqToSQLDataContext connect = new DataLinqToSQLDataContext();
TInStock newStock = new TInStock
{
BarcodeID = barcode,
LocationID = location,
Quantity = quantity
};
TPurchaseLog newLog = new TPurchaseLog
{
BarcodeID = barcode,
LocationID = location,
Quantity = quantity,
Date = date,
TotalCost = Convert.ToDecimal(totalcost)
};
// Add the new object to the Orders collection.
connect.TInStocks.InsertOnSubmit(newStock);
connect.TPurchaseLogs.InsertOnSubmit(newLog);
// Submit the change to the database.
try
{
connect.SubmitChanges();
MessageBox.Show("Item added to stock successfully.");
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
