public IActionResult GetSeparateByHblid(Guid hbId) { CsMawbcontainerCriteria criteriaMaw = new CsMawbcontainerCriteria { Hblid = hbId }; var hbl = csTransactionDetailService.GetSeparateByHblid(hbId); var resultMaw = containerService.Query(criteriaMaw).ToList(); if (resultMaw.Count() > 0) { hbl.CsMawbcontainers = resultMaw; } return(Ok(hbl)); }
public IQueryable <CsMawbcontainerModel> Query(CsMawbcontainerCriteria criteria) { var containers = DataContext.Get(x => (x.Mblid == criteria.Mblid || criteria.Mblid == null) && (x.Hblid == criteria.Hblid || criteria.Hblid == null)); var containerTypes = catUnitRepository.Get(x => x.UnitType == "Container"); var unitOfMeasures = catUnitRepository.Get(x => x.UnitType == "WeightMeasurement"); var packageTypes = catUnitRepository.Get(x => x.UnitType == "Package"); var commodities = catCommodityRepository.Get(); var results = (from container in containers join unitOfMeasure in unitOfMeasures on container.UnitOfMeasureId equals unitOfMeasure.Id into grpUnitOfMeasures from uOfMeasure in grpUnitOfMeasures.DefaultIfEmpty() join containerType in containerTypes on container.ContainerTypeId equals containerType.Id into grpContainerTypes from conType in grpContainerTypes.DefaultIfEmpty() join packageType in packageTypes on container.PackageTypeId equals packageType.Id into grpPackageTypes from packType in grpPackageTypes.DefaultIfEmpty() join commodity in commodities on container.CommodityId equals commodity.Id into grpCommodities from com in grpCommodities.DefaultIfEmpty() select new CsMawbcontainerModel { Id = container.Id, Mblid = container.Mblid, Hblid = container.Hblid, ContainerTypeId = container.ContainerTypeId, ContainerTypeName = conType.UnitNameEn, Quantity = container.Quantity, ContainerNo = container.ContainerNo, SealNo = container.SealNo, MarkNo = container.MarkNo, UnitOfMeasureId = container.UnitOfMeasureId, UnitOfMeasureName = uOfMeasure.UnitNameEn, CommodityId = container.CommodityId, CommodityName = com.CommodityNameEn, PackageTypeId = container.PackageTypeId, PackageTypeName = packType.UnitNameEn, PackageQuantity = container.PackageQuantity, Description = container.Description, Gw = container.Gw, Nw = container.Nw, Cbm = container.Cbm, ChargeAbleWeight = container.ChargeAbleWeight, UserModified = container.UserModified, DatetimeModified = container.DatetimeModified }); return(results); }
public IActionResult GetById(Guid Id) { var statusCode = csTransactionDetailService.CheckDetailPermission(Id); if (statusCode == 403) { return(Forbid()); } CsMawbcontainerCriteria criteriaMaw = new CsMawbcontainerCriteria { Hblid = Id }; var hbl = csTransactionDetailService.GetDetails(Id); var resultMaw = containerService.Query(criteriaMaw).ToList(); if (resultMaw.Count() > 0) { hbl.CsMawbcontainers = resultMaw; } return(Ok(hbl)); }
public IActionResult Query(CsMawbcontainerCriteria criteria) { return(Ok(csContainerService.Query(criteria))); }