public List <Qiyas.BusinessLogicLayer.Entity.PPM.BookPackingOperation> GetPackedByBookPrintingID(int ID) { List <Qiyas.BusinessLogicLayer.Entity.PPM.BookPackingOperation> operations = new List <Entity.PPM.BookPackingOperation>(); var packed = db.GetPackedByPrintingID(ID); foreach (var item in packed) { Qiyas.BusinessLogicLayer.Entity.PPM.BookPackingOperation nitem = new Entity.PPM.BookPackingOperation(); nitem.AllocatedFrom = item.AllocatedFrom; nitem.BookPackingOperationID = item.BookPackingOperationID; nitem.BookPrintingOperationID = item.BookPrintingOperationID; nitem.CreatedDate = item.CreatedDate; nitem.CreatorID = item.CreatorID; nitem.ModifiedByID = item.ModifiedByID; nitem.ModifiedDate = item.ModifiedDate; nitem.Name = item.Name; nitem.PackageTotal = item.PackageTotal; nitem.PackagingTypeID = item.PackagingTypeID; nitem.PackingCalculationTypeID = item.PackingCalculationTypeID; nitem.PackingParentID = item.PackingParentID; nitem.PackingValue = item.PackingValue; nitem.isNew = false; operations.Add(nitem); } return(operations); }
public List <Qiyas.BusinessLogicLayer.Entity.PPM.BookPackingOperation> GetAllPackagingTypeByBookPrintingID(int ID) { var list = (from c in db.BookPackingOperations where c.BookPrintingOperationID == ID select new { c.PackagingTypeID }).ToList(); var packings = (from x in db.BookPackingOperations where x.BookPrintingOperationID == ID select x).ToList(); var packingTypes = (from x in db.PackagingTypes select x).ToList(); var itemsList = (from t1 in packingTypes join t2 in packings on t1.PackagingTypeID equals t2.PackagingTypeID select new { t1.Name, t2 }).ToList(); List <Qiyas.BusinessLogicLayer.Entity.PPM.BookPackingOperation> operations = new List <Entity.PPM.BookPackingOperation>(); foreach (var item in itemsList) { var p = (from x in packings where x.BookPackingOperationID == item.t2.BookPackingOperationID select x).FirstOrDefault(); Qiyas.BusinessLogicLayer.Entity.PPM.BookPackingOperation o = new Entity.PPM.BookPackingOperation(p); o.PackagingTypeName = item.Name; operations.Add(o); } if (operations == null) { operations = new List <Entity.PPM.BookPackingOperation>(); } return(operations); }