public Crystal PreviewFCLShippingInstruction(CsShippingInstructionReportModel model)
{
Crystal result = new Crystal();
var instructions = new List <SeaShippingInstruction>();
var units = unitRepository.Get();
var parameter = new SeaShippingInstructionParameter
{
CompanyName = DocumentConstants.COMPANY_NAME,
CompanyAddress1 = DocumentConstants.COMPANY_ADDRESS1,
CompanyAddress2 = DocumentConstants.COMPANY_ADDRESS2,
CompanyDescription = "itl company",
Contact = model.IssuedUserName,
Tel = string.Empty,
Website = string.Empty,
DecimalNo = 2
};
if (model.CsTransactionDetails == null)
{
return(result);
}
var total = model.CsTransactionDetails.Count();
foreach (var item in model.CsTransactionDetails)
{
string noPieces = string.Empty;
if (item.PackageQty != null && item.PackageQty != 0 && item.PackageType != null && item.PackageType != 0)
{
var packageType = unitRepository.Get(x => x.Id == item.PackageType)?.FirstOrDefault();
noPieces = noPieces + item.PackageQty + " " + packageType.UnitNameEn;
}
var instruction = new SeaShippingInstruction
{
TRANSID = model.BookingNo,
Attn = model.InvoiceNoticeRecevier,
ToPartner = model.SupplierName,
Re = model.BookingNo,
DatePackage = model.InvoiceDate,
ShipperDf = model.Shipper,
GoodsDelivery = model.ConsigneeDescription,
NotitfyParty = model.InvoiceNoticeRecevier,
PortofLoading = model.PodName,
PortofDischarge = model.PodName,
PlaceDelivery = model.PoDelivery,
Vessel = model.VoyNo,
Etd = model.LoadingDate?.ToString("dd/MM/yyyy"),
ShippingMarks = item.ShippingMark,
Containers = item.ContSealNo,
// ContSealNo = item.SealNo,
NoofPeace = noPieces,
SIDescription = item.DesOfGoods,
GrossWeight = item.GW,
CBM = item.CBM,
Qty = total.ToString(),
RateRequest = model.Remark,
Payment = model.PaymenType,
ShippingMarkImport = string.Empty,
MaskNos = string.Empty
};
instructions.Add(instruction);
}
result = new Crystal
{
ReportName = "SeaShippingInstructionNew.rpt",
AllowPrint = true,
AllowExport = true
};
result.AddDataSource(instructions);
result.FormatType = ExportFormatType.PortableDocFormat;
result.SetParameter(parameter);
return(result);
}
public IActionResult PreviewFCLOCL(CsShippingInstructionReportModel model)
{
var result = shippingInstructionService.PreviewOCL(model);
return(Ok(result));
}
public Crystal PreviewOCL(CsShippingInstructionReportModel model)
{
Crystal result = new Crystal();
var shippingInstructions = new List <OnBoardContainerReportResult>();
var parameter = new SeaShippingInstructionParameter
{
CompanyName = DocumentConstants.COMPANY_NAME,
CompanyAddress1 = DocumentConstants.COMPANY_ADDRESS1,
CompanyAddress2 = DocumentConstants.COMPANY_ADDRESS2,
CompanyDescription = "itl company",
Contact = model.IssuedUserName,
Tel = string.Empty,
Website = string.Empty,
DecimalNo = 2
};
if (model.CsTransactionDetails == null)
{
return(result);
}
var total = model.CsTransactionDetails.Count();
foreach (var item in model.CsTransactionDetails)
{
string noPieces = string.Empty;
if (item.PackageQty != null && item.PackageQty != 0 && item.PackageType != null && item.PackageType != 0)
{
var packageType = unitRepository.Get(x => x.Id == item.PackageType)?.FirstOrDefault();
noPieces = noPieces + item.PackageQty + " " + packageType.UnitNameEn;
}
var container = new OnBoardContainerReportResult
{
TRANSID = model.BookingNo,
ShippingMarkImport = string.Empty,
CheckAttachNull = string.Empty,
DatePackage = model.InvoiceDate,
ToPartner = model.SupplierName,
Attn = model.InvoiceNoticeRecevier,
Notify = model.InvoiceNoticeRecevier,
Re = model.BookingNo,
ShipperDf = model.ActualShipperDescription,
GoodsDelivery = model.ConsigneeDescription,
RealShipper = string.Empty,
RealConsignee = string.Empty,
PortofLoading = model.PodName,
PortofDischarge = model.PodName,
PlaceDelivery = model.PoDelivery,
Vessel = model.VoyNo,
ContSealNo = item.ContSealNo,
Etd = model.LoadingDate?.ToString("dd/MM/yyyy"),
ShippingMarks = item.ShippingMark,
RateRequest = model.Remark,
Payment = model.PaymenType,
NoofPeace = noPieces,
Containers = item.ContSealNo,
MaskNos = item.ShippingMark,
SIDescription = item.DesOfGoods,
GrossWeight = item.GW,
CBM = item.CBM,
SeaLCL = false,
SeaFCL = true,
NotifyParty = model.CargoNoticeRecevier,
CTNS = string.Empty,
Measurement = string.Empty,
Qty = total.ToString()
};
shippingInstructions.Add(container);
}
//foreach (var item in containers)
//{
// var container = new OnBoardContainerReportResult
// {
// TRANSID = model.BookingNo,
// ShippingMarkImport = string.Empty,
// CheckAttachNull = string.Empty,
// DatePackage = model.InvoiceDate,
// ToPartner = model.SupplierName,
// Attn = model.InvoiceNoticeRecevier,
// Notify = model.InvoiceNoticeRecevier,
// Re = model.BookingNo,
// ShipperDf = model.ActualShipperDescription,
// GoodsDelivery = model.ConsigneeDescription,
// RealShipper = string.Empty,
// RealConsignee = string.Empty,
// PortofLoading = model.PodName,
// PortofDischarge = model.PodName,
// PlaceDelivery = model.PoDelivery,
// Vessel = model.VoyNo,
// ContSealNo = item.SealNo,
// Etd = model.LoadingDate?.ToString("dd/MM/yyyy"),
// ShippingMarks = item.MarkNo,
// RateRequest = model.Remark,
// Payment = model.PaymenType,
// NoofPeace = item.PackageQuantity?.ToString(),
// Containers = item.ContainerNo + "/ " + item.SealNo,
// MaskNos = item.MarkNo,
// SIDescription = item.Description,
// GrossWeight = item.Gw,
// CBM = item.Cbm,
// SeaLCL = false,
// SeaFCL = true,
// NotifyParty = model.CargoNoticeRecevier,
// CTNS = string.Empty,
// Measurement = string.Empty,
// Qty = total?.ToString()
// };
// containerRS.Add(container);
//}
result = new Crystal
{
ReportName = "SeaOnboardContainerList.rpt",
AllowPrint = true,
AllowExport = true
};
result.AddDataSource(shippingInstructions);
result.FormatType = ExportFormatType.PortableDocFormat;
result.SetParameter(parameter);
return(result);
}
