public eCommerceTaxAndDutyInvoiceReport GetShipmentInvoice(string frayteNumber)
{
eCommerceTaxAndDutyInvoiceReport InvoiceReport = new eCommerceTaxAndDutyInvoiceReport();
var shipment = dbContext.eCommerceShipments.Where(p => p.FrayteNumber == frayteNumber).FirstOrDefault();
if (shipment != null)
{
InvoiceReport = new eCommerceShipmentRepository().GeteCommerceInvoiceObj(shipment.eCommerceShipmentId);
// Fill extra data in invoice object
new eCommerceShipmentRepository().GeteCommerceInvoceData(shipment.eCommerceShipmentId, InvoiceReport);
}
return(InvoiceReport);
}
public FrayteResult GenerateInvoiceReport(int eCommerceShipmentId, eCommerceTaxAndDutyInvoiceReport obj)
{
FrayteResult result = new FrayteResult();
if (!File.Exists(HttpContext.Current.Server.MapPath(AppSettings.eCommerceLabelFolder) + "/" + eCommerceShipmentId + "/" + obj.InvoiceRef.ToString() + ".pdf"))
{
List <eCommerceTaxAndDutyInvoiceReport> reportDataSource = new List <eCommerceTaxAndDutyInvoiceReport>();
if (obj != null)
{
ReportTemplate.Other.eCommerceInvoiceReport re = new ReportTemplate.Other.eCommerceInvoiceReport();
re.xrRichText5.Text = obj.eCommerceBookingDetail.ShipTo.FirstName.ToUpper() + " " + obj.eCommerceBookingDetail.ShipTo.LastName.ToUpper() +
System.Environment.NewLine +
obj.eCommerceBookingDetail.ShipTo.CompanyName.ToUpper() + System.Environment.NewLine + obj.eCommerceBookingDetail.ShipTo.Address.ToUpper();
if (!string.IsNullOrEmpty(obj.eCommerceBookingDetail.ShipTo.Address2))
{
re.xrRichText5.Text += System.Environment.NewLine + obj.eCommerceBookingDetail.ShipTo.Address2.ToUpper();
}
re.xrRichText5.Text += System.Environment.NewLine + obj.eCommerceBookingDetail.ShipTo.City.ToUpper();
if (!string.IsNullOrEmpty(obj.eCommerceBookingDetail.ShipTo.PostCode))
{
re.xrRichText5.Text += " - " + obj.eCommerceBookingDetail.ShipTo.PostCode.ToUpper();
}
if (!string.IsNullOrEmpty(obj.eCommerceBookingDetail.ShipTo.State))
{
re.xrRichText5.Text += System.Environment.NewLine + obj.eCommerceBookingDetail.ShipTo.State.ToUpper();
}
if (obj.eCommerceBookingDetail.ShipTo != null && obj.eCommerceBookingDetail.ShipTo.Country != null && !string.IsNullOrEmpty(obj.eCommerceBookingDetail.ShipTo.Country.Name))
{
re.xrRichText5.Text += System.Environment.NewLine + obj.eCommerceBookingDetail.ShipTo.Country.Name.ToUpper();
}
obj.FreeStorageTime = "YOUR FREE STORAGE PERIOD ENDS " + obj.FreeStorageTime + " HOURS AFTER SHIPMENT ARRIVAL INTO THE UK - £5 per KG will be charged thereafter";
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.Address2))
{
//re.xrRichText2.Text += ", " + obj.CompanyDetail.Address.Address2;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.City))
{
//re.xrRichText2.Text += ", " + obj.CompanyDetail.Address.City;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.Zip))
{
//re.xrRichText2.Text += " " + obj.CompanyDetail.Address.Zip;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.State))
{
//re.xrRichText2.Text += ", " + obj.CompanyDetail.Address.State;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.Country.Name))
{
//re.xrRichText2.Text += ", " + obj.CompanyDetail.Address.Country.Name;
}
//re.xrRichText1.Text = obj.BankDetail.Address.Address1;
if (!string.IsNullOrEmpty(obj.BankDetail.Address.Address2))
{
//re.xrRichText1.Text += ", " + obj.BankDetail.Address.Address2;
}
if (!string.IsNullOrEmpty(obj.BankDetail.Address.City))
{
//re.xrRichText1.Text += ", " + obj.BankDetail.Address.City;
}
if (!string.IsNullOrEmpty(obj.BankDetail.Address.Zip))
{
//re.xrRichText1.Text += ", " + obj.BankDetail.Address.Zip;
}
//re.xrTableCell14.Text = "Company No:" + " " + obj.CompanyDetail.CompanyNo + ".";
//re.xrTableCell14.Text += "Company Registration Number " + "+44 " + obj.CompanyDetail.CompanyPhoneCode + " " + obj.CompanyDetail.CompanyPhone + ". ";
//re.xrTableCell14.Text += "Crest Code " + obj.CompanyDetail.CrestCode + ". ";
//re.xrTableCell14.Text += "Registered address: ";
//re.xrTableCell14.Text += System.Environment.NewLine;
//re.xrTableCell14.Text += obj.CompanyDetail.CompanyName + ", " + obj.CompanyDetail.Address.Address1;
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.Address2))
{
//re.xrTableCell14.Text += ", " + obj.CompanyDetail.Address.Address2;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.City))
{
//re.xrTableCell14.Text += ", " + obj.CompanyDetail.Address.City;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.Zip))
{
//re.xrTableCell14.Text += " " + obj.CompanyDetail.Address.Zip;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.State))
{
//re.xrTableCell14.Text += ", " + obj.CompanyDetail.Address.State;
}
if (!string.IsNullOrEmpty(obj.CompanyDetail.Address.Country.Name))
{
//re.xrTableCell14.Text += ", " + obj.CompanyDetail.Address.Country.Name;
}
// re.xrTableCell14.Text
//re.xrRichText4.Text = "P " + "+44" + obj.CompanyDetail.CompanyPhoneCode + " " + obj.CompanyDetail.CompanyPhone;
//re.xrRichText4.Text += " | " + " E " + obj.CompanyDetail.SalesEmail;
reportDataSource.Add(obj);
re.DataSource = reportDataSource;
var FileName = "CCS - Customs Duty - Vat Invoice [" + obj.InvoiceRef + "] [" + obj.CustomerName + "].pdf";
string filePathToSave = AppSettings.eCommerceLabelFolder + "/" + eCommerceShipmentId.ToString();
filePathToSave = HttpContext.Current.Server.MapPath(filePathToSave);
DevExpress.XtraPrinting.PdfExportOptions pdfOptions = re.ExportOptions.Pdf;
pdfOptions.ImageQuality = DevExpress.XtraPrinting.PdfJpegImageQuality.Highest;
pdfOptions.PdfACompatibility = DevExpress.XtraPrinting.PdfACompatibility.PdfA2b;
if (!System.IO.Directory.Exists(filePathToSave))
{
System.IO.Directory.CreateDirectory(filePathToSave);
}
re.ExportToPdf(HttpContext.Current.Server.MapPath(AppSettings.eCommerceLabelFolder) + "/" + eCommerceShipmentId + "/" + FileName, pdfOptions);
result.Status = true;
}
}
else
{
result.Status = true;
}
return(result);
}