private LCM_PackingListPacks ModelConversionPackingListPacks(PackingListPacksVM model, int userId, int plid) { var entity = model.PlPackID == 0 ? new LCM_PackingListPacks() : (from b in _context.LCM_PackingListPacks.AsEnumerable() where b.PLPackID == model.PlPackID select b).FirstOrDefault(); entity.PLPackID = model.PlPackID; entity.PLID = plid; entity.PackUnit = model.PackUnit; entity.PackQty = model.PackQty; entity.SetOn = model.PlPackID == 0 ? DateTime.Now : _unit.PackingListPacksRepository.GetByID(model.PlPackID).SetOn; entity.SetBy = model.PlPackID == 0 ? userId : _unit.PackingListPacksRepository.GetByID(model.PlPackID).SetBy; entity.ModifiedOn = model.PlPackID == 0 ? (DateTime?)null : DateTime.Now; entity.ModifiedBy = model.PlPackID == 0 ? (int?)null : userId; return(entity); }
public ActionResult GetPackingListById(int plid) { var packingList = _unit.PackingListRepository.GetByID(plid); var result = new PackingListVM { Plid = packingList.PLID, PlNo = packingList.PLNo, PlDate = string.Format("{0:dd/MM/yyyy}", packingList.PLDate), Lcid = packingList.LCID, LcNo = packingList.LCNo, Ciid = packingList.CIID, CiNo = packingList.CINo, NetWeight = packingList.PLNetWeight, NetWeightUnit = packingList.NetWeightUnit, GrossWeight = packingList.PLGrossWeight, GrossWeightUnit = packingList.GrossWeightUnit, PlNote = packingList.PLNote, RecordStatus = packingList.RecordStatus, packingListItem = new List <PackingListItemVM>(), packingListPacks = new List <PackingListPacksVM>() }; if (packingList.LCID != null) { result.LcDate = _unit.LCOpeningRepository.GetByID(packingList.LCID).LCDate.ToString("dd/MM/yyyy"); } if (packingList.CIID != null) { result.CiDate = string.Format("{0:dd/MM/yyyy}", _unit.CommercialInvoiceRepository.GetByID(packingList.CIID).CIDate); } var packingListItems = _unit.PackingListItemRepository.Get().Where(ob => ob.PLID == plid).ToList(); if (packingListItems.Count > 0) { foreach (var item in packingListItems) { var packingListItem = new PackingListItemVM(); packingListItem.PlItemID = item.PLItemID; packingListItem.Plid = item.PLID; packingListItem.ItemID = item.ItemID; if (item.ItemID != null) { packingListItem.ItemName = _unit.SysChemicalItemRepository.GetByID(item.ItemID).ItemName; packingListItem.HsCode = _unit.SysChemicalItemRepository.GetByID(item.ItemID).HSCode; } packingListItem.PackSize = item.PackSize; if (item.PackSize != null) { packingListItem.PackSizeName = _unit.SysSizeRepository.GetByID(item.PackSize).SizeName; } packingListItem.SizeUnit = item.SizeUnit; if (item.SizeUnit != null) { packingListItem.SizeUnitName = _unit.SysUnitRepository.GetByID(item.SizeUnit).UnitName; } packingListItem.PackQty = item.PackQty; packingListItem.PlQty = item.PLQty; packingListItem.PlUnit = item.PLUnit; if (item.PLUnit != null) { packingListItem.PlUnitName = _unit.SysUnitRepository.GetByID(item.PLUnit).UnitName; } packingListItem.SupplierID = item.SupplierID; if (item.SupplierID != null) { packingListItem.SupplierName = _unit.SysSupplierRepository.GetByID(item.SupplierID).SupplierName; } packingListItem.ManufacturerID = item.ManufacturerID; if (item.ManufacturerID != null) { packingListItem.ManufacturerName = _unit.SysSupplierRepository.GetByID(item.ManufacturerID).SupplierName; } result.packingListItem.Add(packingListItem); } } var packingListPacks = _unit.PackingListPacksRepository.Get().Where(ob => ob.PLID == plid).ToList(); if (packingListPacks.Count > 0) { foreach (var pack in packingListPacks) { var packingListPack = new PackingListPacksVM(); packingListPack.PlPackID = pack.PLPackID; packingListPack.Plid = pack.PLID; packingListPack.PackUnit = pack.PackUnit; if (pack.PackUnit != null) { packingListPack.PackUnitName = _unit.SysUnitRepository.GetByID(pack.PackUnit).UnitName; } packingListPack.PackQty = pack.PackQty; result.packingListPacks.Add(packingListPack); } } return(Json(result, JsonRequestBehavior.AllowGet)); }