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