public ActionResult GetBillOfLadingListA()
{
var pl = _unit.ExpBillOfLadingRepository.Get().Select(ob => new
{
ob.BLID,
ob.BLNo,
ob.RefBLNo,
ob.Shipper,
ShipperCode = ob.Shipper == null ? "" : _unit.SysBuyerRepository.GetByID(ob.Shipper).BuyerCode,
ShipperName = ob.Shipper == null ? "" : _unit.SysBuyerRepository.GetByID(ob.Shipper).BuyerName,
BLDate = string.Format("{0:dd/MM/yyyy}", ob.BLDate),
ob.CIID,
CINo = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).CINo,
CIRefNo = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).CIRefNo,
CIDate = ob.CIID == null ? "" : string.Format("{0:dd/MM/yyyy}",
_unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).CIDate),
OrdDeliveryMode = ob.CIID == null ? "" : DalCommon.ReturnOrderDeliveryMode(
_unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).OrdDeliveryMode),
ShipmentFrom = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).ShipmentFrom,
ShipmentTo = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).ShipmentTo,
RecordStatus = ob.CIID == null ? "" : DalCommon.ReturnRecordStatus(_unit.ExpBillOfLadingRepository.GetByID(ob.BLID).RecordStatus)
}).ToList();
return(Json(pl.OrderByDescending(ob => ob.BLID), JsonRequestBehavior.AllowGet));
}
public ActionResult GetComInv()
{
var comInv = _unit.ExpCommercialInvoiceRepository.Get().ToList();
var result = comInv.Select(inv => new
{
inv.CIID,
inv.CINo,
inv.CIRefNo,
CIDate = string.Format("{0:dd/MM/yyyy}", inv.CIDate),
OrdDeliveryMode = DalCommon.ReturnOrderDeliveryMode(inv.OrdDeliveryMode),
RecordStatus = DalCommon.ReturnRecordStatus(inv.RecordStatus)
});
return(Json(result.OrderByDescending(ob => ob.CIID), JsonRequestBehavior.AllowGet));
}
public ActionResult GetBolById(long id)
{
var bol = _unit.ExpBillOfLadingRepository.GetByID(id);
var result = new
{
bol.BLID,
bol.BLNo,
bol.RefBLNo,
BLDate = string.Format("{0:dd/MM/yyyy}", bol.BLDate),
bol.CIID,
CINo = bol.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).CINo,
CIRefNo = bol.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).CIRefNo,
OrdDeliveryMode = bol.CIID == null ? "" : DalCommon.ReturnOrderDeliveryMode(
_unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).OrdDeliveryMode),
CIDate = bol.CIID == null ? "" : string.Format("{0:dd/MM/yyyy}", _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).CIDate),
//bol.PLID,
//PLNo = bol.PLID == null ? "" : _unit.ExpPackingListRepository.GetByID(bol.PLID).PLNo,
ShippedOnBoardDate = string.Format("{0:dd/MM/yyyy}", bol.ShippedOnBoardDate),
ExpectedArrivalTime = string.Format("{0:dd/MM/yyyy}", bol.ExpectedArrivalTime),
bol.Shipper,
ShipperName = bol.Shipper == null ? "" : _unit.SysBuyerRepository.GetByID(bol.Shipper).BuyerName,
bol.ShipmentMode,
bol.VesselName,
bol.VoyageNo,
bol.TransShipmentPort,
TransShipmentPortName = bol.TransShipmentPort == null ? "" : _unit.SysPortRepository.GetByID(bol.TransShipmentPort).PortName,
bol.ShipmentPort,
ShipmentPortName = bol.ShipmentPort == null ? "" : _unit.SysPortRepository.GetByID(bol.ShipmentPort).PortName,
bol.BLNote,
bol.RecordStatus,
Container = _unit.ExpBillOfLadingContainerRepository.Get().Where(ob => ob.BLID == bol.BLID).Select(cont => new
{
cont.BLCcntID,
cont.BLID,
cont.ContainerNo,
cont.ContainerType,
cont.SealNo,
cont.PackageQty,
cont.GrossWeight,
cont.Measurement
}).ToList()
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
