//
// If a manifest has not been marked as shipped, show any lineitems for that manifest
public IEnumerable <HazmatItem> GetOrderLineItems(string orderNo)
{
List <HazmatItem> lineItems = new List <HazmatItem>();
IEnumerable <HazmatInfo> query = GetHazmatInfo();
query = query.Where(i => i.OrderNo == orderNo);
int index = 0;
foreach (HazmatInfo item in query)
{
HazmatItem lineItem = new HazmatItem();
lineItem.Qty = item.Qty.HasValue ? (int)item.Qty : 0;
lineItem.ItemId = item.InvItemID;
lineItem.OrderLineNo = item.OrderLineNo.HasValue ? (int)item.OrderLineNo : index;
lineItem.HazmatInfoId = item.HazmatInfoID;
IEnumerable <AllItems> subquery = (from j in GetAllItems()
select j).Where(j => j.INV_ITEM_ID.Contains(item.InvItemID));
lineItem.Uom = subquery.Select(j => j.UNIT_MEASURE_STD).SingleOrDefault();
lineItem.Size = subquery.Select(j => j.INV_ITEM_SIZE).SingleOrDefault();
lineItem.UnitLbs = Convert.ToInt32(subquery.Select(j => j.INV_ITEM_WEIGHT).SingleOrDefault());
lineItem.TotalLbs = lineItem.Qty * lineItem.UnitLbs;
lineItem.ShipName = subquery.Select(j => j.PAG_SHIPPING_NAME).SingleOrDefault();
lineItem.HazardClass = subquery.Select(j => j.HAZ_CLASS_CD).SingleOrDefault();
lineItem.UnnaNo = subquery.Select(j => j.MSDS_ID).SingleOrDefault();
lineItem.PackingGroup = subquery.Select(j => j.PACKING_CD).SingleOrDefault();
lineItem.Placard = subquery.Select(j => j.PAG_PLACARD_TYPE).SingleOrDefault();
lineItem.ErgNo = "";
lineItems.Add(lineItem);
index++;
}
return(lineItems);
}
//HazmatItem convertToHazmatItem(PendingItems items, string orderNo);
public HazmatItem convertToHazmatItem(HazmatInfo item, string orderNo)
{
HazmatItem hazmatItem = new HazmatItem();
AllItems allItem = context.AllItems.SingleOrDefault(i => i.INV_ITEM_ID == item.InvItemID);
if (allItem != null)
{
hazmatItem.ErgNo = null;
hazmatItem.HazardClass = allItem.HAZ_CLASS_CD;
hazmatItem.HazmatInfoId = item.HazmatInfoID;
hazmatItem.ItemId = item.InvItemID;
hazmatItem.OrderLineItemId = 0;
hazmatItem.OrderLineNo = Convert.ToInt16(item.OrderLineNo);
hazmatItem.PackingGroup = allItem.PACKING_CD;
hazmatItem.Placard = allItem.PAG_PLACARD_TYPE;
hazmatItem.Qty = Convert.ToInt16(item.Qty);
hazmatItem.ShipName = allItem.PAG_SHIPPING_NAME;
hazmatItem.Size = allItem.INV_ITEM_SIZE;
hazmatItem.UnitLbs = Convert.ToInt16(allItem.INV_ITEM_WEIGHT);
hazmatItem.TotalLbs = hazmatItem.Qty * hazmatItem.UnitLbs;
hazmatItem.UnnaNo = allItem.MSDS_ID;
hazmatItem.Uom = allItem.UNIT_MEASURE_STD;
}
return(hazmatItem);
}
//HazmatItem GetItem(string INV_ITEM_ID);
public HazmatItem GetItem(string INV_ITEM_ID)
{
HazmatItem item = new HazmatItem();
AllItems tempItem = context.AllItems.Where(i => i.INV_ITEM_ID == INV_ITEM_ID).SingleOrDefault();
item.ErgNo = "";
item.HazardClass = tempItem.HAZ_CLASS_CD.TrimEnd();
item.ItemId = tempItem.INV_ITEM_ID.TrimEnd();
item.PackingGroup = tempItem.PACKING_CD.TrimEnd();
item.Placard = tempItem.PAG_PLACARD_TYPE.TrimEnd();
item.ShipName = tempItem.PAG_SHIPPING_NAME.TrimEnd();
item.Size = tempItem.INV_ITEM_SIZE.TrimEnd();
item.UnitLbs = Convert.ToInt32(tempItem.INV_ITEM_WEIGHT);
item.UnnaNo = tempItem.MSDS_ID.TrimEnd();
return(item);
}
//
// Get details of lineitem to be added to the shipping manifest
public ActionResult GetOrderLine(string inv_item_id, int?qty)
{
HazmatItem item = new HazmatItem {
ItemId = "0", Size = "0", UnitLbs = 0
};
if ((qty != null) && (qty != 0))
{
item.Qty = (int)qty;
}
else
{
qty = 1;
}
item.TotalLbs = item.Qty * item.UnitLbs;
item.ShipName = "";
item.HazardClass = "";
item.UnnaNo = "";
item.PackingGroup = "";
item.Placard = "";
item.ErgNo = "";
IEnumerable <AllItems> query = from i in hazmatRepository.GetAllItems()
select i;
// Get item details
query = query.Where(i => i.INV_ITEM_ID.Contains(inv_item_id));
foreach (AllItems i in query)
{
item.Uom = i.UNIT_MEASURE_STD.TrimEnd();
item.Size = i.INV_ITEM_SIZE.TrimEnd();
item.UnitLbs = Convert.ToInt16(i.INV_ITEM_WEIGHT);
item.TotalLbs = item.UnitLbs * item.Qty;
item.ShipName = i.PAG_SHIPPING_NAME.TrimEnd();
item.HazardClass = i.HAZ_CLASS_CD.TrimEnd();
item.UnnaNo = i.MSDS_ID.TrimEnd();
item.PackingGroup = i.PACKING_CD.TrimEnd();
item.Placard = i.PAG_PLACARD_TYPE.TrimEnd();
}
return(Json(item, JsonRequestBehavior.AllowGet));
}
public PendingItem convertToPendingItem(HazmatItem item, string orderNo, string receiverId)
{
PendingItem pendingItem = new PendingItem();
pendingItem.ErgNo = item.ErgNo;
pendingItem.HazardClass = item.HazardClass;
pendingItem.HazmatInfoId = item.HazmatInfoId;
pendingItem.ItemId = item.ItemId;
pendingItem.OrderLineItemId = item.OrderLineItemId;
pendingItem.OrderLineNo = item.OrderLineNo;
pendingItem.OrderNo = Convert.ToInt16(orderNo);
pendingItem.PackingGroup = item.PackingGroup;
pendingItem.Placard = item.Placard;
pendingItem.Qty = item.Qty;
pendingItem.RecieverId = receiverId;
pendingItem.ShipName = item.ShipName;
pendingItem.Size = item.Size;
pendingItem.TotalLbs = item.TotalLbs;
pendingItem.UnitLbs = item.UnitLbs;
pendingItem.UnnaNo = item.UnnaNo;
pendingItem.Uom = item.Uom;
return(pendingItem);
}
