public ActionResult GetCIItemByCIID(int ciid)
{
var ciItems = _unit.CommercialInvoiceItemRepository.Get().Where(ob => ob.CIID == ciid).ToList();
var plItemList = new List <PackingListItemVM>();
foreach (var item in ciItems)
{
var pushItem = new PackingListItemVM();
pushItem.ItemID = item.ItemID;
pushItem.ItemName = _unit.SysChemicalItemRepository.GetByID(item.ItemID).ItemName;
pushItem.HsCode = _unit.SysChemicalItemRepository.GetByID(item.ItemID).HSCode;
pushItem.PackSize = item.PackSize;
if (item.PackSize != null)
{
pushItem.PackSizeName = _unit.SysSizeRepository.GetByID(item.PackSize).SizeName;
}
pushItem.SizeUnit = item.SizeUnit;
if (item.SizeUnit != null)
{
pushItem.SizeUnitName = _unit.SysUnitRepository.GetByID(item.SizeUnit).UnitName;
}
pushItem.PackQty = item.PackQty;
pushItem.PlQty = item.CIQty;
pushItem.PlUnit = item.CIUnit;
pushItem.PlUnitName = _unit.SysUnitRepository.GetByID(item.CIUnit).UnitName;
plItemList.Add(pushItem);
}
return(Json(plItemList, JsonRequestBehavior.AllowGet));
}
private LCM_PackingListItem ModelConversionPackingListItem(PackingListItemVM model, int userId, int plid)
{
var entity = model.PlItemID == 0 ? new LCM_PackingListItem() : (from b in _context.LCM_PackingListItem.AsEnumerable()
where b.PLItemID == model.PlItemID
select b).FirstOrDefault();
entity.PLItemID = model.PlItemID;
entity.PLID = plid;
entity.ItemID = model.ItemID;
entity.PackSize = model.PackSize;
entity.SizeUnit = model.SizeUnit;
entity.PackQty = model.PackQty;
entity.PLQty = model.PlQty;
entity.PLUnit = model.PlUnit;
entity.SupplierID = model.SupplierID;
entity.ManufacturerID = model.ManufacturerID;
entity.SetOn = model.PlItemID == 0 ? DateTime.Now : _unit.PackingListItemRepository.GetByID(model.PlItemID).SetOn;
entity.SetBy = model.PlItemID == 0 ? userId : _unit.PackingListItemRepository.GetByID(model.PlItemID).SetBy;
entity.ModifiedOn = model.PlItemID == 0 ? (DateTime?)null : DateTime.Now;
entity.ModifiedBy = model.PlItemID == 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));
}
