private List <PackingListBO> GetCartonData() { var PackingLists = new List <PackingListBO>(); if (Source != null) { PackingLists = Source; } else { OrderDetailQtyBO obj = new OrderDetailQtyBO(); obj.ID = this.OrderDetailQtyID; obj.GetObject(); this.SizeID = obj.Size; var objPack = new PackingListBO(); objPack.WeeklyProductionCapacity = WeekendCapacityID; // objPack.OrderDetail = obj.OrderDetail; objPack.CartonNo = CartonNo; PackingLists = objPack.SearchObjects().ToList(); } Source = PackingLists; return(PackingLists); }
private void AddItem(int orderDetailQtyID, int cartonNo) { OrderDetailQtyBO objOrderDetailQty = new OrderDetailQtyBO(); objOrderDetailQty.ID = orderDetailQtyID; objOrderDetailQty.GetObject(); List <PackingListBO> lstPackingList = Source.Where(m => m.OrderDetail == objOrderDetailQty.OrderDetail && m.CartonNo == cartonNo).ToList(); if (lstPackingList.Any()) { using (TransactionScope ts = new TransactionScope()) { //PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO(); //objPackListCartonItem.PackingList = lstPackingList.SingleOrDefault().ID; //objPackListCartonItem.Size = objOrderDetailQty.Size; //List<PackingListCartonItemBO> lstCartonItem = objPackListCartonItem.SearchObjects(); ////PackingListSizeQtyBO objPackingListSizeQty = new PackingListSizeQtyBO(); ////objPackingListSizeQty.PackingList = lstPackingList.SingleOrDefault().ID; ////objPackingListSizeQty.Size = objOrderDetailQty.Size; ////List<PackingListSizeQtyBO> lstSizeQty = objPackingListSizeQty.SearchObjects(); //if (!lstCartonItem.Any()) //{ // // no records // PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext); // objPackListCartonItemToSave.PackingList = objPackListCartonItem.PackingList; // objPackListCartonItemToSave.Size = objPackListCartonItem.Size; // objPackListCartonItemToSave.Count = 1; // objPackListCartonItem.Count + 1; // addedSizeID = objPackListCartonItem.Size; //} //else if (lstCartonItem.Any() && (lstCartonItem.SingleOrDefault().Count < objOrderDetailQty.Qty)) //{ // //update // PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext); // objPackListCartonItemToSave.ID = lstCartonItem.SingleOrDefault().ID; // objPackListCartonItemToSave.GetObject(); // objPackListCartonItemToSave.Count++; // addedSizeID = objPackListCartonItem.Size; //} ////else if (lstCartonItem.Any() && (lstCartonItem.SingleOrDefault().Count == lstSizeQty.SingleOrDefault().Qty)) ////{ //// //filled ////} PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO(this.ObjContext); objPackListCartonItem.PackingList = lstPackingList.SingleOrDefault().ID; objPackListCartonItem.Size = objOrderDetailQty.Size; objPackListCartonItem.Count = this.ItemNo; // objPackListCartonItem.Count + 1; addedSizeID = objPackListCartonItem.Size; this.ObjContext.SaveChanges(); ts.Complete(); } DisplaySuccessMessage(cartonNo); } else // wrong poly bag { DisplayCartonErrorMessage("ස්කෑන් කරන ලද පොලි බෑගය මෙම පෙට්ටියට අදාළ නොවේ. <br/><br/>නැවත නිවැරදි පෙට්ටිය ස්කෑන් කරන්න.<br/><br/>Scanned Poly bag should not go to this Carton.<br/><br/>Please scan the correct Carton."); } }
private List <PackingListBO> GetPolyBagData() { List <PackingListBO> PackingLists = new List <PackingListBO>(); List <PackingListCartonItemBO> lstCartonItems = new List <PackingListCartonItemBO>(); PackingListBO objPacking = new PackingListBO(); if (Source != null) { PackingLists = Source; } else { OrderDetailQtyBO obj = new OrderDetailQtyBO(); obj.ID = this.OrderDetailQtyID; obj.GetObject(); this.SizeID = obj.Size; var objPack = new PackingListBO(); //objPack.WeeklyProductionCapacity = WeekendCapacityID; objPack.OrderDetail = obj.OrderDetail; //objPack.CartonNo = CartonNo; DateTime monday = WeekEndDate.AddDays(-(int)WeekEndDate.DayOfWeek - 6); // List<PackingListBO> loadedPackingLists = objPack.SearchObjects().Where(m => m.PackingListSizeQtysWhereThisIsPackingList.Where(o => o.Qty > 0).Select(s => s.Size).Contains(this.SizeID) && m.objWeeklyProductionCapacity.WeekendDate.Date == WeekEndDate.Date && m.CartonNo > 0).ToList(); //.Where(m => m.PackingListCartonItemsWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Count < m.PackingListSizeQtysWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Qty).ToList(); List <PackingListBO> loadedPackingLists = objPack.SearchObjects().Where(m => m.PackingListSizeQtysWhereThisIsPackingList.Where(s => s.Qty > 0).Select(s => s.Size).Contains(this.SizeID) && (DateTime.Compare(m.objWeeklyProductionCapacity.WeekendDate.Date, monday.Date) > -1) && m.CartonNo > 0).ToList(); //.Where(m => m.PackingListCartonItemsWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Count < m.PackingListSizeQtysWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Qty).ToList(); foreach (PackingListBO objPackingList in loadedPackingLists) { PackingListCartonItemBO objCartonItem = new PackingListCartonItemBO(); objCartonItem.Size = this.SizeID; objCartonItem.PackingList = objPackingList.ID; objCartonItem.Count = this.ItemNo; lstCartonItems = objCartonItem.SearchObjects(); if (lstCartonItems.Any() && lstCartonItems.Count == 1) { this.polyBagStatus = PolyBagFillingStatus.Filled; break; } else { PackingLists.Add(objPackingList); this.polyBagStatus = PolyBagFillingStatus.Available; } } } if (this.polyBagStatus == PolyBagFillingStatus.Filled) { PackingLists.Clear(); } Source = PackingLists; return(PackingLists); }