public void Elimina(InvoiceBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
//INSPECTION CERTIFICATE DETAIL
List <InvoiceDetailBE> lstInvoiceDetail = null;
lstInvoiceDetail = new InvoiceDetailDL().ListaTodosActivo(pItem.IdInvoice);
foreach (var item in lstInvoiceDetail)
{
InspectionCertificate.ActualizaSituacion(item.IdInspectionCertificate, 14);
InvoiceDetail.Elimina(item);
}
Invoice.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public Int32 Inserta(InvoiceBE pItem, List <InvoiceDetailBE> pListaInvoiceDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
int IdInvoice = 0;
IdInvoice = Invoice.Inserta(pItem);
foreach (var item in pListaInvoiceDetail)
{
InspectionCertificate.ActualizaSituacion(item.IdInspectionCertificate, 15);
item.IdInvoice = IdInvoice;
InvoiceDetail.Inserta(item);
}
ts.Complete();
return(IdInvoice);
}
}
catch (Exception ex)
{ throw ex; }
}
public List <Invoice> GetInvoicesByDate(string today)
{
InvoiceDL invoiceDL = new InvoiceDL();
List <Invoice> invocies = invoiceDL.GetInvoicesByDate(today);
return(invocies);
}
public void Actualiza(InvoiceBE pItem, List <InvoiceDetailBE> pListaInvoiceDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
foreach (var item in pListaInvoiceDetail)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdInvoice = pItem.IdInvoice;
InvoiceDetail.Inserta(item);
}
else
{
InvoiceDetail.Actualiza(item);
}
}
Invoice.Actualiza(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
//private InvoiceDL _invoiceDL = new InvoiceDL();
/// <summary>
/// Lấy danh sách hóa đơn
/// </summary>
/// <returns></returns>
public List <Invoice> GetInvoices()
{
InvoiceDL invoiceDL = new InvoiceDL();
List <Invoice> invocies = invoiceDL.GetInvoices();
return(invocies);
}
public List <Invoice> GetInvoiceStatistical(int type, int value)
{
InvoiceDL invoiceDL = new InvoiceDL();
List <Invoice> invs;
invs = invoiceDL.GetInvoiceStatistical(type, value);
return(invs);
}
/// <summary>
/// Lưu hóa đơn
/// </summary>
/// <param name="master"></param>
/// <param name="detailItem"></param>
public void SaveInvoice(Invoice master, string detailItem)
{
InvoiceDL invoiceDL = new InvoiceDL();
InvoiceDL invoiceItemDL = new InvoiceDL();
Guid invoiceID = Guid.NewGuid();
invoiceDL.SaveInvoice(invoiceID, master);
invoiceItemDL.SaveInvoiceItem(invoiceID, detailItem);
}
public int SeleccionaBusquedaCount(int IdCompany, int IdClient)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
return(Invoice.SeleccionaBusquedaCount(IdCompany, IdClient));
}
catch (Exception ex)
{ throw ex; }
}
public object GetInvoicesPaging(int pageNumber, string fromDate, string toDate)
{
InvoiceDL invoiceDL = new InvoiceDL();
InvoiceDL invoiceDL2 = new InvoiceDL();
List <Invoice> invoices = invoiceDL.GetInvoicesPaging(pageNumber, fromDate, toDate);
int totalRow = invoiceDL2.GetTotalPage(fromDate, toDate);
object obj = new { data = invoices, totalRow = totalRow };
return(obj);
}
public List <InvoiceBE> ListaNumberInvoice(int IdCompany, int IdClient, string NumberInvoice)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
return(Invoice.ListaNumberInvoice(IdCompany, IdClient, NumberInvoice));
}
catch (Exception ex)
{ throw ex; }
}
public List <InvoiceBE> ListaClientDate(int IdCompany, int IdClient, int IdStatus, DateTime DateFrom, DateTime DateTo)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
return(Invoice.ListaClientDate(IdCompany, IdClient, IdStatus, DateFrom, DateTo));
}
catch (Exception ex)
{ throw ex; }
}
public List <InvoiceBE> ListaClient(int IdCompany, int IdClient, int IdStatus)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
return(Invoice.ListaClient(IdCompany, IdClient, IdStatus));
}
catch (Exception ex)
{ throw ex; }
}
public List <InvoiceBE> ListaTodosActivo(int IdCompany)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
return(Invoice.ListaTodosActivo(IdCompany));
}
catch (Exception ex)
{ throw ex; }
}
public InvoiceBE Selecciona(int IdInvoice)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceBE objEmp = Invoice.Selecciona(IdInvoice);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public InvoiceBE SeleccionaNumberInvoice(string NumberInvoice)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceBE objEmp = Invoice.SeleccionaNumberInvoice(NumberInvoice);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public HttpResponseMessage CreateInvoicePDF(string orderkey)
{
var viewmodel = new InvoiceViewModel();
// string orderKey = "33215b82-91a6-11e9-b6c9-3f0945f4a3b5";
DeliveryOrderDL orderDl = new DeliveryOrderDL();
InvoiceDL dl = new InvoiceDL();
var orderBO = orderDl.GetDeliveryOrder(orderkey);
viewmodel.Order = orderBO;
var orderdetailBO = orderDl.GetOrderDetailsByKey(orderkey);
if (orderdetailBO != null && orderdetailBO.Count > 0)
{
var orderdtlList = new List <ThinOrderDetailViewModel>();
orderdetailBO.ForEach(d =>
{
orderdtlList.Add(new ThinOrderDetailViewModel()
{
Chassis = d.Chassis,
ContainerNo = d.ContainerNo,
OrderDetailKey = d.OrderDetailKey,
InvoiceHeader = d.OrderDetailKey != null ? dl.GetInvoicebyOrderDetailKey(Convert.ToString(d.OrderDetailKey)) : null,
InvoiceDetail = d.OrderDetailKey != null ? dl.GetInvoiceDetail(Convert.ToString(d.OrderDetailKey)) : null,
});
});
viewmodel.OrderDtl = orderdtlList;
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Order not found", Configuration.Formatters.JsonFormatter));
}
var stringified = new InvoiceViewController().RenderRazorViewToString("~/Views/InvoiceView/Index.cshtml", viewmodel);
var pdf = IronPdf.HtmlToPdf.StaticRenderHtmlAsPdf(stringified);
var basepath = HttpContext.Current.Server.MapPath("~/App_Data/Files/");
var doccreated = pdf.SaveAs(Path.Combine(basepath, $"{viewmodel.Order.OrderNo}.pdf"));
if (doccreated.PageCount > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invoice generated", Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Error occurred while creating Invoice", Configuration.Formatters.JsonFormatter));
}
}
public void ActualizaSituacion(int IdInvoice, int IdStatus)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
Invoice.ActualizaSituacion(IdInvoice, IdStatus);
//INSPECTION CERTIFICATE DETAIL
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
List <InvoiceDetailBE> lstInvoiceDetail = null;
lstInvoiceDetail = new InvoiceDetailDL().ListaTodosActivo(IdInvoice);
foreach (var item in lstInvoiceDetail)
{
InspectionCertificate.ActualizaSituacion(item.IdInspectionCertificate, 14);
}
}
catch (Exception ex)
{ throw ex; }
}
public void ActualizaSituacionMasivo(List <InvoiceBE> pListaInvoice)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL objInvoice = new InvoiceDL();
foreach (InvoiceBE item in pListaInvoice)
{
objInvoice.ActualizaSituacion(item.IdInvoice, item.IdStatus);
}
ts.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Hàm khởi tạo mặc định
/// </summary>
/// Người tạo: ntxuan (20/6/2019)
public InvoiceBL()
{
invoiceDL = new InvoiceDL();
}
public int GetTotalPage(string fromDate, string toDate)
{
InvoiceDL invoiceDL = new InvoiceDL();
return(invoiceDL.GetTotalPage(fromDate, toDate));
}
public void DeleteInvoice(Guid id)
{
InvoiceDL invoiceDL = new InvoiceDL();
invoiceDL.DeleteInvoice(id);
}
public Invoice GetInvoice(Guid id)
{
InvoiceDL invoiceDL = new InvoiceDL();
return(invoiceDL.GetInvoice(id));
}
public InvoiceItem GetDetailInvoice(Guid id)
{
InvoiceDL invoiceDL = new InvoiceDL();
return(invoiceDL.GetDetailInvoice(id));
}
/// <summary>
///
/// </summary>
/// <param name="custname"></param>
/// <returns></returns>
//[HttpPost]
//[Route("DownloadInvoice_1")]
//[SwaggerOperation("DownloadInvoice_1")]
private HttpResponseMessage DownloadInvoice_1(string orderkey)
{
// var invoicetotals = dl.AutoPullInvoiceCosts(orderkey);
var fileuploadPath = HttpContext.Current.Server.MapPath("~/App_Data/Files/");
PdfDocument pdfDoc = new PdfDocument(new PdfWriter(Path.Combine(fileuploadPath, $"invoice_{orderkey}.pdf")));
DeliveryOrderDL doObj = new DeliveryOrderDL();
var orderHeader = doObj.GetDeliveryOrder(orderkey);
var customer = new CustomerDL().GetCustomerbykey(orderHeader.CustKey);
var orderdetaillist = doObj.GetOrderDetailsByKey(orderkey);
Document doc = new Document(pdfDoc);
/*
* 1483 Via Plata StreetLong Beach, CA
*/
var paragraph = new Paragraph("INVOICE").SetTextAlignment(TextAlignment.CENTER).SetFontSize(15);
doc.Add(paragraph);
var cell = new Cell().SetTextAlignment(TextAlignment.LEFT);
cell.Add(new Paragraph(new Text("PLEASE REMIT TO").SetFontSize(14).SetBold()));
cell.Add(new Paragraph("Junction Collaborative Transports").SetFontSize(12));
cell.Add(new Paragraph("1483 Via Plata Street").SetFontSize(12));
cell.Add(new Paragraph("Long Beach, CA").SetFontSize(12));
cell.Add(new Paragraph("90810").SetFontSize(12));
cell.Add(new Paragraph("Phone: (310) 537-7730").SetFontSize(12));
cell.Add(new Paragraph("Fax: (310) 537-7723").SetFontSize(12));
//p.Add(new Paragraph().Add("PLEASE REMIT TO").Add(customer.CustName).Add(customer.Address.Address1)
// .Add(customer.Address.Address2).Add(customer.Address.City).Add(customer.Address.State)
// .Add(customer.Address.Zip));
doc.Add(cell);
List header = new List();
double runningtotal = 0.0;
InvoiceDL dl = new InvoiceDL();
foreach (var orderdetail in orderdetaillist)
{
var invoice = dl.GetInvoicebyOrderDetailKey(orderdetail.OrderDetailKey.ToString());
Table dtlTable = new Table(UnitValue.CreatePercentArray(7)).UseAllAvailableWidth();
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Container no")));
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Container size")));
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Chassis")));
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Invoice No")));
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Due date")));
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Invoice Date")));
dtlTable.AddHeaderCell(new Cell().Add(new Paragraph("Amount")));
dtlTable.AddCell(new Cell().Add(new Paragraph(orderdetail.ContainerNo)));
dtlTable.AddCell(new Cell().Add(new Paragraph(orderdetail.ContainerSize.ToString())));
dtlTable.AddCell(new Cell().Add(new Paragraph(orderdetail.Chassis)));
dtlTable.AddCell(new Cell().Add(new Paragraph(invoice.InvoiceNo.ToString())));
dtlTable.AddCell(new Cell().Add(new Paragraph(invoice.DueDate.ToString())));
dtlTable.AddCell(new Cell().Add(new Paragraph(invoice.InvoiceDate.ToString())));
dtlTable.AddCell(new Cell().Add(new Paragraph(invoice.InvoiceAmt.ToString())));
runningtotal += (double)invoice.InvoiceAmt;
ListItem dtl = new ListItem();
dtl.Add(new Paragraph().Add(dtlTable));
// doc.Add(dtlTable);
var invoicedtl = dl.GetInvoiceDetail(orderdetail.OrderDetailKey.ToString());
ListItem invoiceItem = new ListItem();
Table table = new Table(UnitValue.CreatePercentArray(5));
table.AddHeaderCell(new Cell().Add(new Paragraph("Item")));
table.AddHeaderCell(new Cell().Add(new Paragraph("Price")));
table.AddHeaderCell(new Cell().Add(new Paragraph("Quantity")));
table.AddHeaderCell(new Cell().Add(new Paragraph("UnitPrice")));
table.AddHeaderCell(new Cell().Add(new Paragraph("Excess Amount")));
foreach (var invoiceline in invoicedtl)
{
table.AddCell(new Cell().Add(new Paragraph(invoiceline.Description)));
table.AddCell(new Cell().Add(new Paragraph(invoiceline.Price.ToString())));
table.AddCell(new Cell().Add(new Paragraph(invoiceline.Quantity.ToString())));
table.AddCell(new Cell().Add(new Paragraph(invoiceline.UnitPrice.ToString())));
table.AddCell(new Cell().Add(new Paragraph(invoiceline.ExcessAmount.ToString())));
runningtotal += (double)invoiceline.Price * (double)invoiceline.Quantity;
}
invoiceItem.Add(new Paragraph("Detailed Breakup:").SetFirstLineIndent(25).Add(table));
dtl.Add(invoiceItem);
header.Add(dtl);
}
header.SetSymbolIndent(80).Add($"Total:{runningtotal.ToString()}");
doc.Add(header);
//Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
// By default column width is calculated automatically for the best fit.
// useAllAvailableWidth() method set table to use the whole page's width while placing the content.
//foreach (var record in invoicetotals)
//{
// table.AddCell(new Cell().Add(new Paragraph(record.ContainerNo)));
// table.AddCell(new Cell().Add(new Paragraph(record.ItemId)));
// table.AddCell(new Cell().Add(new Paragraph(record.UnitPrice.ToString())));
//}
//table.AddCell(new Cell().Add(new Paragraph()));
//table.AddCell(new Cell().Add(new Paragraph("Totals:")));
//table.AddCell(new Cell().Add(new Paragraph(invoicetotals.Select(x => x.UnitPrice).Sum().ToString())));
//doc.Add(table);
//}
doc.Close();
if (doc != null)
{
byte[] bytes = File.ReadAllBytes(Path.Combine(fileuploadPath, $"invoice_{orderkey}.pdf"));
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
//Set the Response Content.
response.Content = new ByteArrayContent(bytes);
//Set the Response Content Length.
response.Content.Headers.ContentLength = bytes.LongLength;
//Set the Content Disposition Header Value and FileName.
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = $"invoice_{orderkey}.pdf";
//Set the File Content Type.
response.Content.Headers.ContentType = new MediaTypeHeaderValue(MimeMapping.GetMimeMapping($"invoice_{orderkey}.pdf"));
return(response);
}
return(Request.CreateResponse(HttpStatusCode.InternalServerError, string.Empty, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage CreatePDFforInvoice(string invoicekey)
{
var viewmodel = new InvoiceViewModel();
DeliveryOrderDL orderDl = new DeliveryOrderDL();
InvoiceDL dl = new InvoiceDL();
string orderkey = dl.getOrderkeybyInvoicekey(invoicekey);
if (!string.IsNullOrEmpty(orderkey))
{
var orderBO = orderDl.GetDeliveryOrder(orderkey);
viewmodel.Order = orderBO;
viewmodel.InvoiceHeader = dl.GetInvoicebyinvoiceKey(invoicekey);
viewmodel.InvoiceDetail = dl.GetInvoiceDetail(invoicekey);
var orderdetailBO = orderDl.GetOrderDetailsByKey(orderkey);
if (orderdetailBO != null && orderdetailBO.Count > 0)
{
var orderdtlList = new List <ThinOrderDetailViewModel>();
orderdetailBO.ForEach(d =>
{
orderdtlList.Add(new ThinOrderDetailViewModel()
{
Chassis = d.Chassis,
ContainerNo = d.ContainerNo,
OrderDetailKey = d.OrderDetailKey,
//InvoiceHeader = d.OrderDetailKey != null ? dl.GetInvoicebyinvoiceKey(Convert.ToString(invoicekey)) : null,
//InvoiceDetail = d.OrderDetailKey != null ? dl.GetInvoiceDetail(invoicekey) : null,
});
});
viewmodel.OrderDtl = orderdtlList;
}
}
//if (orderdetailBO != null && orderdetailBO.Count > 0)
//{
// var orderdtlList = new List<ThinOrderDetailViewModel>();
// orderdetailBO.ForEach(d =>
// {
// orderdtlList.Add(new ThinOrderDetailViewModel()
// {
// Chassis = d.Chassis,
// ContainerNo = d.ContainerNo,
// OrderDetailKey = d.OrderDetailKey,
// InvoiceHeader = d.OrderDetailKey != null ? dl.GetInvoicebyOrderDetailKey(Convert.ToString(d.OrderDetailKey)) : null,
// InvoiceDetail = d.OrderDetailKey != null ? dl.GetInvoiceDetail(Convert.ToString(d.OrderDetailKey)) : null,
// });
// });
// viewmodel.OrderDtl = orderdtlList;
//}
//else
//{
// return Request.CreateResponse(HttpStatusCode.InternalServerError, "Order not found", Configuration.Formatters.JsonFormatter);
//}
if (viewmodel == null)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Order not found", Configuration.Formatters.JsonFormatter));
}
var stringified = new InvoiceViewController().RenderRazorViewToString("~/Views/InvoiceView/Invoice.cshtml", viewmodel);
var pdf = IronPdf.HtmlToPdf.StaticRenderHtmlAsPdf(stringified);
var basepath = HttpContext.Current.Server.MapPath("~/App_Data/Files/");
var doccreated = pdf.SaveAs(Path.Combine(basepath, $"{viewmodel.Order.OrderNo}.pdf"));
if (doccreated.PageCount > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invoice generated", Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Error occurred while creating Invoice", Configuration.Formatters.JsonFormatter));
}
}