private bool UpdateAdjustDetailedEntry(DataTable aTable, int GeneralNumber) { try { AdjustInventoryDetailed aAdjustDetailed = new AdjustInventoryDetailed(); foreach (DataRow aRow in aItemsTable.Rows) { aAdjustDetailed.Number = GeneralNumber; aAdjustDetailed.ItemID = int.Parse(aRow["ItemID"].ToString()); aAdjustDetailed.OldQty = double.Parse(aRow["NewQty"].ToString());/* bug it should be updated to the next one*/ aAdjustDetailed.NewQty = double.Parse(aRow["PhysicalCountColumn"].ToString()); aAdjustDetailed.DifferenceQty = double.Parse(aRow["DifferencesColumn"].ToString()); aAdjustDetailed.DifferenceValue = double.Parse(aRow["DiffValueColumn"].ToString()); double CurrentQty = double.Parse(ReportsHelper.FindData(AllItemsTable,"ID","Qty",aRow["ItemID"].ToString())); if (AdjustInventoryDetailedMgmt.UpdateDetailedSingleEntry(aAdjustDetailed)) { if (!ItemsMgmt.UpdateItemQtyByID(aAdjustDetailed.ItemID, (CurrentQty - (aAdjustDetailed.OldQty - aAdjustDetailed.NewQty)))) { return false; } continue; } else { return false; } } return true; } catch (Exception ex) { MessageBox.Show("Exception in UpdateAdjustDetailedEntry {EXCEPTION}" + ex.ToString(), "PLEASE CONTACT CALCIUM", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } }
private bool AddAdjustDetailedEntry(DataTable aTable, int GeneralNumber) { try { AdjustInventoryDetailed aAdjustDetailed = new AdjustInventoryDetailed(); foreach (DataRow aRow in aItemsTable.Rows) { if (double.Parse(aRow["DifferencesColumn"].ToString()) == 0) { continue; } aAdjustDetailed.Number = GeneralNumber; aAdjustDetailed.ItemID = int.Parse(aRow["ID"].ToString()); aAdjustDetailed.OldQty = double.Parse(aRow["Qty"].ToString()); aAdjustDetailed.NewQty = double.Parse(aRow["PhysicalCountColumn"].ToString()); aAdjustDetailed.DifferenceQty = double.Parse(aRow["DifferencesColumn"].ToString()); aAdjustDetailed.DifferenceValue = double.Parse(aRow["DiffValueColumn"].ToString()); if (AdjustInventoryDetailedMgmt.AddAdjustDetailedItem(aAdjustDetailed)) { if (!ItemsMgmt.UpdateItemQtyByID(aAdjustDetailed.ItemID, aAdjustDetailed.NewQty)) { return false; } continue; } else { return false; } } return true; } catch (Exception ex) { MessageBox.Show("Exception in AddAdjustDetailedEntry {EXCEPTION}" + ex.ToString(), "PLEASE CONTACT CALCIUM", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } }