private void dgTransactionItems_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dgTransactionItems.SelectedIndex > -1)
{
InventoryTransactionItemBinding obj = (InventoryTransactionItemBinding)dgTransactionItems.SelectedCells[0].Item;
mTransactionItem = (InventoryTransactionItem)mTransactionItems[obj.itemID];
if (mTransactionItem.GetInventoryItem() == null)
{
try
{
DataSet data = db.Select("*", InventoryItem.Table, InventoryItem.Fields.itemID.ToString() + " = '" + mTransactionItem.GetItemID() + "'");
data.Read();
mTransactionItem.SetInventoryItem(new InventoryItem(data.GetRecordDataSet()));
}
catch (Exception ex)
{
MessageBox.Show("Loading Item Data - " + msgCodes.GetString("M2102") + ex.Message, "Error - 2102", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
ClearFields();
SelectedItem();
lockItemFields();
txtQuantity.Text = "" + mTransactionItem.GetQuantity();
cmdSaveEditItem.IsEnabled = true;
cmdRemoveItem.IsEnabled = true;
cmdCancelItem.IsEnabled = false;
cmdSaveEditItem.Content = unlockBtnTxt;
if (isFormHidden)
{
displayOrHideForm();
}
}
}
private void LoadDateGrid()
{
mTransactionItems.Clear();
try
{
DataSet data = db.Select("inventory_item_transactions.*,inventory_items.ItemName", "inventory_items LEFT JOIN inventory_item_transactions ON inventory_items.itemID = inventory_item_transactions.itemID", InventoryTransactionItem.Fields.transactionID.ToString() + " = '" + mTransaction.GetTransactionID() + "'");
Collection<InventoryTransactionItemBinding> gridData = data.getBindableCollection<InventoryTransactionItemBinding>();
dgTransactionItems.ItemsSource = gridData;
while (data.Read())
{
InventoryTransactionItem itemObj = new InventoryTransactionItem(data.GetRecordDataSet());
if (!mTransactionItems.ContainsKey(itemObj.GetItemID()))
{
mTransactionItems.Add(itemObj.GetItemID(), itemObj);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Failed loading Transaction Items - " + msgCodes.GetString("M2102") + " " + ex.Message, "Error - 2102", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
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);
}
}
private void selector_ObjectSelected(object sender, RoutedEventArgs e)
{
InventoryItem item;
if (((InventoryItemSelector)sender).SelectedItem != null)
{
if (isFormHidden)
{
displayOrHideForm();
}
item = (InventoryItem)((InventoryItemSelector)sender).SelectedItem;
ClearFields();
if (mTransactionItems.ContainsKey(item.getItemID()))
{
mTransactionItem = (InventoryTransactionItem)mTransactionItems[item.getItemID()];
if (mTransactionItem.GetInventoryItem() == null)
{
mTransactionItem.SetInventoryItem(item);
}
cmdSaveEditItem.Content = unlockBtnTxt;
cmdSaveEditItem.IsEnabled = false;
cmdCancelItem.IsEnabled = false;
cmdRemoveItem.IsEnabled = true;
}
else
{
mTransactionItem = new InventoryTransactionItem(mTransaction.GetTransactionID(), item.getItemID());
mTransactionItem.SetInventoryItem(item);
mTransactionItems.Add(item.getItemID(), mTransactionItem);
cmdSaveEditItem.IsEnabled = false;
cmdCancelItem.IsEnabled = true;
cmdRemoveItem.IsEnabled = false;
cmdSaveEditItem.Content = addBtnTxt;
}
SelectedItem();
}
}
