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