public bool SaveRecord(int?id, bool IsnewInventory = true)
{
if (saveSimpleButton.Tag == null)
{
if (m_AllowAdd == true)
{
saveSimpleButton.Tag = InventoryAdjustmentBLL.GetNewInventoryAdjustmentID();
}
else
{
return(false);
}
}
if (m_Adjustment.UpdateInventoryAdjustment(Convert.ToInt32(saveSimpleButton.Tag), adjustmentDateEdit.DateTime, Convert.ToInt32(customerLookUpEdit.EditValue), Convert.ToInt32(itemLookUpEdit.EditValue), Convert.ToSingle(originalQtyTextEdit.EditValue), Convert.ToSingle(newQtyTextEdit.EditValue), Convert.ToString(reasonMemoExEdit.EditValue), Convert.ToInt32(locationLookUpEdit.EditValue), Convert.ToString(originalLotLookUpEdit.EditValue), newLotTextEdit.Text, Utilities.ChangeType <int?>(lpnLookUpEdit.EditValue), Utilities.ChangeType <DateTime?>(originalLotLookUpEdit.GetColumnValue("Expr")), IsnewInventory) != true)
{
MessageBox.Show("The adjustment record was not updated succesfully.", "Error Encountered", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
else if (m_newLpn && !string.IsNullOrEmpty(originalLotLookUpEdit.Text))
{
LocationInventoryByLot Lpntodelete = Session.DefaultSession.FindObject <LocationInventoryByLot>(new GroupOperator(GroupOperatorType.And, new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber.PropertyName, (object)Utilities.ChangeType <int?>(lpnLookUpEdit.EditValue), BinaryOperatorType.Equal), new BinaryOperator(LocationInventoryByLot.Fields.QuantityOnHand.PropertyName, 0, BinaryOperatorType.Equal), new BinaryOperator("LocationInventoryLot", "", BinaryOperatorType.Equal)));
if (Lpntodelete != null)
{
Lpntodelete.Delete();
Session.DefaultSession.PurgeDeletedObjects();
}
}
printLpn();
inventoryXPView.Reload();
return(true);
}
public static void UpdateStock(Session session, int ItemID, int LocationID, float Quantity, string lot = "", int?LPNNumber = null, DateTime?ExpirationDate = null, bool newInventory = true)
{
if (newInventory)
{
LocationInventory inventory = session.FindObject <LocationInventory>(new BinaryOperator(LocationInventory.Fields.LocationInventoryItem.ItemID.PropertyName, ItemID, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventory.Fields.Location.Oid.PropertyName, LocationID, BinaryOperatorType.Equal));
if (inventory == null)
{
inventory = new LocationInventory(session);
inventory.LocationInventoryItem = session.GetObjectByKey <Items>(ItemID);
inventory.Location = session.GetObjectByKey <Locations>(LocationID);
inventory.QuantityOnHand = Quantity;
}
else
{
inventory.QuantityOnHand += Quantity;
}
inventory.Save();
}
if (((lot == null) || string.IsNullOrEmpty(lot)) && ((LPNNumber == null) || LPNNumber == 0))
{
return;
}
LocationInventoryByLot inventoryByLot = session.FindObject <LocationInventoryByLot>(new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID.PropertyName, ItemID, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.Location.Oid.PropertyName, LocationID, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryLot, lot, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber, (LPNNumber ?? 0), BinaryOperatorType.Equal));
if (inventoryByLot == null)
{
if (Quantity >= 0)
{
inventoryByLot = new LocationInventoryByLot(session);
inventoryByLot.LocationInventoryItem = session.GetObjectByKey <Items>(ItemID);
inventoryByLot.Location = session.GetObjectByKey <Locations>(LocationID);
inventoryByLot.LocationInventoryLot = lot;
inventoryByLot.LPNNumber = LPNNumber;
inventoryByLot.QuantityOnHand = Quantity;
if (ExpirationDate != null)
{
inventoryByLot.ExpirationDate = ExpirationDate;
}
}
else
{
return;
}
}
else
{
inventoryByLot.QuantityOnHand += Quantity;
}
inventoryByLot.Save();
}
private void cancelSimpleButton_Click(object sender, EventArgs e)
{
if (m_newLpn)
{
LocationInventoryByLot Lpntodelete = Session.DefaultSession.FindObject <LocationInventoryByLot>(new GroupOperator(GroupOperatorType.And, new BinaryOperator("LPNNumber", (object)Utilities.ChangeType <int?>(lpnLookUpEdit.EditValue), BinaryOperatorType.Equal), new BinaryOperator(LocationInventoryByLot.Fields.QuantityOnHand.PropertyName, 0, BinaryOperatorType.Equal), new BinaryOperator("LocationInventoryLot", "", BinaryOperatorType.Equal)));
if (Lpntodelete != null)
{
Lpntodelete.Delete();
Session.DefaultSession.PurgeDeletedObjects();
}
}
PrepareNewRecord();
}
public static float GetQtyOnHandByIDAndLot(Session session, int?itemID, int locationID, string lot, int?LPNNumber)
{
if (itemID.HasValue == false || (LPNNumber == null))
{
return(0);
}
//If locationID.HasValue = False Then
// locationID = UsersBLL.GetUsersLocalLocation(My.Settings.UserName).Oid
//End If
try
{
if ((lot == null))
{
if (locationID == 0)
{
return(Convert.ToSingle(session.Evaluate <LocationInventoryByLot>(new AggregateOperand("", LocationInventoryByLot.Fields.QuantityOnHand.PropertyName, Aggregate.Sum), new GroupOperator(GroupOperatorType.And, new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID, itemID.Value, BinaryOperatorType.Equal), new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber, LPNNumber.Value, BinaryOperatorType.Equal)))));
}
else
{
LocationInventoryByLot quantity = session.FindObject <LocationInventoryByLot>(new GroupOperator(new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID, itemID.Value, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.Location.Oid.PropertyName, locationID, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber, LPNNumber.Value, BinaryOperatorType.Equal)));
//Dim item As Items = Session.DefaultSession.GetObjectByKey(Of Items)(itemID, True)
//Return item.s ngQuantityOnHand
return(quantity.QuantityOnHand);
}
}
else
{
if (locationID == 0)
{
return(Convert.ToSingle(session.Evaluate <LocationInventoryByLot>(new AggregateOperand("", LocationInventoryByLot.Fields.QuantityOnHand.PropertyName, Aggregate.Sum), new GroupOperator(GroupOperatorType.And, new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID, itemID.Value, BinaryOperatorType.Equal), new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryLot, lot, BinaryOperatorType.Equal), new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber, LPNNumber.Value, BinaryOperatorType.Equal)))));
}
else
{
LocationInventoryByLot quantity = session.FindObject <LocationInventoryByLot>(new GroupOperator(new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID, itemID.Value, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.Location.Oid.PropertyName, locationID, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryLot, lot, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber, LPNNumber.Value, BinaryOperatorType.Equal)));
//Dim item As Items = Session.DefaultSession.GetObjectByKey(Of Items)(itemID, True)
//Return item.s ngQuantityOnHand
return(quantity.QuantityOnHand);
}
}
}
catch (Exception ex)
{
return(0);
}
}
