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 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);
}
}
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 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);
}
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);
}
}