public HttpResponseMessage GetOrderstoGenerateInvoice()
{
var invoiceDtlList = dl.GetOrderstoGenerateInvoice();
var orders = new List <InvoiceBO>();
foreach (var list in invoiceDtlList)
{
InvoiceBO bo = new InvoiceBO();
bo.order = new DeliveryOrderBO();
bo.orderDetails = new DeliveryOrderDetailBO();
bo.order.OrderKey = list.OrderKey;
bo.order.OrderNo = list.OrderNo;
bo.order.OrderDate = list.OrderDate;
bo.order.OrderType = list.OrderType;
bo.order.BrokerRefNo = list.BrokerRefNo;
bo.order.CustKey = list.CustKey;
bo.order.BillToAddress = list.BillToAddress;
bo.order.SourceAddress = list.SourceAddress;
bo.order.DestinationAddress = list.DestinationAddress;
bo.order.VesselName = list.VesselName;
bo.order.BillofLading = list.BillofLading;
bo.order.BookingNo = list.BookingNo;
// bo.order.CutOffDate = list.CutOffDate;
bo.orderDetails.OrderDetailKey = list.OrderDetails.OrderDetailKey;
bo.orderDetails.ContainerNo = list.OrderDetails.ContainerNo;
bo.orderDetails.ContainerSizeDesc = list.OrderDetails.ContainerSizeDesc;
bo.orderDetails.ContainerSize = list.OrderDetails.ContainerSize;
bo.orderDetails.Chassis = list.OrderDetails.Chassis;
bo.orderDetails.SealNo = list.OrderDetails.SealNo;
if (list.CustKey != null)
{
var addr = new AddressRepository().GetbyId(list.CustKey);
if (addr != null)
{
bo.BillFrom = new AddressBO()
{
AddrKey = addr.addrkey,
Address1 = addr.address1,
Address2 = addr.address2,
City = addr.city,
State = addr.state,
Zip = addr.zipcode,
Email = addr.email,
Phone = addr.phone,
Fax = addr.fax,
Name = addr.addrname
};
}
}
if (list.CustKey != null)
{
var addrBillTo = new AddressRepository().GetbyId(list.BillToAddress);
if (addrBillTo != null)
{
bo.BillTo = new AddressBO()
{
AddrKey = addrBillTo.addrkey,
Address1 = addrBillTo.address1,
Address2 = addrBillTo.address2,
City = addrBillTo.city,
State = addrBillTo.state,
Zip = addrBillTo.zipcode,
Email = addrBillTo.email,
Phone = addrBillTo.phone,
Fax = addrBillTo.fax,
Name = addrBillTo.addrname
};
}
}
if (list.SourceAddress != null)
{
var addrBillTo = new AddressRepository().GetbyId(list.SourceAddress);
if (addrBillTo != null)
{
bo.Pickup = new AddressBO()
{
AddrKey = addrBillTo.addrkey,
Address1 = addrBillTo.address1,
Address2 = addrBillTo.address2,
City = addrBillTo.city,
State = addrBillTo.state,
Zip = addrBillTo.zipcode,
Email = addrBillTo.email,
Phone = addrBillTo.phone,
Fax = addrBillTo.fax,
Name = addrBillTo.addrname
};
}
}
if (list.DestinationAddress != null)
{
var addrBillTo = new AddressRepository().GetbyId(list.DestinationAddress);
if (addrBillTo != null)
{
bo.Delivery = new AddressBO()
{
AddrKey = addrBillTo.addrkey,
Address1 = addrBillTo.address1,
Address2 = addrBillTo.address2,
City = addrBillTo.city,
State = addrBillTo.state,
Zip = addrBillTo.zipcode,
Email = addrBillTo.email,
Phone = addrBillTo.phone,
Fax = addrBillTo.fax,
Name = addrBillTo.addrname
};
}
}
orders.Add(bo);
}
return(Request.CreateResponse(HttpStatusCode.OK, orders, Configuration.Formatters.JsonFormatter));
}