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