private void InventoryAdjustmentXtraForm_Load(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
CheckPermissions();
//Dim fullLPN As String
//fullLPN = CustomersBLL.GetLPNPrefix(7) & Strings.Right("0000000000" & "", Len(CustomersBLL.GetCustomer(7, Session.DefaultSession).LastLPNNumber.ToString))
//lpnLookUpEdit.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric
//lpnLookUpEdit.Properties.DisplayFormat.FormatString = CustomersBLL.GetLPNPrefix(7) & "{0:D" & Len(CustomersBLL.GetCustomer(7, Session.DefaultSession).LastLPNNumber.ToString) & "}"
//lpnXpView.Properties.Add(New ViewProperty("LPN", SortDirection.None, "'" & CustomersBLL.GetLPNPrefix(7) & "' + RIGHT(CONCAT('0000000000',LPNNumber)," & Len(CustomersBLL.GetCustomer(7, Session.DefaultSession).LastLPNNumber.ToString) & ")", True, True))
m_Items = new ItemsBLL();
m_Customers = new CustomersBLL();
m_Adjustment = new InventoryAdjustmentBLL();
PrepareNewRecord();
SetDefaultViewFilter();
FillAdjustmentView();
FilterLpns();
Cursor = Cursors.Default;
}
public static ICollection <Inventory> GetLPNInventoryRecords(Session session, string fullLPNNumber, int customerID)
{
//Dim LPNNumber As Integer = Integer.Parse(fullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(customerID), ""))
ICollection <Inventory> result = new Collection <Inventory>();
result = new XPCollection <Inventory>(session, new BinaryOperator(Inventory.Fields.InventoryItemID.ItemCustomerID.CustomerID.PropertyName, customerID, BinaryOperatorType.Equal) & new BinaryOperator("FullLPNNumber", fullLPNNumber, BinaryOperatorType.Equal));
if (result.Count() == 0 && !fullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(7)))
{
//If customerID = 7 Then
// Dim locationInventorys As XPCollection(Of LocationInventoryByLot) = New XPCollection(Of LocationInventoryByLot)(session,
// New BinaryOperator(LocationInventoryByLot.Fields.LPNNumber.PropertyName, Integer.Parse(fullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(customerID), "")), BinaryOperatorType.Equal))
// If locationInventorys.Count < 1 Then Return result
// Dim locationInventory As LocationInventoryByLot = locationInventorys(0)
// Dim convertToInventory As Inventory = New Inventory(session) With {.InventoryItemID = locationInventory.LocationInventoryItem, .InventoryQuantity = CInt(locationInventory.QuantityOnHand),
// .Lot = locationInventory.LocationInventoryLot, .FullLPNNumber = fullLPNNumber, .ExpirationDate = locationInventory.ExpirationDate}
// result = New Collection(Of Inventory)
// result.Add(convertToInventory)
//Else
result = new XPCollection <Inventory>(session, new BinaryOperator(Inventory.Fields.InventoryItemID.ItemCustomerID.CustomerID.PropertyName, customerID, BinaryOperatorType.Equal) & new BinaryOperator("LPNNumber", int.Parse(fullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(customerID), "")), BinaryOperatorType.Equal));
//End If
}
return(result);
}
private void addBothWaysSimpleButton_Click(System.Object sender, EventArgs e)
{
if (RelatedCustomerBLL.AddRelatedCustomer(CustomersBLL.GetCustomer(m_CurrentCustomer.Value, m_CustomersSession), CustomersBLL.GetCustomer(Convert.ToInt32(relatedCustomerLookUpEdit.EditValue), m_CustomersSession), true) == false)
{
MessageBox.Show("There was a problem while adding the related customer");
}
relatedCustomerXpCollection.Reload();
}
private void resetLPNSimpleButton_Click(object sender, EventArgs e)
{
try
{
Customers customer = CustomersBLL.GetCustomer(m_CurrentCustomer.Value, m_CustomersSession);
customer.NextLPNNumber = Convert.ToInt32(firstLPNNumberTextEdit.EditValue);
customer.Save();
}
catch
{
MessageBox.Show("The LPN labels were not reset.");
}
}
private bool SaveChanges()
{
int selectedID = -1;
if (m_CurrentPoolID.Oid == -1)
{
}
else
{
selectedID = poolSearchGridView.FocusedRowHandle;
}
if (ItemPoolBLL.ValidateRecord(codeTextEdit.Text, (int?)customerLookUpEdit.EditValue))
{
m_CurrentPoolID.PoolCode = codeTextEdit.Text;
m_CurrentPoolID.PoolDescription = descriptionMemoEdit.Text;
m_CurrentPoolID.PoolCustomerID = CustomersBLL.GetCustomer(Convert.ToInt32(customerLookUpEdit.EditValue), m_ItemPoolSession);
m_CurrentPoolID.PoolType = "BP";
}
else
{
MessageBox.Show("You must provide a Pool Code, and Customer name before saving the record.");
return(false);
}
try
{
m_CurrentPoolID.Save();
}
catch (ApplicationException ex)
{
MessageBox.Show(ex.Message, "Error Encountered", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
//Save the details here
foreach (ItemPoolDetails poolDetail in poolDetailsXpCollection)
{
if (poolDetail.ItemPoolID == null || poolDetail.ItemPoolID.Oid == -1)
{
poolDetail.ItemPoolID = m_CurrentPoolID;
}
poolDetail.Save();
}
BindPoolSearch();
BindPoolControls(m_CurrentPoolID.Oid);
poolSearchGridView.FocusedRowHandle = selectedID;
return(true);
}
public void BindCustomersControls(int customerID)
{
m_CustomersSession.DropIdentityMap();
Customers customer = CustomersBLL.GetCustomer(customerID, m_CustomersSession);
m_CurrentCustomer = customer.CustomerID;
nameTextEdit.Text = customer.CustomerName;
contactTextEdit.Text = customer.CustomerContact;
phoneTextEdit.Text = customer.CustomerPhone;
emailTextEdit.Text = customer.CustomerEmail;
faxTextEdit.Text = customer.CustomerFax;
noteMemoEdit.Text = customer.CustomerNote;
addressTextEdit.Text = customer.Address;
cityTextEdit.Text = customer.City;
stateTextEdit.Text = customer.State;
postalTextEdit.Text = customer.ZipCode;
inactiveCheckEdit.Checked = customer.Inactive;
lpnPrefixTextEdit.Text = customer.LPNPrefix;
firstLPNNumberTextEdit.EditValue = customer.FirstLPNNumber;
lastLPNNumberTextEdit.EditValue = customer.LastLPNNumber;
beforeItemCodetextEdit.EditValue = customer.BeforeItemCode;
beforeLotCodetextEdit.EditValue = customer.BeforeLotCode;
beforeQtyCodetextEdit.EditValue = customer.BeforeQtyCode;
endCodeTextEdit.EditValue = customer.EndCode;
plantCodeTextEdit.EditValue = customer.PlantCode;
lpnGroupControl.Text = string.Format("LPN Settings - Next LPN Number: {0}", customer.NextLPNNumber);
expirationDateFormatComboBox.EditValue = customer.ExpirationDateFormat;
if (customer.DefaultLotCodeFormat != null)
{
lotCodeFormatLookUpEdit.EditValue = customer.DefaultLotCodeFormat.Oid;
}
else
{
lotCodeFormatLookUpEdit.EditValue = null;
}
customerItemsXpCollection.Criteria = new GroupOperator(GroupOperatorType.And, new BinaryOperator(Items.Fields.ItemCustomerID.CustomerID.PropertyName, m_CurrentCustomer.Value, BinaryOperatorType.Equal), new BinaryOperator(Items.Fields.ItemType.PropertyName, "FG", BinaryOperatorType.Equal), new BinaryOperator(Items.Fields.Inactive.PropertyName, false, BinaryOperatorType.Equal));
relatedCustomerXpCollection.Criteria = new BinaryOperator(RelatedCustomer.Fields.MainCustomer.PropertyName, CustomersBLL.GetCustomer(m_CurrentCustomer.Value, m_CustomersSession), BinaryOperatorType.Equal);
customerPlantsXpCollection.Criteria = new BinaryOperator(CustomerPlants.Fields.Customer.CustomerID.PropertyName, m_CurrentCustomer.Value, BinaryOperatorType.Equal);
customerShiftsXpCollection.Criteria = new BinaryOperator(CustomerShifts.Fields.Customer.CustomerID.PropertyName, m_CurrentCustomer.Value, BinaryOperatorType.Equal);
customerItemsXpCollection.Reload();
relatedCustomerXpCollection.Reload();
customerPlantsXpCollection.Reload();
customerShiftsXpCollection.Reload();
}
private void CustomersXtraForm_Load(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
m_Customer = new CustomersBLL();
m_CustomersItems = new ItemsBLL();
m_Receiving = new ReceivingsBLL();
m_ReceivingDetails = new ReceivingDetailsBLL();
m_Production = new ProductionBLL();
m_Shippings = new ShippingsBLL();
m_UserPermissions = new UserPermissionsBLL();
m_CustomersSession = new Session(MyDataLayers.SPGDataLayer);
m_CustomersSession.TrackPropertiesModifications = true;
m_CustomersSession.OptimisticLockingReadBehavior = OptimisticLockingReadBehavior.MergeCollisionThrowException;
CheckPermissions();
for (int i = 0; i < components.Components.Count; i++)
{
if ((components.Components[i]) is XPView)
{
((XPView)components.Components[i]).Session = m_CustomersSession;
}
else if ((components.Components[i]) is XPCollection)
{
((XPCollection)components.Components[i]).Session = m_CustomersSession;
}
}
BindCustomerSearch();
customerShiftsXpCollection.Criteria = new BinaryOperator(CustomerShifts.Fields.Customer, null, BinaryOperatorType.Equal);
customerPlantsXpCollection.Criteria = new BinaryOperator(CustomerPlants.Fields.Customer, null, BinaryOperatorType.Equal);
Utilities.MakeFormReadOnly(generalXtraTabPage, true);
addRelatedCustomerGroupControl.Enabled = false;
customerPlantsGridView.OptionsBehavior.Editable = false;
customerShiftsGridView.OptionsBehavior.Editable = false;
deleteGridColumn.Visible = false;
deleteCustomerPlantGridColumn.Visible = false;
deleteCustomerShiftGridColumn.Visible = false;
customerSearchGridControl.Enabled = true;
Cursor = Cursors.Default;
}
public static bool IsLPNShipped(string fullLPNNumber, int customerID, Session DXSession)
{
if (!fullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(customerID)))
{
fullLPNNumber = CustomersBLL.GetLPNPrefix(customerID) + ("0000000000" + fullLPNNumber).Substring(("0000000000" + fullLPNNumber).Length - CustomersBLL.GetCustomer(customerID, DXSession).LastLPNNumber.ToString().Length);
}
CriteriaOperatorCollection filter = new CriteriaOperatorCollection();
filter.Add(new BinaryOperator(ShipDet.Fields.ShipDetMainID.ShipMainCustID.CustomerID.PropertyName, customerID, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator(ShipDet.Fields.FullLPNNumber.PropertyName, fullLPNNumber, BinaryOperatorType.Equal));
int?LPNCount = (int?)XpoDefault.Session.Evaluate <ShipDet>(new AggregateOperand("", "FullLPNNumber", Aggregate.Count), new GroupOperator(GroupOperatorType.And, filter));
if (LPNCount.HasValue && LPNCount.Value >= 1)
{
return(true);
}
else
{
return(false);
}
}
private void lpnNumberTextEdit_Validating(object sender, System.ComponentModel.CancelEventArgs e)
{
if (fromLocationLookUpEdit.EditValue != null && lpnNumberTextEdit.Text.Length > 0)
{
int LocationID = Convert.ToInt32(fromLocationLookUpEdit.EditValue);
try
{
int LPN = int.Parse(lpnNumberTextEdit.Text.Replace(CustomersBLL.GetLPNPrefix(7), ""));
for (int i = 0; i < transferDetailsGridView.RowCount; i++)
{
if (transferDetailsGridView.GetDataRow(i) != null && transferDetailsGridView.GetDataRow(i)["FullLpnNumber"].Equals(LPN))
{
MessageBox.Show("This LPN is already entered.");
lpnNumberTextEdit.EditValue = null;
return;
}
}
foreach (LocationInventoryByLot record in new XPCollection <LocationInventoryByLot>(m_TransfersSession, new GroupOperator(new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber, LPN, BinaryOperatorType.Equal) & new BinaryOperator(LocationInventoryByLot.Fields.Location.Oid.PropertyName, LocationID, BinaryOperatorType.Equal))))
{
transferDetailsGridView.AddNewRow();
transferDetailsGridView.SetRowCellValue(transferDetailsGridView.FocusedRowHandle, transferItemGridColumn, record.LocationInventoryItem.ItemID);
transferDetailsGridView.SetRowCellValue(transferDetailsGridView.FocusedRowHandle, colTransferQuantity, record.QuantityOnHand);
transferDetailsGridView.SetRowCellValue(transferDetailsGridView.FocusedRowHandle, colTransferLot, record.LocationInventoryLot);
transferDetailsGridView.SetRowCellValue(transferDetailsGridView.FocusedRowHandle, colItemExpirationDate, record.ExpirationDate);
transferDetailsGridView.SetRowCellValue(transferDetailsGridView.FocusedRowHandle, fullLpnNumberGridColumn, LPN);
transferDetailsGridView.UpdateCurrentRow();
}
}
catch
{
}
lpnNumberTextEdit.EditValue = null;
}
}
public bool DeleteShippingDetail(Session session, int detailID)
{
SPG.ShippingDetailsDataTable details = Adapter.GetDetailsByDetailID(detailID);
int rowsAffected = 0;
int itemID = 0;
int quantity = 0;
int locationID = 0;
string lot = null;
string fullLPNNumber = null;
if (details.Count() == 1)
{
SPG.ShippingDetailsRow shippingDetail = (SPG.ShippingDetailsRow)details.Rows[0];
itemID = shippingDetail.ShipDetItemID;
quantity = shippingDetail.ShipDetDetQty;
lot = shippingDetail.ShipDetLot;
fullLPNNumber = shippingDetail.FullLPNNumber;
locationID = session.GetObjectByKey <Shipping>(shippingDetail.ShipDetMainID).ShippingLocation.Oid;
rowsAffected = Adapter.Delete(detailID, shippingDetail.ts);
}
if (rowsAffected == 1)
{
ItemsBLL items = new ItemsBLL();
if (fullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(7)))
{
items.UpdateStock(session, itemID, quantity, false, locationID, lot, int.Parse(fullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(7), "")));
}
else
{
items.UpdateStock(session, itemID, quantity, false, locationID);
}
}
//Return true if precisely one row was deleted, otherwise return false.
return(rowsAffected == 1);
}
private void printLpn()
{
int digits = CustomersBLL.GetCustomer(7, Session.DefaultSession).LastLPNNumber.ToString().Length;
XPView lpnXPview = null;
CriteriaOperatorCollection critaria = new CriteriaOperatorCollection();
lpnXPview = new XPView(Session.DefaultSession, typeof(LocationInventoryByLot));
lpnXPview.Criteria = CriteriaOperator.And(new BinaryOperator("LPNNumber", (object)Utilities.ChangeType <int?>(lpnLookUpEdit.EditValue), BinaryOperatorType.Equal), new BinaryOperator("QuantityOnHand", 0, BinaryOperatorType.Greater));
lpnXPview.Properties.AddRange(new ViewProperty[]
{
new ViewProperty("Item", SortDirection.None, "[LocationInventoryItem.ItemCode]", false, true),
new ViewProperty("ItemDesc", SortDirection.None, "[LocationInventoryItem.ItemDescription]", false, true),
new ViewProperty("Allergens", SortDirection.None, "[LocationInventoryItem.Allergens]", false, true),
new ViewProperty("Qty", SortDirection.None, "[QuantityOnHand]", false, true),
new ViewProperty("Expr", SortDirection.None, "[ExpirationDate]", false, true),
new ViewProperty("Lot", SortDirection.None, "[LocationInventoryLot]", false, true),
new ViewProperty("LPN", SortDirection.Ascending, "[LPNNumber]", false, true)
});
LPNLabelsXtraReport labels = new LPNLabelsXtraReport();
labels.DataSource = lpnXPview;
labels.lpnGroupHeader.GroupFields.Add(new GroupField("LPN", XRColumnSortOrder.Ascending));
labels.itemCodeXrLabel.DataBindings.Add("Text", lpnXPview, "Item");
labels.itemDescXrLabel.DataBindings.Add("Text", lpnXPview, "ItemDesc");
labels.AllergensXrLabel.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "Iif(Len(Trim([Allergens]))>0,'Allergens: ' + [Allergens],'Allergens: None')"));
labels.exprXrLabel.DataBindings.Add("Text", lpnXPview, "Expr", "{0:MM/dd/yyyy}");
labels.qtyXrLabel.DataBindings.Add("Text", lpnXPview, "Qty");
labels.lotXrLabel.DataBindings.Add("Text", lpnXPview, "Lot");
labels.LPNXrBarCode.DataBindings.Add("Text", lpnXPview, "LPN", "SPG{0:D" + digits + "}");
labels.SumQtyXrLabel.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "sumSum([Qty])"));
labels.ReprintXrLabel.Visible = !m_newLpn;
labels.CreateDocument();
labels.ShowPreviewDialog();
}
private void deleteBarButtonItem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this customer.", "Delete Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Hand) == DialogResult.No)
{
return;
}
try
{
if (m_Customer.DeleteCustomer(m_CurrentCustomer.Value, m_CustomersSession) == true)
{
RelatedCustomerBLL.DeleteRelatedCustomers(CustomersBLL.GetCustomer(m_CurrentCustomer.Value, m_CustomersSession));
BindCustomerSearch();
}
else
{
MessageBox.Show("The customer was not deleted.");
}
}
catch (ApplicationException ex)
{
MessageBox.Show(ex.Message, "Error Encountered", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool InsertDetails(Session session, int shippingID, int?itemID, string lot, int?quantity, float?pallets, string note, DateTime?expirationDate, string fullLPNNumber)
{
SPG.ShippingDetailsDataTable details = new SPG.ShippingDetailsDataTable();
SPG.ShippingDetailsRow shippingDetail = details.NewShippingDetailsRow();
shippingDetail.ShipDetMainID = shippingID;
shippingDetail.ShipDetItemID = itemID.Value;
if (string.IsNullOrEmpty(lot))
{
shippingDetail.SetShipDetLotNull();
}
else
{
shippingDetail.ShipDetLot = lot;
}
shippingDetail.ShipDetDetQty = quantity.Value;
shippingDetail.SetsngPackagesNull();
if (!pallets.HasValue)
{
shippingDetail.SetsngPalletsNull();
}
else
{
shippingDetail.sngPallets = pallets.Value;
}
if (string.IsNullOrEmpty(note))
{
shippingDetail.SetNoteNull();
}
else
{
shippingDetail.Note = note;
}
if (expirationDate.HasValue)
{
shippingDetail.ExpirationDate = expirationDate.Value;
}
else
{
shippingDetail.SetExpirationDateNull();
}
if (string.IsNullOrEmpty(fullLPNNumber))
{
shippingDetail.SetFullLPNNumberNull();
}
else
{
shippingDetail.FullLPNNumber = fullLPNNumber;
}
details.AddShippingDetailsRow(shippingDetail);
int rowsAffected = Adapter.Update(details);
if (rowsAffected == 1)
{
ItemsBLL items = new ItemsBLL();
if (fullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(7)))
{
items.UpdateStock(session, itemID.Value, quantity.Value * -1, false, session.GetObjectByKey <Shipping>(shippingID).ShippingLocation.Oid, lot, int.Parse(fullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(7), "")));
}
else
{
items.UpdateStock(session, itemID.Value, quantity.Value * -1, false, session.GetObjectByKey <Shipping>(shippingID).ShippingLocation.Oid);
}
}
return(rowsAffected == 1);
}
private void PrintLpnSimpleButton_Click(object sender, EventArgs e)
{
int digits = CustomersBLL.GetCustomer(7, m_LocationSession).LastLPNNumber.ToString().Length;
XPView lpnXPview = null;
CriteriaOperatorCollection critaria = new CriteriaOperatorCollection();
lpnXPview = new XPView(m_LocationSession, typeof(LocationInventoryByLot));
if (inventoryByLotGridView.GroupCount > 0)
{
int i = -1;
while (inventoryByLotGridView.IsValidRowHandle(i))
{
if (inventoryByLotGridView.GetChildRowHandle(i, 0) > -1)
{
//INSTANT C# NOTE: The ending condition of VB 'For' loops is tested only on entry to the loop. Instant C# has created a temporary variable in order to use the initial value of inventoryByLotGridView.GetChildRowCount(i) + inventoryByLotGridView.GetChildRowHandle(i, 0) for every iteration:
int tempVar = inventoryByLotGridView.GetChildRowCount(i) + inventoryByLotGridView.GetChildRowHandle(i, 0);
for (int ci = inventoryByLotGridView.GetChildRowHandle(i, 0); ci < tempVar; ci++)
{
if (inventoryByLotGridView.IsRowVisible(ci) == RowVisibleState.Visible)
{
int? lpn = Utilities.ChangeType <int?>(inventoryByLotGridView.GetRowCellValue(ci, colLPNNumber));
string lot = inventoryByLotGridView.GetRowCellValue(ci, colLot).ToString();
if (lpn.HasValue && lot.Length > 0)
{
critaria.Add(new GroupOperator(GroupOperatorType.And, new BinaryOperator("LPNNumber", lpn.Value, BinaryOperatorType.Equal), new BinaryOperator("LocationInventoryLot", lot, BinaryOperatorType.Equal)));
}
}
}
}
i -= 1;
}
}
else
{
for (int ci = 0; ci < inventoryByLotGridView.RowCount; ci++)
{
if (inventoryByLotGridView.IsRowVisible(ci) == RowVisibleState.Visible)
{
int? lpn = Utilities.ChangeType <int?>(inventoryByLotGridView.GetRowCellValue(ci, colLPNNumber));
string lot = inventoryByLotGridView.GetRowCellValue(ci, colLot).ToString();
if (lpn.HasValue && lot.Length > 0)
{
critaria.Add(new GroupOperator(GroupOperatorType.And, new BinaryOperator("LPNNumber", lpn.Value, BinaryOperatorType.Equal), new BinaryOperator("LocationInventoryLot", lot, BinaryOperatorType.Equal)));
}
}
}
}
lpnXPview.Criteria = CriteriaOperator.Or(critaria);
lpnXPview.Properties.AddRange(new ViewProperty[]
{
new ViewProperty("Item", SortDirection.None, "[LocationInventoryItem.ItemCode]", false, true),
new ViewProperty("ItemDesc", SortDirection.None, "[LocationInventoryItem.ItemDescription]", false, true),
new ViewProperty("Allergens", SortDirection.None, "[LocationInventoryItem.Allergens]", false, true),
new ViewProperty("Qty", SortDirection.None, "[QuantityOnHand]", false, true),
new ViewProperty("Expr", SortDirection.None, "[ExpirationDate]", false, true),
new ViewProperty("Lot", SortDirection.None, "[LocationInventoryLot]", false, true),
new ViewProperty("LPN", SortDirection.Ascending, "[LPNNumber]", false, true)
});
LPNLabelsXtraReport labels = new LPNLabelsXtraReport();
labels.DataSource = lpnXPview;
labels.lpnGroupHeader.GroupFields.Add(new GroupField("LPN", XRColumnSortOrder.Ascending));
labels.itemCodeXrLabel.DataBindings.Add("Text", lpnXPview, "Item");
labels.itemDescXrLabel.DataBindings.Add("Text", lpnXPview, "ItemDesc");
labels.AllergensXrLabel.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "Iif(Len(Trim([Allergens]))>0,'Allergens: ' + [Allergens],'Allergens: None')"));
labels.exprXrLabel.DataBindings.Add("Text", lpnXPview, "Expr", "{0:MM/dd/yyyy}");
labels.qtyXrLabel.DataBindings.Add("Text", lpnXPview, "Qty");
labels.lotXrLabel.DataBindings.Add("Text", lpnXPview, "Lot");
labels.LPNXrBarCode.DataBindings.Add("Text", lpnXPview, "LPN", "SPG{0:D" + digits + "}");
labels.SumQtyXrLabel.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "sumSum([Qty])"));
labels.ReprintXrLabel.Visible = true;
labels.CreateDocument();
labels.ShowPreviewDialog();
}
public bool UpdateShippingDetails(Session session, int?detailID, int shippingID, int?itemID, string lot, int?quantity, float?pallets, string note, DateTime?expirationDate, string fullLPNNumber)
{
if (!itemID.HasValue)
{
throw new ApplicationException("You must provide shipping item.");
}
if (!quantity.HasValue)
{
throw new ApplicationException("You must provide the Quantity shipped.");
}
SPG.ShippingDetailsDataTable details = Adapter.GetDetailsByDetailID(detailID.Value);
if (details.Count() == 0)
{
//It is a new Detail
return(InsertDetails(session, shippingID, itemID, lot, quantity, pallets, note, expirationDate, fullLPNNumber));
}
SPG.ShippingDetailsRow shippingDetail = details[0];
int originalItem = 0;
int originalQuantity = 0;
int newQuantity = 0;
bool itemChanged = false;
object[] originalRecord = shippingDetail.ItemArray;
SPG.ShippingDetailsRow originalDetail = details.NewShippingDetailsRow();
originalDetail.ItemArray = (object[])originalRecord.Clone();
originalItem = shippingDetail.ShipDetItemID;
if (itemID.HasValue && originalItem != itemID.Value)
{
itemChanged = true;
}
shippingDetail.ShipDetItemID = itemID.Value;
if (string.IsNullOrEmpty(lot))
{
shippingDetail.SetShipDetLotNull();
}
else
{
shippingDetail.ShipDetLot = lot;
}
originalQuantity = shippingDetail.ShipDetDetQty;
newQuantity = quantity.Value - shippingDetail.ShipDetDetQty;
shippingDetail.ShipDetDetQty = quantity.Value;
shippingDetail.SetsngPackagesNull();
if (!pallets.HasValue)
{
shippingDetail.SetsngPalletsNull();
}
else
{
shippingDetail.sngPallets = pallets.Value;
}
if (string.IsNullOrEmpty(note))
{
shippingDetail.SetNoteNull();
}
else
{
shippingDetail.Note = note;
}
if (expirationDate.HasValue)
{
shippingDetail.ExpirationDate = expirationDate.Value;
}
else
{
shippingDetail.SetExpirationDateNull();
}
if (string.IsNullOrEmpty(fullLPNNumber))
{
shippingDetail.SetFullLPNNumberNull();
}
else
{
shippingDetail.FullLPNNumber = fullLPNNumber;
}
if (!(originalRecord == null))
{
UpdateAuditTrail(shippingDetail, originalRecord);
}
int rowsAffected = Adapter.Update(shippingDetail);
if (rowsAffected == 1)
{
ItemsBLL items = new ItemsBLL();
int locationID = session.GetObjectByKey <Shipping>(shippingID).ShippingLocation.Oid;
//If itemChanged = True Then
if (originalDetail.FullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(7)))
{
items.UpdateStock(session, originalItem, originalQuantity, false, locationID, originalDetail.ShipDetLot, int.Parse(originalDetail.FullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(7), "")));
}
else
{
items.UpdateStock(session, originalItem, originalQuantity, false, locationID);
}
if (fullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(7)))
{
items.UpdateStock(session, itemID.Value, quantity.Value * -1, false, locationID, lot, int.Parse(fullLPNNumber.Replace(CustomersBLL.GetLPNPrefix(7), "")));
}
else
{
items.UpdateStock(session, itemID.Value, quantity.Value * -1, false, locationID);
}
//Else
// If newQuantity <> 0 Then
// items.UpdateStock(session, itemID.Value, newQuantity * -1, False, locationID)
// End If
//End If
}
return(rowsAffected == 1);
}
private void ProductionXtraForm_Load(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
m_ProductionSession = new Session(MyDataLayers.SPGDataLayer)
{
TrackPropertiesModifications = true,
OptimisticLockingReadBehavior = OptimisticLockingReadBehavior.MergeCollisionThrowException
};
CheckPermissions();
for (int i = 0; i < components.Components.Count; i++)
{
if ((components.Components[i]) is XPView)
{
((XPView)components.Components[i]).Session = m_ProductionSession;
}
else if ((components.Components[i]) is XPCollection)
{
((XPCollection)components.Components[i]).Session = m_ProductionSession;
}
}
m_Items = new ItemsBLL();
m_Production = new ProductionBLL();
m_Shift = new ShiftsBLL();
m_Machines = new MachinesLinesBLL();
m_Customers = new CustomersBLL();
LookUpColumnInfo shiftNameColumn = new LookUpColumnInfo()
{
Caption = "Shift",
FieldName = "ShiftName"
};
shiftLookUpEdit.Properties.Columns.Add(shiftNameColumn);
shiftLookUpEdit.Properties.DisplayMember = "ShiftName";
shiftLookUpEdit.Properties.ValueMember = "ShiftID";
shiftFilterLookUpEdit.Properties.Columns.Add(shiftNameColumn);
shiftFilterLookUpEdit.Properties.DisplayMember = "ShiftName";
shiftFilterLookUpEdit.Properties.ValueMember = "ShiftID";
//Dim machineNameColumn As Controls.LookUpColumnInfo = New Controls.LookUpColumnInfo() With {.Caption = "Machine Line", .FieldName = "MachineLineName"}
//Me.machineLookUpEdit.Properties.Columns.Add(machineNameColumn)
//Me.machineLookUpEdit.Properties.DisplayMember = "MachineLineName"
//Me.machineLookUpEdit.Properties.ValueMember = "MachineLineID"
//Me.machineFilterLookUpEdit.Properties.Columns.Add(machineNameColumn)
//Me.machineFilterLookUpEdit.Properties.DisplayMember = "MachineLineName"
//Me.machineFilterLookUpEdit.Properties.ValueMember = "MachineLineID"
FillDropDowns();
PrepareNewRecord();
if (DateTime.Now.TimeOfDay < new TimeSpan(9, 0, 0))
{
productionDateEdit.DateTime = DateTime.Today.AddDays(-1);
}
else
{
productionDateEdit.DateTime = DateTime.Today;
}
SetDefaultViewFilter();
FillProductionView();
Cursor = Cursors.Default;
}
public static XPView GetItemCodeAndIDsByTypesAndCustomerID(int?customerID, string types, bool universal, Session DXSession)
{
XPView ItemCodesXPView = new XPView(Session.DefaultSession, typeof(Items));
ItemCodesXPView.Properties.AddRange(new ViewProperty[]
{
new ViewProperty("ItemID", SortDirection.None, "[ItemID]", false, true),
new ViewProperty("ItemCode", SortDirection.Ascending, "[ItemCode]", false, true),
new ViewProperty("ItemCustomerID", SortDirection.None, "[ItemCustomerID]", false, true),
new ViewProperty("ItemType", SortDirection.None, "[ItemType]", false, true)
});
if (universal == true)
{
int universalCustomer = CompanySettingsBLL.GetUniversalCustomer();
if (customerID.HasValue)
{
ItemCodesXPView.Criteria = CriteriaOperator.And(CriteriaOperator.Or(new BinaryOperator(Items.Fields.ItemCustomerID.PropertyName, customerID.Value, BinaryOperatorType.Equal), new BinaryOperator(Items.Fields.ItemCustomerID.PropertyName, universalCustomer, BinaryOperatorType.Equal), new InOperator(Items.Fields.ItemCustomerID.PropertyName, CustomersBLL.GetRelatedCustomerIDs(CustomersBLL.GetCustomer(customerID.Value, DXSession)))), new InOperator(Items.Fields.ItemType.PropertyName, types.Split('|')));
}
else
{
ItemCodesXPView.Criteria = new InOperator(Items.Fields.ItemType.PropertyName, types.Split('|'));
}
}
else
{
if (customerID.HasValue)
{
ItemCodesXPView.Criteria = CriteriaOperator.And(new BinaryOperator(Items.Fields.ItemCustomerID.PropertyName, customerID.Value, BinaryOperatorType.Equal), new InOperator(Items.Fields.ItemType.PropertyName, types.Split('|')));
}
else
{
ItemCodesXPView.Criteria = new InOperator(Items.Fields.ItemType.PropertyName, types.Split('|'));
}
}
return(ItemCodesXPView);
}