public InventoryAutoGenerator()
{
DataSet data = db.Select("*", InventoryItem.Table);
db.BeginTransaction();
while (data.Read())
{
InventoryItem item = new InventoryItem(data.GetRecordDataSet());
Random rnd = new Random();
int quantity = rnd.Next(1, 1000);
float price = (float)rnd.Next(1, 20) * (float)rnd.NextDouble();
item.setQuantity(quantity);
item.setCurrentCost(price);
item.setAverageCost(price);
item.SaveObject(db);
}
db.CommitTransaction();
}
private void cmboItemID_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
if (itemIDs.Contains(cmboItemID.Text.ToUpper()))
{
DataSet data = db.Select("*", InventoryItem.Table, InventoryItem.Fields.itemID.ToString() + " = '" + cmboItemID.Text.ToUpper()+"'");
data.Read();
InventoryItem item = new InventoryItem(data.GetRecordDataSet());
SelectedItem = item;
RoutedEventArgs args = new RoutedEventArgs(ObjectSelectedEvent);
RaiseEvent(args);
this.Close();
}
else
{
MessageBox.Show("Item Does not exist in the database. Please try again or add the missing item.", "Item Does not exist!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
private void dgItems_MouseDown(object sender, MouseButtonEventArgs e)
{
if (e.ClickCount == 2)
{
if (dgItems.SelectedCells.Count > 0)
{
InventoryItemBinding obj = (InventoryItemBinding)dgItems.SelectedCells[0].Item;
dataGridViewData.SeekToPrimaryKey(obj.itemID);
InventoryItem item = new InventoryItem(dataGridViewData.GetRecordDataSet());
SelectedItem = item;
RoutedEventArgs args = new RoutedEventArgs(ObjectSelectedEvent);
RaiseEvent(args);
this.Close();
}
}
}
/// <summary>
/// Sets the InventoryItem for temporary use only.
/// </summary>
/// <param name="pItem"></param>
public void SetInventoryItem(InventoryItem pItem)
{
item = pItem;
}
private void RecalculateAverage(InventoryItem item)
{
try
{
DataSet dataSet = db.Select("inventory_item_transactions.*", "inventory_transactions, inventory_item_transactions", "inventory_transactions.transactionID = inventory_item_transactions.transactionID AND inventory_transactions.ClientType = 2 AND inventory_item_transactions.itemID = '" + item.getItemID() + "'",InventoryTransaction.Fields.DateOfTransaction.ToString());
item.setQuantity(0);
item.setCurrentCost(0);
item.setAverageCost(0);
item.SaveObject(db);
float qty = 0;
float avg = 0;
while (dataSet.Read())
{
InventoryTransactionItem transItem = new InventoryTransactionItem(dataSet.GetRecordDataSet());
if (!transItem.GetTransactionID().Equals(mTransaction.GetTransactionID()))
{
qty += transItem.GetQuantity();
avg = (avg * qty) + (transItem.GetUnitPrice() * transItem.GetQuantity());
avg = avg / (qty + transItem.GetQuantity());
item.setCurrentCost(transItem.GetUnitPrice());
}
}
item.setAverageCost(avg);
item.setQuantity(qty);
item.SaveObject(db);
}
catch (Exception ex)
{
MessageBox.Show("Failed to Recalculate new average of item - " + msgCodes.GetString("M2102") + " " + ex.Message, "Error - 2102", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
