private List <SamplePackageResult> GetSamplePackages(Control row, out int count)
{
GridView grid = (GridView)row.FindControl("SamplePackages");
PackagingRule rule = new PackagingRule();
rule.BoxHeight = decimal.Parse(((TextBox)row.FindControl("HeightField")).Text);
rule.BoxLength = decimal.Parse(((TextBox)row.FindControl("LengthField")).Text);
rule.BoxWidth = decimal.Parse(((TextBox)row.FindControl("WidthField")).Text);
rule.Limits.AddRange(
((BVModules_Shipping_Package_Rules_PackageMatchEditor)row.FindControl("PackageMatchEditor")).GetMatches());
rule.Name = ((TextBox)row.FindControl("NameField")).Text.Trim();
rule.TareWeight = decimal.Parse(((TextBox)row.FindControl("TareWeightField")).Text);
Packager packager = new Packager(rule);
count = 0;
// Scan all placed orders
List <SamplePackageResult> results = new List <SamplePackageResult>();
int rowCount = 0;
foreach (Order order in Order.FindByCriteria(new OrderSearchCriteria(), -1, grid.PageSize * 5, ref rowCount))
{
Order heavyOrder = Order.FindByBvin(order.Bvin);
// "Unship" all of the items so that the samples look like they
// were just placed. Skip any orders with deleted items.
bool skipOrder = false;
foreach (LineItem lineitem in heavyOrder.Items)
{
if (lineitem.AssociatedProduct == null || lineitem.AssociatedProduct.ShippingMode == ShippingMode.None)
{
skipOrder = true;
}
else
{
lineitem.QuantityShipped = 0;
}
}
if (skipOrder)
{
break;
}
ExtendedShippingGroupList groups = new ExtendedShippingGroupList();
foreach (ShippingGroup group in heavyOrder.GetShippingGroups())
{
groups.Add(new ExtendedShippingGroup(0, group, group.Items));
}
foreach (ExtendedShippingGroup group in groups)
{
ExtendedShippingGroupList splitGroups = packager.Split(group);
List <String> remainingItems = new List <string>();
SamplePackageResult result;
Boolean matchingPackage = false;
foreach (ExtendedShippingGroup splitGroup in splitGroups)
{
if (splitGroup.Name.Equals(rule.Name))
{
matchingPackage = true;
count += 1;
result = new SamplePackageResult();
result.OrderNumber = order.OrderNumber;
result.OrderDisplay = string.Format("<a href=\"{0}\" target=\"order\">{1}</a>",
Page.ResolveUrl(
string.Format("~/BVAdmin/Orders/ViewOrder.aspx?id={0}",
order.Bvin)),
order.OrderNumber);
List <string> matchValues = new List <string>();
List <string> limitValues = new List <string>();
for (int index = 0; index < rule.Limits.Count; index++)
{
PackageMatch match = rule.Limits[index];
string matchValue =
PackagePropertiesHelper.GetPackagePropertyValue(splitGroup, match.PackageProperty, match.ItemProperty,
match.CustomProperty, "1").ToString();
if (string.IsNullOrEmpty(matchValue))
{
matchValue = "(empty)";
}
matchValues.Add(matchValue);
string limitValue =
PackagePropertiesHelper.GetPackagePropertyValue(splitGroup, match.LimitPackageProperty, match.LimitItemProperty,
match.LimitCustomProperty, match.Limit).ToString();
if (string.IsNullOrEmpty(limitValue))
{
limitValue = "(empty)";
}
limitValues.Add(limitValue);
}
result.MatchValues = string.Join(", ", matchValues.ToArray());
result.LimitValues = string.Join(", ", limitValues.ToArray());
result.Volume = splitGroup.GetShippingVolume().ToString("0.000");
result.Weight = splitGroup.GetShippingWeight().ToString("0.000");
if (splitGroup.HasBoxDimensions)
{
decimal boxVolume = splitGroup.BoxHeight * splitGroup.BoxLength * splitGroup.BoxWidth;
result.FillFactor = string.Format("{0:0.000}%", splitGroup.GetShippingVolume() * 100M / boxVolume);
}
else
{
result.FillFactor = "n/a";
}
List <string> lineitems = new List <string>();
foreach (LineItem lineitem in splitGroup.Items)
{
lineitems.Add(string.Format("{0:0} × {1}", lineitem.Quantity, lineitem.ProductSku));
}
result.Items = string.Join(", ", lineitems.ToArray());
results.Add(result);
}
else
{
foreach (LineItem lineitem in splitGroup.Items)
{
remainingItems.Add(string.Format("{0:0} × {1}", lineitem.Quantity, lineitem.ProductSku));
}
}
if (count > grid.PageSize * 5)
{
break;
}
}
// If there was at least one matching package, then list the unmatched items
if (matchingPackage && (remainingItems.Count > 0))
{
result = new SamplePackageResult();
result.OrderNumber = order.OrderNumber;
result.OrderDisplay = string.Format("<a href=\"{0}\" target=\"order\">{1}</a>",
Page.ResolveUrl(
string.Format("~/BVAdmin/Orders/ViewOrder.aspx?id={0}",
order.Bvin)),
order.OrderNumber);
result.MatchValues = "unpackaged items";
result.Items = string.Join(", ", remainingItems.ToArray());
results.Add(result);
}
}
if (count > grid.PageSize * 5)
{
break;
}
}
results.Sort();
return(results);
}
private List<SamplePackageResult> GetSamplePackages(Control row, out int count)
{
GridView grid = (GridView) row.FindControl("SamplePackages");
PackagingRule rule = new PackagingRule();
rule.BoxHeight = decimal.Parse(((TextBox)row.FindControl("HeightField")).Text);
rule.BoxLength = decimal.Parse(((TextBox)row.FindControl("LengthField")).Text);
rule.BoxWidth = decimal.Parse(((TextBox)row.FindControl("WidthField")).Text);
rule.Limits.AddRange(
((BVModules_Shipping_Package_Rules_PackageMatchEditor) row.FindControl("PackageMatchEditor")).GetMatches());
rule.Name = ((TextBox)row.FindControl("NameField")).Text.Trim();
rule.TareWeight = decimal.Parse(((TextBox)row.FindControl("TareWeightField")).Text);
Packager packager = new Packager(rule);
count = 0;
// Scan all placed orders
List<SamplePackageResult> results = new List<SamplePackageResult>();
int rowCount = 0;
foreach (Order order in Order.FindByCriteria(new OrderSearchCriteria(), -1, grid.PageSize * 5, ref rowCount))
{
Order heavyOrder = Order.FindByBvin(order.Bvin);
// "Unship" all of the items so that the samples look like they
// were just placed. Skip any orders with deleted items.
bool skipOrder = false;
foreach (LineItem lineitem in heavyOrder.Items)
{
if (lineitem.AssociatedProduct == null || lineitem.AssociatedProduct.ShippingMode == ShippingMode.None)
skipOrder = true;
else
lineitem.QuantityShipped = 0;
}
if (skipOrder) break;
ExtendedShippingGroupList groups = new ExtendedShippingGroupList();
foreach (ShippingGroup group in heavyOrder.GetShippingGroups())
{
groups.Add(new ExtendedShippingGroup(0, group, group.Items));
}
foreach (ExtendedShippingGroup group in groups)
{
ExtendedShippingGroupList splitGroups = packager.Split(group);
List<String> remainingItems = new List<string>();
SamplePackageResult result;
Boolean matchingPackage = false;
foreach (ExtendedShippingGroup splitGroup in splitGroups)
{
if (splitGroup.Name.Equals(rule.Name))
{
matchingPackage = true;
count += 1;
result = new SamplePackageResult();
result.OrderNumber = order.OrderNumber;
result.OrderDisplay = string.Format("<a href=\"{0}\" target=\"order\">{1}</a>",
Page.ResolveUrl(
string.Format("~/BVAdmin/Orders/ViewOrder.aspx?id={0}",
order.Bvin)),
order.OrderNumber);
List<string> matchValues = new List<string>();
List<string> limitValues = new List<string>();
for (int index = 0; index < rule.Limits.Count; index++)
{
PackageMatch match = rule.Limits[index];
string matchValue =
PackagePropertiesHelper.GetPackagePropertyValue(splitGroup, match.PackageProperty, match.ItemProperty,
match.CustomProperty, "1").ToString();
if (string.IsNullOrEmpty(matchValue)) matchValue = "(empty)";
matchValues.Add(matchValue);
string limitValue =
PackagePropertiesHelper.GetPackagePropertyValue(splitGroup, match.LimitPackageProperty, match.LimitItemProperty,
match.LimitCustomProperty, match.Limit).ToString();
if (string.IsNullOrEmpty(limitValue)) limitValue = "(empty)";
limitValues.Add(limitValue);
}
result.MatchValues = string.Join(", ", matchValues.ToArray());
result.LimitValues = string.Join(", ", limitValues.ToArray());
result.Volume = splitGroup.GetShippingVolume().ToString("0.000");
result.Weight = splitGroup.GetShippingWeight().ToString("0.000");
if (splitGroup.HasBoxDimensions)
{
decimal boxVolume = splitGroup.BoxHeight * splitGroup.BoxLength * splitGroup.BoxWidth;
result.FillFactor = string.Format("{0:0.000}%", splitGroup.GetShippingVolume() * 100M / boxVolume);
}
else
{
result.FillFactor = "n/a";
}
List<string> lineitems = new List<string>();
foreach (LineItem lineitem in splitGroup.Items)
{
lineitems.Add(string.Format("{0:0} × {1}", lineitem.Quantity, lineitem.ProductSku));
}
result.Items = string.Join(", ", lineitems.ToArray());
results.Add(result);
}
else
{
foreach (LineItem lineitem in splitGroup.Items)
{
remainingItems.Add(string.Format("{0:0} × {1}", lineitem.Quantity, lineitem.ProductSku));
}
}
if (count > grid.PageSize * 5) break;
}
// If there was at least one matching package, then list the unmatched items
if (matchingPackage && (remainingItems.Count > 0))
{
result = new SamplePackageResult();
result.OrderNumber = order.OrderNumber;
result.OrderDisplay = string.Format("<a href=\"{0}\" target=\"order\">{1}</a>",
Page.ResolveUrl(
string.Format("~/BVAdmin/Orders/ViewOrder.aspx?id={0}",
order.Bvin)),
order.OrderNumber);
result.MatchValues = "unpackaged items";
result.Items = string.Join(", ", remainingItems.ToArray());
results.Add(result);
}
}
if (count > grid.PageSize*5) break;
}
results.Sort();
return results;
}