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